A_CnsldtnPartFctArHierDir

DDL: A_CNSLDTNPARTFCTARHIERDIR Type: view BASIC

Combined Partner Functional Area Hierarchy Directory

A_CnsldtnPartFctArHierDir is a Basic CDS View that provides data about "Combined Partner Functional Area Hierarchy Directory" 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 ACSPFUNCNLAHDIR 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 Partner Functional Area Hierarchy Directory view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy Cnsldtn Partner Functional Area Hier
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
MDHierType
HierarchyType 
@AbapCatalog:{
  sqlViewName: 'ACSPFUNCNLAHDIR',
  compiler.compareFilter: true,
  preserveKey: 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 Partner Functional Area Hierarchy Directory'

define view A_CnsldtnPartFctArHierDir
  as select from I_CnsldtnFuncnlAreaHierarchy
{
      @EndUserText.label: 'Cnsldtn Partner 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNFUNCNLAREAHIERARCHY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More