A_CNSLDTNCUSTOMERGROUPHIER

CDS View

Combined Customer Group Hierarchy

A_CNSLDTNCUSTOMERGROUPHIER is a CDS View in S/4HANA. Combined Customer Group Hierarchy. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CnsldtnCustomerGroupHierT view inner BASIC Combined Customer Group Hierarchy Text

Fields (1)

KeyField CDS FieldsUsed in Views
NodeType NodeType 1 
@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
}

Learn More