I_FldLogsReturnDocFlow

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 I_FldLogsReturnDocFlow.
-- 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: IFLDOCFLWRETURN

CREATE VIEW I_FldLogsReturnDocFlow AS
SELECT
  cast( FldLogsMaintenanceOrder as preced_doc) AS PrecedingDocument,
  cast(MaintenanceOrderComponent as posnr_nach) AS PrecedingDocumentItem,
  cast(FldLogsReferenceDocumentNumber as subsequ_doc) AS SubsequentDocument,
  cast(ReferenceDocumentItem as posnr_von) AS SubsequentDocumentItem,
  PrecedingDocumentCategory,
  cast(FldLogsReferenceDocCategory as char4) AS SubsequentDocumentCategory,
  FldLogsReferenceDocumentNumber,
  cast(lpad(FldLogsReferenceDocumentNumber,20,'0') as char20) AS ReferenceDocumentLongNumber,
  ReferenceDocumentItem,
  cast('' as /scwm/tanum_conv_alpha ) AS WarehouseTask,
  EWMWarehouse AS WarehouseTaskasPrecedingDocument,
  cast('' as /scwm/lgnum) as EWMWarehouse AS EWMInboundDeliveryasPrecedingDocument,
  _EwmGoodsReceipt.EWMWarehouse AS EWMWarehouse
FROM I_FldLogsRetMaintOrder
LEFT OUTER JOIN I_FldLogsRefDocFlow AS _Refdocflow ON _Refdocflow.ReferenceDocumentNumber = _DeliveryItem.ReferenceSDDocument  -- association [0..1]
LEFT OUTER JOIN I_FldLogsOutboundDelivEWM AS _EWMRefDocOBDItem ON _EWMRefDocOBDItem.FldLogsReferenceDocumentNumber = I_FldLogsRefDocFlow.ReferenceDocumentNumber AND _EWMRefDocOBDItem.ReferenceDocumentItem = I_FldLogsRefDocFlow.ReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsOutboundDelivEWMTsk AS _ObdEwm ON I_FldLogsGoodsIssueEWM.ReferenceDocumentNumber = _ObdEwm.FldLogsReferenceDocumentNumber AND I_FldLogsGoodsIssueEWM.ReferenceDocumentItem = _ObdEwm.ReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsGoodsIssueAll AS _GoodsIssue ON I_FldLogsInboundDel.ReferenceDocumentNumber = _GoodsIssue.ReferenceDocumentNumber AND I_FldLogsInboundDel.ReferenceDocumentItem = _GoodsIssue.ReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsInboundDelivEWM AS _EWMRefDocIBDItem ON _EWMRefDocIBDItem.FldLogsReferenceDocumentNumber = _GoodsIssue.ReferenceDocumentNumber AND _EWMRefDocIBDItem.ReferenceDocumentItem = _GoodsIssue.ReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnItem AS _LeGoodsReceipt ON FldLogsReferenceDocumentNumber = _LeGoodsReceipt.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnItem AS _FlogReturn ON FldLogsReferenceDocumentNumber = _FlogReturn.FldLogsReferenceDocumentNumber  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FldLogsFlogReturnBasic, I_DeliveryDocumentItem, I_FldLogsRefDocFlow, I_FldLogsOutboundDelivEWMTsk, I_FldLogsGoodsIssueEWM, I_FldLogsGoodsIssue, I_FldLogsInboundDel, I_FldLogsGoodsIssueAll, I_FldLogsGoodsReceipt, I_FldLogsInboundDelivEWMTsk, I_FldLogsRetMaintOrder, I_FldLogsReturnItem
;