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 eketmenge eketwemng ekpowebaz eketeindt
INTO CORRESPONDING FIELDS OF TABLE ekpo_tab FROM ekpo
INNER JOIN ekko ON ekkoebeln = ekpoebeln
INNER JOIN eket
ON eketebeln = ekpoebeln AND eketebelp = ekpoebelp
WHERE ekpoloekz = '' AND ekpoelikz = ''
AND ekpomatnr = p_matnr AND ekpowerks = p_werks
AND ( ekkobsart = 'NB' OR ekkobsart = 'LP' ).
Bluesky
