SD Tables

[Former Member]

Hi,

can any one provide me the list of most commonly used std SD tables for functional consultant.

Thank you

Hemant

[Former Member]

Closed

[Former Member]

VBUK - Header Status and Administrative Data

VBAK - Sales Document - Header Data

VBAKUK - VBAK + VBUK

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.

Customer Table Codes in SD

KNA1 - General Data

KNB1 - Customer Master u2013 Co. Code Data (payment method, reconciliation acct)

KNB4 - Customer Payment History

KNB5 - Customer Master u2013 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

Delivery Document Tables in SD

LIPS - Delivery Document item data, includes referencing PO

LIKP - Delivery Document Header data

Billing Document Tables in SD

VBRK - Billing Document Header

VBRP - Billing Document Item

Shipping Unit Tables in SD

VEKP - Shipping Unit Item (Content)

VEPO - Shipping Unit Header

[Former Member]

Hi

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

[Former Member]

Hi,

Bascally you have to know:

Order:

VBAK - Sales Document Header

VBAP - Sales document Item

VBEP - Schedule lines

Delivery:

LIKP - Delivery Header

LIPS - Delivery Item

Billing:

VBRK - Billing Header

VBRP - Billing Item.

Use transaction SE16 or SE11 to view them.

For more details use below link:

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

Regards

[former_member184555]

Hi

VBAK - Sales Document Header

VBAP - Sales document Item

VBEP - Schedule lines

LIKP - Delivery Header

LIPS - Delivery Item

VBRK - Billing Header

VBRP - Billing Item

Thanks,

Ravi

[Lakshmipathi]

Dear Hemant

Please go thru this link

[SAP Table|http://www.erpgenie.com/abap/tables.htm]

thanks

G. Lakshmipathi

[claudia_neudeck]

Hello,

this is a very good link.

Thanks

Claudia

[Lakshmipathi]

Thanks Claudia

[Former Member]

Hi,

Thanks for your reply.its really very good and helpful link.

Hemant