cancel
Showing results for 
Search instead for 
Did you mean: 

DTW Unified Federal Tax ID

Former Member
0 Kudos

Hi all,

I need to import the field Unified Federal Tax ID

into Business Partners master data through DTW

I didn't find the relevant field in DTW template

could you help ?

thanks in advance

Christian

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Christian,

You are right that 'FederalTaxID' actually points to OCRD.LicTradNum rather than OCRD.VatIdUnCmp which has been clarified in Note [1097964|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1097964].

The field VatIdUnCmp has not yet been exposed in the DI and therefore not exposed in the DTW.

In the meantime user may update the field directly via B1 client or as a possible workaround, you can import the value to Federal Tax ID via DTW and then put a formatted search on the Unified Federal Tax ID field using the query

SELECT $[$41.0.0]

to select the contents of the Federal Tax ID. Ensure in the formatted search definition you select Auto Refresh When Field Changes using the field Federal Tax ID.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Christian,

afaik the column is called FederalTaxID.

Regards Steffen

Former Member
0 Kudos

the DTW field FederalTaxID populates the SAP field LicTradNum

I need to populate the SAP field VatIdUnCmp which exists in Business Partners screens in the French setup