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 . 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 ..