Skip to Content
avatar image
Former Member

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 10 at 01:02 PM

    Hi,

    In CRD1 template, use CRD1.Address field to indicate whether Ship to or Bill to.

    AddressName Address Bill To

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded