How to read actuals from ACDOCA in RTC Consolidation model

[Former Member]

Dear Forum,

Can anyone please highlight as to how to read actuals from ACDOCA in RTC Consolidation model? Currently despite making all relevant setting as per configuration document, it is not reading anything from ACDOCA. Most of the functions- write back, currency translation is only working on data from ACDOCC. Can some one please provide a solution? I can see data from ACDOCA until foundation view generated from model, however, when we analyse the calculation view for each category, one with suffix A (reading from ACDOCA) is not showing any data.

I can see the foundation view is called in this calculation view and don't seems to see any inconsistency in mapping etc.

thank you for your help

[former_member545113]

Any update on this issue?

[former_member232506]

Hi Wasay,

I have assigned union view to virtual provider. However even before this step, while analysing, I noticed individual calc view generated for each category with suffix A (for ACDOCA) is not showing any data from ACDOCA and similar issue in UNION view too. However the foundation view:

ZTEST/RTC_C_FOUNDATIONA is showing data correctly from ACDOCA.

Refer Script view from individual calc view without DRR (data release) "RTC_C_190SCON01_BPCACT_M200A" below for more info:

/********* Begin Procedure Script ************/ BEGIN
VAR_OUT = SELECT
A.RCLNT,
cast ('SCON01' as NVARCHAR(6)) as MODEL,
cast ('ACT_M200' as NVARCHAR(10)) as BPC_CATG,
cast ('' as NVARCHAR(2)) as RTFLG,
B.ENTITY,
cast (COALESCE( C.ENTITY, 'NONE') as NVARCHAR(32)) as PENTITY,
D.FISCAL_YEAR_VARIANT as PERIV,
D.FISCAL_YEAR_PERIOD as FISCYEARPER,
E.KKTPL as KTOPL,
E.RACCT,
cast (case A.RMVCT when '' then '999' else A.RMVCT end as NVARCHAR(3)) as RMVCT,
cast ('G_NONE' as NVARCHAR(20)) as RCONGR1,
cast ('INPUT' as NVARCHAR(20)) as AUDIT_TRA,
cast (sum(A.HSL) as DECIMAL( 23, 2 ) ) as CONS_SL,
cast ('LC' as NVARCHAR(5)) as CONS_CUR,
cast ('ZCC' as NVARCHAR(3)) as DIM,
A.SCNTR,
A.PSEGMENT,
A.SEGMENT,
A.ANBWA,
A.RBUSA,
A.KDGRP,
A.KOKRS,
A.VTWEG,
A.RCOMP,
A.RFAREA,
A.PPRCTR,
A.MATKL,
A.PS_PSPID,
A.SPART,
A.RASSC,
A.RCNTR,
A.PS_POSID,
A.VKORG,
A.SBUSA,
A.SFAREA,
A.ANLN1,
A.PRCTR
FROM "_SYS_BIC"."ZTEST/RTC_C_FOUNDATIONA" as A
join "_SYS_BIC"."ZTEST/RTC_C_200SCON01_ENTITY" as B
on a.RBUKRS = b.RBUKRS
left outer join "_SYS_BIC"."ZTEST/RTC_C_200SCON01_ENTITY" as C
on a.PBUKRS = c.RBUKRS
join "_SYS_BIC"."ZTEST/RTC_C_200SCON01_FYVM" as D
on A.BUDAT = D.CALENDAR_DATE
join "_SYS_BIC"."ZTEST/RTC_C_200SCON01_FSIM" as E
on A.KTOPL = E.KTOPL
and A.RACCT = E.SAKNR
WHERE A.RCLNT = '200'
group by A.RCLNT, B.ENTITY, C.ENTITY, A.RMVCT, A.RHCUR,
D.FISCAL_YEAR_VARIANT,
D.FISCAL_YEAR_PERIOD,
E.KKTPL,
E.RACCT,
A.SCNTR,
A.PSEGMENT,
A.SEGMENT,
A.ANBWA,
A.RBUSA,
A.KDGRP,
A.KOKRS,
A.VTWEG,
A.RCOMP,
A.RFAREA,
A.PPRCTR,
A.MATKL,
A.PS_PSPID,
A.SPART,
A.RASSC,
A.RCNTR,
A.PS_POSID,
A.VKORG,
A.SBUSA,
A.SFAREA,
A.ANLN1,
A.PRCTR
;END /********* End Procedure Script ************/

[syedwasay_safder]

Hi Manish,

The union view that is generated from the RTCMD "generate view" step will be assigned provide to your Consolidation Virtual InfoProvider and therefore provide the actuals data from ACDOCA.

Please see the blog below which might give a better overview of how data flows in RTC.

https://blogs.sap.com/2019/06/10/functional-overview-of-real-time-consolidation-in-sap-s4hana-1709/

Best Regards,

Syed Wasay