cancel
Showing results for 
Search instead for 
Did you mean: 

What is the table where we find this details

Former Member
0 Kudos

hi gurus

In which table we will find this information like if we enter customer details. Means Number we will find this customer belongs to so and so plant and distribution chain and sales organisation. Which transaction if we enter only customer system automatically shows the details like pant and sales org distribtuion channel. One more thing where these things sotred means which table these data will be storing.

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please check the table of KNVV & KNA1 for the details u required.

The transaction is VA01, sales order creation, where if u enter the customer no, the system will automatically propose a pop up box of regarding the customer's sales area details.

Sales order details are stored in the table of VBAK, VBAP, VBEP

Hope it is useful.

Reward if useful..

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

All the details you require is available in KNVV. You pass the customer number in the selection screen and you will get the details like Sales Org, Dist Channel Division Plant etc.

Thanks

Krishna.

Former Member
0 Kudos

hello, friend.

a simple way is to do any of the following transactions:

XD01, XD02, XD03

VD01, VD02, VD03

now a screen will be displayed and you will enter in field for customer number (even in create mode, assuming the customer has already been created and you wish to extend).

in the same screen, after you have entered the customer number, click on the lower right button 'Customer's Sales Areas'. you will now see all sales areas existing for the customer.

you do not really create a customer in a plant (unlike for a material). but you do make entries in Delivering Plant in the Shipping Tabs of the Sales Area Data in the Customer master.

you can also see these data when you do ABAP queries. more on this if you need. just post again.

regards.

Former Member
0 Kudos

Hi,

You find the required details in KNVV.

Reward if useful.

Thanks,

Pramod

Former Member
0 Kudos

Hi,

Please check table KNVV, you can get details u have asked for.

Regards

Anil