What is I_FldLogsReturnDocFlow in SAP S/4HANA?

I_FldLogsReturnDocFlow is a composite CDS view in SAP S/4HANA. FL Return Docflow Union It contains 137 fields.

Which tables does I_FldLogsReturnDocFlow read from?

I_FldLogsReturnDocFlow reads data from: I_FldLogsGoodsIssueAll, I_FldLogsFlogReturnBasic, I_FldLogsGoodsIssue, I_FldLogsGoodsIssueEWM, I_FldLogsGoodsReceipt and more.

What VDM layer is I_FldLogsReturnDocFlow?

I_FldLogsReturnDocFlow is classified as a Composite view that combines data from multiple basic views.

I_FldLogsReturnDocFlow

DDL: I_FLDLOGSRETURNDOCFLOW SQL: IFLDOCFLWRETURN Type: view COMPOSITE Package: FLOG_RETURN

137 Fields 19 Data Sources 6 Associations

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 137 fields with key fields PrecedingDocument, PrecedingDocumentItem, SubsequentDocument, SubsequentDocumentItem, PrecedingDocumentItem. It has 6 associations to related views. Part of development package FLOG_RETURN.

Data Sources (19)

Source	Alias	Join Type
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_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 (6)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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 (137)

Key	Field	Source Table	Source Field	Description
KEY	PrecedingDocument		FldLogsMaintenanceOrder	Order
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		FldLogsReferenceDocumentNumber	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem		ReferenceDocumentItem	Outb. Delivery Item
KEY	SubsequentDocument			Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory		FldLogsReferenceDocCategory	Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem		ReferenceDocumentItem	Outb. Delivery Item
KEY	SubsequentDocument		OutboundDelivery	Reference Doc Number
KEY	SubsequentDocumentItem		OutboundDeliveryItem	Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem		ReferenceDocumentItem	Outb. Delivery Item
KEY	SubsequentDocument	_EWMRefDocOBDItem	EWMOutboundDeliveryOrder	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
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
	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
KEY	PrecedingDocumentItem		OutboundDeliveryItem	Outb. Delivery Item
KEY	SubsequentDocument		GoodsIssueMaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory		GoodsMovementType	Movement Type
	FldLogsReferenceDocumentNumber		ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		InboundDelivery	Reference Doc Number
KEY	SubsequentDocumentItem		DeliveryDocumentItem	Reference item
	PrecedingDocumentCategory	I_FldLogsGoodsIssueAll	GoodsMovementType	Movement Type
	SubsequentDocumentCategory		InboundDeliveryItemCategory	Movement Type
	FldLogsReferenceDocumentNumber		ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument	_EWMRefDocIBDItem	EWMInboundDelivery	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory	I_FldLogsGoodsIssueAll	GoodsMovementType	Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber	I_FldLogsGoodsIssueAll	ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
	EWMInboundDeliveryasPrecedingDocument
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		GoodsReceiptMaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory		GoodsMovementType	Movement Type
	FldLogsReferenceDocumentNumber	_EWMRefDocIBDItem	FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem		DeliveryDocumentItem	Outb. Delivery Item
KEY	SubsequentDocument		GoodsReceiptMaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory		GoodsMovementType	Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		GoodsReceiptMaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory	I_FldLogsGoodsIssueAll	GoodsMovementType	Movement Type
	SubsequentDocumentCategory	I_FldLogsGoodsReceipt	GoodsMovementType	Movement Type
	FldLogsReferenceDocumentNumber	I_FldLogsGoodsIssueAll	ReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		WarehouseTask	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory	_EwmGoodsReceipt	GoodsMovementType	Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument	_LeGoodsReceipt	MaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		FldLogsReferenceDocumentNumber	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument	_FlogReturn	InboundDelivery	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		GoodsReceiptMaterialDocument	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		WarehouseTask	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
KEY	PrecedingDocumentItem			Outb. Delivery Item
KEY	SubsequentDocument		FldLogsReferenceDocumentNumber	Reference Doc Number
KEY	SubsequentDocumentItem			Reference item
	PrecedingDocumentCategory			Movement Type
	SubsequentDocumentCategory			Movement Type
	FldLogsReferenceDocumentNumber		FldLogsReferenceDocumentNumber	Reference Doc Number
	ReferenceDocumentLongNumber
	ReferenceDocumentItem		ReferenceDocumentItem	Reference item

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
  FldLogsMaintenanceOrder AS PrecedingDocument,
  cast(MaintenanceOrderComponent as posnr_nach) AS PrecedingDocumentItem,
  FldLogsReferenceDocumentNumber AS SubsequentDocument,
  cast(ReferenceDocumentItem as posnr_von) AS SubsequentDocumentItem,
  cast('WO' as char4 ) AS PrecedingDocumentCategory,
  cast(FldLogsReferenceDocCategory as char4) AS SubsequentDocumentCategory,
  FldLogsReferenceDocumentNumber,
  cast(lpad(FldLogsReferenceDocumentNumber,20,'0') as char20) AS ReferenceDocumentLongNumber,
  ReferenceDocumentItem AS WarehouseTaskasPrecedingDocument,
  ReferenceDocumentItem AS EWMInboundDeliveryasPrecedingDocument,
  ReferenceDocumentItem
FROM I_FldLogsRetMaintOrder
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_FldLogsRefDocFlow, I_FldLogsOutboundDelivEWMTsk, I_FldLogsGoodsIssueEWM, I_FldLogsGoodsIssue, I_FldLogsInboundDel, I_FldLogsGoodsIssueAll, I_FldLogsGoodsReceipt, I_FldLogsInboundDelivEWMTsk, I_FldLogsRetMaintOrder, I_FldLogsReturnItem
;

Depth:

I_FldLogsReturnDocFlow view

C_FldLogsReturnDocFlow view