R_WorkCenterTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WorkCenterTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWRKCTRTP

CREATE VIEW R_WorkCenterTP AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  _Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  Plant,
  WorkCenterCategoryCode,
  WorkCenterResponsible,
  _WorkCenterResponsible.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  SupplyArea,
  WorkCenterUsage,
  CapacityInternalID,
  _SchedgCap.CapacityCategoryCode AS CapacityCategoryCode,
  _SchedgCap.Capacity AS Capacity,
  WorkCenterIsToBeDeleted,
  ValidityStartDate,
  ValidityEndDate,
  WorkCenterFormulaParam1,
  WorkCenterFormulaParam2,
  WorkCenterFormulaParam3,
  WorkCenterFormulaParam4,
  WorkCenterFormulaParam5,
  WorkCenterFormulaParam6,
  WorkCenterFmlaParamValue1,
  WorkCenterFmlaParamValue2,
  WorkCenterFmlaParamValue3,
  WorkCenterFmlaParamValue4,
  WorkCenterFmlaParamValue5,
  WorkCenterFmlaParamValue6,
  WorkCenterFmlaParamUnit1,
  WorkCenterFmlaParamUnit2,
  WorkCenterFmlaParamUnit3,
  WorkCenterFmlaParamUnit4,
  WorkCenterFmlaParamUnit5,
  WorkCenterFmlaParamUnit6,
  StandardWorkFormulaParamGroup,
  WrkCtrStdValMaintRule1,
  WrkCtrStdValMaintRule2,
  WrkCtrStdValMaintRule3,
  WrkCtrStdValMaintRule4,
  WrkCtrStdValMaintRule5,
  WrkCtrStdValMaintRule6,
  WorkCenterStandardWorkQtyUnit1,
  WorkCenterStandardWorkQtyUnit2,
  WorkCenterStandardWorkQtyUnit3,
  WorkCenterStandardWorkQtyUnit4,
  WorkCenterStandardWorkQtyUnit5,
  WorkCenterStandardWorkQtyUnit6,
  OperationControlProfile,
  MatlCompIsMarkedForBackflush,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WrkCtrSetupSchedgFmla,
  WrkCtrProcgSchedgFmla,
  WrkCtrTeardownSchedgFmla,
  WrkCtrIntProcgSchedgFmla,
  WorkCenterLastChangeDateTime,
  ShiftNoteType,
  ShiftReportType
FROM I_WorkCenter AS header
LEFT OUTER JOIN I_Capacity AS _SchedgCap ON CapacityInternalID = _SchedgCap.CapacityInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterCostCenterCount AS _CostCtrCount ON WorkCenterInternalID = _CostCtrCount.WorkCenterInternalID AND WorkCenterTypeCode = _CostCtrCount.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN R_WorkCenterTextTP AS _Description ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_WorkCenterCostCenterTP AS _CostCenter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkCenterCapacityTP AS _Capacity ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkCenterPooledCapAllocTP AS _PooledCap ON /* condition not available in parsed metadata */  -- association [0..*]
;