0 records problem in Master Data load

On a rainy noon of Friday faced strange type of problem while loading master data text in SAP APO server (EHP2 for SAP SCM 7.0).

Problem: There is one generic transaction data source for Master data which was coming from BW side. We have to load its data in different-different info objects like plant, division, sales organisation etc. by putting selection of particular info object in Info package. e.g. – Division

After schedule the Info package we were able to see the 76 records of division at PSA level. Then putting the same selection at DTP level

After executing the DTP we was getting 0 records at manage level instead of 76 records for Division at PSA level.

Solution:

1. Check the data at PSA level,how it looks

2. At DTP level filter is same as data in PSA not as selection of info package(all upper case letter)

3. After executing the DTP we were able to got 76 records of division at info object manage level.

The solution is very simple but some times simple things do wonderful things.

Note: While doing master data load check Handle Duplicate records in update tab of DTP and activate master data after loading.

Thanks for reading..