R_WorkCenterCapacityTextTP

DDL: R_WORKCENTERCAPACITYTEXTTP SQL: RWRKCTRCAPTXT Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_WKC

Work Center Capacity Text

R_WorkCenterCapacityTextTP is a Transactional CDS View that provides data about "Work Center Capacity Text" in SAP S/4HANA. It reads from 2 data sources (R_WorkCenterCapacityTP, I_WorkCenterCapacityText) and exposes 9 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, Language. Part of development package VDM_PP_MD_WKC.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
R_WorkCenterCapacityTP _Cap inner
I_WorkCenterCapacityText _capText from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Capacity Text 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 (9)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityText WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacityText WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacityText CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityText CapacityInternalID
KEY Language I_WorkCenterCapacityText Language
CapacityText I_WorkCenterCapacityText CapacityText
CapacityLastChangeDateTime I_WorkCenterCapacityText CapacityLastChangeDateTime
_CapHeader _CapHeader
_Header _Header 
//@AbapCatalog.sqlViewName: 'RWRKCTRCAPTXT'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Capacity Text'
//@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_WorkCenterCapacityTextTP
  as select from I_WorkCenterCapacityText as _capText
    inner join   R_WorkCenterCapacityTP   as _Cap on  _capText.CapacityInternalID         = _Cap.CapacityInternalID
                                                  and _capText.CapacityCategoryAllocation = _Cap.CapacityCategoryAllocation
                                                  and _capText.WorkCenterInternalID       = _Cap.WorkCenterInternalID
                                                  and _capText.WorkCenterTypeCode         = _Cap.WorkCenterTypeCode

  association to parent R_WorkCenterCapacityTP as _CapHeader on  $projection.CapacityInternalID         = _CapHeader.CapacityInternalID
                                                             and $projection.CapacityCategoryAllocation = _CapHeader.CapacityCategoryAllocation
                                                             and $projection.WorkCenterInternalID       = _CapHeader.WorkCenterInternalID
                                                             and $projection.WorkCenterTypeCode         = _CapHeader.WorkCenterTypeCode
  /*Association To Header*/
  association to R_WorkCenterTP                as _Header    on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                             and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode

{
  key _capText.WorkCenterInternalID       as WorkCenterInternalID,
  key _capText.WorkCenterTypeCode         as WorkCenterTypeCode,
  key _capText.CapacityCategoryAllocation as CapacityCategoryAllocation,
  key _capText.CapacityInternalID         as CapacityInternalID,
  key _capText.Language                   as Language,
      _capText.CapacityText,
      _capText.CapacityLastChangeDateTime,

      @Consumption.hidden: true
      _CapHeader,
      _Header
}

Learn More