Skip to Content
-2

Lead Time - SQV1

Feb 20, 2017 at 12:19 PM

45

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jelena Perfiljeva
Feb 21, 2017 at 04:46 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
G Lakshmipathi
Feb 20, 2017 at 02:05 PM
0

Try inserting VBFA between VBAK and LIKP

Share
10 |10000 characters needed characters left characters exceeded