R_WORKCENTERTP

CDS View

Work Center Header

R_WORKCENTERTP is a CDS View in S/4HANA. Work Center Header. It contains 15 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 15 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_WorkCenter view_entity projection CONSUMPTION Work Center Header
C_ProcessFlowResources view_entity from CONSUMPTION Resources
I_WorkCenterTP view_entity projection TRANSACTIONAL Interface for the BO WorkCenter - TP

Fields (15)

KeyField CDS FieldsUsed in Views
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
OperationControlProfile OperationControlProfile 1
Plant Plant 1
ShiftNoteType ShiftNoteType 1
ShiftReportType ShiftReportType 1
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup 1
SupplyArea SupplyArea 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterLocation WorkCenterLocation 1
WorkCenterResponsible WorkCenterResponsible 1
WorkCenterResponsibleName WorkCenterResponsibleName 1
WorkCenterUsage WorkCenterUsage 1 
//@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