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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

sales order details

Former Member

‎2007 May 16 5:40 PM

0 Kudos
87

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

‎2007 May 16 5:41 PM

0 Kudos
58

Hi,

You can use the transaction VA05

Thanks,

Naren

Former Member

‎2007 May 16 7:27 PM

0 Kudos
58

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

‎2007 May 16 8:04 PM

0 Kudos
58

The tables that would intrest you are,

VBAK - Header sales,

VBAP - Line item sales,

KNA1, KNVV, KONV, KONA.

Shreekant