May 20, 2014

0 records problem in Master Data load

Via Content in SCN

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
DTP+0+recorde.PNG
                     
After executing the DTP we was getting 0 records at manage level instead of 76 records for Division at PSA level.

Manage+0+recorde.PNG


Solution:

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

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

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

Manage+recordes+added.PNG

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.

setting for master.PNG

Thanks for reading..

No comments: