Skip to Content
0

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

Jan 10 at 11:40 AM

35

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagarajan K Jan 10 at 01:02 PM
0

Hi,

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

AddressName Address Bill To

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded