I_UniversalHierClassFieldVal

DDL: I_UNIVERSALHIERCLASSFIELDVAL SQL: IUHCLFDVAL Type: view BASIC

Universal Hierarchy Class Field Value

I_UniversalHierClassFieldVal is a Basic CDS View that provides data about "Universal Hierarchy Class Field Value" in SAP S/4HANA. It reads from 1 data source (uhdt_clfd_val) and exposes 7 fields with key fields UniversalHierObjectID, UniversalHierClFldName, UniversalHierClFldValueSign, UniversalHierClFldLowValue. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
uhdt_clfd_val uhdt_clfd_val from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_UniversalHierClassFieldValT _Text $projection.UniversalHierObjectID = _Text.UniversalHierObjectID and $projection.UniversalHierClFldName = _Text.UniversalHierClFldName and $projection.UniversalHierClFldValueSign = _Text.UniversalHierClFldValueSign and $projection.UniversalHierClFldLowValue = _Text.UniversalHierClFldLowValue

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IUHCLFDVAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Universal Hierarchy Class Field Value view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierObjectID obj_id
KEY UniversalHierClFldName fld_name
KEY UniversalHierClFldValueSign val_sign
KEY UniversalHierClFldLowValue val_low
UniversalHierClFldHighValue val_high
UniversalHierarchyVersionID ver_id
_Text _Text 
@AbapCatalog.sqlViewName: 'IUHCLFDVAL'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Universal Hierarchy Class Field Value'

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #M
}
define view I_UniversalHierClassFieldVal as select from uhdt_clfd_val

association [0..*] to I_UniversalHierClassFieldValT as _Text on $projection.UniversalHierObjectID = _Text.UniversalHierObjectID
                                                            and $projection.UniversalHierClFldName = _Text.UniversalHierClFldName
                                                            and $projection.UniversalHierClFldValueSign = _Text.UniversalHierClFldValueSign
                                                            and $projection.UniversalHierClFldLowValue = _Text.UniversalHierClFldLowValue
{
  key obj_id    as UniversalHierObjectID,
  key fld_name  as UniversalHierClFldName,
  key val_sign  as UniversalHierClFldValueSign,
  key val_low   as UniversalHierClFldLowValue,
  
  val_high  as UniversalHierClFldHighValue,
  ver_id as UniversalHierarchyVersionID,
  _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UHDT_CLFD_VAL"
],
"ASSOCIATED":
[
"I_UNIVERSALHIERCLASSFIELDVALT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More