SAP SD Tables
As SAP SD Consultant or as Abaper, knowing SAP SD tables is very important. It is useful while we design a report or create user exit or develop new application that related to sales and distribution module. No need deep understanding, but just little know about function for each SAP SD tables is enough.
Here are some of the SAP SD Tables are often used in the SAP implementation.
Sales / Order Document Tables
VBAK – Sales Document: Header Data
VBAP – Sales Document: Item Data
VBEP – Sales Document: Schedule Line Data
VBKD – Sales Document: Business Data
VBEH – Schedule line history
VBLB – Sales document: Release order data
VBBE – Sales Requirements: Individual Records
VBPA – Sales Document: Partner
VEPVG – Delivery Due Index
VKDFS – SD Index: Billing Initiator
VAPMA – Sales Index: Order Items by Material
VAKPA – Sales Index: Orders by Partner Function
Shipping / Delivery Document Tables
LIKP – SD Document: Delivery Header Data
LIPS – SD document: Delivery: Item data
VTTP – Shipment Item
VTTK – Shipment Header
VBLK – SD Document: Delivery Note Header
VEPO – Packing: Handling Unit Item (Contents)
VEKP – Handling Unit – Header Table
Billing Document Tables
VBRK – Billing Document: Header Data
VBRP – Billing Document: Item Data
VBSK – Collective Processing for a Sales Document Header
VBSS – Collective Processing: Sales Documents
VKDFS – SD Index: Billing Initiator
NAST – Message Status
VRPMA – SD Index: Billing Items per Material
VRKPA – Sales Index: Bills by Partner Functions
Status Tables
VBUK – Sales Document: Header Status and Administrative Data
VBUP – Sales Document: Item Status
Sales Document Flow Tables
VBFA – Sales Document Flow
Condition – SAP SD Tables
KONV – Conditions (Transaction Data)
KONP – Conditions (Item)
Customer Master Data Tables
KNA1 – General Data in Customer Master
KNVP – Customer Master Partner Functions
KNVV – Customer Master Sales Data
KNVD – Customer master record sales request form
KNB1 – Customer Master (Company Code)
KNB5 – Customer master (dunning data)
Material Master Data Tables
MARA – General Material Data
MAKT – Material Descriptions
MARM – Units of Measure for Material
MARC – Plant Data for Material
MVKE – Sales Data for Material
T179 – Materials: Product Hierarchies
MLAN – Tax Classification for Material
STXH – STXD SAPscript text file header
STXL – STXD SAPscript text file lines
Above are list of some SAP SD tables. I will share tables from other SAP modules. See you.
Other people found this article using terms: sap sd tables, SD document: Delivery: Item data, sap sales order index tables, vkdfs vbuk, understanding sd tables, star schema vbap, sd conditions tables, SAP table with transactional sales data, SAP SD Tax classification, abap vapma