Skip to main content

Commonly used Tables in SD

Customer Master Data 

KNA1 - General Data
KNB1 - Company Code Data
KNVV - Sales Area Data
KNVP - Partner Function Data
KNVI - Tax Classification Data

Material Master Data

MARA - Basic Data
MARC - Plant Level Data
MARD - Storage Location Data
MARDH - Storage Location history Data
MVKE - Sales Data
MBEW - Accounting Data
MBEWH - Accounting History Data

Customer Material Info Record

KNMT - Customer-Material Info Record Data Table

Sales Document Data

VBAK - Header Data
VBAP - Item Data
VBEP - Schedule Line Data
VBKD - Business Data
VBUK - Sales Document Status
VBFA - Document Flow
VBPA - Sales Partner Data

Delivery Document Data

LIKP - Header Data
LIPS - Item Data

Billing Document Data

VBRK - Header Data
VBRP - Item Data

Pricng Tables

KONV - Conditions (Transaction Data)

Logic to fetch pricing data from KONV Table

Fetch KNUMV (Condition Number)  from VBAK table and pass onto KONV table to fetch conditions data

Pricing Field Catalog Structures

KOMK - Communication Header for Pricing
KOMP - Communication Item for Pricing
KOMG - Allowed Fields for Condition Structures

Address Tables

ADRC - Addresses (Business Address Services)
ADR2 - Telephone Numbers (Business Address Services)
ADR3 - Fax Numbers (Business Address Services)
ADR4 - Teletex Numbers (Business Address Services
ADR5 - Telex Numbers (Business Address Services)
ADR6 - E-Mail Addresses (Business Address Service)
ADR7 - Remote Mail Addresses (SAP - SAP - Communication)

Logic to fetch Address data from customer Master Data

Fetch ADRNR from KNA1 table and pass ADRNR into above address tables to fetch relevant data

Logic to fetch Address data from Sales, Delivery and Billing Partner Data

Fetch ADRNR from VBPA table and pass ADRNR into above address tables to fetch relevant data


Comments

Popular posts from this blog

M7021 : Deficit of stock relevant error message during Material Document Cancellation

Issue : When posting a Cancellation for a Material Document in transaction MIGO, you see error 'M7021 Deficit of not stock relevant' although the Purchase Order is setup with an Account assignment. Material / Batch is not managed on Stock Level even though material is valuated. Resolution : The issue is due to program bug and require to implement note - 2502183 - Slog: correction for quantity check. This note is applicable for S/4 HANA 1610 (S4CORE 101) and 1709 (S4CORE 102).

Revenue Account Determination - SAP SD

Revenue account determination is one critical integration point between Sales & Distribution and Financial Module. Here on posting a billing document to account, based on this revenue account determination, system determines relevant G/L accounts for revenue posting. As like any other basic function configuration like pricing, its configuration also based on condition technique. The condition technique is used in account determination in order to allocate the correct GL account and account key assigned in the pricing procedure against condition types carries the condition values from SD to FI. IMG -> SD -> Basic Function -> Account Assignment -> Revenue account determination -> Check master data relevant for account assignment. Through check master data relevant for account assignment, one has the opportunity to create account assignment grouping criteria. This grouping criteria provides the system with an extra variable in determ

Determinations in SAP SD

Plant Determination in Sales Order 1st Preference: System fetches Delivering plant from Customer Material Info Record if Plant is not found at this level then system will look into 2nd Preference:   Delivering plant from Customer Master data if Plant is not found at this level then system will look into 3rd Preference : the Delivering plant for Material Master data If business user overwrites Plant at sales document level then this will be given highest preference. Shipping Point Determination Delivering Plant (Based on above conditions) + Shipping Conditions ( Sales Document Type or  Customer Master Data) + Loading Group ( Material Master ) Storage Location Determination Plant + Shipping Point + Storage Conditions ( Material Master )  ( MALA) Plant + Shipping Point + Situation  ( RETA) Route Determination Departure Zone or Country of the Delivering Plant + Destination Zone or Country of the Ship to Party + Shipping Condition from the Customer Master + Transport