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:

Hey, now that you have found your tables, check out my article on how to be an expert table browser using SE16N.

Note: Click column headers to sort.

[table sort=”asc”]

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.
VBKD,Sales Document: Business Data,Sales Documents,Additional Sales Document header values such as incoterms and PO information
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.

[/table]

5 thoughts on “SAP SD Reference Guide: Tables

Add yours

What say you?

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