R_WorkCtrPooledCapacityTextTP

DDL: R_WORKCTRPOOLEDCAPACITYTEXTTP SQL: RPOOLEDCAPTXT Type: view_entity TRANSACTIONAL

Work Center Pooled Capacity Description

R_WorkCtrPooledCapacityTextTP is a Transactional CDS View that provides data about "Work Center Pooled Capacity Description" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterPooledCapacity, I_CapacityText) and exposes 5 fields with key fields CapacityInternalID, Language.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterPooledCapacity _PooledCapHeader inner
I_CapacityText _Text from

Annotations (7)

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

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_CapacityText CapacityInternalID
KEY Language I_CapacityText Language
CapacityText I_CapacityText CapacityText
CapacityLastChangeDateTime _Header CapacityLastChangeDateTime
_Header _Header 
//@AbapCatalog.sqlViewName: 'RPOOLEDCAPTXT'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Pooled Capacity 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_WorkCtrPooledCapacityTextTP
  as select from I_CapacityText             as _Text
    inner join   I_WorkCenterPooledCapacity as _PooledCapHeader on _Text.CapacityInternalID = _PooledCapHeader.CapacityInternalID
  association to parent R_WorkCenterPooledCapacityTP as _Header on $projection.CapacityInternalID = _Header.CapacityInternalID
{
  key _Text.CapacityInternalID           as CapacityInternalID,
  key _Text.Language,
      _Text.CapacityText,
      _Header.CapacityLastChangeDateTime as CapacityLastChangeDateTime,
      /*Association*/
      _Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITYTEXT",
"I_WORKCENTERPOOLEDCAPACITY",
"R_WORKCENTERPOOLEDCAPACITYTP"
],
"ASSOCIATED":
[
"R_WORKCENTERPOOLEDCAPACITYTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More