CO background jobs for updating COPA datasource

[amruta_kedar]

Hi,

I have a copa data source which extracts the delta data from ECC on daily basis at 6.30 AM.

On ECC side the last settlement job runs at 6.15 AM(ZNO_CO_STSO).

Now the BI reports shows constanly lower revenu than ECC report (ke30 report)

After doing much of analysis i found that only those postings which are settled around 2 am to 3 am are captured in BI.

Rest of the postings which are setteled after 6.15 am are captured in next days Delta data load.

The settlement job(CO job) ZNO_CO_STSO which runs in ECC at 6.15 hardly takes 10 mins to finish. In BI we start the copa data load at 6.30.

So i think all the transactions should be captured in BI and hence ECC and BI reports should show same values.

How much time it takes to fill the delta queqe in ECC after settlement jobs are finished. Could it be possible that we start extraction in BI before the data ia updated in ECC????

Or is there any other job which we have to run in ECC after settlement jobs so that the data is updated in ECC tables??

[amruta_kedar]

Solution: For COPA, there is a safety interval upper limit of 30 min...meaning the records posted in the last 30 min will not be extracted.

So only option is to reschedule either BI job or ECC job

[Former Member]

Interesting. Thanks for sharing the solution with us.

[Former Member]

Hi Amruta,

if you are using summarization levels, the problem may be that the extraction reads from those rather than from the line item table CE1XXXX. In that case you should schedule the update of your summarization levels to happen before the BW update.

Regards

Nikolas

[amruta_kedar]

I know that BI reports shows the data of 1 day old.

But in this case i am getting 2 day old data in my report.

I have asked functional consultant about this. I got to know that there are 4 types of Settlement jobs which updates ECC reports.

1) ZNO_CO_ORDST order Settlement job

2) ZNO_CO_PPORDST Cant figure out what this is

3) ZNO_CO_STPRJ Project Settlement job

4) ZNO_CO_STSO Sales order Settlement job

first three jobs runs at around 2 AM and complets in few minutes.

Hence the data is Settlements is updated in bi.

4rt job runs at 6.15. This job basically updates Sales orders related data.

When we see ke24 report, i see that only Sales order related transactions are not fetched in BI (with sales order num and no WBS assigned).

I think this could be because of less time gap between SO Settlement job and BI data extraction job.

[ajaycwa1981]

Hi Amruta

This is a well known fact that BI reports most of the time are not online

You always see a lag of 1 day in them i.e on 30th, you would see the data as of 29th or atleast a few hours delay

The ideal option is to accept it

br, Ajay M