Skip to Content
avatar image
Former Member

purchase order ship to party no at item level

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 06, 2007 at 01:47 PM


    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



    Add comment
    10|10000 characters needed characters exceeded