A_WorkCenters

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 A_WorkCenters.
-- 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: AWORKCENTER

CREATE VIEW A_WorkCenters AS
SELECT
  WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  _Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  Plant,
  WorkCenterCategoryCode,
  WorkCenterResponsible,
  _WorkCenterResponsible.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  SupplyArea,
  WorkCenterUsage,
  CapacityInternalID,
  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
FROM I_WorkCenter AS WorkCenter
LEFT OUTER JOIN A_WorkCenterCapacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN A_WorkCenterDayOperation AS _WorkCenterTodayOp ON WorkCenterInternalID = _WorkCenterTodayOp.WorkCenterInternalID AND _WorkCenterTodayOp.ManufacturingOrderCategory = '10'  -- association [0..*]
LEFT OUTER JOIN A_WorkCenterPipeLineOperation AS _WorkCenterQueuingOp ON WorkCenterInternalID = _WorkCenterQueuingOp.WorkCenterInternalID AND _WorkCenterQueuingOp.ManufacturingOrderCategory = '10'  -- association [0..*]
LEFT OUTER JOIN A_WorkCenterResponsible AS _WorkCenterResponsible ON Plant = _WorkCenterResponsible.Plant AND WorkCenterResponsible = _WorkCenterResponsible.WorkCenterResponsible  -- association [0..1]
LEFT OUTER JOIN A_WorkCenterAllCapacity AS _WorkCenterCapacity ON WorkCenterInternalID = _WorkCenterCapacity.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterCapacity.WorkCenterTypeCode  -- association [1..*]
LEFT OUTER JOIN A_WorkCenterAllCapacity_2 AS _WorkCenterAllCapacity ON WorkCenterInternalID = _WorkCenterAllCapacity.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterAllCapacity.WorkCenterTypeCode  -- association [0..*]
LEFT OUTER JOIN A_WorkCenterDescription AS _WorkCenterDescription ON WorkCenterInternalID = _WorkCenterDescription.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterDescription.WorkCenterTypeCode  -- association [1..*]
LEFT OUTER JOIN A_WorkCenterCostCenter AS _WorkCenterCostCenter ON WorkCenterInternalID = _WorkCenterCostCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterCostCenter.WorkCenterTypeCode  -- association [0..*]
;