purchase order ship to party no at item level

[Former Member]

Hi All,

I am able to get Ship To Party Address from ADRC table(Iam getting ADRNR from EKPO) But my client requirement is to get the KUNNR and not the address.

Is there any way to get KUNNR based on ADRNR at item level .I have search through the (KNA1 , LFA1 , VBPA , EKPA , EKPV ) But I couldn't get the relationship (KUNNR).

Actually Iam not able to get who the Ship To Party is at item level.

If we take it as shipping address of the purchasing party i could't find it in T001W.Where as if it is header it is maintained in T001W.

Do we have to take it as Third Party Ship to Party (i.e purchasing for a third party and shipping it directly to them).

Can anybody help me on this.PLZ.This is very urgent.

Thanks,

Saritha.

[rmazzali]

Hi,

the field ADRNR is in table KNA1 not as a key field but it is present and filled.

From kna1-adrnr you then can find kna1-kunnr.

pls. reward if helpful

Regards

Roberto

[Former Member]

Hi,

Thank you for ur response.

ADRNR address value is not maintained in KNA1 table.

Thanks,

Saritha.

[rmazzali]

it's quite strange because ths field is always filled !

maybe your ship-to is a one-time customer or has been changed in the order so, no kunnr is found.

Roberto