R_WorkCenterTP

DDL: R_WORKCENTERTP SQL: IWRKCTRTP Type: view_entity TRANSACTIONAL

Work Center Header

R_WorkCenterTP is a Transactional CDS View that provides data about "Work Center Header" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 63 fields with key fields WorkCenterInternalID, WorkCenterTypeCode. It has 6 associations to related views.

1 data source(s) 63 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenter header from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Capacity _SchedgCap $projection.CapacityInternalID = _SchedgCap.CapacityInternalID
[0..1] I_WorkCenterCostCenterCount _CostCtrCount $projection.WorkCenterInternalID = _CostCtrCount.WorkCenterInternalID and $projection.WorkCenterTypeCode = _CostCtrCount.WorkCenterTypeCode
[1..*] R_WorkCenterTextTP _Description
[0..*] R_WorkCenterCostCenterTP _CostCenter
[0..*] R_WorkCenterCapacityTP _Capacity
[0..*] R_WorkCenterPooledCapAllocTP _PooledCap

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Header view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name WorkCenter view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center Internal Id
KEY WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
WorkCenter WorkCenter
WorkCenterDesc
Plant Plant
WorkCenterCategoryCode WorkCenterCategoryCode
WorkCenterResponsible WorkCenterResponsible
WorkCenterResponsibleName _WorkCenterResponsible WorkCenterResponsibleName
SupplyArea SupplyArea
WorkCenterUsage WorkCenterUsage
CapacityInternalID CapacityInternalID
CapacityCategoryCode _SchedgCap CapacityCategoryCode
Capacity _SchedgCap Capacity
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
WorkCenterFormulaParam1 WorkCenterFormulaParam1
WorkCenterFormulaParam2 WorkCenterFormulaParam2
WorkCenterFormulaParam3 WorkCenterFormulaParam3
WorkCenterFormulaParam4 WorkCenterFormulaParam4
WorkCenterFormulaParam5 WorkCenterFormulaParam5
WorkCenterFormulaParam6 WorkCenterFormulaParam6
WorkCenterFmlaParamValue1 WorkCenterFmlaParamValue1
WorkCenterFmlaParamValue2 WorkCenterFmlaParamValue2
WorkCenterFmlaParamValue3 WorkCenterFmlaParamValue3
WorkCenterFmlaParamValue4 WorkCenterFmlaParamValue4
WorkCenterFmlaParamValue5 WorkCenterFmlaParamValue5
WorkCenterFmlaParamValue6 WorkCenterFmlaParamValue6
WorkCenterFmlaParamUnit1 WorkCenterFmlaParamUnit1
WorkCenterFmlaParamUnit2 WorkCenterFmlaParamUnit2
WorkCenterFmlaParamUnit3 WorkCenterFmlaParamUnit3
WorkCenterFmlaParamUnit4 WorkCenterFmlaParamUnit4
WorkCenterFmlaParamUnit5 WorkCenterFmlaParamUnit5
WorkCenterFmlaParamUnit6 WorkCenterFmlaParamUnit6
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup
WrkCtrStdValMaintRule1 WrkCtrStdValMaintRule1
WrkCtrStdValMaintRule2 WrkCtrStdValMaintRule2
WrkCtrStdValMaintRule3 WrkCtrStdValMaintRule3
WrkCtrStdValMaintRule4 WrkCtrStdValMaintRule4
WrkCtrStdValMaintRule5 WrkCtrStdValMaintRule5
WrkCtrStdValMaintRule6 WrkCtrStdValMaintRule6
WorkCenterStandardWorkQtyUnit1 WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQtyUnit2 WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQtyUnit3 WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQtyUnit4 WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQtyUnit5 WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQtyUnit6 WorkCenterStandardWorkQtyUnit6
OperationControlProfile OperationControlProfile
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush
WorkCenterLocation WorkCenterLocation
WorkCenterLocationGroup WorkCenterLocationGroup
WrkCtrSetupSchedgFmla WrkCtrSetupSchedgFmla
WrkCtrProcgSchedgFmla WrkCtrProcgSchedgFmla
WrkCtrTeardownSchedgFmla WrkCtrTeardownSchedgFmla
WrkCtrIntProcgSchedgFmla WrkCtrIntProcgSchedgFmla
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime
ShiftNoteType ShiftNoteType
ShiftReportType ShiftReportType
_Description _Description
_CostCenter _CostCenter
_Capacity _Capacity
_PooledCap _PooledCap
_CostCtrCount _CostCtrCount 
//@AbapCatalog.sqlViewName: 'IWRKCTRTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Header'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.sapObjectNodeType.name: 'WorkCenter'
define root view entity R_WorkCenterTP
  as select from I_WorkCenter as header
  -- to WorkCenter Description
  composition [1..*] of R_WorkCenterTextTP           as _Description
  -- to WorkCenter CostCenter
  composition [0..*] of R_WorkCenterCostCenterTP     as _CostCenter
  -- to Capacity Header
  composition [0..*] of R_WorkCenterCapacityTP       as _Capacity
  -- to Pooled Capacity Header
  composition [0..*] of R_WorkCenterPooledCapAllocTP as _PooledCap

  association [0..1] to I_Capacity                   as _SchedgCap    on  $projection.CapacityInternalID = _SchedgCap.CapacityInternalID

  association [0..1] to I_WorkCenterCostCenterCount  as _CostCtrCount on  $projection.WorkCenterInternalID = _CostCtrCount.WorkCenterInternalID
                                                                      and $projection.WorkCenterTypeCode   = _CostCtrCount.WorkCenterTypeCode

