I_ProductWorkScheduling

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 I_ProductWorkScheduling.
-- 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 I_ProductWorkScheduling AS
SELECT
  WorkScheduling.Product AS Product,
  WorkScheduling.Plant AS Plant,
  WorkScheduling.MaterialBaseQuantity AS MaterialBaseQuantity,
  WorkScheduling.UnlimitedOverDelivIsAllowed AS UnlimitedOverDelivIsAllowed,
  WorkScheduling.OverDelivToleranceLimit AS OverDelivToleranceLimit,
  WorkScheduling.UnderDelivToleranceLimit AS UnderDelivToleranceLimit,
  WorkScheduling.ProductionInvtryManagedLoc AS ProductionInvtryManagedLoc,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  WorkScheduling.ProdnOrderIsBatchRequired AS ProdnOrderIsBatchRequired,
  WorkScheduling.ProdIsWithdrawnFrmProdnBin AS ProdIsWithdrawnFrmProdnBin,
  WorkScheduling.TransitionMatrixProductsGroup AS TransitionMatrixProductsGroup,
  WorkScheduling.OrderChangeManagementProfile AS OrderChangeManagementProfile,
  WorkScheduling.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  WorkScheduling.SetupAndTeardownTime AS SetupAndTeardownTime,
  WorkScheduling.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  WorkScheduling.TransitionTime AS TransitionTime,
  WorkScheduling.ProcessingTimeInDays AS ProcessingTimeInDays,
  WorkScheduling.ProductionSupervisor AS ProductionSupervisor,
  WorkScheduling.ProductProductionQuantityUnit AS ProductProductionQuantityUnit,
  WorkScheduling.HasProductionVersion AS HasProductionVersion,
  _Product.BaseUnit AS BaseUnit,
  _Product._BaseUnitOfMeasure AS _BaseUnitOfMeasure
FROM P_ProductPlantBasic AS WorkScheduling
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN E_Productplant AS _ProdWorkSchedulingExt ON Product = _ProdWorkSchedulingExt.Product AND Plant = _ProdWorkSchedulingExt.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _ProductionInvtryManagedLoc ON Plant = _ProductionInvtryManagedLoc.Plant AND ProductionInvtryManagedLoc = _ProductionInvtryManagedLoc.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ProductionSchedulingProfile AS _ProductionSchedulingProfile ON Plant = _ProductionSchedulingProfile.Plant AND ProductionSchedulingProfile = _ProductionSchedulingProfile.ProductionSchedulingProfile  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductProductionQuantityUnit ON ProductProductionQuantityUnit = _ProductProductionQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProdnOrdBatDetnCodeText AS _ProdnOrdBatDetnCodeText ON ProdnOrderIsBatchRequired = _ProdnOrdBatDetnCodeText.ProductionOrderBatchCode  -- association [0..*]
LEFT OUTER JOIN I_ProdComponentBackflushCodeT AS _ProdComponentBackflushCodeT ON MatlCompIsMarkedForBackflush = _ProdComponentBackflushCodeT.ProductComponentBackflushCode  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription_2 AS _ProductDescription ON Product = _ProductDescription.Product  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON BaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ProdProdnQuantityUnitText ON ProductProductionQuantityUnit = _ProdProdnQuantityUnitText.UnitOfMeasure  -- association [0..*]
;