cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Order Date and Despatch Advice Date

Former Member
0 Kudos

Hi all,

I need to create a view that contains Sales Order #, Despatch Advice # , Sales Order Date, Despatch Advice Date and Sales Organization. Please tell me that using which tables, required view can be created?

Regards,

AI.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

VBAP

LIPS

Joining fields are

LIPS-VGBEL ~ VBAP-VBELN

AND LIPS-TRAGR ~ VBAP-POSNR

Assuming : Despatch advise is Delivery.

Former Member
0 Kudos

Thanks Ashish Mohapatra . I have created a view using 2 tables and conditions you mentioned. But it is saying that field name "ERDAT" not unique and same error is appearing for many fields. What should I do then?

Regards,

AI.

Former Member
0 Kudos

Sorry it is not

LIPS-TRAGR ~ VBAP-POSNR

The second line in the "join condition" should be

LIPS-VGPOS ~ VBAP-POSNR

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

In table VBAK, you can take the fields Sales Organisation, po # & Date.

What do you mean by Despatch Advice # ?? If you are referring to delivery which we generate in VL01N, you can make use of table LIKP for header level and LIPS for item level.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi,

please check the following tables.

header:VBAK

item: VBAP

sc line: VBEP

CHEERS