Table name for sales order with Customer info

[Former Member]

Hi Gurus,

Could you please provide me table name for sales order with customer no and customer name.

I have list of sales order number (more than 1000 no's ) i need to identify customer number and customer name (ship to party and sold to party information). I am running this report every week. so i plan to create sqvi for this report.

Thanks and regards,

B.Deethya.

[Former Member · Accepted solution]

Hi,

You can use report VA05 or VA05N in this you will get sales order sold to , ship to etc

OR ELSE

Use table VBAK & VBAP

kapil

[jignesh_mehta3]

Hello,

Access Tables VBAK & VBAP.

From the above tables you will get Solt to Party & Ship to Party Codes.

For Customer names you have to pass the Customer Codes to Table - KNA1

Hope this clarifies.

Thanks,

Jignesh Mehta

[Former Member]

solved.

Sqvi report:

Table joins:

VBAK & KNA1