I_PRODUCTIONRESOURCETEXT

CDS View

Production Resource - Text

I_PRODUCTIONRESOURCETEXT is a CDS View in S/4HANA. Production Resource - Text. It contains 4 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_LineHierarchyText view_entity from BASIC Line Hierarchy - Text
I_LineHierarchyText_2 view_entity from BASIC Line Hierarchy - Text
I_MiscProdnRsceToolText view from BASIC Miscellaneous PRT - Text
I_WorkCenterGroupText view_entity from COMPOSITE Work Center Group Text
I_WorkCenterHierarchyHeaderTxt view_entity from BASIC Work Center Hierarchy Header - Text
I_WorkCenterText view from BASIC Work Center - Text

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY ProductionResourceInternalID LineHierarchyInternalID,ProductionResourceInternalID,WorkCenterGroupInternalID,WorkCenterInternalID 5
KEY ProductionResourceType ProductionResourceType,WorkCenterGroupTypeCode,WorkCenterTypeCode 5
ProductionResourceText MiscProductionResourceToolDesc 1 
//@AbapCatalog.sqlViewName: 'IPPPRODNRESTEXT'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.technicalName: 'IPPPRODNRESTEXT'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'ProductionResourceInternalID'
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #MASTER}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Production Resource - Text'

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

define view entity I_ProductionResourceText
  as select from crtx as crtx
  
  association [1..1] to I_ProductionResourceType as _ProductionResourceType on $projection.ProductionResourceType = _ProductionResourceType.ProductionResourceType
  association [1..1] to I_Language               as _Language               on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_ProductionResourceType'
  key cast(crtx.objty as productionresourcetype preserving type)  as ProductionResourceType,
  key crtx.objid                                                  as ProductionResourceInternalID,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast(crtx.spras as spras preserving type)                   as Language,

      // Text

      @Semantics.text: true
      cast (crtx.ktext as productionresourcetext preserving type) as ProductionResourceText,

      // Associations

      _ProductionResourceType,
      _Language
};

Learn More