Skip to Content
0
Former Member
May 03, 2007 at 03:42 PM

Data Retrieve

66 Views

hi,

I have to retrieve the data from the different tables...

BSEG ( WEBTR, BELNR, BURKS), BKPF( BKTXT, BLNR, BLDAT, BLART, GJAHR), LFA1( LIFNR, NAME1), EKKO( EBELN) and T001W( WERKS)...

can anyone guide me what is the best way to do this...

being BSEG is cluster table.. i think its better to retrieve the data from BSEG first of all into one internal table and then for all entries in that int. table retrieving the records from the other tables bkpf into one int.table, LFA1 into another int.table and T001W into another int.table.... and combining all these records into final int.table

is this is correct way to do...

one more doubt is EBELN and WERKS existing in the BSEG table, is it necessary to take those from the EKKO and T001W tables.... is there any difference if i take from BSEG.

Thanks a lot for your anticipation...

naveen