cancel
Showing results for 
Search instead for 
Did you mean: 

Sd Tables

Former Member
0 Kudos

Can any one provide list of SD Tables with the table descripton

Accepted Solutions (0)

Answers (10)

Answers (10)

Former Member
0 Kudos

Sales related

VBAK: Sales Document(Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

VTTK: Shipment Table (Header Data)(TKNUM)

VTTP: Shipment Table (Item Data)( TKNUM,TPNUM,VBELN)

(VTTP-VBELN = LIKP-VBELN)

VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

Apart from these tables there are lot of other tables which starts with

‘V’, but we use the following tables frequently.

VBUK: All Sales Documents status & Admn. Data(Header)(VBELN,VBTYP)

VBTYP= ‘C’(Sales Order) VBTYP=’J’(Delivery) VBTYP=’M’(Invoice)

VBUP: Sales Documents status & Admn. Data(Item)(VBELN,POSNR)

VBEP: Sales Doc. Schedule Lines Data(VBELN,POSNR,EDATU,WMENG)

VBKD: To get sales related Business data like Payment terms etc.(VBELN,ZTERM)

VBFA: sales document flow data(VBELV,VBELN,POSNV,VBTYP)

VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

VEDA: Contract Data(VBELN,VPOSN)

VEDAPO: Contract Data(VBELN,VPOSN)

regards,

srinivas

<b>*reward for useful answers*</b>

Former Member
0 Kudos

Hi,

Sales and Distribution:

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 DocumeLIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

Thanks

Hussain

Former Member
0 Kudos

Hi gurus,

how to change payment method for 1000 vendors at a time .plz let me know anybody.

regards ,

priyanka

Former Member
0 Kudos

HI

THE MAIN SD TABLES ARE

Table Description

VBAK- Sale Order Header

VBAP- Sale Order Line Items

LIKP- Delivery Order Header

LIPS- Delivery Order Line Items

VEKP- Shipping Unit Header

VEPO- Shipping Unit Line Items

EIKP- Foreign Trade: Header

EIPO- Foreign Trade: Line Items

VBRK- Billing Header

VBRP- Billing Line Items

VBUK- Sale Document Status Header

VBUP- Sale Document Status Line Items

VBFA- Document Flow

VBPA- Sale Document Partner

KONV- Pricing Condition

THE FOLLOWING LINK GIVES THE JOIN CONDITION THAT CAN BE USED FOR THE SD TABLES.

<a href="http://www.sapgenie.com/abap/tables_sd.htm">http://www.sapgenie.com/abap/tables_sd.htm</a>

IF ITS USEFUL PLEASE REWARD POINTS.

REGARDS,

ANOOP

Message was edited by: ANOOP R.S

Former Member
0 Kudos

Hi

6 Sales and Distribution (SD) :

VBFA Document flow (alg.)

VTFA Flow shipping documents

6.1 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

6.2 Billing document :

VBRK header data

VBRP Item data

6.3 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)

6.4 Delivery :

LIKP Delivery header

LIPS Delivery item

6.5 Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

6.6 contracts :

VEDA Contract data

regards

kishore

Former Member
0 Kudos

check for downloads in sap-img.com

there click on SAP tables...u ll get reqiored tables.

Former Member
0 Kudos
jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

Go to Transaction SE11.

In that in database table,press F4.

Click Information system icon at the bottom.

Enter SD in Application component.

Click Right mark.

You will get all the SD tables with description.

Kindly reward points if it helps you.

former_member188685
Active Contributor
0 Kudos

Hi avinash,

Check this link....

http://www.sapgenie.com/abap/tables_sd.htm

Regards

vijay

Former Member
0 Kudos

Hi Avinash,

Have a look at this <a href="http://www.sapgenie.com/abap/tables_sd.htm">SD tables</a>

this gives the name of the tables and the relation between them..

it'll be really helpful..

regards

satesh

Former Member
0 Kudos

Hi avinash,

1. VA is the package where we can find

SD tables.

2.

<b>VBAK Sales Document: Header Data

VBAP Sales Document: Item Data</b>

The above two are the main tables.

PVINX Index of New Sales Documents for Product Proposal

T176T Sales Documents: Customer Order Types: Texts

T661T Difference Tolerances for External and Internal Conditions

TERRF Erroneous Data for First Data Transfer

TVDC Delivery Times:Categories

TVDCT Delivery Times: Texts

TVRMAVK Repair Procedure: Actions

TVRMAVT Repair Procedure: Action Texts

TVSTAT Display/Maintain Status in Sales Overview

TVVFS Variant Matching Procedure: Procedures

TVVFT Variant Determination Procedure: Texts

TVVFZ Variant Matching Procedure: Time Control

VAKGU Sales Index: Quotation Validity

VAKPA Sales Index: Orders by Partner Function

VAPMA Sales Index: Order Items by Material

VBAG Sales Document: Release Data by Schedule Line in Sch.Agrmt.

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBKD Sales Document: Business Data

VBKFZ Cumulative Quantity Corrections

VBLB Sales document: Release order data

VBMUE Sales Document: Characteristic Overview

VBMUET Sales Document: Characteristic Overview Description

VBMUEZ Sales Document: Characteristic Overview Assignments

VBPK Sales Document: Product Proposal Header

VBPV Sales Document: Product Proposal

VBREF SD Object Link to Item References

VBSN Change status relating to scheduling agreements

VBSP SD Document Item for Models of Material Structures

VBUV Sales Document: Incompletion Log

VCRSELA Cross Selling Analysis

VCRSELA_RES Cross Selling Analysis: Results

VEDA Contract Data

VEPVG Delivery Due Index

VKDFS SD Index: Billing Initiator

VLPKM Scheduling agreements by customer material

regards,

amit m.

Former Member
0 Kudos

just go through this ... u can find aal the tables and relation b/w them..

http://www.sapgenie.com/abap/tables_sd.htm