HI Gurus!
Our MDM goes through a tedious data clean-up process when moving one ship-to partner from one sold-to partner to a new sold-to partner.
They are required to delete the ship-to partner from current sold-to location in all sales organizations. Then partner the sold-to information for each sales organization.
If the ship-to location has a business location ID. Expire the current role and change the operator to the new Sold-to.
So I need to create a program to accomplish the above steps to will improve data integrity and reduce the number of accounts to manage.
So i need to develop a program that can re-partner ship-to locations from one ship-to partner from one sold-to partner to a new sold-to partner. Produce an exception log for any bill-to, payer, customer contact information that has moved but could possibly be incorrect. Create a new role in the Business Location ID.
Using an ALV only allowing user to move records that can be transferred:
u2022 Only allow ship-to transfer for non-marked for deletion records.
u2022 Only allow transfer of ship-to records that are currently partnered to sold-to.
u2022 Do not allow transfer of ship-to records that have different sold-to/bill-to/payer accounts. These will need to be move manually.
u2022 Only allow change if the valid Operator number is the same customer number as the sold-to or the re-partnered sold-to.
So I was just wondering if there is any BAPI that can be used for it or dow e go by BDC or if there is a way to do this in a better manner.
COuld anyone please help me assist in as how to approch the program and go forward please.
Thanks
Aarav