A_CnsldtnCustomerGroupHier

@AbapCatalog:{
  sqlViewName: 'ACSCUSGROUPHIER',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #XL}
//  representativeKey: 'HierarchyNode'

  }
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
  }
@EndUserText.label: 'Combined Customer Group Hierarchy'
@OData.entitySet.name: 'CustomerGroupHier'

define view A_CnsldtnCustomerGroupHier
  as select from I_CnsldtnCustGroupHierNode as _CnsldtnCustGroupHierNode

  association [0..1] to A_CnsldtnCustomerGroup      as _CnsldtnCustomerGroup        on  $projection.CustomerGroup = _CnsldtnCustomerGroup.CustomerGroup

  association [0..*] to A_CnsldtnCustomerGroupHierT as _CnsldtnCustomerGroupHierT   on  $projection.AdditionalMasterDataHierarchy = _CnsldtnCustomerGroupHierT.AdditionalMasterDataHierarchy
                                                                                    and $projection.HierarchyNode                 = _CnsldtnCustomerGroupHierT.HierarchyNode
                                                                                    and $projection.CustomerGroup                 = ''

  association [0..*] to A_CnsldtnCustomerGroupHierT as _CnsldtnCustomerGroupHierT_2 on  $projection.AdditionalMasterDataHierarchy = _CnsldtnCustomerGroupHierT_2.AdditionalMasterDataHierarchy
                                                                                    and $projection.HierarchyNode                 = _CnsldtnCustomerGroupHierT_2.HierarchyNode
                                                                                    and $projection.ValidityEndDate               = _CnsldtnCustomerGroupHierT_2.ValidityEndDate
                                                                                    and $projection.CustomerGroup                 = ''

  association [0..*] to A_CnsldtnCustomerGroupT     as _CnsldtnCustomerGroupT       on  $projection.CustomerGroup = _CnsldtnCustomerGroupT.CustomerGroup

  //  association [0..1] to A_CnsldtnCustomerGrpHierDir as _CnsldtnCustomerGrpHierDir on  $projection.AdditionalMasterDataHierarchy = _CnsldtnCustomerGrpHierDir.AdditionalMasterDataHierarchy

  //                                                                                  and $projection.ValidityEndDate               = _CnsldtnCustomerGrpHierDir.ValidityEndDate

{
      //      @ObjectModel.foreignKey.association: '_CnsldtnCustomerGrpHierDir'

  key _CnsldtnCustGroupHierNode.AdditionalMasterDataHierarchy,

      @ObjectModel.text.association: '_CnsldtnCustomerGroupHierT_2'
  key HierarchyNode,

      @Semantics.businessDate.to: true
  key _CnsldtnCustGroupHierNode.ValidityEndDate,

      ParentNode,

      @Semantics.businessDate.from: true
      _CnsldtnCustGroupHierNode.ValidityStartDate,

      @ObjectModel.text.association: '_CnsldtnCustomerGroupT'
      _CnsldtnCustGroupHierNode.CustomerGroup,

      // STS - compatible ATC cleanup change - to be removed

      cast(_CnsldtnCustGroupHierNode.HierarchyNodeSequence as abap.char( 56 ) ) as SequenceNumber,
      // STS - compatible ATC cleanup change - to be removed


      // STS - compatible ATC cleanup change

      _CnsldtnCustGroupHierNode.HierarchyNodeSequence,
      // STS - compatible ATC cleanup change


      _CnsldtnCustGroupHierNode.HierarchyNodeLevel,

      _CnsldtnCustGroupHierNode.NodeType,

      @Consumption.hidden: true
      _CnsldtnCustGroupHierNode.HierarchyType                                   as MDHierType,

      @Consumption.hidden: true
      _CnsldtnCustGroupHierNode.HierarchyType,

      //      @Consumption.hidden: true

      //      _CnsldtnCustomerGrpHierDir,


      _CnsldtnCustomerGroup,
      _CnsldtnCustomerGroupHierT,
      _CnsldtnCustomerGroupHierT_2,
      _CnsldtnCustomerGroupT
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNCUSTGROUPHIERNODE"
],
"ASSOCIATED":
[
"A_CNSLDTNCUSTOMERGROUP",
"A_CNSLDTNCUSTOMERGROUPHIERT",
"A_CNSLDTNCUSTOMERGROUPT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/