I_RFDYConfirmation

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_RFDYConfirmation.
-- 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: IRFDYCNFIRMATION

CREATE VIEW I_RFDYConfirmation AS
SELECT
  RFDYConfirmationUUID,
  RFDYRequirementUUID,
  RFDYWorklistUUID,
  ConfirmedQuantityInBaseUnit,
  PrevConfirmedQtyInBaseUnit,
  BaseUnit,
  ConfdProdAvailabilityUTCDteTme,
  ConfdProdAvailabilityTimeZone,
  ConfirmedLoadingUTCDateTime,
  ConfirmedLoadingTimeZone,
  ConfirmedGoodsIssueUTCDateTime,
  ConfirmedGoodsIssueTimeZone,
  ConfirmedDeliveryUTCDateTime,
  ConfirmedDeliveryTimeZone,
  IsWithinSelectionHorizon
FROM atp_r4d_confirma
LEFT OUTER JOIN I_RFDYRequirement AS _RFDYRequirement ON RFDYRequirementUUID = _RFDYRequirement.RFDYRequirementUUID  -- association [1..1]
LEFT OUTER JOIN I_RFDYWorklist AS _RFDYWorklist ON RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;