Reporting+solution+page

One reporting solution (HOT, Mild & Cold)

Option A: S/4HANA data and SCP EDW data will be joined for consolidate/years of reporting

Option B: S/4HANA data and SAC Import Data for consolidate/years of reporting

S/4HANA Model from CDS View

Dimensions (Characteristics

Measures (Key figures

CDS View

CDS View: I_GLACCOUNTLINEITEMCUBE
association[1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear and
$projection.CompanyCode = _FiscalYear.CompanyCode
association[1] to I_FiscalYearVariant as _FiscalYearVariant on $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
association[0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea

//association[0..1] to I_Currency as _BalanceTransactionCurrency on $projection.BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency
//association[0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association[1] to I_Currency as _CompanyCodeCurrency on $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
association[0..1] to I_Currency as _GlobalCurrency on $projection.GlobalCurrency = _GlobalCurrency.Currency
//association[0..1] to I_Currency as _FreeDefinedCurrency1 on $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency
//association[0..1] to I_Currency as _FreeDefinedCurrency2 on $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency
//association[0..1] to I_Currency as _FreeDefinedCurrency3 on $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency

//association[0..1] to I_UnitOfMeasure as _BaseUnit on $projection.BaseUnit = _BaseUnit.UnitOfMeasure
association[0..1] to I_UnitOfMeasure as _CostSourceUnit on $projection.CostSourceUnit = _CostSourceUnit.UnitOfMeasure
//association[0..1] to I_UnitOfMeasure as _AdditionalQuantity1Unit on $projection.AdditionalQuantity1Unit = _AdditionalQuantity1Unit.UnitOfMeasure
//association[0..1] to I_UnitOfMeasure as _AdditionalQuantity2Unit on $projection.AdditionalQuantity2Unit = _AdditionalQuantity2Unit.UnitOfMeasure
//association[0..1] to I_UnitOfMeasure as _AdditionalQuantity3Unit on $projection.AdditionalQuantity3Unit = _AdditionalQuantity3Unit.UnitOfMeasure

association[0..1] to I_Segment as _Segment on $projection.Segment = _Segment.Segment
association[0..] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter association[0..] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea and
$projection.CostCenter = _CostCenter.CostCenter
association[0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association[0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
//association[0..1] to I_WBSElement as _WBSElement on $projection.ps_posid = _WBSElement.WBSElement
//association[0..1] to I_Project as _Project on $projection.ps_pspid = _Project.Project

//association[0..1] to I_BusinessArea as _PartnerBusinessArea on $projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea
//association[0..1] to I_Segment as _PartnerSegment on $projection.segment = _PartnerSegment.Segment
association[0..1] to I_FunctionalArea as _PartnerFunctionalArea on $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea
association[0..] to I_ProfitCenter as _PartnerProfitCenter on $projection.ControllingArea = _PartnerProfitCenter.ControllingArea and $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter association[0..] to I_CostCenter as _PartnerCostCenter on $projection.ControllingArea = _PartnerCostCenter.ControllingArea and
$projection.PartnerCostCenter = _PartnerCostCenter.CostCenter
//association[0..1] to I_WBSElement as _PartnerWBSElement on $projection.pps_posid = _PartnerWBSElement.WBSElement
//association[0..1] to I_Project as _PartnerProject on $projection.pps_pspid = _PartnerProject.Project

association[0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and
$projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
association[1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

association[1] to I_ControllingDebitCreditCode as _ControllingDebitCreditCode on $projection.ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode

association[0..1] to I_Material as _Material on $projection.Material = _Material.Material
association[0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association[0..1] to I_Ledger as _Ledger on $projection.Ledger = _Ledger.Ledger
association[0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
//association[0..1] to I_CostCenterActivityType as _CostCenterActivityType on $projection.lstar = _CostCenterActivityType.CostCtrActivityType
//association[0..1] to I_CostCenterActivityType as _PartnerCostCtrActivityType on $projection.lstar = _PartnerCostCtrActivityType.CostCtrActivityType
association[0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
association[0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup
association[0..1] to I_CustomerGroup as _CustomerGroup on $projection.CustomerGroup = _CustomerGroup.CustomerGroup

BW Model from InfoCube

Object typeField/Object NameTechnical name
CharacteristicsBusiness area0BUS_AREA
Chart of accounts0CHRT_ACCTS
Company0COMP_CODE__0COMPANY
Company code0COMP_CODE
Currency Type0CURTYPE
G/L Account0GL_ACCOUNT
Indicator: Balance Sheet Account0GL_ACCOUNT__0BAL_FLAG
Indicator: Balance Sheet Account0GL_ACCOUNT__0INCST_FLAG
Planning Item from Account0GL_ACCOUNT__0SEM_POSIT
Value Type for Reporting0VTYPE
Version0VERSION
Key figuresCumulative Balance0BALANCE
Total Debit Postings0DEBIT
Total credit postings0CREDIT
Time characteristicsFiscal year0FISCYEAR
Fiscal year / period0FISCPER
Fiscal year variant0FISCVARNT
Posting period0FISCPER3
UnitsCurrency Key0CURRENCY
StructureINCOME STATEMENT – ROWSZFIGL_IS
BALANCE SHEET – ROWSZFIGL_BS
BALANCE SHEET – COLUMNSZFIGL_BS_COLUMNS
INCOME STATEMENT – COLUMNSZFIGL_IS_COLUMNS
INCOME STATEMENT BY MATERIAL – ROWSZFIGL_IS_BYMATERIAL

ECC Model from Extractor

Extractor: 0FI_GL_1 (BWFI2D_GET_FIGL_TRFI)
Extractor Structure: DTFIGL_1
Field in Extract StructureDescription of Field in the Extract StructureTable of OriginField in Table of Origin
KTOPLChart of AccountsT001KTOPL
SAKNRG/L account numberGLT0RACCT
BUKRSCompany CodeGLT0BUKRS
GSBERBusiness areaGLT0GSBER
WRTTPReporting value typeGLT0RRCTY
VERSNVersionGLT0RVERS
FISCPERFiscal Year/PeriodGLT0RYEAR and calculation
FISCVARFiscal Year VariantT001PERIV
CURTYPECurrency TypeFrom data entered 
CURRENCYCurrency keyCustomizing 
UMSOLTotal Debit PostingsCalculated 
UMHABTotal Credit PostingsCalculated 
KUMSLAccumulated BalanceCalculated 
UPDMODBW delta process: update modefixedSPACE
SHKZGCredit/Debit IndicatorGLT0DRCRK