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_WorkCenterCapacityListTP.
-- 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.
CREATE VIEW R_WorkCenterCapacityListTP AS
SELECT
_Cap.CapacityInternalID AS CapacityInternalID,
_Cap.Plant AS Plant,
_WrkCtr.WorkCenterInternalID AS WorkCenterInternalID,
_WrkCtr.WorkCenterTypeCode AS WorkCenterTypeCode,
_Cap.Capacity AS Capacity,
_Cap._Text[1:Language=$session.system_language].CapacityText AS CapacityText,
_Cap.CapacityCategoryCode AS CapacityCategoryCode,
_CapCatText.CapacityCategoryName AS CapacityCategoryName,
_Cap.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
_CapRespText.CapacityResponsiblePlannerName AS CapacityResponsiblePlannerName,
_Cap.CapacityIsPooled AS CapacityIsPooled,
_WrkCtr.WorkCenterCategoryCode AS WorkCenterCategoryCode,
_WrkCtr.WorkCenterLastChangeDateTime AS WorkCenterLastChangeDateTime,
_Cap._Plant.PlantName AS PlantName,
case _Cap.Capacity when '' then _WrkCtr.WorkCenter else ' ' end as WorkCenter AS WorkCenterelseendasWorkCenter,
case _Cap.Capacity when '' then _Mat.NumberOfProducts else _PooledCapMatCt.NumberOfProducts end as NumberOfProducts AS NumberOfProductsendasNumberOfProducts,
_Cap.ShiftGroup AS ShiftGroup,
_Cap.CapacityIsFinite AS CapacityIsFinite,
_Cap.CapacityHasIndivCapacities AS CapacityHasIndivCapacities,
_Cap.CapacityIsExcldFrmLongTermPlng AS CapacityIsExcldFrmLongTermPlng,
case _Cap.FactoryCalendar when '' then _Plant.FactoryCalendar else _Cap.FactoryCalendar end as FactoryCalendar AS FactoryCalendarendasFactoryCalendar,
_Cap.CapacityActiveVersion AS CapacityActiveVersion,
_Cap.AuthorizationGroup AS AuthorizationGroup,
cast('H' as unit) AS WorkCenterCapacityUnit,
cast('%' as unit) AS WorkCenterUtilizationUnit,
cast ( substring( cast ( tstmp_add_seconds( cast ('10010102000000' as abap.dec(15,0)), cast( _Cap.CapacityStartTimeID as abap.dec(15,0) ), 'FAIL') as abap.sstring(50)), 9,6) as abap.tims) as CapacityStartTime AS timsasCapacityStartTime,
cast ( substring( cast ( tstmp_add_seconds( cast ('10010102000000' as abap.dec(15,0)), cast( _Cap.CapacityEndTimeID as abap.dec(15,0) ), 'FAIL') as abap.sstring(50)), 9,6) as abap.tims) as CapacityEndTime AS timsasCapacityEndTime,
_Cap.CapacityBreakDuration AS CapacityBreakDuration,
cast(_Cap.CapacityPlanUtilizationPercent as abap.dec(3,0)) AS CapacityPlanUtilznInPercent,
_Cap.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
cast(_Cap.CapOverloadThresholdInPercent as abap.dec(3,0)) AS WrkCtrCapOvrldThldInPct,
_Cap.CapacityQuantityUnit AS CapacityQuantityUnit,
_Cap.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
cast( cast( '0000000000' as abap.char(10) ) as cr_hname preserving type ) AS WorkCenterGroup,
cast( cast( '0000000000' as abap.char(10) ) as cr_wrkctrgrptyp preserving type ) AS WorkCenterGroupType,
cast( cast( '' as abap.char(40) ) as matnr preserving type ) AS Product,
cast( cast( '0000' as abap.char(4) ) as verid preserving type ) AS ProductionVersion,
cast('00:00:00' as abap.char(8)) AS CapacityBreakDurationFrmtdVal,
case _Cap.Capacity when '' then _WrkCtr.WorkCenter else _Cap.Capacity end as MassMaintCapApplHeaderVal AS CapacityendasMassMaintCapApplHeaderVal,
coalesce(_PMRPChgProposalPerCap.PMRPCapacityChangeIsNeeded, cast( '' as abap_boolean ) ) AS CapacityHasPMRPChangeProposal,
_ShiftGrpText.ShiftGroupingName AS ShiftGroupingName,
_AvailCapText.AvailableCapacityTypeName AS AvailableCapacityTypeName,
_UnitText.UnitOfMeasureName AS UnitOfMeasureName,
_WrkCtr.WorkCenterResponsible AS WorkCenterResponsible
INNER JOIN I_MassMaintCapAreaOfRespy AS _WrkCtrCapAOR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterGroupObjectCount AS _ObjectCount ON _ObjectCount.ObjectTypeCode = 'A' AND _ObjectCount.ObjectInternalID = _WrkCtrCapAOR.WorkCenterInternalID -- association [0..1]
LEFT OUTER JOIN I_BillOfOpsOpWorkCenterCount AS _OP ON _OP.WorkCenterTypeCode = 'A' AND _OP.WorkCenterInternalID = _WrkCtrCapAOR.WorkCenterInternalID -- association [0..1]
LEFT OUTER JOIN I_MfgBOOMatlAssgmtWrkCtrCt AS _Mat ON _Mat.WorkCenterTypeCode = 'A' AND _Mat.WorkCenterInternalID = _WrkCtrCapAOR.WorkCenterInternalID -- association [0..1]
LEFT OUTER JOIN I_MassMaintCapOpsCtPooledCap AS _PooledCapOPCt ON _PooledCapOPCt.CapacityInternalID = _Cap.CapacityInternalID -- association [0..1]
LEFT OUTER JOIN I_MassMaintCapMatlCtPooledCap AS _PooledCapMatCt ON _PooledCapMatCt.CapacityInternalID = _Cap.CapacityInternalID -- association [0..1]
LEFT OUTER JOIN I_MassMaintCapGrpCtPooledCap AS _PooledCapObjCt ON _PooledCapObjCt.CapacityInternalID = _Cap.CapacityInternalID -- association [0..1]
LEFT OUTER JOIN I_CapacityCategoryText AS _CapCatText ON _CapCatText.CapacityCategoryCode = _Cap.CapacityCategoryCode AND _CapCatText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_CapacityRespPlannerText AS _CapRespText ON _CapRespText.CapacityResponsiblePlanner = _Cap.CapacityResponsiblePlanner AND _CapRespText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant -- association [1..1]
LEFT OUTER JOIN P_PMRPChgProposalPerCapacity AS _PMRPChgProposalPerCap ON _PMRPChgProposalPerCap.PMRPResourceInternalID = _Cap.CapacityInternalID -- association [1..1]
LEFT OUTER JOIN I_ShiftGroupingText AS _ShiftGrpText ON _ShiftGrpText.ShiftGrouping = ShiftGroup AND _ShiftGrpText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendarText AS _CalText ON _CalText.FactoryCalendar = FactoryCalendar AND _CalText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_AvailableCapacityTypeText AS _AvailCapText ON _AvailCapText.AvailableCapacityType = CapacityActiveVersion AND _AvailCapText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitText ON _UnitText.UnitOfMeasure = CapacityBaseQtyUnit AND _UnitText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN R_MassMaintCapIntervalShiftTP AS _CapIntvlShift ON /* condition not available in parsed metadata */ -- association [1..*]
LEFT OUTER JOIN R_MassMaintCapPMRPChgPrpslTP AS _PMRPChgProposalBuckets ON /* condition not available in parsed metadata */ -- association [1..*]
;