Ads

SAP Sales and Distribution(SD) Tables

-

SAP Sales and Distribution(SD) Tables

These are very useful SD modules tables list for functional and technical consultants in SAP.
SAP SD (Sales and Distribution) is one of the worth noting modules of SAP ERP. It defines all the information regarding customer and services. In an organization, it deals with shipping, selling and transportation of goods and services.

SAP SD is specially designed to facilitate the following business processes in an enterprise:
Customer Master and Material Master data
Sales Orders
Deliveries
Pricing
Billing
Credit Management

SD Important Tables 


KNVD : Output type
KNVS : Customer Master Ship Data
KLPA : Customer/Vendor Link
VBUK : Header Status and Administrative Data
VBAK : Sales Document – Header Data
VBKD : Sales Document – Business Data
VBUP : Item Status
VBAP : Sales Document – Item Data
VBPA : Partners
VBEP : Sales Document Schedule Line
VBBE : Sales Requirements: Individual Records
LIPS : Delivery Document item data, includes referencing PO
LIKP : Delivery Document Header data
VBRK : Billing Document Header
VBRP : Billing Document Item
VEKP : Shipping Unit Item (Content)
VEPO : Shipping Unit Header
KNA1 : General Data
KNB1 : Customer Master – Co. Code Data (payment method, reconciliation acct)
KNB4 : Customer Payment History
KNB5 : Customer Master – Dunning info
KNBK : Customer Master Bank Data
KNKA : Customer Master Credit Mgmt.
KNKK : Customer Master Credit Control Area Data (credit limits)
KNVV : Sales Area Data (terms, order probability)
KNVI : Customer Master Tax Indicator
KNVP : Partner Function key
VBFA : Document Flow

Sales tables 

VAPMA - Sales Index: Order Items by Material
VAKPA - Sales Index: Orders by Partner Function
TVAK - Sales Document Types
VEPVG - Delivery Due Index
VKDFS - SD Index: Billing Initiator
VBAK - Sales Document: Header Data
VBAP - Sales Document: Item Data
VBKD - Sales Document: Business Data
VBEP - Sales Document: Schedule Line Data
VEDA - Contract Data
TVAUT - Sales Documents: Order Reasons: Texts
VBLB - Sales document: Release order data
TVLVT - Release order usage ID: Texts
VBUV - Sales Document: Incompletion Log
TVAP - Sales Document: Item Categories

Billing tables 

VBRK - Billing Document: Header Data
VBRP - Billing Document: Item Data
KNVI - Customer Master Tax Indicator
TVCPF - Billing: Copying Control
A147 - Customer Hierarchy (Sales Deal)
A149 - Customer-dependent data determination
FPLTC - Payment cards: Transaction data - SD
TVFK - Billing: Document Types
VRKPA - Sales Index: Bills by Partner Functions
VBREVE - Revenue Recognition: Revenue Recognition Lines
A399 - Withholding tax code - country-specific
A145 - Sales Deal - Customer/Material
A148 - Product Hierarchy
A144 - Sales Deal Basic Data
A146 - Customer Hierarchy

Basic Functions tables 


TNAPR - Processing programs for output
VBUP - Sales Document: Item Status
KNMT - Customer-Material Info Record Data Table
T180 - Screen Sequence Control: Transaction Default Values
KNVH - Customer Hierarchies
VBFA - Sales Document Flow
VBPA - Sales Document: Partner
VBUK - Sales Document: Header Status and Administrative Data
FPLA - Billing Plan
VBSK - Collective Processing for a Sales Document Header
TVTA - Organizational Unit: Sales Area(s)
TVM1T - Material pricing group 1: Description
VBBE - Sales Requirements: Individual Records
TVKO - Organizational Unit: Sales Organizations
FPLT - Billing Plan: Dates

Sales Support tables 


VKAWV - Sales Activities by Follow-up Date
VBKA_KONTAKTE - Generierte Tabelle zu einem View
V_T182C - Generierte Tabelle zu einem View
VBKA - Sales Activities
VBRP_VRPMA - Generated Table for View
VBAP_VAPMA - Generated Table for View
LIPS_VLPMA - Generierte Tabelle zu einem View
TVC6 - Sales Activity Status Groups
VKAOF - Sales Index: Open Sales Activities
SADLVBKA - Generierte Tabelle zu einem View
SADLVBKA2 - Generierte Tabelle zu einem View
TVC5 - Sales Activities: Allowed Statuses by Status Group
SADLSTRECB - Dynamic Part of Address List (Record Body)
V_TINPA - Generierte Tabelle zu einem View
TKSF - Value Table: Statistics Grp for Sls Activ. Procg in Header

SD General tables

VBAK - Sales Document: Header Data
VBAP - Sales Document: Item Data
VBRK - Billing Document: Header Data
VBPA - Sales Document: Partner
VBEP - Sales Document: Schedule Line Data
KONP - Conditions (Item)
VBUK - Sales Document: Header Status and Administrative Data
E000 - Condition Table for Rebate $
TNAPR - Processing programs for output
VBUP - Sales Document: Item Status
VEDA - Contract Data
KONA - Agreements
VBRP - Billing Document: Item Data
VBFA - Sales Document Flow
VBKD - Sales Document: Business Data.

