report
This is lalitha,
i have stuck up in my pro with an error
i have to make an innerjoin for ekko & ekpo tabels as i need matnr(material no) which is not present in ekko .
In my selection screen: s_matnr for v_matnr (v " validation)
p_werks
s_lifnr for v_lifnr (v " validation)
in ekko(purchasing document header)
in ekpo(purchasing document item)
The fields taken from ekko are:ebeln,lifnr
The fields taken from ekpo are: matnr.
THis is part of my pro where iam wrong .
FORM POPULATE_IT_EKkO.
SELECT A~EBELN
A~LIfNR
B~MATNR
B~WERKS
FROM EKpo AS A INNERJOIN EKko AS B
ON AEBELN = BEBELN
INTO TABLE it_EKkO WHERE LIFNR IN S_LIFNR AND MATNR IN S_MATNR AND
WERKS = P_WERKS .
ThankU
With regards .