Top SAP © Tables Sales and Distribution Module SD
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11
Sales Documents
| Table | Table - Name | S/4HANA -Table and general Notes | LIKP | SD Document: Delivery Header Data | In Logical Database ALV PSJ VLV. | LIKPUK | View: Delivery Header + Status Data | VAKPA | Sales 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
| Table | Table - Name | S/4HANA -Table and general Notes | A005 | Customer/Material | For 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 | KONH | Conditions (Header) | In Logical Database ERM ILM V12L. | KONP | Conditions (Item) | In Logical Database ERM ILM V12L. | VBREVK | Revenue Recognition: Control Lines | VBRK | Billing Document: Header Data | In Logical Database ARV VFV VXV. | VBRKUK | Billing Document Header and Status Data | VBRP | Billing Document: Item Data | In Logical Database ARV VC2 VFV VXV. | VRPMA | SD Index: Billing Items per Material |
Billing Documents Copy Control
| Table | Table - Name | S/4HANA -Table and general Notes | TVCPF | Billing: Copying Control | TVFSP | Billing: Blocking Reasons |
Customer for Sales and Distribution
| Table | Table - Name | S/4HANA -Table and general Notes | ABUSINESSPARTNER | Businesspartner | Only available in S/4. Shows supplier-, customer- and business-partner relationship. | BP001 | FS-Specific Attributes; Organization | General financial services information for the organisation-BP, e.g. for the trading partner. | BUT000 | Business Partner: General data I | Field TYPE for the Business Partner category: 1 = Person, 2 = Organization, 3 = Group. In Logical Database REBP UKM_BUPA. | BUT020 | Business Partner: Addresses | In Logical Database REBP. | BUT100 | Business Partner: Roles | In Logical Database REBP. | CVI_CUST_LINK | Assignment Between Customer and Business Partner | Linked to table BUT000 via the field Partner_GUID. | IBUPACUSTOMER | View for the customer - business partner | Only available in S/4. | 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
| Table | Table - Name | S/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
| Table | Table - Name | S/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
| Table | Table - Name | S/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
| Table | Table - Name | S/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
| Table | Table - Name | S/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
| Table | Table - Name | S/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. To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - Name | S/4HANA -Table and general Notes | T001K | Valuation area | T001L | Storage Locations | T001W | Plants/Branches | T300 | WM Warehouse Numbers | T320 | Assignment IM Storage Location to WM Warehouse Number | T499S | Location | TSPA | Organizational Unit: Sales Divisions | TVBUR | Organizational Unit: Sales Offices | TVBVK | Organizational Unit: Sales Groups per Sales Office | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | TVKGR | Organizational Unit: Sales Groups | TVKO | Organizational Unit: Sales Organizations | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | TVTA | Organizational Unit: Sales Area(s) | TVTW | Organizational Unit: Distribution Channels |
Customizing - Tables To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - Name | S/4HANA -Table and general Notes | C001 | Cust.Grp/MaterialGrp/AcctKey | FI-Accounting determination in SD for invoices. Edit with transaction VKOA. | NRIV | Number Range Intervals | Edit with transaction SNUM. |
Report a missing table or a suggestion for improvement here...
Additional tables for the following modules at Erp-Top.com:
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 AP-MD-BP Top Transaction - List Sales and Distribution Module SD
©Customer for Sales and Distribution
| Transaction | Transaction - Name | Notes | BP | Maintain Business Partner | Menu Extras Create/Change to see the BP grouping used for the Business Partner | MDS_LINKS | Get the Mapped Cust/Vend/BP |
Customizing - Transactions
| Transaction | Transaction - Name | Notes | MMNR | Define Material Master Number Ranges | OMS2 | Maintain Material Types |
