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 |