topic Re: WEMNG in Application Development and Automation Discussions

WEMNG

Former Member — Thu, 03 Jan 2008 10:40:22 GMT

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 — Thu, 03 Jan 2008 10:43:15 GMT

Hi,

check EKET

Former Member — Thu, 03 Jan 2008 10:43:38 GMT

EKET

Former Member — Thu, 03 Jan 2008 10:44:38 GMT

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

Vijay

Former Member — Thu, 03 Jan 2008 10:47:00 GMT

You must relate EKPO & EKET to get matnr and wemng

Former Member — Thu, 03 Jan 2008 10:53:01 GMT

Former Member — Thu, 03 Jan 2008 10:53:27 GMT

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' ).