Skip to Content
avatar image
Former Member

Link PO lines to Receipt

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 27, 2017 at 07:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 05:55 AM

    Did you use table EKBE in your query?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 27, 2017 at 06:04 AM

    Yes I did-

    Add comment
    10|10000 characters needed characters exceeded