populating fields

[Former Member]

i have one ztable with following fields

MJAHR(PK)

MBLNR(PK)

ZIELE(PK)

MATNR

EBELP

now i added three fields after MATNR

1)WERKS

2)LGORT

3)EBELN

This table has 25,000 rows now i want to fetch the rows for WERKS LGORT AND EBELN..From which Table i have to fetch the rows and fill in this table ? can u give me some ideas.. for right answer points for sure..

regards

Srin

[Former Member]

Hi Srini,

you can use EKPO table to get WERKS, LGORT, EBELN.

regards,

ram

[Former Member]

Hi,

Join ztable-mblnr with mseg-mblnr to get

werks,lgort,ebeln . Please check mseg table.

Regards

Amole

[Former Member]

Hi,

select werks lgort ebeln into table itab

from mseg

inner join ztable on

mblnr = ztable-mblnr and

mjahr = ztable-mjahr and

zeile = ztable-zeile.

Regards

Amole