EKKO, COEP and LFA1

[Former Member]

Hi,

I'm trying to do an extract with many tables ( COBK, COEP, EKPO, ONRKS, CSKT, CSKU, EKKO and LFA1) but my problem seems to come from tables COEP, EKKO and LFA1.

Everything works fine, until I add table LFA1. I linked EKKO to COEP (EBELN) by including all records from COEP and only EKKO when the joined fields are equal.

When I add LFA1 and do the same thing by linking with LIFNR, if there is no Purchase document associated to the transaction, the lines aren't displayed anymore.

I tried changing the join type between LFA1 and EKKO but then I get no results...

Thanks for your help!

[Former Member]

HI,

As you said, in absence of Doc no., the join will not work and hence it will not bring any records. This is natural behaviour in join conditions. You can use the tcode SQVI in R3 to see what are the common fields in tables and on which fields you can based your join.

Rgds...

Shambhu