C_CustomerReturnDeliveryFS

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_CustomerReturnDeliveryFS.
-- 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: CCUSTRETDELFS

CREATE VIEW C_CustomerReturnDeliveryFS AS
SELECT
  CustomerReturnDelivery AS ReturnsDelivery,
  cast( _CustomerReturnDelivery._DeliveryDocumentType._Text[1: Language=$session.system_language].DeliveryDocumentTypeName as bezei20) AS DeliveryDocumentTypeName,
  ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyFullName,
  SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyFullName,
  ShippingPoint,
  OverallSDProcessStatus,
  cast( case OverallSDProcessStatus when '' then 0 when 'A' then 2 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 )as OvrlSDProcessStatusCriticality AS int1asOvrlSDProcessStatusCriticality,
  DeliveryDate,
  SalesOrganization,
  cast(HeaderGrossWeight as le_brgew) AS HeaderGrossWeight,
  HeaderNetWeight,
  HeaderWeightUnit,
  HeaderVolume,
  HeaderVolumeUnit,
  DocumentDate,
  _CustomerReturnDelivery._DeliveryDocumentType.DeliveryDocumentType AS DeliveryDocumentType,
  cast (PlannedGoodsIssueDate as wadak_plan) AS PlannedGoodsIssueDate,
  ActualGoodsMovementDate,
  OverallPutawayStatus,
  OverallPickingConfStatus,
  OverallWarehouseActivityStatus,
  OverallGoodsMovementStatus,
  cast( case OverallGoodsMovementStatus when '' then 0 when 'A' then 2 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 )as OvrlGdsMovementStsCriticality AS int1asOvrlGdsMovementStsCriticality,
  DelivAdvncdShipgRcvgRlvnce,
  ReadyForWarehouseExecStatus
FROM I_CustomerReturnDelivery AS _CustomerReturnDelivery
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _Partner ON ReturnsDelivery = _Partner.SDDocument AND _Partner.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_CustomerReturnDeliveryItemFS AS _CustomerReturnDeliveryItemFs ON ReturnsDelivery = _CustomerReturnDeliveryItemFs.CustomerReturnDelivery  -- association [0..*]
LEFT OUTER JOIN E_DeliveryDocument AS _Extension ON ReturnsDelivery = _Extension.DeliveryDocument association[0..1] to C_SDDocumentPartnerCard as _ShipToParty on _CustomerReturnDelivery.CustomerReturnDelivery = _ShipToParty.SDDocument AND _ShipToParty.PartnerFunction = 'WE' AND _ShipToParty.SDDocumentItem is initial association[0..1] to C_SDDocumentPartnerCard as _SoldToParty on _CustomerReturnDelivery.CustomerReturnDelivery = _SoldToParty.SDDocument AND _SoldToParty.PartnerFunction = 'AG' AND _SoldToParty.SDDocumentItem is initial  -- association [1]
;