SAP SD Tables ,SD Tables ,SD Modules and Sales and Distribution module in SAP.

 SAP Material Master(MM) Module Tables
SAP Vendor Master tables

SAP CRM Tables 
SAP Master Data Tables
SAP Transactions Codes List
How to start SAP ABAP
SAP Technical and Functional Modules List 
SAP Storage Location Table 


Comments

Post a Comment

Popular posts from this blog

BADI Interview Questions in SAP ABAP

-
BADI Interview Questions in SAP ABAP A BAdI is an object-oriented enhancement option, which makes it the most sophisticated enhancement type. The main characteristic of a BAdI is that it provides a mechanism to change the functionality of a well-defined business function without making changes to the delivered source code. Future upgrades of the original business function can be applied without losing the customer-specific enhancements or the need to merge the changes.  If you want to become a professional and technical blogger practically, read these real-world practical SAP ABAP books . These books will help you to become a more flexible coding developer in future SAP technology. What is a BADI in SAP? BADI (Business Add-In) is a new SAP Object Oriented enhancement technique that is used to add our own business functionality to the existing SAP standard functionality.  BADI follows the Object-Oriented approach to make them reusable. A BADI can be used any number of times
Read more

Sample SAP ABAP Programming Examples for Practice

-
Sample SAP ABAP Programming Examples for Practice Are you a beginner at ABAP Language, you're looking for example programs for practice. Here I collected some sample programs from various objects in ABAP that are useful for beginners to improve their Technical skills. To familiar with coding and ABAP applications, you must be practice all applications. As per my experience, practice makes you perfect, as a technical consultant, should be ready to develop any object based on the need of the client, then only, we will get appreciation from the client and from our team side and it helps us to develop complex objects in SAP. ABAP Syntax ABAP Statements ABAP Program Types SAP ABAP Workbench Tools SAP Modules SAP Transaction Codes SAP Tables SAP ABAP Hello world Program Example ABAP- Simple ALV report Example ABAP- Interactive ALV Report Example ABAP- BDC Call Transaction Method Programming ABAP- BDC Session Method Programming Example ABAP- Smartforms
Read more

Module Pool Programming Interview Questions and Answers in SAP ABAP

-
Module Pool Programming(Dialog Programming)  Interview Questions and Answers in SAP ABAP As an ABAP Consultant, you should be strong in Module pool programming techniques as well as when you face the real-time or fresher interview, Questions, and answers to test your talent to select for the interview. For that purpose, I am sharing my interview experiences in which I faced the most of the times on these topics that are at exit command, events difference between set screen and call screen difference between call screen and set screen in module pool,chain-end chain in module pool. What is the transaction code for the screen painter? SE51. What is the transaction code for Menu painter? SE41. What is the transaction code for the screen painter? SE93. What are the main components of dialog programs? Screens Module pools Subroutines Menus Transactions What is Screen flow Logic? The screen flow logic is like an ABAP program in that it serves as a
Read more

Step by Step tutorial on BDC Session Method Program in SAP ABAP

-
Image
Step by Step tutorial on BDC Session Method Program in SAP ABAP BDC Session Method is used to upload data from Non-SAP to SAP System. Using Session method, we can transfer data through more than one Transaction, Unlike BDC Call Transaction Method Program . We are Processing Batch input Session From SM35 Transaction Code. Session method. 1) synchronous processing. 2) can transfer a large amount of data. 3) processing is slower. 4) error log is created 5) data is not updated until the session is processed. Call transaction Method. 1) asynchronous processing 2) can transfer a small amount of data 3) processing is faster. 4) errors need to be handled explicitly 5) data is updated automatically Go to SHDB and Press Enter Click on New Recording Button and Give the zrecord1 name and enter transaction code MM01 and click on the Start recording button. The system goes to the Create material screen, there give the industry sector and material type and selects ba
Read more

SAP ABAP Interview Questions and Answers for 10 Years Experienced

-
SAP ABAP Interview Questions and Answers for 10 Years Experienced This post will helpful for SAP ABAP experienced candidates who may have 3,4 5, 6,7, and 10 years of experience, all of them can be follow this interview pattern for their successful interview.  SAP Data Dictionary Realtime Interview Questions SAP BDC Realtime Interview Questions SAP ALV Reports  Real-time Interview Questions Module Pool Interview Questions SAP Smartforms Realtime Interview Questions SAP BADI Realtime Interview Questions SAP BAPI Realtime Interview Questions SAP  IDOC Realtime Interview Questions ABAP Check and Value Table Questions SAP SD MM FICO Flow Interview Questions SAP OOPs Realtime Interview Questions SAP OOPs Part One  Real-time Interview Questions SAP OOPs Part two Real time Interview Questions SAP OOPs Part three Realtime Interview Questions SAP OOPs Part four Realtime Interview Questions ABAP  Realtime Interview Questio
Read more