Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 .

Former Member
Not what you were looking for? View more on this topic or Ask a question