SAP SD (Sales & Distribution) important Table-Part:1

List of Important SAP SD Tables (Sales and Distribution) : list of the most used tables in SAP SD including Customer, Sales Documents, Delivery and Billing.

Delivery Doc Tables
Description
KNA1
Customer Master: General Data
KNB1
Customer Master: Company Code Data
KNB4
Customer Payment History
KNB5
Customer Master: Dunning data
KNBK
Customer Master: Bank Details
KNBW
Customer Master: Withholding tax types
KNKA
Customer Master: Credit Mgmt.
KNKK
Customer Master: Credit Control Area Data – credit limits
KNVA
Customer Master: Loading/Unloading Points
KNVD
Customer Master: Record sales request form/documents
KNVH
Customer Hierarchies
KNVI
Customer Master: Tax Indicator
KNVK
Customer Master: Contact Partner
KNVL
Customer Master: Licenses
KNVP
Customer Master: Partner Functions
KNVS
Customer Master: Shipping Data
KNVT
Customer Master: Record Texts for Sales
KNVV
Customer Master: Sales Data
KLPA
Customer/Vendor Link


Pricing Tables in SAP SD
Description
KOMK
Pricing Communications: Header (Structure)
KOMP
Pricing Communication: Item (Structure)
KONV
Conditions: Transaction Data
KONP
Conditions: Item
KONH
Conditions: Header
KOND
SAP Contracts Table in SAP SD
VEDA
Contract Data
 

Comments

Post a Comment

Popular posts from this blog

New commodity code create in SAP S/4 Hana

Image
Commodity codes are internationally recognized reference numbers. A code describes a specific product when importing or exporting goods. You will use this code on any customs declarations and can find them in the Trade Tariff tool. Before S/4 Hana we can create commodity code by using GUI but from S/4 Hana need to use fiori interface to create commodity code. Let's explore it.   T-Code: /UI2/FLP Launchpad is opening and then select Manage commodity codes Tile. After that need to provide No. Scheme contend and click Go button and then need to click add button. Give commodity code and Description with valid from date to valid To date. After that press save button. That's it, your commodity code is created and now need to assign it against material number. Check /SAPSLL/CLSNR table for commodity code added or not.  Check MARC table stawn field to confirm material level assigned or not.
Read more

INITCAP- First letter of the word Capital in SAP ABAP

In sap abap some times we need to capitalize starting word. In that case we need to use FM. Just use "FI_CONVERT_FIRSTCHARS_TOUPPER" and get the result. Sample: data: P_Sampby type string value 'RAJIB HOSSAIN'. CALL FUNCTION 'FI_CONVERT_FIRSTCHARS_TOUPPER' EXPORTING input_string = P_Sampby SEPARATORS = ' ' IMPORTING OUTPUT_STRING = P_Sampby . Output: Rajib Hossain
Read more

BAPI to Change STO PO/ PO Delivery date in SAP

Image
 In SAP, a BAPI (Business Application Programming Interface) serves as a standardized method to allow external applications or custom code to access and interact with data and processes within SAP business objects, essentially providing a way to "call" specific business functions within the SAP system from outside applications, ensuring data integrity and proper business logic execution through a defined interface. Function: BAPIs enable external applications to read, create, update, or delete data within SAP by interacting with the underlying business object model. Implementation: BAPIs are implemented as function modules in the SAP system, which can be called remotely using the Remote Function Call (RFC) protocol. Business Object Repository (BOR): BAPIs are defined as methods of SAP Business Object Types, which are stored and managed within the BOR.  Benefits:     Standardized Access: Provides a consistent way for external applications to interact with SAP fun...
Read more