A_CnsldtnFuncnlAreaHierDir

DDL: A_CNSLDTNFUNCNLAREAHIERDIR Type: view BASIC

Combined Functional Area Hierarchy Dir

A_CnsldtnFuncnlAreaHierDir is a Basic CDS View that provides data about "Combined Functional Area Hierarchy Dir" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFuncnlAreaHierarchy) and exposes 7 fields with key fields AdditionalMasterDataHierarchy, ValidityEndDate.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnFuncnlAreaHierarchy I_CnsldtnFuncnlAreaHierarchy from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ACSFUNCNLAHDIR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 Functional Area Hierarchy Dir view

Fields (7)

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

define view A_CnsldtnFuncnlAreaHierDir
  as select from I_CnsldtnFuncnlAreaHierarchy
{
      @EndUserText.label: 'Cnsldtn Functional Area Hier'
  key cast(left(CnsldtnFunctionalAreaHierarchy, 40) as fincs_hryid preserving type ) as AdditionalMasterDataHierarchy,

      @Semantics.businessDate.to: true
  key ValidityEndDate,

      ValidityStartDate,
      LastChangedByUser,
      LastChangeDateTime,

      cast ( 'CS05' as hrytype )                                                     as MDHierType,
      cast ( 'CS05' as hrytype )                                                     as HierarchyType
}

Learn More