SAP SD Reference Guide: Tables

For any SAP consultant or power user, a good understanding of the SAP database table structure and underlying relationship is valuable.  When looking for documents, I often find myself navigating to SE16n to review table contents rather than other list transactions.  These also come in handy when constructing SQVI queries:

Note: Click column headers to sort.

Table SAP Desc. Category Long Description
KNMT Cust-Mat’l Inforecord Master Data Customer-Material Inforecord information.  Customer Material Numbers, descriptions, UoM's, etc.
KNA1 Customer Master (General) Master Data General customer information including address
KNVV Customer Master (Sales) Master Data Customer master sales information by Sales Area.
KNA1VV Customer Master (General/Sales) Master Data This is a convenient joined table containing both General and Sales information.
LIKP SD Doc: Delivery Hdr. Data Delivery Delivery Header data
LIPS SD Doc: Item Data Delivery Delivery item data
MARA General material data Materials Material Master general data (Basic Data views)
MARC Plant data for material Materials Material Master plant data
MVKE Sales data for material Materials Material Master Sales data (Sales Org 1, 2 and others)
VBAK Sales Document: Header Sales Documents Sales Document header data
VBAP Sales Document: Item Sales Documents Sales Document line item data
VBEH Schedule Line History Sales Documents Sales Document Schedule Line history
VBEP Sales Doc: Schedule Lines Sales Documents Sales Document Schedule Line data
VBFA Sales Document Flow General Document flow table – you can search for preceding and subsequent documents.  Document category is a handy filtering tool for large flows.
VBPA Sales Document: Partner General Sales Document Partner information
VBRK Bill. Doc: Header Data Billing Documents Billing Document Header data
VBRP Bill. Doc: Item Data Billing Documents Billing Document Item data
VBUK Sales Doc: Header Status General Sales Document Header Status – Helpful for troubleshooting billing and completion issues.
VBUP Sales Doc: Item Status General Sales Document Item Status – Helpful for troubleshooting billing and completion issues.
MARD Storage Location Data for Material Inventory Inventory Levels by material plant and storage location.
MSKA Sales Order Stock Inventory Inventory Levels by material plant storage location batch and Sales Document / Item.
VCRSELA Cross Selling Analysis Cross Selling Table which stores Sales Documents used in Cross Selling Analysis (Program SDCRSL01).
VCRSELA_RES Cross Selling Analysis: Results Cross Selling Table which stores Cross-sold material pairs used during dynamic proposal of cross selling in VA01.
FPLA Billing Plan Billing Table which stores Billing Plan header information along with the assignment to the SD object.
FPLT Billing Plan Dates Billing Table which stores individual Billing Plan date records.  Credit Card transactions are also stored here.

One thought on “SAP SD Reference Guide: Tables”

What say you?

…Husband, Father, SAP Consultant