B1iSN: How to map BPFiscalTaxID under BP Master Data
Our MDM system send BusinessPartners with BPAddresses to B1 via EDI and I do mapping in the xsl style sheet in B1iSN.
And I also need to map “FederalTaxID”(MDM system sends this element under the BusinessPartners) to <BPFiscalTaxID>/<TaxId0>.
I checked the note 1145532 - How to import tax information under BP Master Data,
I found that there is always an extra address line(Address Name is empty and Address Type=’B’) in the CRD7 table and seems only the Ship-To address have the value of TaxId0, do you know why?
My intension is that, to copy all information we needs for <BPFiscalTaxID> from BPAddress and add a dummy line into <BPFiscalTaxID> which align with the CRD7 table.
And only map the TaxId0 to all “Ship-To” address. I am not sure if this approach is correct or not.