A_CnsldtnCustomerGroupHierT

DDL: A_CNSLDTNCUSTOMERGROUPHIERT SQL: ACSCUSTGRPHIERT Type: view BASIC

Combined Customer Group Hierarchy Text

A_CnsldtnCustomerGroupHierT is a Basic CDS View that provides data about "Combined Customer Group Hierarchy Text" in SAP S/4HANA. It reads from 3 data sources (A_CnsldtnCustomerGroupHier, A_CnsldtnCustomerGrpHierDir, I_CnsldtnCustGroupHierNodeT) and exposes 8 fields with key fields AdditionalMasterDataHierarchy, HierarchyNode, ValidityEndDate, Language. It has 1 association to related views.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
A_CnsldtnCustomerGroupHier _CnsldtnCustomerGroupHier inner
A_CnsldtnCustomerGrpHierDir _CnsldtnCustomerGrpHierDirJ inner
I_CnsldtnCustGroupHierNodeT I_CnsldtnCustGroupHierNodeT from

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_CnsldtnCustomerGrpHierDir _CnsldtnCustomerGrpHierDir $projection.AdditionalMasterDataHierarchy = _CnsldtnCustomerGrpHierDir.AdditionalMasterDataHierarchy and $projection.ValidityEndDate = _CnsldtnCustomerGrpHierDir.ValidityEndDate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ACSCUSTGRPHIERT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Combined Customer Group Hierarchy Text view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey HierarchyNode view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name CustomerGroupHierText view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy I_CnsldtnCustGroupHierNodeT AdditionalMasterDataHierarchy
KEY HierarchyNode I_CnsldtnCustGroupHierNodeT HierarchyNode
KEY ValidityEndDate I_CnsldtnCustGroupHierNodeT ValidityEndDate
KEY Language Language
HierarchyNodeText HierarchyNodeText Node Description
ValidityStartDate I_CnsldtnCustGroupHierNodeT ValidityStartDate
NodeType A_CnsldtnCustomerGroupHier NodeType
_CnsldtnCustomerGrpHierDir _CnsldtnCustomerGrpHierDir 
@AbapCatalog.sqlViewName: 'ACSCUSTGRPHIERT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Combined Customer Group Hierarchy Text'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'HierarchyNode'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #XL}
  @VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@OData.entitySet.name: 'CustomerGroupHierText'
@Metadata.ignorePropagatedAnnotations: true
define view A_CnsldtnCustomerGroupHierT as select from I_CnsldtnCustGroupHierNodeT 
inner join A_CnsldtnCustomerGrpHierDir as _CnsldtnCustomerGrpHierDirJ on I_CnsldtnCustGroupHierNodeT.AdditionalMasterDataHierarchy = _CnsldtnCustomerGrpHierDirJ.AdditionalMasterDataHierarchy
                                                    and I_CnsldtnCustGroupHierNodeT.ValidityEndDate         = _CnsldtnCustomerGrpHierDirJ.ValidityEndDate
    inner join A_CnsldtnCustomerGroupHier as _CnsldtnCustomerGroupHier 
                                                  on I_CnsldtnCustGroupHierNodeT.AdditionalMasterDataHierarchy = _CnsldtnCustomerGroupHier.AdditionalMasterDataHierarchy
                                                    and I_CnsldtnCustGroupHierNodeT.HierarchyNode           = _CnsldtnCustomerGroupHier.HierarchyNode
                                                    and I_CnsldtnCustGroupHierNodeT.ValidityEndDate         = _CnsldtnCustomerGroupHier.ValidityEndDate

association [0..1] to A_CnsldtnCustomerGrpHierDir as _CnsldtnCustomerGrpHierDir on $projection.AdditionalMasterDataHierarchy = _CnsldtnCustomerGrpHierDir.AdditionalMasterDataHierarchy
and $projection.ValidityEndDate = _CnsldtnCustomerGrpHierDir.ValidityEndDate 
{
@ObjectModel.foreignKey.association: '_CnsldtnCustomerGrpHierDir'
key I_CnsldtnCustGroupHierNodeT.AdditionalMasterDataHierarchy, 
key I_CnsldtnCustGroupHierNodeT.HierarchyNode, 
@Semantics.businessDate.to: true
key I_CnsldtnCustGroupHierNodeT.ValidityEndDate, 
@Semantics.language: true
key Language, 
@Semantics.text: true
@EndUserText.label: 'Node Description'
HierarchyNodeText, 
@Semantics.businessDate.from: true
I_CnsldtnCustGroupHierNodeT.ValidityStartDate,
_CnsldtnCustomerGroupHier.NodeType,
_CnsldtnCustomerGrpHierDir
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CNSLDTNCUSTOMERGROUPHIER",
"A_CNSLDTNCUSTOMERGRPHIERDIR",
"I_CNSLDTNCUSTGROUPHIERNODET"
],
"ASSOCIATED":
[
"A_CNSLDTNCUSTOMERGRPHIERDIR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More