sd tables

[Former Member]

Hi,

I am giving country code in the selection screen.

Based on the country i want to fetch plant and sales organization .

which table i want to use for this.

After getting sales organization i want to fetch the sales order .

regards,

vijay

[Former Member · Accepted solution]

Hi,

For sales ordes Table VBAK

For Sales org/Company code relation table TVKO

Reward points if useful

Regards,

Amrish Purohit

Message was edited by:

AMRISH PUROHIT

[Former Member]

Narayana

Message was edited by:

manam narayana

Message was edited by:

manam narayana

[Former Member]

Thanks for suggestions.

iam able to fetch the WERKS VKORG from the table TVKO.

Now my problem is for sales orders.

how i can fetch the SO for corresponding WERKS and VKORG.

What table i have use for SO.

regards,

vijay

[Former Member]

hi

use VBAK

pl reward if helpful.

Thanks

Sadhu Kishore

[Former Member]

Hi,

You can use T001 to get the company codes for the given country...t001-land1.

Then You can use table T001K, TVKO to get the plants and sales organization for the given company codes..

Thanks,

Sadhu Kishore

[Former Member]

give me ur mail id i will send a mail

[former_member183879]

Table joining country code and plant T001W

Table joining plant and Sales org TVKWZ

Tables joining sales org and sales documents VBAK

Item level details of the sales document VBAP

Schedule line details of sales document VBEP.

So if your requirement is to find out all sales documents for a specific country code, the logic should be

SELECT VBAK-VBELN

WHERE VBAK-VKORG=TVKWZ-VKORG AND

TVKWZ-WERKS=T001W-WERKS

WHERE

T001W-LAND1=ENTERED COUNTRY CODE

But make sure you have only one plant assigned to a country code. If you use many plants for a country, then the documents for all the plants will come up.

There can be another way of coding also where sales order plant equals to the plant of a given country. It solely depends on your purpose and the details you want to have in the report.

Pls lemme know if you need further info.

Reward point if it helps.

You can also download the std tables used in SD from website (just put a search SAP-SD Tables in google)

[Former Member]

Hi

pls refer below

http://www.easymarketplace.de/transactions-n-o.php

[Former Member]

This contains the entire list of tables..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e944e133-0b01-0010-caa2-be2cb240...

Reward points if useful !!!!