Ship to party name in Sales Order

[Former Member]

Hello all. I created a sales order. I saw the technical information of a Ship-party in a sales order. It is a structure KUAGV. Field is TXTPA. I want to know the real database table this information came from. Your help will be appreciated.

Shirish

[Former Member]

hi,

the field in sales order can be found in vbak table and then u can join it wid kna1, knvv to get the necessary info.

saurabh

[Former Member]

Hey AJ

I know I have not framed my question properly about ship to party. I want to know from where does the name of the ship-to party comes from in Sales Order. I have re-checked the structure. It is KUWEV. Feild name is TXTPA. In the functional specs can I give to KNA1-NAME1.

[Former Member]

Thats right Kumar,

Customers Name comes from KNA1.

REgards,

Ajai.

[Former Member]

Sorry folks the structure is KUAGV. Field is NAME1. Help me out here.

[Former Member]

Kumar,

That is "Display text for partners (name, city, country, street)".

The data comes from the address table ADRC and Customer master table KNA1.

The key between these two tables is ADRC-ADDRNUMBER and KNA1-ADRNR.

Hope this helps you.

Regards,

Ajai.