Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

populating fields

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

Hi Srini,

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

regards,

ram

Former Member
0 Kudos

Hi,

Join ztable-mblnr with mseg-mblnr to get

werks,lgort,ebeln . Please check mseg table.

Regards

Amole

Former Member
0 Kudos

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