I_FldLogsReturnDocFlow

DDL: I_FLDLOGSRETURNDOCFLOW SQL: IFLDOCFLWRETURN Type: view COMPOSITE

FL Return Docflow Union

I_FldLogsReturnDocFlow is a Composite CDS View that provides data about "FL Return Docflow Union" in SAP S/4HANA. It reads from 19 data sources and exposes 175 fields with key fields PrecedingDocument, PrecedingDocumentItem, SubsequentDocument, SubsequentDocumentItem, PrecedingDocumentItem. It has 7 associations to related views.

Data Sources (19)

SourceAliasJoin Type
I_DeliveryDocumentItem _DeliveryItem union_all
I_FldLogsGoodsIssueAll _GoodsIssue union_all
I_FldLogsFlogReturnBasic I_FldLogsFlogReturnBasic union_all
I_FldLogsGoodsIssue I_FldLogsGoodsIssue union_all
I_FldLogsGoodsIssueEWM I_FldLogsGoodsIssueEWM union_all
I_FldLogsGoodsReceipt I_FldLogsGoodsReceipt union_all
I_FldLogsGoodsReceipt I_FldLogsGoodsReceipt union_all
I_FldLogsGoodsReceipt I_FldLogsGoodsReceipt union_all
I_FldLogsGoodsReceipt I_FldLogsGoodsReceipt union_all
I_FldLogsInboundDel I_FldLogsInboundDel union_all
I_FldLogsInboundDelivEWMTsk I_FldLogsInboundDelivEWMTsk union_all
I_FldLogsInboundDelivEWMTsk I_FldLogsInboundDelivEWMTsk union_all
I_FldLogsInboundDelivEWMTsk I_FldLogsInboundDelivEWMTsk union_all
I_FldLogsOutboundDelivEWMTsk I_FldLogsOutboundDelivEWMTsk union_all
I_FldLogsRefDocFlow I_FldLogsRefDocFlow union_all
I_FldLogsRetMaintOrder I_FldLogsRetMaintOrder from
I_FldLogsRetMaintOrder I_FldLogsRetMaintOrder union_all
I_FldLogsRetMaintOrder I_FldLogsRetMaintOrder union_all
I_FldLogsReturnItem I_FldLogsReturnItem union_all

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_FldLogsRefDocFlow _Refdocflow _Refdocflow.ReferenceDocumentNumber = _DeliveryItem.ReferenceSDDocument
[0..1] I_FldLogsOutboundDelivEWM _EWMRefDocOBDItem _EWMRefDocOBDItem.FldLogsReferenceDocumentNumber = I_FldLogsRefDocFlow.ReferenceDocumentNumber and _EWMRefDocOBDItem.ReferenceDocumentItem = I_FldLogsRefDocFlow.ReferenceDocumentItem
[0..1] I_FldLogsOutboundDelivEWMTsk _ObdEwm I_FldLogsGoodsIssueEWM.ReferenceDocumentNumber = _ObdEwm.FldLogsReferenceDocumentNumber and I_FldLogsGoodsIssueEWM.ReferenceDocumentItem = _ObdEwm.ReferenceDocumentItem
[0..1] I_FldLogsGoodsIssueAll _GoodsIssue I_FldLogsInboundDel.ReferenceDocumentNumber = _GoodsIssue.ReferenceDocumentNumber and I_FldLogsInboundDel.ReferenceDocumentItem = _GoodsIssue.ReferenceDocumentItem
[0..1] I_FldLogsInboundDelivEWM _EWMRefDocIBDItem _EWMRefDocIBDItem.FldLogsReferenceDocumentNumber = _GoodsIssue.ReferenceDocumentNumber and _EWMRefDocIBDItem.ReferenceDocumentItem = _GoodsIssue.ReferenceDocumentItem
[0..1] I_FldLogsReturnItem _LeGoodsReceipt $projection.FldLogsReferenceDocumentNumber = _LeGoodsReceipt.FldLogsReferenceDocumentNumber
[0..1] I_FldLogsReturnItem _FlogReturn $projection.FldLogsReferenceDocumentNumber = _FlogReturn.FldLogsReferenceDocumentNumber

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLDOCFLWRETURN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label FL Return Docflow Union view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (175)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument Order
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem ReferenceDocumentItem Outb. Delivery Item
KEY SubsequentDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory FldLogsReferenceDocCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem _Refdocflow ReferenceDocumentItem Outb. Delivery Item
KEY SubsequentDocument I_DeliveryDocumentItem DeliveryDocument Reference Doc Number
KEY SubsequentDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber _Refdocflow ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem _Refdocflow ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem ReferenceDocumentItem Outb. Delivery Item
KEY SubsequentDocument _EWMRefDocOBDItem EWMOutboundDeliveryOrder Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument WarehouseTask Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentcategory
SubsequentDocumentcategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask WarehouseTask Warehouse Task
WarehouseTaskasPrecedingDocument
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument GoodsIssueMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentcategory
SubsequentDocumentcategory GoodsMovementType Movement Type
FldLogsReferenceDocumentNumber ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask _ObdEwm WarehouseTask Warehouse Task
KEY PrecedingDocumentItem OutboundDeliveryItem Outb. Delivery Item
KEY SubsequentDocument GoodsIssueMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory GoodsMovementType Movement Type
FldLogsReferenceDocumentNumber ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument InboundDelivery Reference Doc Number
KEY SubsequentDocumentItem DeliveryDocumentItem Reference item
PrecedingDocumentCategory I_FldLogsGoodsIssueAll GoodsMovementType
SubsequentDocumentCategory InboundDeliveryItemCategory Movement Type
FldLogsReferenceDocumentNumber ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument _EWMRefDocIBDItem EWMInboundDelivery Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory I_FldLogsGoodsIssueAll GoodsMovementType
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber I_FldLogsGoodsIssueAll ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
EWMInboundDeliveryasPrecedingDocument
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument GoodsReceiptMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory GoodsMovementType Movement Type
FldLogsReferenceDocumentNumber _EWMRefDocIBDItem FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem _EWMRefDocIBDItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem DeliveryDocumentItem Outb. Delivery Item
KEY SubsequentDocument GoodsReceiptMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory GoodsMovementType Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument GoodsReceiptMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory I_FldLogsGoodsIssueAll GoodsMovementType
SubsequentDocumentCategory I_FldLogsGoodsReceipt GoodsMovementType Movement Type
FldLogsReferenceDocumentNumber I_FldLogsGoodsIssueAll ReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem I_FldLogsGoodsIssueAll ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument WarehouseTask Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory _EwmGoodsReceipt GoodsMovementType
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument _LeGoodsReceipt MaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument FldLogsReferenceDocumentNumber Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument _FlogReturn InboundDelivery Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument GoodsReceiptMaterialDocument Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument WarehouseTask Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask WarehouseTask Warehouse Task
KEY PrecedingDocumentItem Outb. Delivery Item
KEY SubsequentDocument FldLogsReferenceDocumentNumber Reference Doc Number
KEY SubsequentDocumentItem Reference item
PrecedingDocumentCategory
SubsequentDocumentCategory Movement Type
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ReferenceDocumentLongNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
WarehouseTask WarehouseTask Warehouse Task
EWMWarehouse _EwmGoodsReceipt EWMWarehouse Warehouse No.

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
;