cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Group Reporting Data Collection GRDC overwrite issue in FORMS

UmaArjunan
Active Participant
0 Kudos
1,088

Dear SDN,

Version : SAPK-105001CPS4CORE

In GRDC Forms , when the data is overwritten by a new value , its appending the value to ACDOCU table instead of writing the delta amount. and the report shows the aggregated value instead of the latest value .

We tried to implement latest SAP note 3081399 and updated the changes in the function module "FC_TOTALS_SELECT", not seems to be working

Any one faced and resolved Overwrite issue in SAP Group Reporting Data Collection (GRDC) ? pl. help and share details .

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

sraycpa2707
Explorer
0 Kudos

Hi A. Uma,

My solution was just a work-around through a similar manual template for writing data into ACDOCU.

However this is the system behaviour in your specific scenario.

For Group Reporting Data Collection under Run Data Mapping and Import options under the Update mode Delete All option this is what happens:

Delete all option happens on total level, not on document level.

Within a block (combination of Ledger, Consolidation chart of accounts, Version, Fiscal Year, Period and Consolidation Unit) of the pre-existing data set are reset to zero before loading the new data and then the data is replaced by posting a delta instead of physically deleting existing data set.

Thanks

Kind Regards,

Somnath

Somnath Ray, CPA (US) , SAP S/4 HANA Finance (1909) Certified Associate

Answers (5)

Answers (5)

steven_foo
Participant
0 Kudos

We have setup GRDC 3 subaccount under 1 global account in eu10.

1 - DEV, 1- QAS and 1 - PRD.

We want to have all changes made in DEV and have CTMS transport into QAS.

In QAS we only want to have test in place and not changes to config.

Same as PRD.

How to achieve ? We could not find the solution.

Any idea?

At the subaccount properties, if we set it user for production = yes, will it help?

michaeldubois1
Explorer
0 Kudos

Hi Uma

On the 'General information' tab part of define forms, there is the option to switch between periodic and YTD. You want the form to be in YTD mode for the system to calculate deltas between periods. Are you currently in this mode?


Thanks

Mike

sraycpa2707
Explorer
0 Kudos

Hey A. Uma,

To fix your issue we can use the Flexible Upload template as provided in my earlier reply for your question by using the Data Collection Task from the Data Monitor as given in the screenshot below.

Thanks

Kind Regards,

Somnath

Somnath Ray, CPA (US) , SAP S/4 HANA Finance (1909) Certified Associate

UmaArjunan
Active Participant
0 Kudos

Its not upload , it is done thru SAP S/4 hana "MANUAL DATA COLLECTION " option -->"Enter Group Reporting Data " Fiori app

https://www.youtube.com/watch?v=aENAqA82wdo

UmaArjunan
Active Participant
0 Kudos

Hi Somnath ,

Thanks for the reply ! Please find the GRDC INPUT form (not upload )given below , after we update new value 100

in place of 420 , it is showing as 520, ACDOCU table is not capturing the delta amount 100 , total shows 520 in the report and also in the form. Can the update mode as delete all be enabled for INPUT FORMS Also ? how to enable it in this INPUT form .

To add on , upload functionality is working fine ( after note 3081399 impl) with the above options, the problem is GRDC INPUT Forms are not working, Is there any global settings in the GRDC web input forms to enable update mode as delete all, becos basis changed the connection from development to quality and it stopped working for GRDC INPUT FORMS

sraycpa2707
Explorer
0 Kudos

Hey A Uma,

For solving this issue we can choose the UPDATEMODE as "Delete All" mode by which we can delete the entire data for the same field combinations for your data (example of a field combination for a data set given below as in the screenshot) and creates a new document.

Thanks

Kind Regards,

Somnath

Somnath Ray, CPA (US) , SAP S/4 HANA Finance (1909) Certified Associate