RTC - Data exists in ACDOCA and ACDOCC, still no data at Agg Level,VP, CP, Hana view ?

[Former Member]

Hi Experts, need your help !!

I am working with Real Time Consolidations (RTC) S4H 1610, BW 751 SP02. We have records in ACDOCA table. I have also used Flexible Upload to add records in ACDOCC table.

However, i don`t see any data at Virtual Provider or Composite provider level. I checked in Hana Studio for the Hana Views which get generated using TCode RTCMD, that Preliminary Consolidation Hana view also does not show any records.

For the CoA configuration, we are using 1000 as Operating CoA and 2000 as Group CoA, all accounts in 1000 have a group account field populated as well. We have also created FSV for both Op and Grp CoA.

Any ideas why we are not able to see data even though data exists in both ACDOCA and ACDOCC?

[former_member612856]

Hi

Did you solve this issue?

Any idea as to why the data from ACDOCA isn't read into UNION view which is called into Virtual provider and composite provider? While we can post and read records from ACDOCC but not able to read records from ACDOCA. We have tested the foundation view for Actual. In there, we can read the actual data from ACDOCA but not further upwards.

Thanks,

Manish

[former_member625995]

Hi ManishKumar,

Did you solve this issue? Currently we are facing the same problem. We already tested all the foundation views and they are working just fine, but at the moment of creating the Virtual Provider for the BPC_UNION view, the InfoCube is not pulling any records.

We created several RTC Modelling but we are having the same result.

Thanks.

Best regards.

Dante G.

[mbond09]

Have you manage to solve your issue?

Though Data from ACDOCA can be displayed, Hana Views which get generated via T-Code RTCMD, Preliminary Consolidation Views does not show any data records.

[former_member216978]

Hi, I got the solution to this which very simple and no need of any notes or upgrade:

Just open the script for _06 hana view:

/********* Begin Procedure Script ************/ BEGIN VAR_OUT = SELECT T1.RCOMP as ENTITY, case T1.RASSC when '' then 'NONE' else T1.RASSC end as PENTITY, T1.ANLN1 , T1.AUDIT_TRA , T1.BPC_CATG , T1.CONS_CUR , T1.CONS_SL , T1.FISCYEARPER , T1.GLACCOUNT_TYPE , T1.HSL , T1.KDGRP , T1.KOKRS , T1.KSL , T1.KTOPL , T1.KUNNR , T1.MATNR , T1.MODEL , T1.MSL , T1.PBUKRS , T1.PERIV , T1.POPER , T1.PPRCTR , T1.PRCTR , T1.PSEGMENT , T1.RACCT , T1.RBUKRS , T1.RBUSA , T1.RCLNT , T1.RCNTR , T1.RCONGR1 , T1.RFAREA , T1.RHCUR , T1.RKCUR , T1.RMVCT , T1.RUNIT , T1.RWCUR , T1.RYEAR , T1.SBUSA , T1.SCNTR , T1.SEGMENT , T1.SFAREA , T1.TIMESTAMP , T1.WSL FROM "ACDOCC" AS T1 join ( select P1.MANDT, P1.MODEL, P1.BPC_CATG, P1.FYEAR, P1.FPERI, P1.ENTITY, P1.CLOSE_TIME , P1.PRUUID from "RTC_PULL_REQ" as P1 inner join ( select MANDT, MODEL, BPC_CATG, FYEAR, FPERI, ENTITY, max(CLOSE_TIME) as CLOSE_TIME from "RTC_PULL_REQ" where USTATUS = 4 and REQ_TYPE = 21 group by MANDT, MODEL, BPC_CATG, FYEAR, FPERI, ENTITY ) as P2 on P1.MANDT = P2.MANDT and P1.MODEL = P2.MODEL and P1.BPC_CATG = P2.BPC_CATG and P1.FYEAR = P2.FYEAR and P1.FPERI = P2.FPERI and P1.ENTITY = P2.ENTITY and P1.CLOSE_TIME = P2.CLOSE_TIME ) as P on T1.RCLNT = P.MANDT and T1.MODEL = P.MODEL and T1.BPC_CATG = P.BPC_CATG and T1.RYEAR = P.FYEAR and T1.POPER = P.FPERI and T1.RCOMP = P.ENTITY and T1.PR_UUID = P.PRUUID WHERE T1.RCLNT = '210' AND T1.MODEL = 'ATGCB4' AND T1.DELFLG = '' AND P.BPC_CATG = 'FINAL' ;END /********* End Procedure Script ************/

Notice the script is looking for RTC_PULL_REQ table for any data release information.

If you have missed out on any configuration especially this one : RTCBCT where you define on which category the data submission is to be enabled.

Once you do this and then do flexible upload, system will be able to find an entry in table RTC_PULL_REQ and subsequently the view will start fetching data >and correspondingly the Composite provider will also fetch data.

Just wanted to list this solution properly here as lot of people will face the same issue in final category and system with multiple clients where this configuration might be missing, has to be maintained in each client.

thanks

rakesh

[mehmet_diyar_yatkin]

Have you manage to solve your issue?

I am having the same issue - RTC_C_..._07 view doesn't return any data... Data submit requests doesn't capture any data either.

[lucas_costa3]

Hi Garg,

If data is not being shown in the HANA views it can be an entity mapping issue. Remember that consolidation dimension 100 has some issues with leading zeros (check notes 2490401 and 2493811).

Another possible issue is related to your client. RTC requires that you generate "All Objects" T-code RTCMD in the client you're working on. If you you're DEV with data in a separate client, you need to perform this task in the client with data.

Note this options are considering you have relevant authorizations.

Cheers,

Lucas

[Former Member]

Hi Lucas,

Data from ACDOCA and ACDOCC will not be available on Virtual provider. Virtual provider only saves records which are create in BPC. You can try to execute CT and see records which are generate during CT will be seen in VP. Hope this helps.
Regards,
Rupank