Regarding Table management

[Former Member]

Hi All..

A customer will place an order for few items to a company.

Company will make sales order, which will contain the customer name and items list and their price.

Is there any table, which will store the sale order data..??

If so, how the system will assign the number of items (say 10) with one customer..???

If we want a report reflecting the details of items per customer, how to fetch the data..????

How this type of data is maintained in the database tables..??

Please give your ideas/suggestions....

Regards

Pavan

[Former Member]

hi,

Sales order header data is stored in VBAK Table

for items, refer to VBAP

[Former Member]

Hi

Please check this link

http://www.erpgenie.com/sap/abap/tables.htm

And if you click on SD Tables you will see the linkage and details of what you require

[Former Member]

Hi pavan,

KNA1 hold the customer info.KUNNR is the key.

Sales Order Master Table

VBAK-KUNNR --- Hold the customer info

Example:

SELECT SINGLE * FROM kna1 WHERE kunnr = vbak-kunnr.

Then you got the detail.