Skip to Content
0
Former Member
Jun 20, 2007 at 05:10 AM

why the output for the view was coming in different format for same code.

8 Views

Hi guru,

I am having a doubt regarding views output report...

i created a view 'zcust_purch_sale' from 3 tables called 'zcust', 'zpurch', 'zsale'.

and when i am trying to retrieve output for the zcust_purch_sale view. i am getting output in different way. I added code with this thread.. can u observe it clearly and explain why the output was coming in this way?????

***************************************************************************************************

tables: zcust_purch_sale.

data: itab_zcust_purch_sale like zcust_purch_sale occurs 0

with header line.

select * from zcust_purch_sale

into table itab_zcust_purch_sale.

loop at itab_zcust_purch_sale.

write:/ itab_zcust_purch_sale-custnum,

itab_zcust_purch_sale-custname,

itab_zcust_purch_sale-email,

itab_zcust_purch_sale-vendor,

itab_zcust_purch_sale-purc_doc,

itab_zcust_purch_sale-purc_org,

itab_zcust_purch_sale-sales_doc,

itab_zcust_purch_sale-doc_date,

itab_zcust_purch_sale-sal_org.

endloop.

  • if i wrote in this way,output was coming in correct way... but if i try in this way......

tables: zcust_purch_sale.

data: itab_zcust_purch_sale like zcust_purch_sale occurs 0

with header line.

select * from zcust_purch_sale

into table itab_zcust_purch_sale.

loop at itab_zcust_purch_sale.

write:/ itab_zcust_purch_sale.

endloop.

******output....

The last three fields were compressing to each other, and date field i.e itab_zcust_purch_sale-doc_date was printing in different format.

once plz go through this code and solve my query.

thanks in advance.