on 04-04-2007 11:47 AM
hi,experts
i want to know the tables and the fields name in which we can see the cust code,name of party,address,total qty,uom,tin no,invoice no.,total invoice amount(without tax),excise duty/cess,total taxbale amount,sale tax amount ,sale tax percentage, lst& cst
Hi Prem,
Important Tabels in SAP Sales and Distribution
T.Code : SE11/ SE16 -->
Sales and Distribution Module Related Tables:
Cycle : Inquiry --> Quotation --> Sales Order --> Delivery ( Picking, Packing, Post Goods Issue and Shipment) --> Billing to FI
Tabel Name Description Important Fields
1. VBAK : Sales Document(Header Data) VBELN
2. VBAP : Sales Document(Item Data) VBELN, POSNR, MATNR, ARKTX, CHARG
Inquiry, Quotation, Sales Order are Differentiated based on Doc Type (VBTYP - Field) in VBAK, VBAP Tables ( For Inquiry VBTYP = A, For Quotation 'B' and for Order it is 'C'.
3. VBEP :Sales Document(ScheduleLine Data) VBELN , POSNR, WMENG, ETENR, ETTYP, EDATU
4.VBKD : Sales Document Businees Data
5.VBUV : Sales Document Incompletion Log
6. VIVEDA :Sales Document Header Item Data
7.VBAP_VAPMA: Access to Item Info via Material Index
8.KONH : Conditions (Header)
9.KONP : Conditions (Item)
10.KONV : Conditions (Transaction Data)
11.KOND : Conditions (Data)
8. LIKP : Delivery Table ( Header Data) VBELN, LFART, KUNNR, WADAT, INCO1
9. LIKS : Delivery Table ( Item Data) VBELN, POSNR, WERKS, LGORT, MATNR, VGBEL
( LIPS - VGBEL = VBAK - VBELN, LIPS - VGPOS = VBAP - POSNR )
10. VTTK : Shipment Table ( Header Data ) TKNUM
11. VTTP : Shipment Table ( Item Data ) TKNUM, TPNUM, VBELN
( VTTP - VBELN = LIKP - VBELN )
12. VTFA : Shipping Document Flow TKNUM, VBELV, VBELN
13. VTPA : Shipping Partners Data VBELN, PARVW, KUNNR, PERNR
14.VTTS : Stages in Shippment TKNUM, TSNUM, TSTYP
15.VTSP : Transport Stage / Shipment Item Allocation TKNUM,TSNUM, TPNUM
16.VEKP : Handling Unit : Header VENUM, VSTPL
17.VEPO:Packing: Handling Unit Item (Contents) VENUM, VEPOS, VBELN
18.VBRK : Billing Table ( Header Data) VBELN, FKART, BELNR
19.VBRP : Billing Table ( Item Data) VBELN, POSNR, FKIMG, NETWR, VGBEL, VGPOS
( VBRP - AUBEL = VBAK - VBELN, VBRP - VGBEL = LIKP - VBELN )
Note : Apart from these Tabels there are lot of other tables which starts with ' V ' but we use the Following Tables Frequently
20.VBUK : All Sales Documents Status & Admn. Data ( Header ) ( VBELN, VBTYP )
VBTYP = ' C ' ( Sales Order ) VBTYP = ' J ' ( Delivery ) VBTYP = ' M ' ( Invoice )
21.VBUP : Sales Document Status & Admn . Data ( Header ) ( VBELN, POSNR )
22.VBKD : To get Sales Related Business Data like Payment Terms etc. ( VBELN, ZTERM )
23.VBFA : Sales Document Flow Data ( VBELN,
Hope this will helps you.Please reward if really helpful,
Thanks and Regards,
Sateesh.Kandula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prem,
VBFA Document flow (alg.)
VTFA Flow shipping documents
Sales order:
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
Billing document:
VBRK header data
VBRP Item data
Shipping:
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)
Delivery:
LIKP Delivery header
LIPS Delivery item
Pricing:
KONH Conditions header
KONP Conditions items
KONV Procedure (billing doc or sales order)
KOND
Contracts:
VEDA Contract data
*It solves ur issue, reward points
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.