C_RFDYMaterialWithTotals

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_RFDYMaterialWithTotals.
-- 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_RFDYMaterialWithTotals AS
SELECT
  RFDYMaterialUUID,
  RFDYWorklistUUID,
  Material,
  SupplyingPlant,
  ProcessingStatus,
  ConfirmedQuantityInBaseUnit,
  RequestedQuantityInBaseUnit,
  AvailableQuantityInBaseUnit,
  UnconsideredQuantityInBaseUnit,
  BaseUnit,
  NumberOfRqmtsWithConfDeficit,
  cast( 0 as atp_r4d_impact_normalized) AS ConfirmationDeficitImpact,
  cast( '' as atp_r4d_impact_critical_ind preserving type) AS ConfDeficitImpactIsCritical,
  coalesce(_RFDYDocSyncStatus[1: RFDYDocumentSyncStatus = 'P'].NumberOfRequirements, 0) AS NmbrOfRqmtsWithDocSyncInProc
FROM I_RFDYMaterialWithTotals
LEFT OUTER JOIN C_RFDYPrsnlWorklistWithTotQts AS _RFDYWorklist ON RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID  -- association [1..1]
LEFT OUTER JOIN C_RFDYSurplusBucket AS _RFDYSurplusBucket ON RFDYMaterialUUID = _RFDYSurplusBucket.RFDYMaterialUUID  -- association [1..*]
LEFT OUTER JOIN C_RFDYRequirementWithCalcFigs AS _RFDYRequirement ON RFDYMaterialUUID = _RFDYRequirement.RFDYMaterialUUID  -- association [1..*]
LEFT OUTER JOIN P_RFDYDocSyncStatusByMaterial AS _RFDYDocSyncStatus ON RFDYMaterialUUID = _RFDYDocSyncStatus.RFDYMaterialUUID  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;