Customer master data migration – Dunning level and Last Dunned date field values are not required
As part of majority of SAP Implementations, the customer master is one of the key master data objects to be loaded from Legacy system into SAP system.
The customer master data is very important in clients business, and the fields of the same should not be compromised during migration.
One of the main attributes of the customer master data is the dunning data, which will appraise the business with the status (riskiness for the item to be realized) of the open items.
Dunning data for customer open items is captured at two places as mentioned below:
1. Customer master data is updated with highest level of dunning irrespective of the Dunning level of
individual line items.
2. While migrating customer open items, the last dunning date and dunning level of each individual open
item is also migrated as part of the open items migrated to the new system
With the above explanation and understanding, we will now see why we require migration of Dunning information only at line item level but do not require at the Customer master data level.
For Example Customer account number 172110290 in legacy system was last dunned on 28.02.2014 and Dunning level as 2
Note: Dunning Procedure should be migrated.
Open line items of the same customer were also migrated with Dunning information as shown below.
When Dunning run is carried out for the same Customer in new SAP system, Customer open line item (If considered by Dunning run) will be updated with the next Dunning level and the Customer master data will always get updated with highest Dunning level of all the open items.
Customer line items reach the next Dunning level.
Customer master data gets updated with highest Dunning level 3
This situation would have been same in case Last Dunned date and Dunning level were not migrated while migrating customer master data. So, in a nutshell, MADAT-KNB5 (Last Dunned date) and MAHNS-KNB5 (Dunning level) fields can be excluded from Customer Master data migration strategy and rest of the other important data fields can be focused for successful migration of customer master data.