Skip to Content
avatar image
-2
Former Member

Lead Time - SQV1

Hello,

I am trying to export a report using SQV1.

My Aim is to capture the below in on report:

  • 1. Notification Number (VIQMEL-QMNUM) and Creation Date (VIQMEL-ERDAT)
  • 2. Sales Order (VBAK-VBELN) and Creation Date (VBAK - ERDAT)
  • 3. Outbound Delivery Number (LIKP-VBELN) and Creation DateLIKP-BLDAT

How can I proceed a table join to achieve this?

Rgds

Ben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Feb 21, 2017 at 04:46 PM

    Have you tried simply taking a couple of documents and checking the data in SE16? VBAK and LIKP are header tables but the document flow is at the item level, so how do you expect this to work?

    Overall - similar questions have been asked many times before. There is also a good old SAP table list that can easily be found in Google and shows connections between major tables. And, as I said, you could just look at the data in SE16 and make conclusions there. Plenty of options to solve this on your own.

    P.S. Also you've posted a very similar question several days ago already and it was answered already. Kindly review this blog for proper etiquette and rules of SCN.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 02:05 PM

    Try inserting VBFA between VBAK and LIKP

    Add comment
    10|10000 characters needed characters exceeded