CDS Views for Consolidation (EC-CS)

CDS View NameDescriptionSQL View Name
C_CNSLDTNRELDACCTGJRNLENTRITMCnsldtn - Released Acct Journal Ent ItemCRELDJRNLITM
C_CNSLDTNRELEASEDRPTDFINDATAConsolidation - Released Reported DataCREPFINDRLAG
C_REALTIMERPTDFINDATAConsolidation - Realtime Reported DataCREALTPTDFIND
I_CNSLDTNRELDACCTGJRNLENTRITMCnsldtn - Released Acct Journal Ent ItemIRELDJRNLITM
I_CNSLDTNRELEASEDRPTDFINDATAConsolidation - Released Reported DataIREPFINDRLAG
I_REALTIMERPTDFINDATAConsolidation - Realtime Reported DataIREALTPTDFIND
P_CNSLDTNDATAWCNSLDTNLOGICConsolidation: Consolidated Data with Reporting LogicPCDATACLOGIC
P_CNSLDTNDATAWCNSLDTNLOGICYTDConsolidation: Consolidated Data with Reporting LogicPCDATACLOGICYTD
P_CONSOLIDATEDDATAConsolidated DataPCONSOLIDTEDDATA
P_CONSOLIDATIONUNITCURRENCYGet local currencyPCONSUNITCURR
P_CONSOLIDATIONUNITCURRENCY_01Invert RYEAR in TF164PCONSUNITCURR01
P_CONSOLIDATIONUNITCURRENCY_02Get correct entry of TF164 for all possible fiscal yearsPCONSUNITCURR02
P_DATASUBMITREQUESTEvaluate data submission request (RTC_PULL_REQ)PDATASUBMITREQ
P_ECMCA_CTR_01Get customer/vendor country per documentPECMCACTR01
P_ECMCA_CTR_02Get customer/vendor country per documentPECMCACTR02
P_ECMCA_DSR_01Evaluate data submission request (RTC_PULL_REQ)PECMCADSR01
P_ECMCA_TF164Invert RYEAR in TF164PECMCATF164
P_PLANDATA_RLReported Financial Data for Real-time Units (Plan Version)PPLANDATARL
P_PLANDATA_RTReported Financial Data for Real-time UnitsPPLANDATA
P_PLANDATA_RT_01Select from ACDOCP; Consolidation Unit; Period and YearPPLANDATA_01
P_PLANDATA_RT_02Evaluate Data Submit RequestPPLANDATA_02
P_PLANDATA_RT_03Account mapping and Partner Consolidation UnitPPLANDATA_03
P_PLANDATA_RT_04Get Subitem (TF100, TF103A, TF110)PPLANDATA_04
P_PLANDATA_RT_05Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040)PPLANDATA_05
P_PLANDATA_RT_06Fill curreny fieldsPPLANDATA_06
P_PLANDATA_RT_07Evaluate breakdown by RTCUR and provide fields from ACDOCAPPLANDATA_07
P_REALTIMERPTDFINDATAReported Financial Data for Real-time UnitsPREALTIMERFD
P_REALTIMERPTDFINDATA_01Select from ACDOCA; Consolidation Unit; Period and YearPREALTIMERFD_01
P_REALTIMERPTDFINDATA_02Account mapping and Partner Consolidation UnitPREALTIMERFD_02
P_REALTIMERPTDFINDATA_03Get Subitem (TF100, TF103A, TF110)PREALTIMERFD_03
P_REALTIMERPTDFINDATA_04Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040)PREALTIMERFD_04
P_REALTIMERPTDFINDATA_05Fill curreny fieldsPREALTIMERFD_05
P_REALTIMERPTDFINDATA_06Evaluate breakdown by RTCUR and provide fields from ACDOCAPREALTIMERFD_06
P_REPFINDATA_RT_AGGRReported Financial Data for Real-time UnitsPRFDRTAG
P_REPFINDATA_RT_AGGR_01Aggregated select from ACDOCAPRFDRTAG_01
P_REPFINDATA_RT_AGGR_02Consolidation Unit; Period and YearPRFDRTAG_02
P_REPFINDATA_RT_AGGR_03Account mapping and Partner Consolidation UnitPRFDRTAG_03
P_REPFINDATA_RT_AGGR_04Get Subitem (TF100, TF103A, TF110)PRFDRTAG_04
P_REPFINDATA_RT_AGGR_05Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040)PRFDRTAG_05
P_REPFINDATA_RT_AGGR_06Fill curreny fieldsPRFDRTAG_06
P_REPFINDATA_RT_AGGR_07Evaluate breakdown by RTCUR and provide fields from ACDOCAPRFDRTAG_07
P_REPORTEDFINANCIALDATAConsolidation: Reported Financial DataPREPORTEDFINDATA
P_REPORTEDFINANCIALDATA_RLReported Financial Data for Real-time UnitsPREPFINDRL
P_REPORTEDFINANCIALDATA_RL_AGReported Financial Data for Real-time UnitsPREPFINDRLAG
P_REPORTEDFINANCIALDATA_RTReported Financial Data for Real-time UnitsPREPFINDRT
P_REPORTEDFINANCIALDATA_RT_01Select from ACDOCA; Consolidation Unit; Period and YearPREPFINDRT_01
P_REPORTEDFINANCIALDATA_RT_02Evaluate Data Submit RequestPREPFINDRT_02
P_REPORTEDFINANCIALDATA_RT_03Account mapping and Partner Consolidation UnitPREPFINDRT_03
P_REPORTEDFINANCIALDATA_RT_04Get Subitem (TF100, TF103A, TF110)PREPFINDRT_04
P_REPORTEDFINANCIALDATA_RT_05Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040)PREPFINDRT_05
P_REPORTEDFINANCIALDATA_RT_06Fill curreny fieldsPREPFINDRT_06
P_REPORTEDFINANCIALDATA_RT_07Evaluate breakdown by RTCUR and provide fields from ACDOCAPREPFINDRT_07
P_RFD_RT_AGGR_SIMPLEReported Financial Data for Real-time UnitsPRFDRTAGS
P_RFD_RT_AGGR_SIMPLE_01Aggregated select from ACDOCAPRFDRTAGS_01
P_RFD_RT_AGGR_SIMPLE_02Consolidation Unit; Period and YearPRFDRTAGS_02
P_RFD_RT_AGGR_SIMPLE_03Account mapping and Partner Consolidation UnitPRFDRTAGS_03
P_RFD_RT_AGGR_SIMPLE_04Get Subitem (TF100, TF103A, TF110)PRFDRTAGS_04
P_RFD_RT_AGGR_SIMPLE_05Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040)PRFDRTAGS_05
P_RFD_RT_AGGR_SIMPLE_06Fill curreny fieldsPRFDRTAGS_06
P_RFD_RT_AGGR_SIMPLE_07Evaluate breakdown by RTCUR and provide fields from ACDOCAPRFDRTAGS_07
P_STANDARDIZEDDATAConsolidation: Standardized DataPSTANDARDIZEDDAT
VD_ECMCT_RRCumulative amounts of totals records of type R in ECMCTV_ECMCT_RR
VD_ECMCT_RR_01Select record type R from ECMCTV_ECMCT_RR_01
VD_ECMCT_RR_02Find correct entries in TF164 and TF184V_ECMCT_RR_02
VD_ECMCT_RR_03Get local currency key (TF164) and ledger assignment (TF184)V_ECMCT_RR_03
VD_ECMCT_RR_04Get currency type (T881)V_ECMCT_RR_04
VD_ECMCT_RR_05Get group currency key (for currency type 30 vs. 80)V_ECMCT_RR_05
VD_INVYEAR_TF164VD_INVYEAR_TF164V_INVYEAR_TF164
VD_INVYEAR_TF184Invert RYEAR in TF184V_INVYEAR_TF184