About SAP

Learn About SAP from my SAP Consultant experiences

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. icon smile SAP SD Tables



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

There are no comments related to SAP SD Tables