SAP Result Analysis data migration from Legacy (Non SAP system) to SAP ECC system

[Jaredantao]

Dear Experts,

We are currently using SAP ECC system. We are doing a rollout of a company which has a go live date of 1st August 2024 (Transfer Date is not the 1st date of the Fiscal Year) The current legacy system is a non SAP system. 

With ECC, the the revenue based result analysis will be used to determine work in progress and Reserves for Unrealized costs. 

On the go live date, the expectations is that open WBS elements will also be transferred in ECC system. 

I have the below situation:

Planning details are as below:

The planning margin is 40%

on the last day in Legacy system, there is only cost booked against the WBS

The cost is settled in the legacy system by capitalizing the cost as Work in progress. 

on the go live date 1st August'2024, we have actual costs and actual revenues

Note: The cost of legacy period (1500) has been posted in the ECC system and is displayed in actual values in the WBS report. 

When the KKA2 is run, the, to date actual cost, are coming as 2500 (1500 +1000) and actual revenue is coming as 3000. As the Revenue based model is selected for result analysis, the system calculates correctly the cost of sales and calculated profit based on planned revenue margin of 40%

System also calculates the WIP amount correctly as 700 for till date. 

The issue is that I am expecting that system posts an entry of 800 (1500-800=700) to reduce the WIP to bring the WIP to 700. But when the settlement is run, the system is posting additional 700 in WIP. 

Due to this the balance in WIP is becoming 2200 (1500 + 700 = 2200)

How do I get the system to get the WIP reversed by 800?

Do let me know if additional information is required from my end. 

Regards,

Jared Antao

[Ken_Melching]

When I had a similar conversion I posted Inception to Date (up to 7/30) actual costs and actual revenues in the new system on 7/30, then ran RA and Settlement for Period July.  This set up the new system with a starting point that matched the old system.  Then you can proceed with new August business and RA should calculate correctly.

[MarcioBlos]

From what I understand, you are doing the first settlement in the ECC, correct?

If this is the case, I think there is no WIP to "adjust" in the settlement since it is the first settlement. The adjustment would be made if it were not the first settlement because with each settlement, the values are "adjusted."

Check how this WIP amount (800) was posted in period 7. If it was not posted by the RA, I think it will not be "seen" by RA.

Regards
Marcio Blos