C_RFDYSalesOrderRequirement

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_RFDYSalesOrderRequirement.
-- 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 C_RFDYSalesOrderRequirement AS
SELECT
  RFDYRequirementUUID,
  RFDYMaterialUUID,
  cast(ATPRelevantDocument as vdm_sales_order preserving type) AS SalesOrder,
  ATPRelevantDocumentItem AS SalesOrderItem,
  ATPRelevantDocScheduleLine AS SalesOrderScheduleLine,
  SupplyingStorageLocation,
  Batch,
  ReqdProdAvailabilityUTCDateTme,
  OrderedQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  RequestedLoadingUTCDateTime,
  RequestedGoodsIssueUTCDateTime,
  RequestedDeliveryUTCDateTime,
  IsProtected,
  IsPostponed,
  PostponementCategory,
  IsProcessable,
  _SalesOrderScheduleLine._SalesOrder.SoldToParty AS SoldToParty,
  _SalesOrderScheduleLine._SalesOrder._SoldToParty.CustomerName AS SoldToPartyName,
  _SalesOrderScheduleLine._SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrderScheduleLine._SalesOrder.SalesOrderDate AS SalesOrderDate,
  _SalesOrderScheduleLine._SalesOrderItem.DeliveryPriority AS DeliveryPriority
FROM I_RFDYRequirementWithCalcFigs
LEFT OUTER JOIN C_RFDYMaterialWithTotals AS _RFDYMaterial ON RFDYMaterialUUID = _RFDYMaterial.RFDYMaterialUUID  -- association [1..1]
LEFT OUTER JOIN C_RFDYChangedRequirement AS _RFDYChangedRequirement ON RFDYRequirementUUID = _RFDYChangedRequirement.RFDYRequirementUUID  -- association [0..*]
LEFT OUTER JOIN C_RFDYSalesOrderConfirmation AS _RFDYSalesOrderConfirmation ON RFDYRequirementUUID = _RFDYSalesOrderConfirmation.RFDYRequirementUUID  -- association [1..*]
LEFT OUTER JOIN C_RFDYSalesOrderConfirmation AS _RFDYSlsOrdConfWthnSelHorizon ON RFDYRequirementUUID = _RFDYSlsOrdConfWthnSelHorizon.RFDYRequirementUUID AND _RFDYSlsOrdConfWthnSelHorizon.IsWithinSelectionHorizon = 'X'  -- association [1..1]
LEFT OUTER JOIN C_RFDYSalesOrderConfirmation AS _RFDYSlsOrdConfOutwithSelHrzn ON RFDYRequirementUUID = _RFDYSlsOrdConfOutwithSelHrzn.RFDYRequirementUUID AND _RFDYSlsOrdConfOutwithSelHrzn.IsWithinSelectionHorizon = ''  -- association [1..*]
LEFT OUTER JOIN C_RFDYSalesOrder AS _RFDYSalesOrder ON SalesOrder = _RFDYSalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderScheduleLine AS _SalesOrderScheduleLine ON SalesOrder = _SalesOrderScheduleLine.SalesOrder AND SalesOrderItem = _SalesOrderScheduleLine.SalesOrderItem AND SalesOrderScheduleLine = _SalesOrderScheduleLine.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN I_PostponementCategoryText AS _PostponementCategoryText ON PostponementCategory = _PostponementCategoryText.PostponementCategory  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON deliverypriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderType AS _SalesOrderType ON salesordertype = _SalesOrderType.SalesOrderType  -- association [0..1]
LEFT OUTER JOIN C_RFDYOutboundDeliveryItem AS _OutboundDeliveryItem ON SalesOrder = _OutboundDeliveryItem.ReferenceSDDocument AND SalesOrderItem = _OutboundDeliveryItem.ReferenceSDDocumentItem AND _OutboundDeliveryItem.ReferenceSDDocumentCategory = 'C'  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesOrderTypeText ON salesordertype = _SalesOrderTypeText.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPriorityText AS _DeliveryPriorityText ON deliverypriority = _DeliveryPriorityText.DeliveryPriority  -- association [0..*]
;