SAP SD Tables
SD related tables and structures
Let’s Connect with our Senior SAP Expert for Free Consultation
SAP SD Tables
SD related tables and structures
Purpose
This page will discuss SAP SD 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 |
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: Withholding 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 |