0 Replies Latest reply on Dec 27, 2018 6:25 PM by Rajeev Parimi

    SAP IS Utilities Sales Stats Delta Issue

    Rajeev Parimi
    Visibility: Open to anyone

      Hi ASUG Members,

       

      Quick help I need on Extracting the SAP IS U Sales Stats Delta

       

      Currently we are able to extract 0UC_SALES_STATS_02 data from SAP ECC Production to SAP BI Production

       

      We got new BW 7.5 landscape, where we plan to implement the Sales Stats Solution using 0UC_SALES_STATS_02

       

      We were told by SAP that it’s possible by using the Data Source- 0UC_SALES_STATS_03 to do parallel extraction

      But to be able to use the data source, we have to be on SAP ECC ehp 7/8

      We are low on ehp [02]. So that rules out using the Parallel Extraction option.

       

      The landscape restriction [our SAP ECC is  ehp 2 ], compels to load from old BI System to new BW system.

      We are trying this approach in Test Environment.

       

      Currently the Business Warehouse Test Environment is pointed to our SAP ECC Sandbox

       

      SAP ECC Sandbox is copy of SAP ECC Production

       

      When it’s working in current SAP ECC Production, ideally it should work in SAP Sandbox, which is a copy of Production.

       

      From Sandbox, we are trying to load the Sales Statistics [0uc_sales_stats_02] to Old SAP BI Quality

       

      We performed the following Steps to load in Sandbox,

       

      Steps performed in SAP ECC Sandbox

      • Post Transactions
      • Close the Reconciliation Keys and
      • Transferring the Reconciliation keys to GL

      We performed Mass activity using T Code: EBW_DQ_SS

       

       

      Outcome: The Delta Job got cancelled. When it got cancelled, it pulled some records to Old SAP BI, but we are not sure if the records it pulled are right amount of records?

       

      When we tried to run a delta on BI side it pulled 44m records which is not sure is the right delta. We want to start testing again, how do we make the sure the daily job triggers and captures the right delta correctly.

       

       

      We want to start testing again, how do we make the sure the daily job triggers and captures the right delta correctly.

       

      So we scheduled the Mass Activity job, but the jobs are getting cancelled with the error stating the job started on 14.11.2018 is to finished.

       

       

      Mass activity 14.11.2018 SS001, started by user is already active
      Job cancelled after system exception ERROR_MESSAGE Job started

       

       

      But the stated job already got cancelled ..

       

      Any thoughts!!

       

       

      Thanks,

      Rajeev