Lead Time - SQV1

[Former Member]

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

[Jelena]

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.

[Lakshmipathi]

Try inserting VBFA between VBAK and LIKP