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 the Condition record number (KNUMH) and go to table KONP. |
| FPLA | Billing Plan | In Logical Database ERM PSJ SD_SALES_DOCUMENT. Category (FPTYP) =0 for the 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 |
|---|---|
| TVCPF | Billing: Copying Control |
| TVFSP | Billing: Blocking Reasons |
Customer for Sales and Distribution
| Table | Table - name | S/4HANA -Table and General Notes |
|---|---|---|
| ABUSINESSPARTNER | Business partner | Only available in S/4. Shows supplier-, customer- and business-partner relationships. |
| 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 | 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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. |
𝐃𝐢𝐬𝐜𝐥𝐚𝐢𝐦𝐞𝐫 – All the post has only been shared for technology-related educational and knowledge-sharing purposes. Information was obtained from the source above and credited to the author or product/service company. There is no endorsement of any products or services.
Content credit goes to https://erp-top.com
Was this article useful?
