see 0F document type data in reconciliation balance using SF_JOURNAL_ENTRIES_02

[MD92]

Hello experts,

I am writing to ask for your help with this problem. We have implemented the ICMR module with the 1909 version of Group Reporting, using the datasource SF_JOURNAL_ENTRIES_02. We have verified the data for the period 12.2023 loaded via flat file, but now, following the balance carryforward and release universal journal, we do not see the data derived from document type 0F.

We have already set up the reconciliation case with a filter on posting level "is empty" for document type 0F, and posting level between 00 and 10. We also tried replacing "is empty" with "is equal to #", but without success. Attached are some illustrative screenshots.

Any suggestions for a solution are welcome, thank you in advance.

[GraceZou]

Hi @MD92 Data source SF_JOURNAL_ENTRIES_02 joins ACDOCA table from accounting and ACDOCU from Group reporting.

Documents with cons. document type 0F can be read from ACDOCA, it doesn't rely on "Release Universal Journal" task in data monitor. If you see these documents are missing in ICMR apps, you need to check filters in app Define Matching Methods, because the method-level filters specify the overall data scope. You can also right-click an amount in Reconciliation Balances to drill down to Display Matching Items to see which items account for the balances. 

You can also refer to https://me.sap.com/notes/3113859. 

Grace

[MD92]

Hi @GraceZou , thank you for your help. The Matosching Method is set with filter on posting level between 00 and 10, posting level equal to 0C and posting level is empty to catch data coming from release (sorry I can't upload the image). I've also seen that there is also the possibility to filter on Consolidation Document Type: here I expected to find Group Reporting document Type, there are ACDOCA ones instead and I don't know if I should select something and what. Thank you if you have any other suggestions!.

[GraceZou]

Hi, you don't have to restrict posting level like this in matching method, because they are already restricted in the CDS view that is assigned to the data source: where rrcty = '0' and( plevl = '' or plevl = '00' or plevl = '01' or plevl = '0C' or plevl = '10' ) . Adding more filters using posting level/doc type doesn't fix the missing data. If after checking the SAP Note 3113859, you still can't find the answer, you can raise an incident. Thanks!

[MD92]

Hi, thank you a lot! I ask just another hint... I realized that we have another initial problem: when we select the method and click on 'run Matching,' we get this error: 'Cannot get current fiscal year/period. Check FYV setting in data source.'. Searching on the SAP help Portal, we have fount this note: https://me.sap.com/notes/3410358/E. We have checked step “1: In Tcode ICADS go to sub node "Mandatory Filter Fields", make sure there is mandatory filter on RVERS (Consolidation Version)”, we have it. Step“2. In Tcode CXB1, PERIV (Fiscal Year Variant) should be set in the consolidation version.” But in our Group Reporting version, we don’t have any FYV parameter to fill. Could this be the main problem and the lack of data in reconciliation balance a consequence?

[GraceZou]

Hi, features in Group reporting have been evolved a lot in newer releases compared to OP1909, e.g. FYV assignment, extension versions, so ICMR also adapts to the new group reporting features. FYV was assigned to consolidation group/unit master data in earlier release. It's recommended to upgrade to higher release if possible. For current issues you are facing, we need to connect to the system for in-depth analysis. You can raise an incident. Regards, Grace