Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Aug 14, 2017 at 01:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 13, 2017 at 05:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2017 at 11:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 12, 2017 at 08:13 AM

    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



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03 at 02:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded