R_WorkCenterTextTP

DDL: R_WORKCENTERTEXTTP SQL: IWRKCTRTXTTP Type: view_entity TRANSACTIONAL

Description

R_WorkCenterTextTP is a Transactional CDS View that provides data about "Description" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterText) and exposes 8 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, Language.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterText Desc from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Description view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center Internal Id
KEY WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
KEY Language Language
WorkCenterText WorkCenterText
Plant _Header Plant
WorkCenterCategoryCode _Header WorkCenterCategoryCode
WorkCenter _Header WorkCenter
_Header _Header 
//@AbapCatalog.sqlViewName: 'IWRKCTRTXTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Description'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }

define view entity R_WorkCenterTextTP
  as select from I_WorkCenterText as Desc
  association to parent R_WorkCenterTP as _Header on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                  and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode
{
      // Key

      @EndUserText.label:'Work Center Internal Id'
  key WorkCenterInternalID,
      @EndUserText.label:'Work Center Type Code'
  key WorkCenterTypeCode,
  key Language,
      WorkCenterText,
      _Header.Plant                                      as Plant,
      _Header.WorkCenterCategoryCode                     as WorkCenterCategoryCode,
      _Header.WorkCenter                                 as WorkCenter,
      case when _Header.WorkCenterLastChangeDateTime is null then
           cast(dats_tims_to_tstmp(cast('20190101' as dats), cast('120000'as tims), 'UTC', $session.client, 'NULL') as cr_lastchange_datetime)
           else _Header.WorkCenterLastChangeDateTime end as WorkCenterLastChangeDateTime,

      /* Associations */
      _Header
}
where
  WorkCenterTypeCode = 'A'

Learn More