SHIP-TO-DESCRIPTION

[Former Member]

hi friends,

i need to retrive ship to description.

for that we need to read tables BSID,VBPA for documnet number vbeln and and partner function PARVW = 'WE'

RETRIVE name1 FOR PARTNER FUNCTION 'WE' AND BILLING DOCUMENT NUMBER

<b>BUT NAME1 FIELD IS NOT THERE IN ABOVE TABLES</b>

PLZ GUIDE ME HOW TO FETCH THE DESCRIPTION

REGARDS,

SIRI

[Former Member]

hi friends,

i need to retrive ship to description.

for that we need to read tables BSID,VBPA for documnet number vbeln and and partner function PARVW = 'WE'

RETRIVE name1 FOR PARTNER FUNCTION 'WE' AND BILLING DOCUMENT NUMBER

<b>BUT NAME1 FIELD IS NOT THERE IN ABOVE TABLES</b>

PLZ GUIDE ME HOW TO FETCH THE DESCRIPTION

REGARDS,

SIRI

[Former Member]

Get VBPA-KUNNR and then First get the ADRNR number from KNA1-ADRNR where KNA1-KUNNR = VBPA-KUNNR and then goto ADRC-ADRNR to get the details like name1 , name2 etc.

Cheers

VJ

Message was edited by: Vijayendra Rao

[Former Member]

Hi,

Even though its a ship-to-party, the record is also maintained in KNA1 hence look for NAME1 field in table KNA1.

Reward if helpful.

Regards

[Former Member]

Hi Sireesha,

once you have Kunnr (ship to party),go to table KNA1 with that KUNNR and get the NAME1 from KNA1 table, that will give the Description.

Regards

vijay

[Former Member]

I think you need to read vbpa with the document number and from that fetch the address number...using the address number read table ADRC to get the details.

Regards

Anurag

[Former Member]

Hi

   For few cases the address details of the partner 
details can be changed for a specific document. So to 
avoid these cases it is always adviceble to fetch the 
ADRNR of the partner from VBPA and then fetch the 
details from ADRC or using FM: ADDR_GET.


Kind Regards
Eswar