Update branch assignment through DTW for Business Partner Master Data

[Former Member]

Hi experts,

I want to assign the branch to the list of business partners through DTW. I have huge list of business partner which will be assigned by a branch.

So please let me know if there is a way to upload or update the branch assignment through DTW. or any other way except manual assignment.

Thanks

[ANKIT_CHAUHAN]

Hi,

For importing BP Branch Assignment via DTW, please find below the key points:

1. "CRD8 -BPBranchAssignment" template can be created via DTW. Go to Templates → Customize Template → Select BusinessPartners object → right click on BPBranchAssignment → Create Template for the Structure.
2. If you are adding a new Business Partner without CRD8 template, then all active branches will be assigned to the Business Partner.
3. When updating BPBranchAssignment, LineNum is necessary. The value should be an integer which begins with 0.
4. It is not possible to delete records using DTW, only importing new records or updating existing ones are supported. It means, if the BP already exists in database and all branches are checked, then it is not possible to delete(uncheck) branch by updating BP via DTW.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[adilnishat]

YOU CAN UPDATE THE NEW BRANCH ASSIGNMENT THROUGH DTW TEMPLATE BY

USING ONLY TWO FIELD IN DTW TEMPLATE. (1) BPCode & (2) BPLid.

EXAMPLE:

BPCode BPLid

BCF001 1

BCF001 2

BCF001 3

BCF002 1

BCF002 2

BCF002 3

[Abdul]

Hi,

There is a table named as CRD8 which stores BP code and Branch Id and you can update it with DTW. Just two column in your template BP Code and BPL Id

[Former Member]

Thanks for reply.

How can i update two branches for single business partner?

and How can i update only one branch to the business partners?

Scenario is that i already uploaded the business partners and by default two branches are selected for all business partner. how can i assign only one now.?

[Abdul]

To assign branches template will be like this

Cardcode1 Branch1

Cardcode1 Branch2

Carscode1 Branch3

Cardcode2 Branch1

Cardcode2 Brabch2

To remove already assigned branches try to assign all business partners default branch or remove branches via DTW using / (you need to test this one for one business partner).

If nothing works use delete statement to unassigned branches and assign it through DTW. Regarding update and delete statements please keep in mind its not recommended by SAP according to Below SAP note you may loose SAP Support.

896891 - Support Scope for SAP Business One - DB Integrity

SAP will not support any database, which is inconsistent, due to SQL-Queries, which modify datasets or the datastructure of the SAP Business One Database. This includes any update-, delete- or dropstatements executed via SQL-Server Tools or via the the query interface of SAP Business One. This is stated in the support contract between SAP and the SAP Business Partner also. "SAP will not provide support for any problem that arises because Partner or end customer has altered Software or SDK inappropriately " and "Nor will SAP provide any support services for problems that lie in Partner's or end customer's area of responsibility and result, for example, from inappropriate installation, unsatisfactory end-user training, lack of or incorrect business design, incorrect operation, or faulty hardware" Where inconsistencies are found in a database as outlined above, SAP Business One Product Support will be unable to process the incident further. In order to continue the support for this SAP Business One installation, it is expected to revert to a database backup where inappropriate changes