Sales and Distribution SD

Top Tables overview for the Sales and Distribution Module SD in SAP©
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11





Sales Documents    

TableTable - NameS/4HANA -Table and general Notes
LIKP SD Document: Delivery Header Data In Logical Database ALV PSJ VLV.
LIKPUKView: Delivery Header + Status Data
VAKPASales Index: Orders by Partner Function
VBAK Sales Document: Header Data In Logical Database AAV CKS CKS_WAO PSJ SD_ORDER SD_SALES_DOCUMENT VAV VC1.
VBAKUK Generated Table for View VBAK & VBUK.
VBAP Sales Document: Item Data In Logical Database AAV CKS CKS_WAO PSJ SD_ORDER SD_SALES_DOCUMENT VAV VC2.
VBBE Sales Requirements: Individual Records
VBDKA Document Header View for Inquiry,Quotation,Order
VBDPA Document Item View for Inquiries,Quotation,Order
VBEP Sales Document: Schedule Line Data In Logical Database AAV SD_ORDER SD_SALES_DOCUMENT VAV.
VBFA Sales Document Flow In Logical Database AAV AKV ALV ARV SD_ORDER SD_SALES_DOCUMENT VAV VC1 VFV VLV.
VBKA Sales Activities In Logical Database AKV VC1 VC2.
VBKD Sales Document: Business Data In Logical Database AAV PSJ SD_ORDER SD_SALES_DOCUMENT VAV.
VBPA Sales Document: Partner In Logical Database AAV AKV ALV ARV SD_ORDER SD_SALES_DOCUMENT VAV VC1 VFV VLV.
VBUK Sales Document: Header Status and Administrative Data In Logical Database AAV AKV ALV ARV PSJ SD_ORDER SD_SALES_DOCUMENT VAV VFV VLV.
VBUV Sales Document: Incompletion Log In Logical Database AAV AKV SD_ORDER SD_SALES_DOCUMENT VAV.
VEDA Contract Data In Logical Database SD_ORDER SD_SALES_DOCUMENT.

Billing and Pricing    

TableTable - NameS/4HANA -Table and general Notes
A005Customer/MaterialFor items get the value in Condition record number (KNUMH) and go to table KONP.
FPLA Billing Plan In Logical Database ERM PSJ SD_SALES_DOCUMENT. Category (FPTYP)=0 for Billing plan in SD
KOMK Communication Header for Pricing
KOMP Communication Item for Pricing
KONHConditions (Header)In Logical Database ERM ILM V12L.
KONP Conditions (Item) In Logical Database ERM ILM V12L.
VBREVKRevenue Recognition: Control Lines
VBRK Billing Document: Header Data In Logical Database ARV VFV VXV.
VBRKUKBilling Document Header and Status Data
VBRP Billing Document: Item Data In Logical Database ARV VC2 VFV VXV.
VRPMASD Index: Billing Items per Material

Billing Documents Copy Control    

TableTable - NameS/4HANA -Table and general Notes
TVCPF Billing: Copying Control
TVFSP Billing: Blocking Reasons

Customer for Sales and Distribution    

TableTable - NameS/4HANA -Table and general Notes
BUT000 Business Partner: General data I In Logical Database REBP UKM_BUPA.
BUT020Business Partner: AddressesIn Logical Database REBP.
BUT100 Business Partner: Roles In Logical Database REBP.
CVI_CUST_LINK Assignment Between Customer and Business Partner
KLPA Customer/Vendor Linking
KNA1 General Data in Customer Master In Logical Database BRF DDF SD_KUSTA VC1 VC2 VDF WTY.
KNB1 Customer Master (Company Code) In Logical Database BRF DDF VDF.
KNB4 Customer Payment History In Logical Database BRF DDF.
KNB5 Customer master (dunning data) In Logical Database BRF DDF.
KNBK Customer Master (Bank Details) In Logical Database BRF DDF.
KNKA Customer master credit management: Central data In Logical Database DDF.
KNKK Customer master credit management: Control area data In Logical Database BRF DDF.
KNVA Customer Master Unloading Points
KNVD Customer master record sales request form
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner In Logical Database SD_KUSTA VC1 VC2.
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions In Logical Database SD_KUSTA VC2.
KNVS Customer Master Shipping Data
KNVV Customer Master Sales Data In Logical Database SD_KUSTA VC1 VC2.

