Where to get the Sold-to Party's description?

[Former Member]

Hi Friends,

I have a question:

Where to get the Sold-to Party's description? (not name) I mean in which table and field?

Thanks a lot!

[Former Member]

KNA1 table

[Former Member]

Dear Firend,

check this VBPA table for sold to party address.

PARVW is the field to check sold to party or ship to party based on conditions.

Pass this customer number KUNNR to KNA1 table and get the details.

Regards,

K.S.Kannan.

Edited by: kannan ks on Dec 16, 2008 3:28 PM

[GauthamV]

KNA1-MCOD1.

[Former Member]

Hi,

check the table kna1.

[Former Member]

Hi,

The table is VBAK and the field is kunnr(sold to party).

if u want to select it from master data then you can use the table KNA1

Hope it helps.

Regards,

Rahul

Edited by: Rahul Kumar Sinha on Dec 16, 2008 11:03 AM

[ThomasZloch]

Or maybe TPART-VTEXT? Let's keep guessing...

Thomas

[jaheer_hussain]

Hi,

select single * from kna1 where

kunnr = vbak-kunnr.

select single * from adrc where addrnumber = kna1-adrnr.

itaback-kunnr = kna1-kunnr.

itaback-name = adrc-name1.

Adrc-name1 is the description of sold to party...

with Regards,

Jaheer

[Former Member]

huh! sold-to-party description?

[Former Member]

Hi,

KNA1 - General Data in Customer Master

KNVV - Customer Master Sales Data

ADRC - Addresses (Business Address Services)

These are main tables from where you can get all basic fields.

For ADRC table you need to take ADRNR from KNA1 and need to map with ADRC.

-Maharshi

[dev_parbutteea]

Hi,

You have to use table TPART-VTEXT to get description of partner function - sold-to.

Thanks and Regards,

Dev.