How to get Display text for partners (name, city, country, street)

[sudhakara_reddy4]

Hi i have sales order no i need to get text sold-to-party and ship-to-party

if you dispaly the customer in va03, we are having sold-to-pary and ship-to-party and thier text adress. Please tell me how to get that text.

[Former Member]

Hi

U need to check the table for sales order partner VBPA, here u can find the field ADRNR:

- If it's not filled it means the address data are the original data, so u can find them in the master data (KNA1 or LFA1)

- If it's filled it means some address data was changed in the order so u can find them in the table ADRC.

Max

[sudhakara_reddy4]

Hi i have adress no , i want text of that adress. please check va03 transaction you will ship-to-part no and text

[Former Member]

Hi

What do you mean? Which kind of text? Standard text?

Max

[GauthamV]

hi,

check this view.

M_DEBIA.

[sudhakara_reddy4]

i want to Display text for partners (name, city, country, street) filed KUAGV-TXTPA

[Former Member]

Hi

The contenent of the field KUAGV-TXTPA is created at runtime: here the system inserts the address data get from master table: KNA1 and ADRC:

U can use the fm SD_ADDRESS_BUILD in order to know how that field has to be filled

Max

[Former Member]

Hi,

Goto vbpa give vbeln = vbak-vbeln and parvw = 'PY' " for payer

or parvw = 'SH* " for ship-to party

or parvw = 'SP' "for sold to party

or *

Get the kunnr and goto kna1 for the rest details of address....

Regards

Debarshi

[Former Member]

Hi Reddy

Try function module BAPI_CUSTOMER_GETDETAIL2

give the customer number as input (which is displayed in VA03)

Check the "CUSTOMERADDRESS" structure

Regards

Rajvansh

Edited by: Rajvansh Ravi on Nov 19, 2008 11:21 AM

[sudhakara_reddy4]

i build from ADRC table . thank you all