Saravanan

Saravanan

Wednesday, May 30, 2012

SAP SD Tables


What is a Table? How can you view your Table?
A table is nothing but a matirx containing rows and columns which Show the database would handle the data. All tables can be viewed via the SAP data dictionary using transaction code SE11

Table :  Description

Customers:
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
KNVD Output type
KNVS Customer Master Ship Data
KLPA Customer/Vendor Link

Sales Documents:  VBAKUK VBAK + VBUK
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
VBFA Document Flow
VBEP Sales Document Schedule Line
VBBE Sales Requirements: Individual Records

SD Delivery Document :
LIPS Delivery Document item data, includes referencing PO
LIKP Delivery Document Header data

SD Billing Document:
VBRK Billing Document Header
VBRP Billing Document Item

SD: Shipping Unit
VEKP Shipping Unit Item (Content)
VEPO Shipping Unit Header
 -------------------------------------------------------------------------------------------------------------
SD Transaction Code Flow:

Inquiry / Document type IN
Tcode for creation VA11,VA12,VA13. tables VBAK, VBAP

Quotation / QT
Tcode for creation VA21,VA22,VA23. tables VBAK, VBAP

Purchase Order PO
Tcode for creation ME21,ME22,ME23. tables EKKO, EKPO.

Sales Order OR
Tcode for creation VA01,VA02,VA03. tables VBAK, VBAP

Delivery LF
Tcode for creation VL01,VL02,VL03. tables LIKP, LIPS

Billing MN
Tcode for creation VF01,VF02,VF03. tables VBRK, VBRP

To create a sales order we need purchase order number and custmer number
Before that, to create a purchase order we need to have material no, vendor no.

To create vendor tcode is
xk01(create), xk02(change) , xk03(display)
Tables are LFA1.

To create custmer tcode is xd01, xd02, xd03.
Table is KNA1. 

1 comment:

  1. Very informative. Good Job.
    SAP-SD (Order Fulfillment) is one of the most important modules in SAP Software.
    http://eonlinetraining.co/course/sap-sd-online-training/

    ReplyDelete