A_CnsldtnFSItemHierDir

DDL: A_CNSLDTNFSITEMHIERDIR Type: view BASIC

Financial Statement Item Hierarchy Dir

A_CnsldtnFSItemHierDir is a Basic CDS View that provides data about "Financial Statement Item Hierarchy Dir" in SAP S/4HANA. It reads from 1 data source (I_FinStmntItmHierDir) and exposes 9 fields with key fields ConsolidationChartOfAccounts, FinancialStatementItemHier. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FinStmntItmHierDir I_FinStmntItmHierDir from

Associations (2)

CardinalityTargetAliasCondition
[0..1] A_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts
[0..*] A_CnsldtnChartOfAccountsT _CnsldtnChartOfAccountsT $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ACSFSITEMHIERDIR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey FinancialStatementItemHier view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Financial Statement Item Hierarchy Dir view
OData.entitySet.name FinancialStatementItemHierDir view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts
KEY FinancialStatementItemHier
AdditionalMasterDataHierarchy
LastChangedByUser LastChangedByUser
MDHierType
HierarchyType
LastChangeDateTime LastChangeDateTime
_CnsldtnChartOfAccountsT _CnsldtnChartOfAccountsT
_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts
@AbapCatalog:{
  sqlViewName: 'ACSFSITEMHIERDIR',
  compiler.compareFilter: true
  }
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
@ObjectModel.representativeKey: 'FinancialStatementItemHier'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
  }
@EndUserText.label: 'Financial Statement Item Hierarchy Dir'
@OData.entitySet.name: 'FinancialStatementItemHierDir'

// HL 2308: not exposed in SEGW project API_GRMasterData. Largely obsolete except for some old dependencies


define view A_CnsldtnFSItemHierDir
  //    as select from I_CnsldtnFSItemHierarchy_2 not possible, see below

  as select from I_FinStmntItmHierDir

  association [0..1] to A_CnsldtnChartOfAccounts  as _CnsldtnChartOfAccounts  on $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts

  association [0..*] to A_CnsldtnChartOfAccountsT as _CnsldtnChartOfAccountsT on $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts

{
      @ObjectModel.foreignKey.association: '_CnsldtnChartOfAccounts'
      @ObjectModel.text.association: '_CnsldtnChartOfAccountsT'
  key ConsolidationChartOfAccounts,

  key cast( FinancialStatementItemHier as fc_ithry preserving type )       as FinancialStatementItemHier,

      // field should not be exposed. Therefore, I_CnsldtnFSItemHierarchy_2 cannot be used. Code dupliction or use some constant value.

      cast( AdditionalMasterDataHierarchy as fincs_hryid preserving type ) as AdditionalMasterDataHierarchy,

      LastChangedByUser,

      cast ( 'CS15' as hrytype preserving type )                           as MDHierType,

      cast ( 'CS15' as hrytype preserving type )                           as HierarchyType,

      // HL 2308: should not be exposed.

      LastChangeDateTime,
//      cast( '20220727034743' as hryupdtime  )                              as LastChangeDateTime,



      // associations

      @Consumption.hidden: true
      _CnsldtnChartOfAccountsT, // required for text retrieval


      @Consumption.hidden: true
      _CnsldtnChartOfAccounts // required for value help retrieval

};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINSTMNTITMHIERDIR"
],
"ASSOCIATED":
[
"A_CNSLDTNCHARTOFACCOUNTS",
"A_CNSLDTNCHARTOFACCOUNTST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/