08-22-2007 2:18 PM
Hi ,
Could you plz help me .
how to find the names of the ship to party , sold to party depending on the
sold to party (likp-kunnr) and ship to party(likp-kuang).
Thanks
Suresh.
08-22-2007 2:27 PM
Sold-to-party
Take ur likp-kunnr ,do compare compare with kna1-kunnr,take adrnr number from kna1,use adrc table..
so adrc table field is name1
Ship-to-party :
take LIKP-kunag,do compare with kna1-kunnr,get adrnr field from kna1,do compare with ADRC Table with adrnr,
so you can use ADRC-NAME1 field
Thanks
Seshu
08-22-2007 2:27 PM
Hi Suresh
PARVW
KUNNR
If PARVW is SP then KUNNR becomes Sold to Party
if PARVW is SH then KUNNR becomes ship to party
reward points to all helpful answers
kiran.M
08-22-2007 2:41 PM
08-22-2007 2:57 PM
Hello Suresh,
PARVW Field is at VBPA Table,but you can use my logic to get customer name like sold to party and ship-to-party.
anyhow check the VBPA Table ,here you need to pass sales order number
Thanks
Seshu
08-22-2007 2:27 PM
Sold-to-party
Take ur likp-kunnr ,do compare compare with kna1-kunnr,take adrnr number from kna1,use adrc table..
so adrc table field is name1
Ship-to-party :
take LIKP-kunag,do compare with kna1-kunnr,get adrnr field from kna1,do compare with ADRC Table with adrnr,
so you can use ADRC-NAME1 field
Thanks
Seshu