Finance Links for Sales and Distribution    

TableTable - NameS/4HANA -Table and general Notes
COES CO Object: Sales Order Value Line Items
KNA1 General Data in Customer Master In Logical Database BRF DDF SD_KUSTA VC1 VC2 VDF WTY.
KNB1 Customer Master (Company Code) In Logical Database BRF DDF VDF.
KNB5 Customer master (dunning data) In Logical Database BRF DDF.
KNVD Customer master record sales request form
KNVP Customer Master Partner Functions In Logical Database SD_KUSTA VC2.
KNVV Customer Master Sales Data In Logical Database SD_KUSTA VC1 VC2.

Material Management-Link for Sales and Distribution     

TableTable - NameS/4HANA -Table and general Notes
MAKT Material Descriptions Field ‘Material description in upper case’ (MAKTG) for the search. In Logical Database MMIMRKPFRESB S1L S2L.
MARA General Material Data In Logical Database /SAPSLL/CUSMSM BAM BKM BMM CKM EBM ECM ENM ESM IFM S1L WTY.
MARC Plant Data for Material S/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM S1L.
MARD Storage Location Data for Material S/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM MSM.
MARM Units of Measure for Material In Logical Database MSM.
MBEW Material Valuation In Logical Database /SAPSLL/CUSMSM BMM CKA.
MLAN Tax Classification for Material
MVKE Sales Data for Material In Logical Database MSM.
T179 Materials: Product Hierarchies

Sales Documents Copy Control    

TableTable - NameS/4HANA -Table and general Notes
TVAK Sales Document Types
TVASP Sales Documents: Blocking Reasons
TVCPA Sales Documents: Copying Control
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control

Sales Document Item Categories Copy Control    

TableTable - NameS/4HANA -Table and general Notes
T184 Sales Documents: Item Category Determination
TVAPT Sales document item categories: Texts
TVCPA Sales Documents: Copying Control
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control
TVEPZ Sales Document: Schedule Line Category Determination
TVLP Deliveries: Item Categories
TVPT Sales documents: Item categories

Delivery Documents Copy Control    

TableTable - NameS/4HANA -Table and general Notes
T184L Sales Documents: Item Category Determination
TVCPF Billing: Copying Control
TVCPL Deliveries: Copying Control
TVLSP Delivery Blocks

More Sales and Distribution Tables    

TableTable - NameS/4HANA -Table and general Notes
NAST Message Status In Logical Database AAV AKV ALV ARV ERM.
SADR Address Management: Company Data In Logical Database AAV AKV ALV ARV.
T049E Control Data for Swiss ISR Procedure
TNAPR Processing programs for output

Enterprise Structure    Part of the Customizing

TableTable - NameS/4HANA -Table and general Notes
T001KValuation area
T001LStorage Locations
T001W Plants/Branches
T300WM Warehouse Numbers
T320Assignment IM Storage Location to WM Warehouse Number
T499SLocation
TSPAOrganizational Unit: Sales Divisions
TVBUROrganizational Unit: Sales Offices
TVBVKOrganizational Unit: Sales Groups per Sales Office
TVKBZOrg.Unit: Sales Office: Assignment to Organizational Unit
TVKGROrganizational Unit: Sales Groups
TVKOOrganizational Unit: Sales Organizations
TVKWZOrg.Unit: Allowed Plants per Sales Organization
TVTAOrganizational Unit: Sales Area(s)
TVTWOrganizational Unit: Distribution Channels

Customizing    

TableTable - NameS/4HANA -Table and general Notes
C001 Cust.Grp/MaterialGrp/AcctKey FI-Accounting determination in SD for invoices.
NRIV Number Range Intervals Edit with transaction SNUM.

Report a missing table...


Additional tables for the following modules:

FI          FI-GL          FI-AR          FI-AP          FI-BL          FI-AA          CO          CO-OM-CEL          CO-OM-CCA          CO-OM-OPA          CO-PC          EC-PCA          RE-FX          RE-FX-LA          MM          MM-PUR          QM          PM          PP          PP-PI          PS          PA          ABAP          Basis          Cross Module          Business Partner