Extraction from Datasource 0UC_SALES_STATS_02
We are currently working on developments of sales statistics 0UCSA_C05 cube for a large utility company. As part of building this cube, we are using data source 0UC_SALES_STATS_02 .
When we run info package to extract data from R/3 to BI - PSA, we are not able to get any records into delta queue in source system and as a result the info package is returning "0" records.
We checked the same data source in extract checker (RSA3) & there a pop up comes & ask for print document no .If I provide print document no then it extract 5 records for that particular print document no otherwise it is giving 0 records.
I feel I need to give print document as my selection criteria in the Infopackage so that it will extract that 5 records. But problem is that print document no (OPBEL) is not available in data source 0UC_SALES_STATS_02 so how can I give it as a selection criteria in infopackage.
Please let me know if anyone has worked on data source 0UC_SALES_STATS_02 extraction & what is the exact extraction procedure for this data source.
If anyone has any clue on why the delta is not getting built in source system, pls let us know and appreciate your attention to this message.