R_WorkCenterCapacityTextTP

DDL: R_WORKCENTERCAPACITYTEXTTP SQL: RWRKCTRCAPTXT Type: view_entity TRANSACTIONAL

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 1 data source (I_WorkCenterCapacityText) and exposes 9 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, Language.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
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 Language
CapacityText CapacityText
CapacityLastChangeDateTime 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
  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 Language                            as Language,
      CapacityText,
      CapacityLastChangeDateTime,

      @Consumption.hidden: true
      _CapHeader,
      _Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYTEXT"
],
"ASSOCIATED":
[
"R_WORKCENTERCAPACITYTP",
"R_WORKCENTERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More