C_OutboundDeliveryFs

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_OutboundDeliveryFs.
-- 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: COUTBDELIVFS

CREATE VIEW C_OutboundDeliveryFs AS
SELECT
  OutboundDelivery,
  cast( OutboundDelivery._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,
  cast(_OverallSDProcessStatus._Text[1: Language=$session.system_language].OverallSDProcessStatusDesc as gbstk_name) AS OverallSDProcessStatusDesc,
  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,
  cast( case when OutboundDelivery.DeliveryDate < $session.system_date and OverallSDProcessStatus != 'C' then 1 else case when OutboundDelivery.DeliveryDate = $session.system_date and OverallSDProcessStatus != 'C' then 2 else case when OutboundDelivery.DeliveryDate > $session.system_date and OverallSDProcessStatus != 'C' then 3 else 0 end end end as abap.int1 ) as DeliveryDateCriticality AS int1asDeliveryDateCriticality,
  SalesOrganization,
  cast (HeaderGrossWeight as le_brgew) AS HeaderGrossWeight,
  HeaderNetWeight,
  HeaderVolume,
  DocumentDate,
  OutboundDelivery._DeliveryDocumentType.DeliveryDocumentType AS DeliveryDocumentType,
  PickingDate,
  cast( case when OverallPickingStatus = '' then 0 else case when OutboundDelivery.PickingDate < $session.system_date and (OverallPickingStatus = 'A' or OverallPickingStatus = 'B') then 1 else case when OutboundDelivery.PickingDate = $session.system_date and (OverallPickingStatus = 'A' or OverallPickingStatus = 'B') then 2 else case when OutboundDelivery.PickingDate > $session.system_date and (OverallPickingStatus = 'A' or OverallPickingStatus = 'B') then 3 else 0 end end end end as abap.int1 ) as PickingDateCriticality AS int1asPickingDateCriticality,
  cast( TransportationPlanningDate as tddat_plan) AS TransportationPlanningDate,
  LoadingDate,
  cast(PlannedGoodsIssueDate as wadak_plan) AS PlannedGoodsIssueDate,
  cast( case when OverallGoodsMovementStatus = 'C' then 0 else case when OutboundDelivery.PlannedGoodsIssueDate < $session.system_date and OverallGoodsMovementStatus != 'C' then 1 else case when OutboundDelivery.PlannedGoodsIssueDate = $session.system_date and OverallGoodsMovementStatus != 'C' then 2 else case when OutboundDelivery.PlannedGoodsIssueDate > $session.system_date and OverallGoodsMovementStatus != 'C' then 3 else 0 end end end end as abap.int1 ) as PlannedGIDateCriticality AS int1asPlannedGIDateCriticality,
  cast(ActualGoodsMovementDate as vdm_actualgmdate) AS ActualGoodsMovementDate,
  cast(OverallPickingStatus as kostk_code) AS OverallPickingStatus,
  OverallWarehouseActivityStatus,
  OverallPickingConfStatus,
  OverallPackingStatus,
  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,
  OverallChmlCmplncStatus,
  cast( case OverallChmlCmplncStatus when '' then 0 when 'A' then 3 when 'C' then 1 when 'D' then 1 else 0 end as abap.int1) as OvrlChmlCmplncStsCriticality AS int1asOvrlChmlCmplncStsCriticality,
  OverallDangerousGoodsStatus,
  cast( case OverallDangerousGoodsStatus when '' then 0 when 'A' then 3 when 'B' then 2 when 'D' then 1 else 0 end as abap.int1 ) as OvrlDngrsGdsStsCriticality AS int1asOvrlDngrsGdsStsCriticality,
  OverallSafetyDataSheetStatus,
  IntcoExtTransfOfCtrlDteTmeTmzn,
  IntcoExtActlTransfOfCtrlDteTme,
  IntcoExtPlndTransfOfCtrlDteTme,
  IntcoIntTransfOfCtrlDteTmeTmzn,
  IntcoIntActlTransfOfCtrlDteTme,
  IntcoIntPlndTransfOfCtrlDteTme,
  cast ('' as char0064) AS ExtPlndTransfOfCtrlFrmdDTVal,
  cast ('' as char0064) AS ExtActlTransfOfCtrlFrmdDTVal,
  cast ('' as char0064) AS IntPlndTransfOfCtrlFrmdDTVal,
  cast ('' as char0064) AS IntActlTransfOfCtrlFrmdDTVal,
  cast ( case OverallSafetyDataSheetStatus when '' then 0 when 'A' then 3 when 'B' then 2 when 'D' then 1 else 0 end as abap.int1 ) as OvrlSftyDataSheetStsCritlty AS int1asOvrlSftyDataSheetStsCritlty,
  EU_DeliveryARCStatus,
  cast('' as char005) AS IsActive,
  cast('' as xfeld) AS ExciseMovementIsActive,
  cast('' as xfeld) AS IntTransfOfCtrlDteAreRelevant,
  cast('' as xfeld) AS ExtTransfOfCtrlDteAreRelevant,
  ProposedDeliveryRoute,
  OvrlTrdCmplncLegalCtrlChkSts,
  OverallTrdCmplncEmbargoSts,
  OvrlTrdCmplncSnctndListChkSts,
  cast('' as boole_d preserving type ) AS TradeComplianceIsInactive
FROM I_OutboundDelivery AS OutboundDelivery
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _Partner ON OutboundDelivery = _Partner.SDDocument AND _Partner.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_OutboundDeliveryItemFs AS _OutboundDeliveryItemFs ON OutboundDelivery = _OutboundDeliveryItemFs.OutboundDelivery  -- association [0..*]
LEFT OUTER JOIN I_OverallPickingStatus AS _OverallPickingStatus ON OverallPickingStatus = _OverallPickingStatus.OverallPickingStatus  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocument AS _Extension ON OutboundDelivery = _Extension.DeliveryDocument association[0..1] to C_SDDocumentPartnerCard as _ShipToParty on OutboundDelivery.OutboundDelivery = _ShipToParty.SDDocument AND _ShipToParty.PartnerFunction = 'WE' AND _ShipToParty.SDDocumentItem is initial association[0..1] to C_SDDocumentPartnerCard as _SoldToParty on OutboundDelivery.OutboundDelivery = _SoldToParty.SDDocument AND _SoldToParty.PartnerFunction = 'AG' AND _SoldToParty.SDDocumentItem is initial  -- association [1]
;