Skip to Content
author's profile photo Former Member
Former Member

DTW Unified Federal Tax ID

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 16, 2009 at 03:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 12:43 PM

    Hi Christian,

    afaik the column is called FederalTaxID.

    Regards Steffen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.