SD table required

[Former Member]

Hi,

Plz tell me from which table I can extract the sales order number, sales order stock for a particular line item (material). Also tell me the important SD tables.

Thanks,

Sachin

Edited by: Sachin PP on Dec 5, 2008 7:05 AM

[Lakshmipathi · Accepted solution]

Dear Sachin

Check this link

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

thanks

G. Lakshmipathi

[Former Member]

Thanks all for the help. I am closing the thread.

[Former Member]

Dear Sachin,

--> To extract Sales Order Number:

Table-Field: VBAK-VBELN

--> To Check, sales order stock for a particular line item

Table: VBUP - Sales Document: Item Status

To check Important Tables in SD, Please refer:

[Imp SD Tables|http://www.sap-img.com/sap-sd/important-tables-for-sap-sd.htm]

[Imp. SD Tables|http://abaplovers.blogspot.com/2008/02/table-description-vbakuk-sales-document.html]

[SAP Table Relation|http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF]

Best Regards,

Amit

[Former Member]

HI Sachin,

You can extract the sale order number from VBAK table and order quantity from VBAP.

Apart from these there are many other tables like,

KNA1, KONV, LIPS, LIKP, KONP, VBBE, VBEH, VBEP, VBFA etc.

Kindly explore the website sap-img.com

[Former Member]

Hi Sachin,

SD Tables use in mostly are the:This are all main tables in sd.

VBAK Sales document header details

VBAP Sales docuement item details

VBEP Sales document scheduline details

LIKP Delivery header details

LIPS Delivery item details

VBRK Billing header details

VBRP Billing item details

VBUK Header Status and Administrative Data

VBKD Sales Document - Business Data

VBUP Item Status

VBPA Partners

VBFA Document Flow

VBBE Sales Requirements: Individual Records

Regards

Rajen

[Former Member]

Hi

Please check the link

sorry earlier is not working

http://www.erpgenie.com/sd/131-sd-tables-and-their-relationships

Thx.

[Former Member]

Hi

Please check link below

http://www.erpgenie.com/sd/131-sd-tables-and-their-relationships

Thx.

[jignesh_mehta3]

Dear Sachin,

Following are the Sales Order (Sales Document) Tables...

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

You can use any of the above to get the required data...

Hope this helps...

Reward if useful...

Thanks,

Jignesh Mehta