C_ChgImpctETOShopFloorRtgDets

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 C_ChgImpctETOShopFloorRtgDets.
-- 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: CCHGIMPCTETOROUT

CREATE VIEW C_ChgImpctETOShopFloorRtgDets AS
SELECT
  ChgImpactETORoutingDets.BillOfOperationsGroup AS BillOfOperationsGroup,
  ChgImpactETORoutingDets.BillOfOperationsType AS BillOfOperationsType,
  ChgImpactETORoutingDets.BillOfOperationsVariant AS BillOfOperationsVariant,
  ChgImpactETORoutingDets.BillOfOperationsVersion AS BillOfOperationsVersion,
  ChgImpactETORoutingDets.IsLatestBOOVersion AS IsLatestBOOVersion,
  ChgImpactETORoutingDets.NumberOfBOOVersionSuccessors AS NumberOfBOOVersionSuccessors,
  ChgImpactETORoutingDets.BillOfOperationsRefType AS BillOfOperationsRefType,
  ChgImpactETORoutingDets.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  ChgImpactETORoutingDets.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  ChgImpactETORoutingDets.BOOReferenceVersion AS BOOReferenceVersion,
  ChgImpactETORoutingDets.BillOfOperationsDesc AS BillOfOperationsDesc,
  ChgImpactETORoutingDets.BillOfOperationsVersionStatus AS BillOfOperationsVersionStatus,
  ChgImpactETORoutingDets.BillOfOperationsUsage AS BillOfOperationsUsage,
  ChgImpactETORoutingDets.BillOfOperationsStatus AS BillOfOperationsStatus,
  _BillOfOperationsStatusText.BillOfOperationsStatusDesc AS BillOfOperationsStatusDesc,
  ChgImpactETORoutingDets.Plant AS ProductionPlant,
  ChgImpactETORoutingDets.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  ChgImpactETORoutingDets.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  ChgImpactETORoutingDets.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ChgImpactETORoutingDets.WorkCenter AS WorkCenter,
  ChgImpactETORoutingDets.BillOfOperationsUnit AS BillOfOperationsUnit,
  cast( ChgImpactETORoutingDets.InspectionPartialLot as qtlos ) AS InspectionPartialLot,
  ChgImpactETORoutingDets.InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
  ChgImpactETORoutingDets.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  ChgImpactETORoutingDets.SmplDrawingProcedure AS SmplDrawingProcedure,
  ChgImpactETORoutingDets.InspLotDynamicRule AS InspLotDynamicRule,
  ChgImpactETORoutingDets.InspectionLotDynamicLevel AS InspectionLotDynamicLevel,
  ChgImpactETORoutingDets.CreationDateTime AS CreationDateTime,
  ChgImpactETORoutingDets.CreatedByUser AS CreatedByUser,
  ChgImpactETORoutingDets.LastChangeDateTime AS LastChangeDateTime,
  ChgImpactETORoutingDets.LastChangedByUser AS LastChangedByUser,
  ChgImpactETORoutingDets.LastUsageDate AS LastUsageDate,
  ChgImpactETORoutingDets.NumberOfUsages AS NumberOfUsages,
  cast('00000000'as abap.dats) AS ValidityStartDate,
  cast('00000000'as abap.dats) AS ValidityEndDate,
  _BillOfOperationsTypeText[1:Language = $session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
  _ChgImpctETORtgETOVersBOM[1:BillOfOperationsGroup = BillOfOperationsGroup and BillOfOperationsType = BillOfOperationsType and BillOfOperationsVariant = BillOfOperationsVariant and BillOfOperationsVersion = BillOfOperationsVersion].MaterialName AS MaterialName,
  _ChgImpctETORtgETOVersBOM[1:BillOfOperationsGroup = BillOfOperationsGroup and BillOfOperationsType = BillOfOperationsType and BillOfOperationsVariant = BillOfOperationsVariant and BillOfOperationsVersion = BillOfOperationsVersion].Material AS Material
FROM I_ProductionRoutingVersion AS ChgImpactETORoutingDets
LEFT OUTER JOIN I_BillOfOperationsTypeText AS _BillOfOperationsTypeText ON BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType  -- association [0..*]
LEFT OUTER JOIN I_BillOfOperationsStatusText AS _BillOfOperationsStatusText ON BillOfOperationsStatus = _BillOfOperationsStatusText.BillOfOperationsStatus AND _BillOfOperationsStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ChgImpactRoutingMBOM AS _ChgImpctETORtgETOVersBOM ON BillOfOperationsGroup = _ChgImpctETORtgETOVersBOM.BillOfOperationsGroup AND BillOfOperationsType = _ChgImpctETORtgETOVersBOM.BillOfOperationsType AND BillOfOperationsVariant = _ChgImpctETORtgETOVersBOM.BillOfOperationsVariant AND BillOfOperationsVersion = _ChgImpctETORtgETOVersBOM.BillOfOperationsVersion  -- association [0..*]
LEFT OUTER JOIN I_ProductionRoutingVersion AS _ProdnRtgReferenceVersion ON BillOfOperationsType = _ProdnRtgReferenceVersion.BillOfOperationsType AND BillOfOperationsGroup = _ProdnRtgReferenceVersion.BillOfOperationsGroup AND BillOfOperationsVariant = _ProdnRtgReferenceVersion.BillOfOperationsVariant AND BOOReferenceVersion = _ProdnRtgReferenceVersion.BillOfOperationsVersion  -- association [0..1]
LEFT OUTER JOIN C_ChgImpactRoutingDets AS _SourceRouting ON BillOfOperationsRefType = _SourceRouting.BillOfOperationsType AND BillOfOperationsRefGroup = _SourceRouting.BillOfOperationsGroup AND BillOfOperationsRefVariant = _SourceRouting.BillOfOperationsVariant AND BOOReferenceVersion = _SourceRouting.BillOfOperationsVersion  -- association [0..1]
;