Hi Sunil
Hope you're well!
You'd need table KNVP. Then assuming they are customer ship-to partners, you'd need KNA1 which has address number, along with ADRC for the address - connecting by address number.
If you're using v12.1, you can use the conversion exit to ensure the partner types are converted to the display version, rather than the stored version, so you'd see SH instead of WE
Attached is a quick example.
HTH
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 05-15-2020 16:44
From: SUNIL DEV
Subject: Customer Master with partners download
Is there a query template available to down load customer master partners with address details by sales area and ship-to?
------------------------------
SUNIL DEV | Sr. Manager-SAP Supply Chain
Ingredion | 6305208889
------------------------------