I_CO_UGPPGLAccountHierSubtree

DDL: I_CO_UGPPGLACCOUNTHIERSUBTREE Type: view_entity COMPOSITE

I_CO_UGPPGLAccountHierSubtree is a Composite CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 15 fields with key fields StatryRptCategory, CompanyCode, GLAccountHierarchy, HierarchyNode, GLAccount.

7 data source(s) 15 fields

Data Sources (7)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_CompanyCode CompanyCode inner
I_CO_UGPPGLAccountCategory GLAccountCategory inner
I_CO_GLAccountHierSubtree I_CO_GLAccountHierSubtree from
I_CO_GLAccountHierSubtree I_CO_GLAccountHierSubtree union_all
I_StRpCategory StRpCategory inner
I_StRpCategory StRpCategory inner

Parameters (2)

NameTypeDefault
P_FinancialStatementVersion versn_011
P_StatryRptCategory srf_rep_cat_id

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory I_StRpCategory StatryRptCategory
KEY CompanyCode I_CompanyCode CompanyCode
KEY GLAccountHierarchy GLAccount GLAccountHierarchy
KEY HierarchyNode GLAccount HierarchyNode
KEY GLAccount GLAccount GLAccount
CO_UGPPGLAccountCategory
ChartOfAccounts GLAccount ChartOfAccounts
StatryRptCategoryasStatryRptCategory
KEY CompanyCode I_CompanyCode CompanyCode
KEY GLAccountHierarchy GLAccount GLAccountHierarchy
KEY HierarchyNode GLAccount HierarchyNode
KEY GLAccount
CO_UGPPGLAccountCategory I_CO_UGPPGLAccountCategory CO_UGPPGLAccountCategory
ChartOfAccounts
ValidityEndDate GLAccount ValidityEndDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType.dataClass: #MIXED,
  usageType.serviceQuality: #D,
  usageType.sizeCategory: #M
}
@VDM.viewType: #COMPOSITE

define view entity I_CO_UGPPGLAccountHierSubtree
  with parameters
    @EndUserText.label: 'Financial Statement Variant'
    P_FinancialStatementVersion : versn_011,
    @EndUserText.label: 'Statutory Report Category'
    P_StatryRptCategory         : srf_rep_cat_id

  as select from I_CO_GLAccountHierSubtree(
                    P_FinancialStatementVersion: $parameters.P_FinancialStatementVersion ) as GLAccount

    inner join   I_CompanyCode                                                             as CompanyCode  on CompanyCode.ChartOfAccounts = GLAccount.ChartOfAccounts

    inner join   I_StRpCategory                                                            as StRpCategory on  StRpCategory.StatryRptCategory   = $parameters.P_StatryRptCategory
                                                                                                           and StRpCategory.StatryRptCatVersion = 'ACT'
                                                                                                           and StRpCategory.Country             = CompanyCode.Country
{
  key StRpCategory.StatryRptCategory as StatryRptCategory,
  key CompanyCode.CompanyCode        as CompanyCode,
  key GLAccount.GLAccountHierarchy   as GLAccountHierarchy,
  key GLAccount.HierarchyNode        as HierarchyNode,
  key GLAccount.GLAccount            as GLAccount,
      ''                             as CO_UGPPGLAccountCategory,
      GLAccount.ChartOfAccounts      as ChartOfAccounts,
      GLAccount.ValidityEndDate      as ValidityEndDate
}
where
      StRpCategory.StatryRptCategory = 'CO_UGPP_TRIAL_BALANCE'
  and GLAccount.NodeType             = 'N'

union all

select from  I_CO_GLAccountHierSubtree(
                P_FinancialStatementVersion: $parameters.P_FinancialStatementVersion ) as GLAccount

  inner join I_CO_UGPPGLAccountCategory                                                as GLAccountCategory on GLAccountCategory.CO_UGPPGLAccountCategory = GLAccount.GLAcctHierarchyNodeCategory

  inner join I_CompanyCode                                                             as CompanyCode       on CompanyCode.ChartOfAccounts = GLAccount.ChartOfAccounts

  inner join I_StRpCategory                                                            as StRpCategory      on  StRpCategory.StatryRptCategory   = $parameters.P_StatryRptCategory
                                                                                                            and StRpCategory.StatryRptCatVersion = 'ACT'
                                                                                                            and StRpCategory.Country             = CompanyCode.Country
{
  key StRpCategory.StatryRptCategory                                            as StatryRptCategory,
  key CompanyCode.CompanyCode                                                   as CompanyCode,
  key GLAccount.GLAccountHierarchy                                              as GLAccountHierarchy,
  key GLAccount.HierarchyNode                                                   as HierarchyNode,
  key cast( left( GLAccount.GLAccount, 10 ) as fis_racct preserving type )      as GLAccount,
      GLAccountCategory.CO_UGPPGLAccountCategory                                as CO_UGPPGLAccountCategory,
      cast( left( GLAccount.ChartOfAccounts, 4 ) as fis_ktopl preserving type ) as ChartOfAccounts,
      GLAccount.ValidityEndDate                                                 as ValidityEndDate
}
where
      StRpCategory.StatryRptCategory = 'CO_UGPP_AUX_ACCT'
  and GLAccount.NodeType             = 'N'

Learn More