Sales and Distribution SD

Top Tables 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 Databases ALV PSJ VLV.
LIKPUKView: Delivery Header + Status Data
VBAK Sales Document: Header Data In Logical Databases 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 Databases 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 Databases AAV SD_ORDER SD_SALES_DOCUMENT VAV.
VBFA Sales Document Flow In Logical Databases AAV AKV ALV ARV SD_ORDER SD_SALES_DOCUMENT VAV VC1 VFV VLV.
VBKA Sales Activities In Logical Databases AKV VC1 VC2.
VBKD Sales Document: Business Data In Logical Databases AAV PSJ SD_ORDER SD_SALES_DOCUMENT VAV.
VBPA Sales Document: Partner In Logical Databases AAV AKV ALV ARV SD_ORDER SD_SALES_DOCUMENT VAV VC1 VFV VLV.
VBUK Sales Document: Header Status and Administrative Data In Logical Databases AAV AKV ALV ARV PSJ SD_ORDER SD_SALES_DOCUMENT VAV VFV VLV.
VBUV Sales Document: Incompletion Log In Logical Databases AAV AKV SD_ORDER SD_SALES_DOCUMENT VAV.
VEDA Contract Data In Logical Databases 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 Databases ERM PSJ SD_SALES_DOCUMENT. Category (FPTYP)=0 for Billing plan in SD
KOMK Communication Header for Pricing
KOMP Communication Item for Pricing
KONP Conditions (Item) In Logical Databases ERM ILM V12L.
VBRK Billing Document: Header Data In Logical Databases ARV VFV VXV.
VBRKUKBilling Document Header and Status Data
VBRP Billing Document: Item Data In Logical Databases 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 Databases 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 Databases BRF DDF SD_KUSTA VC1 VC2 VDF WTY.
KNB1 Customer Master (Company Code) In Logical Databases BRF DDF VDF.
KNB4 Customer Payment History In Logical Databases BRF DDF.
KNB5 Customer master (dunning data) In Logical Databases BRF DDF.
KNBK Customer Master (Bank Details) In Logical Databases BRF DDF.
KNKA Customer master credit management: Central data In Logical Database DDF.
KNKK Customer master credit management: Control area data In Logical Databases 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 Databases SD_KUSTA VC1 VC2.
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions In Logical Databases SD_KUSTA VC2.
KNVS Customer Master Shipping Data
KNVV Customer Master Sales Data In Logical Databases 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 Databases BRF DDF SD_KUSTA VC1 VC2 VDF WTY.
KNB1 Customer Master (Company Code) In Logical Databases BRF DDF VDF.
KNB5 Customer master (dunning data) In Logical Databases BRF DDF.
KNVD Customer master record sales request form
KNVP Customer Master Partner Functions In Logical Databases SD_KUSTA VC2.
KNVV Customer Master Sales Data In Logical Databases SD_KUSTA VC1 VC2.

Material Management-Link for Sales and Distribution     

TableTable - NameS/4HANA -Table and general Notes
MAKT Material Descriptions In Logical Databases MMIMRKPFRESB S1L S2L.
MARA General Material Data In Logical Databases /SAPSLL/CUSMSM BAM BKM BMM CKM EBM ECM ENM ESM IFM S1L WTY.
MARC Plant Data for Material In Logical Databases /SAPSLL/CUSMSM S1L.
MARD Storage Location Data for Material In Logical Databases /SAPSLL/CUSMSM MSM.
MARM Units of Measure for Material In Logical Database MSM.
MBEW Material Valuation In Logical Databases /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 Databases AAV AKV ALV ARV ERM.
SADR Address Management: Company Data In Logical Databases 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
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
NRIV Number Range Intervals


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    RE-FX    RE-FX-LA    MM    MM-PUR    QM    PM    PP    PP-PI    PS    PA    






Book recommendations    




Logistics with SAP S/4HANA