Top Table - list SAP © 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. | VKDFS | SD Index: Billing Initiator | Billing index table that the billing due list and invoice list worklists use. An entry is put on this table for every sales document that needs to be invoiced. Once it has been invoiced the entry is removed from this table. | 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, eg 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 | Also transaction S_ALR_87012179. 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 | Also transaction S_ALR_87012179. 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. | KNZA | Permitted Alternative Payer |
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 SAP © 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 |
