I_ProdAllocationSequenceGroup

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_ProdAllocationSequenceGroup.
-- 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: IPASQNC_GRP

CREATE VIEW I_ProdAllocationSequenceGroup AS
SELECT
  ProdAllocSequenceGroupUUID,
  ProductAllocationSequenceGroup,
  ProductAllocationSequence,
  ProductAllocationSequenceUUID,
  ProdAllocSequenceGroupType,
  ProdAllocSqncGrpPriorityValue,
  NumberOfBackwardCnsmpnPeriods,
  NumberOfForwardCnsmpnPeriods,
  HorizontalConsumptionDirection,
  PastPeriodIsAllowed,
  OnlyOverlappingQtyIsConsumed,
  ProdAllocSqncGrpCnsmpnUnit,
  IsDeleted
FROM pasqnc_grp
LEFT OUTER JOIN I_ProdAllocationSequenceGroupT AS _Text ON ProdAllocSequenceGroupUUID = _Text.ProdAllocSequenceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_ProductAllocationSequence AS _ProductAllocationSequence ON ProductAllocationSequenceUUID = _ProductAllocationSequence.ProductAllocationSequenceUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocSequenceConstraint AS _ProdAllocSequenceConstraint ON ProdAllocSequenceGroupUUID = _ProdAllocSequenceConstraint.ProdAllocSequenceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_HrzConsumptionDirection AS _HrzConsumptionDirection ON HorizontalConsumptionDirection = _HrzConsumptionDirection.HorizontalConsumptionDirection  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocSequenceGroupType AS _ProdAllocSequenceGroupType ON ProdAllocSequenceGroupType = _ProdAllocSequenceGroupType.ProdAllocSequenceGroupType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConsumptionUnitOfMeasure ON ProdAllocSqncGrpCnsmpnUnit = _ConsumptionUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;