Skip to Content
0

Link PO lines to Receipt

Jun 26, 2017 at 06:19 PM

54

avatar image
Former Member

capture.pnghello Experts.

I am trying to develop a SQVI query to be able to analyse the commitment of supplier to the dates below:

  • - Statistic Date EKET. EINDT
  • - Delivery Date EJET SLFDT
  • - vendor Confirmation Delivery date EKES EINDT

I am linking this to MSEG to extract the Posting Date.

I manage to extract some information, the issue is that I have duplicated lines in the report that do not have the same delivery & Posting Date.

See attached.

Hope you can help

Ben

capture.png (427.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jürgen L Jun 27, 2017 at 07:23 AM
1

As you joined the EKET and EKES table just on PO document and item number it is logical that the a record in EKET and 2 records in EKES create duplicate combinations as each record in EKET results in a join to each record in EKES.

Not every join makes some sense, if you enter a confirmation just ask yourself if you reference somewhere a delivery schedule line or if you do it only at PO item. Not everything can be build with a simple quickview, thats why ABAPers still have a job.

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Jun 27, 2017 at 05:55 AM
0

Did you use table EKBE in your query?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 27, 2017 at 06:04 AM
0

Yes I did-

Share
10 |10000 characters needed characters left characters exceeded