WEMNG

[Former Member]

Hi All

Can anyone tell me in which table i cann access the field WEMNG is.I can see that in table S012.I want the field aprt from table S012.

VIjay

[Former Member]

Hi All

Can anyone tell me in which table i cann access the field WEMNG is.I can see that in table S012.I want the field aprt from table S012.

VIjay

[Former Member]

Hi,

check EKET

[Former Member]

EKET

[Former Member]

hi

Please tell me a table where both MATNR and WEMNG are placed

Vijay

[Former Member]

You must relate EKPO & EKET to get matnr and wemng

[Former Member]

Have look at this query...which I'm using to get WEMNG..you'll get some idea..

DATA : BEGIN OF ekpo_tab OCCURS 0.

DATA : menge LIKE eket-menge,

wemng LIKE eket-wemng,

webaz LIKE ekpo-webaz,

eindt LIKE eket-eindt,

END OF ekpo_tab.

SELECT eket_{menge eket}wemng ekpo_{webaz eket}eindt

INTO CORRESPONDING FIELDS OF TABLE ekpo_tab FROM ekpo

INNER JOIN ekko ON ekko_{ebeln = ekpo}ebeln

INNER JOIN eket

ON eket_{ebeln = ekpo}ebeln AND eket_{ebelp = ekpo}ebelp

WHERE ekpo_{loekz = '' AND ekpo}elikz = ''

AND ekpo_{matnr = p_matnr AND ekpo}werks = p_werks

AND ( ekko_{bsart = 'NB' OR ekko}bsart = 'LP' ).

[Former Member]

f