Important Tables In Sales
Sales documents are â€œscatteredâ€ in a number of different tables. While inquiry, quotation and sales order use pretty much the same tables, delivery and billing documents have separate tables where their data is stored. Letâ€™s list the most important tables here and view the lesson to get the detailed information on the importance of these tables. You will see the structure of these tables and the fields most commonly used in sales documents.
VBAK table stores important information about inquiry, quotation and sales order header data. Header data is applied to the entire document, so it cannot be maintained as different on item level. Most of the header data is about the customer, document itself, type of document, sales area, and many more.
VBAP table is a child table of VBAK and contains inquiry, quotation and sales order item level data. This information is maintained for every item separately. These are material number, item category, batch, quantities, rejection reason data and many more.
LIKP table contains header level data for a delivery. Some important fields in this table are sales organization, shipping point, delivery type, loading date, incoterms, route, shipping conditions.
LIPS table is a child table of LIKP and contains item level data for a delivery document. It contains information about material, item category, delivering plant, storage location, batch, quantities.
VBRK contains header level data for a billing document. It stores information like billing type and category, document category, document currency, sales area, pricing procedure, shipping conditions, billing date, posting period, fiscal year etc.
VBRP is a child table to VBRK, it contains data on item level for a billing document. It stores the information on materials and quantities, net value, item category, product hierarchy etc.
KONV is a table that is important for more documents, it contains conditions for transaction data. It contains information on condition type used in a sales document, its pricing date, condition base value, amount, condition value, currency etc.
Knowing these tables and the data within helps you understand how the system works in the background and can help you create your custom reports or look up for any data you need without searching through separate documents one by one.