SD related tables and structures
Purpose
This page will discuss SAP tables and structures used in SAP Sales and Distribution. This can be used as a ready reference for writing FS or for data analysis.
- Transaction code: SE16N can be used to view data in Table
- Transaction code: SE11 can be used to view Table structure
Sales Document
Table/Structure | Description |
VBAK | Sales Document: Header Data |
VBAP | Sales Document: Item Data |
VBKD | Sales Document: Business Data/Sales district data |
VBPA | Partners |
VAKPA | Partner index |
VBFA | Document Flow |
VBEP | Sales Document: Schedule Line / Data related to line items, delivery lines |
VBAKUK | Sales Document: Header and Status Data |
VBUP | Sales Document: Item Status |
VBUK | Header Status and Administrative Data |
VBBE | Sales Requirements: Individual Records |
VBBS | Summarized requirements |
VBUV | Incompletion log |
VBLB | Forecast delivery schedules |
VMVA | Matchcodes |
VEDA | Contract Data |
VBKA | Sales activity |
Outbound Delivery Document
Table/Structure | Description |
LIKP | Delivery Document: Header data |
LIPS | Delivery Document: Item data |
Shipping and Transportation Management
Table/Structure | Description |
VTTK | Shipment header |
VTTP | Shipment item |
VTTS | Stage in transport |
VTSP | Stage in transport per shipment item |
VTPA | Shipment partners |
VEKP | Handling Unit – Header Table |
VEPO | Packing: Handling Unit Item – Contents |
Customer Billing Document
Table/Structure | Description |
VBRK | Billing: Header data |
VBRP | Billing: Item data |
Customer Master
Table/Structure | Description |
KNA1 | Customer Master: General Data |
KNB1 | Customer Master: Company Code Data |
KNB4 | Customer Payment History |
KNB5 | Customer Master: Dunning data |
KNBK | Customer Master: Bank Details |
KNBW | Customer Master: Wwithholding tax types |
KNKA | Customer Master: Credit Mgmt. |
KNKK | Customer Master: Credit Control Area Data – credit limits |
KNVA | Customer Master: Loading/Unloading Points |
KNVD | Customer Master: Record sales request form/documents |
KNVH | Customer Hierarchies |
KNVI | Customer Master: Tax Indicator |
KNVK | Customer Master: Contact Partner |
KNVL | Customer Master: Licenses |
KNVP | Customer Master: Partner Functions |
KNVS | Customer Master: Shipping Data |
KNVT | Customer Master: Record Texts for Sales |
KNVV | Customer Master: Sales Data |
KLPA | Customer/Vendor Link |
Material Master
Table/Structure | Description |
MARA | General Material Data |
MVKE | Sales Data for Material |
MARC | Plant Data for Material |
MARD | Storage Location Data for Material |
MAKT | Short texts |
MARM | Conversion factors |
MVKE | Sales data – for each sales organization and distribution channel |
MLAN | Sales data – for each country |
MAEX | Export licenses |
MBEW | Valuation data |
MLGN | Warehouse management inventory data |
MLGT | Warehouse management inventory type data |
MVER | Consumption data |
MAPR | Pointers for forecast data |
MCHA | Batches |
MCH1 | Cross-plant Batches |
MCHB | Batch stocks |
KNMTK | Header table – for increased performance |
KNMT | Data table |
Bill of Material (BOM)
Table/Structure | Description |
MAST | Material assignment to BOM |
EQST | Equipment assignment to BOM |
KDST | Sales order assignment to BOM |
DOST | Document assignment to BOM |
STST | Standard object assignment to BOM |
TPST | Functional location assignment to BOM |
STKO | BOM header data |
STZU | Time-independent STL data |
STAS | BOM item selection |
STPO | BOM item data |
STPU | BOM sub-item data |
Sales and Purchasing Pricing
Table/Structure | Description |
KOMK | Pricing Communications: Header (Structure) |
KOMP | Pricing Communication: Item (Structure) |
KONV | Conditions: Transaction Data |
KONP | Conditions: Item |
KONH | Conditions: Header |
KOND | Contracts |
VEDA | Contract Data |
Output
Table/Structure | Description |
NAST | Output: Message Status |
Text
Table/Structure | Description |
STXH | Texts: Header |
STXL | Texts: Line |