Automate

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
------------------------------

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
------------------------------