C_RFDYRequirementWithCalcFigs

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_RFDYRequirementWithCalcFigs.
-- 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: CRFDYREQ

CREATE VIEW C_RFDYRequirementWithCalcFigs AS
SELECT
  RFDYRequirementUUID,
  RFDYMaterialUUID,
  RFDYWorklistUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  SupplyingStorageLocation,
  Batch,
  ReqdProdAvailabilityUTCDateTme,
  ReqdProdAvailabilityTimeZone,
  cast(0 as syst_tzone) AS ReqdAvailyTmznUTCOffsetInSecs,
  OrderedQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  RequestedLoadingUTCDateTime,
  RequestedLoadingTimeZone,
  cast(0 as syst_tzone) AS ReqdLoadgTmznUTCOffsetInSecs,
  RequestedGoodsIssueUTCDateTime,
  RequestedGoodsIssueTimeZone,
  cast(0 as syst_tzone) AS ReqdGdsIssTmznUTCOffsetInSecs,
  RequestedDeliveryUTCDateTime,
  RequestedDeliveryTimeZone,
  cast(0 as syst_tzone) AS ReqdDelivTmznUTCOffsetInSecs,
  IsProtected,
  IsPostponed,
  PostponementCategory,
  IsProcessable,
  cast('' as atp_requirement_recipient) AS Recipient,
  _DocumentData.RecipientInInternalFormat AS IdentifiableRecipient,
  _DocumentData.RecipientName AS RecipientText,
  _DocumentData.ATPRlvtDocumentTypeInIntFrmt AS ATPRlvtDocumentTypeInIntFrmt,
  cast('' as atp_relevant_document_type) AS ATPRelevantDocumentType,
  _DocumentData._ATPRelevantDocumentTypeText[1: Language = $session.system_language ].ATPRelevantDocumentTypeName AS ATPRelevantDocumentTypeName,
  _DocumentData.ATPRelevantDocumentDate AS ATPRelevantDocumentDate,
  _DocumentData.DeliveryPriority AS DeliveryPriority
FROM I_RFDYRequirementWithCalcFigs
LEFT OUTER JOIN P_RFDYRequirementDocumentData AS _DocumentData ON RFDYRequirementUUID = _DocumentData.RFDYRequirementUUID  -- association [1..1]
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_RFDYRqmtDpndcyGroupMember AS _RFDYRqmtDpndcyGroupMember ON RFDYRequirementUUID = _RFDYRqmtDpndcyGroupMember.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_RFDYOutboundDeliveryItem AS _OutboundDeliveryItem ON ATPRelevantDocument = _OutboundDeliveryItem.ReferenceSDDocument AND ATPRelevantDocumentItem = _OutboundDeliveryItem.ReferenceSDDocumentItem AND SDDocumentCategory = _OutboundDeliveryItem.ReferenceSDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN C_RFDYSalesOrderRequirement AS _RFDYSalesOrderRequirement ON RFDYRequirementUUID = _RFDYSalesOrderRequirement.RFDYRequirementUUID  -- association [0..1]
LEFT OUTER JOIN C_RFDYStockTransptRequirement AS _RFDYStockTransptRequirement ON RFDYRequirementUUID = _RFDYStockTransptRequirement.RFDYRequirementUUID  -- association [0..1]
LEFT OUTER JOIN I_PostponementCategoryText AS _PostponementCategoryText ON PostponementCategory = _PostponementCategoryText.PostponementCategory  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPriorityText AS _DeliveryPriorityText ON deliverypriority = _DeliveryPriorityText.DeliveryPriority  -- association [0..*]
;