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

[SAP EWM] Batch job to reprocess the failed queues in SMQ1 and SMQ2

Reports RSQOWKEX/RSQIWKEX can be scheduled as a periodic background job to reset the status of LUWs registered to outbound(SMQ1)/inbound(SMQ2) queues. RSQOWKEX for outbound queues (SMQS/SMQ1). RSQIWKEX for inbound queues (SMQR/SMQ2). The below parameters are to be maintained : Queue Name as '*' Select 'No Running Queues' Do not select 'No Retry queus' Queues running longer than  < Time in Mins > ideally 20 mins No queues older than < Data > Note that this job will change the status of the failed queue to 'READY' status so that scheduler will process it. But for any queues struck in 'READY' status, th ese need to be processed manually.

[SAP SD] Mass deletion of deliveries in SAP

If there is the requirement for collective deletion of Outbound deliveries in standard, the following can be performed. Transaction VL10* with corresponding user role settings can meet this requirement. Go to VL10*, only flag indicator 'With Deliveries' in 'Data Selection' column in User Role After flagging above indicator, go into the following screen. Then flag indicator of 'Add to delivery', and fill the delivery numbers or other parameters into corresponding fields and then execute In the display screen, select the lines and click 'Delete' button

Stock Inconsistency Reports

Report: RM07KO01 - Stock consistency check between ML and IM Description : With the Stock Consistency Check report (RM07KO01), you can check the consistency of your stock data at company code level, valuation level, or material level. Possible errors in your stocks can thus be determined at an early stage before they cause major problems Transaction Code : CKMC - Consistency check between Material Master and Material Ledger