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 A_{EBELN = B}EBELN

INTO TABLE it_EKkO WHERE LIFNR IN S_LIFNR AND MATNR IN S_MATNR AND

WERKS = P_WERKS .

ThankU

With regards .