A_CnsldtnCustomerHierDir

DDL: A_CNSLDTNCUSTOMERHIERDIR SQL: ACSCUSTHIERDIR Type: view BASIC

Combined Customer Hierarchy Directory

A_CnsldtnCustomerHierDir is a Basic CDS View that provides data about "Combined Customer Hierarchy Directory" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnCustomerHierDir) and exposes 7 fields with key fields AdditionalMasterDataHierarchy, ValidityEndDate.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnCustomerHierDir I_CnsldtnCustomerHierDir from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ACSCUSTHIERDIR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey AdditionalMasterDataHierarchy view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Combined Customer Hierarchy Directory view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
MDHierType
HierarchyType 
@AbapCatalog.sqlViewName: 'ACSCUSTHIERDIR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
  ignorePropagatedAnnotations: true
}
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
@ObjectModel.representativeKey: 'AdditionalMasterDataHierarchy'
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
  }
@EndUserText.label: 'Combined Customer Hierarchy Directory'

define view A_CnsldtnCustomerHierDir
  as select from I_CnsldtnCustomerHierDir
{

  key cast(ConsolidationCustomerHierarchy as fincs_universalhierhierarchyid preserving type ) as AdditionalMasterDataHierarchy,

      @Semantics.businessDate.to: true
  key ValidityEndDate,

      @Semantics.businessDate.from: true 
      ValidityStartDate,
      LastChangedByUser,
      LastChangeDateTime,

      cast('CS08' as hrytype preserving type )                                                as MDHierType,
      cast('CS08' as hrytype preserving type )                                                as HierarchyType

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

Learn More