I_RevProdAllocChkCstrtRslt

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_RevProdAllocChkCstrtRslt.
-- 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_RevProdAllocChkCstrtRslt AS
SELECT
  RevProdAllocChkCstrtRsltUUID,
  RevProdAllocChkSubReqUUID,
  ATPCheckUUID,
  ProdAllocSqncConstraintUUID,
  CharcValueCombinationUUID,
  ProdAllocChkDataSnapshotType,
  ProdAllocChkRstrcnStatus,
  ProdAllocCheckQuantity,
  ProdAllocRequestedQuantityUnit,
  ProdAllocCheckUTCDateTime,
  ProdAllocCheckTimeZone,
  ProdAllocGoodsIssueUTCDateTime,
  ProdAllocGoodsIssueTimeZone,
  ProdAllocMatlAvailyUTCDateTime,
  ProdAllocMatlAvailyTimeZone,
  ProdAllocLeadTmeStartUTCDteTme,
  ProdAllocReqdDelivUTCDateTime,
  ProdAllocReqdDelivTimeZone,
  NumberOfBackwardCnsmpnPeriods,
  NumberOfForwardCnsmpnPeriods,
  HorizontalConsumptionDirection,
  PastPeriodIsAllowed,
  ProdAllocLeadTimeDuration,
  ProdAllocLeadTimeDurationUnit,
  ProdAllocationConstraintStatus,
  ProductAllocationRate,
  ProdAllocCheckDateTimeType,
  OnlyOverlappingQtyIsConsumed,
  ValidityStartUTCDateTime,
  ValidityEndUTCDateTime
FROM rpalchk_cstrtr
LEFT OUTER JOIN I_ATPCheck AS _ATPCheck ON ATPCheckUUID = _ATPCheck.ATPCheckUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocSequenceConstraint AS _ProdAllocSequenceConstraint ON ProdAllocSqncConstraintUUID = _ProdAllocSequenceConstraint.ProdAllocSqncConstraintUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocObjCharcValCombn AS _ProdAllocObjCharcValCombn ON CharcValueCombinationUUID = _ProdAllocObjCharcValCombn.CharcValueCombinationUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocChkDataSnpshtType AS _ProdAllocChkDataSnpshtType ON ProdAllocChkDataSnapshotType = _ProdAllocChkDataSnpshtType.ProdAllocChkDataSnapshotType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocChkRstrcnStatus AS _ProdAllocChkRstrcnStatus ON ProdAllocChkRstrcnStatus = _ProdAllocChkRstrcnStatus.ProdAllocChkRstrcnStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON ProdAllocRequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocCheckTimeZone ON ProdAllocCheckTimeZone = _ProdAllocCheckTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _GoodsIssueTimeZone ON ProdAllocGoodsIssueTimeZone = _GoodsIssueTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _MatlAvailyTimeZone ON ProdAllocMatlAvailyTimeZone = _MatlAvailyTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ReqdDelivTimeZone ON ProdAllocReqdDelivTimeZone = _ReqdDelivTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocLeadTmeDurationUnit AS _LeadTimeDurationUnit ON ProdAllocLeadTimeDurationUnit = _LeadTimeDurationUnit.ProdAllocLeadTimeDurationUnit  -- association [0..1]
LEFT OUTER JOIN I_HrzConsumptionDirection AS _HorizontalCnsmpnDirection ON HorizontalConsumptionDirection = _HorizontalCnsmpnDirection.HorizontalConsumptionDirection  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _PastPeriodIsAllowedIndicator ON PastPeriodIsAllowed = _PastPeriodIsAllowedIndicator.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocConstraintStatus AS _ProdAllocConstraintStatus ON ProdAllocationConstraintStatus = _ProdAllocConstraintStatus.ProdAllocationConstraintStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCheckDateTimeType AS _ProdAllocCheckDateTimeType ON ProdAllocCheckDateTimeType = _ProdAllocCheckDateTimeType.ProdAllocCheckDateTimeType  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OnlyOverlappingQtyIsCnsmdInd ON OnlyOverlappingQtyIsConsumed = _OnlyOverlappingQtyIsCnsmdInd.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_RevProdAllocChkCnsmpn AS _RevProdAllocChkCnsmpn ON /* condition not available in parsed metadata */  -- association [0..*]
;