SAP B1 9.2 PL09 DTW into CRD1 UDF where CRD1.AdresType = S

Hi everyone,

I have a question regarding the use of DTW.

We have created a UDF in the CRD1 table where we intend to store a copy of a customer's email address for use in a third party application which SAP exports data to.

I want to use DTW to populate this UDF from a .TXT import template, and have run it successfully and imported data.

However I wanted to update this UDF for fields where the CRD1.AdresType value = 'S' or the Ship To address, not the 'B' Bill To address.

I cannot see anywhere in the DTW engine which would allow me to specify this, nor do I think it will work to specify the CRD1.AdresType field in the import template as surely that will just overwrite the valueso I was hoping someone on the forum could advise me on the correct procedure to follow.

Thanks in advance for help!