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.
Very informative. Good Job.
ReplyDeleteSAP-SD (Order Fulfillment) is one of the most important modules in SAP Software.
http://eonlinetraining.co/course/sap-sd-online-training/