I_LineHierarchyText_2

DDL: I_LINEHIERARCHYTEXT_2 SQL: ILINEHIERTEXT2 Type: view_entity BASIC Package: VDM_PP_MD_WKC

Line Hierarchy - Text

I_LineHierarchyText_2 is a Basic CDS View that provides data about "Line Hierarchy - Text" in SAP S/4HANA. It reads from 1 data source (I_ProductionResourceText) and exposes 6 fields with key fields LineHierarchyInternalID, WorkCenterTypeCode, Language. It has 2 associations to related views. Part of development package VDM_PP_MD_WKC.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionResourceText text from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterType _WorkCenterType $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey LineHierarchyInternalID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Line Hierarchy - Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LineHierarchyInternalID I_ProductionResourceText ProductionResourceInternalID
KEY WorkCenterTypeCode I_ProductionResourceText ProductionResourceType
KEY Language
LineHierarchyName
_WorkCenterType _WorkCenterType
_Language _Language 
//@AbapCatalog.sqlViewName: 'ILINEHIERTEXT2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true 

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE, #SEARCHABLE_ENTITY]
@ObjectModel.representativeKey: 'LineHierarchyInternalID'
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Line Hierarchy - Text'

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
//define view I_LineHierarchyText_2

define view entity I_LineHierarchyText_2
  as select from I_ProductionResourceText as text
  association [1..1] to I_WorkCenterType as _WorkCenterType on $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
  association [1..1] to I_Language       as _Language       on $projection.Language = _Language.Language
{
//      @ObjectModel.text.element: 'LineHierarchyName'

  key text.ProductionResourceInternalID                                as LineHierarchyInternalID,
      @ObjectModel.foreignKey.association: '_WorkCenterType'
  key text.ProductionResourceType                                      as WorkCenterTypeCode,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast(text.Language as spras preserving type)                     as Language,

      // Text

      @Search: {defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8}
      @Semantics.text: true
      cast(text.ProductionResourceText as ld_line_txt preserving type) as LineHierarchyName,

      // Associations

      _WorkCenterType,
      _Language
}
where
  ProductionResourceType = 'A';

Learn More