{
      @EndUserText.label:'Work Center Internal Id'
  key WorkCenterInternalID,
      @EndUserText.label:'Work Center Type Code'
  key WorkCenterTypeCode,
      WorkCenter,
      _Text[1:Language=$session.system_language].WorkCenterText as WorkCenterDesc,
      Plant,
      WorkCenterCategoryCode,
      WorkCenterResponsible,
      @Semantics.text: true
      _WorkCenterResponsible.WorkCenterResponsibleName,
      SupplyArea,
      WorkCenterUsage,
      CapacityInternalID,
      _SchedgCap.CapacityCategoryCode                           as CapacityCategoryCode,
      _SchedgCap.Capacity                                       as Capacity,

      WorkCenterIsToBeDeleted,

      ValidityStartDate,
      ValidityEndDate,

      WorkCenterFormulaParam1,
      WorkCenterFormulaParam2,
      WorkCenterFormulaParam3,
      WorkCenterFormulaParam4,
      WorkCenterFormulaParam5,
      WorkCenterFormulaParam6,

      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit1'
      WorkCenterFmlaParamValue1,
      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit2'
      WorkCenterFmlaParamValue2,
      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit3'
      WorkCenterFmlaParamValue3,
      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit4'
      WorkCenterFmlaParamValue4,
      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit5'
      WorkCenterFmlaParamValue5,
      @Semantics.quantity.unitOfMeasure : 'WorkCenterFmlaParamUnit6'
      WorkCenterFmlaParamValue6,

      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit1,
      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit2,
      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit3,
      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit4,
      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit5,
      //      @Semantics.unitOfMeasure: true

      WorkCenterFmlaParamUnit6,

      StandardWorkFormulaParamGroup,
      WrkCtrStdValMaintRule1,
      WrkCtrStdValMaintRule2,
      WrkCtrStdValMaintRule3,
      WrkCtrStdValMaintRule4,
      WrkCtrStdValMaintRule5,
      WrkCtrStdValMaintRule6,

      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit1,
      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit2,
      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit3,
      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit4,
      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit5,
      //      @Semantics.unitOfMeasure: true

      WorkCenterStandardWorkQtyUnit6,

      OperationControlProfile,
      MatlCompIsMarkedForBackflush,
      WorkCenterLocation,
      WorkCenterLocationGroup,

      WrkCtrSetupSchedgFmla,
      WrkCtrProcgSchedgFmla,
      WrkCtrTeardownSchedgFmla,
      WrkCtrIntProcgSchedgFmla,

      @Semantics.systemDateTime.lastChangedAt: true
      WorkCenterLastChangeDateTime,
      ShiftNoteType,
      ShiftReportType,

      /*Associations*/
      _Description,
      _CostCenter,
      _Capacity,
      _PooledCap,
      _CostCtrCount
}
where
  WorkCenterTypeCode = 'A'

Learn More