topic Re: Regarding Table management in Application Development and Automation Discussions

Regarding Table management

Former Member — Wed, 06 Dec 2006 09:00:07 GMT

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 — Wed, 06 Dec 2006 09:01:59 GMT

hi,

Sales order header data is stored in VBAK Table

for items, refer to VBAP

Former Member — Wed, 06 Dec 2006 09:07:50 GMT

Please check this link

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

Former Member — Wed, 06 Dec 2006 09:10:57 GMT

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.