Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

sales order details

Former Member
0 Kudos
58

hi,

how to get sales order report to display details like sales organisation,customer no, customer name ,order date and material details according to sales division,distribution channel and order date

3 REPLIES 3

Former Member
0 Kudos
29

Hi,

You can use the transaction VA05

Thanks,

Naren

Former Member
0 Kudos
29

Hi

Use the tables KNA1,VBAK and VBAP

fields

sales organisation - VBAK-VKORG

customer no - VBAK-KUNNR

customer name - KNA1-kunnr

order date - VBAK-AUDAT

material No - VBAP-MATNR

sales division - VBAP-SPART

distribution channel - VBAK-VTWEG

links

VBAK-KUNNR = KNA1-KUNNR

VBAK-VBELN = VBAP-VBELN

Reward points if useful

Regards

Anji

Former Member
0 Kudos
29

The tables that would intrest you are,

VBAK - Header sales,

VBAP - Line item sales,

KNA1, KNVV, KONV, KONA.

Shreekant