topic Re: vbpa and kna1 in Application Development and Automation Discussions

vbpa and kna1

Former Member — Tue, 06 Nov 2007 04:51:08 GMT

Hi all..

i have an issue..

am fetching the details of customer from table KNA1... especially address and name....

but wat happened is.. in table VBPA, for that particular ship-to party address is different...

but it was not reflected in KNA1 table...in KNA1 the address is different...

what needs to be followed.... or should i need to use some other methodolgy...

incase if i need to find the description of address.. where can i find???

please help....this issue

Re: vbpa and kna1

Former Member — Tue, 06 Nov 2007 04:53:48 GMT

Hi,

use the VBPA-ADRNR and go to the table ADRC with the VBPA-ADRNR value..there you can get the address...

Thanks

naren

Re: vbpa and kna1

Former Member — Tue, 06 Nov 2007 05:19:49 GMT

Hi Naveena,

Either u select KNA1-ADRNR & pass it in table ADRC as ADDRNUMBER

Or u select VBPA-ADRNR & pass it in table ADRC as ADDRNUMBER.

U will get ur all required field for ship to party.

Reward pts if it is helpfull.

Regards

Srimanta

Re: vbpa and kna1

Former Member — Tue, 06 Nov 2007 05:27:46 GMT

thank you both of you...

But the changes to the order.. will be reflected first in VBPA ?????

like in the order,, if am going to change the address... it would be reflected in the table VBPA..

a customer may have different address?/////////////////

Re: vbpa and kna1

Former Member — Tue, 06 Nov 2007 05:31:49 GMT

Hi,

Yes..you can override the address at the sales order level..

When you override the address in the sales order...Then a new address number will be generated and stored in the table VBPA...Then the address details for the address number will be stored in ADRC table..

Thanks

naren

Re: vbpa and kna1

Former Member — Tue, 06 Nov 2007 05:35:27 GMT

A customer will not have different address

Have you considering the Partner function PARVW field in VBPA correctly

for Shipto it is WE

enter order number (VBELN) in VBPA and this PARVW = 'WE' then take the ADRNR and pass this to ADRC table

also take KUNNR and take from KNA1 also.

Generally one partner will not have different addresses

but in some cases if the same KUNNR is acting as both SOLD to nad SHIPTO then the addresses may be different

so based on the partner function (PARVW) take the addresses

Regards

Anji

Regards

Anji