cancel
Showing results for 
Search instead for 
Did you mean: 

experts

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

reazuddin_md
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Please send me my required fields and related tables names.