topic Re: populating fields in Application Development and Automation Discussions

populating fields

Former Member — Tue, 13 Jun 2006 08:38:01 GMT

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

Re: populating fields

Former Member — Tue, 13 Jun 2006 09:21:30 GMT

Hi Srini,

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

regards,

ram

Re: populating fields

Former Member — Tue, 13 Jun 2006 09:24:25 GMT

Hi,

Join ztable-mblnr with mseg-mblnr to get

werks,lgort,ebeln . Please check mseg table.

Regards

Amole

Re: populating fields

Former Member — Tue, 13 Jun 2006 09:28:16 GMT

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