I_FldLogsProcessReturnHeader

DDL: I_FLDLOGSPROCESSRETURNHEADER Type: view_entity COMPOSITE
46 Fields 1 Data Sources 10 Associations

Process Return Header

I_FldLogsProcessReturnHeader is a Composite CDS View that provides data about "Process Return Header" in SAP S/4HANA. It reads from 1 data source (I_FldLogsProcReturnHeaderBasic) and exposes 46 fields with key field FldLogsReturnHeaderUUID. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsProcReturnHeaderBasic I_FldLogsProcReturnHeaderBasic from

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_RecommendedActionText _RecommendedActionText _RecommendedActionText.FldLogsRecommendedAction = $projection.FldLogsRecommendedAction
[0..*] I_FldLogsCtnItmQuickActionTxt _HandlingDecisionText _HandlingDecisionText.FldLogsCtnQuickAction = $projection.FldLogsCtnQuickAction and _HandlingDecisionText.FieldLogisticsProcessType = $projection.FieldLogisticsProcessType
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_FldLogsProcRetStatusText _StatusText $projection.FldLogsReturnedItemStatus = _StatusText.FldLogsReturnedItemStatus
[0..1] I_FldLogsProcReturnItemSum _Quantity _Quantity.FldLogsReturnHeaderUUID = $projection.FldLogsReturnHeaderUUID and _Quantity.FldLogsRetdQtyOrderUnit = $projection.FldLogsRetdQtyOrderUnit
[0..*] I_FldLogsSupplyProcessText _SupplyProcessText $projection.FldLogsSupplyProcess = _SupplyProcessText.FldLogsSupplyProcess
[0..1] I_FldLogsReceivedShipmentItem _ShipmentItem $projection.FldLogsShptItmHndlgUnitID is initial and $projection.FldLogsContainerID = _ShipmentItem.FldLogsContainerID and $projection.DispatchedStartDate = _ShipmentItem.DispatchedStartDate and $projection.FldLogsDispatchPlant = _ShipmentItem.FldLogsDispatchPlant and $projection.NumberOfCtnTripsPerDay = _ShipmentItem.NumberOfCtnTripsPerDay and $projection.FldLogsReferenceDocumentNumber = _ShipmentItem.FldLogsReferenceDocumentNumber
[0..1] I_FldLogsRcvdHndlgUntItm _HandlingUnit $projection.FldLogsShptItmHndlgUnitID is not initial and $projection.FldLogsShptItemUUID = _HandlingUnit.FldLogsShptItemUUID and $projection.FldLogsShptItmHndlgUnitID = _HandlingUnit.FldLogsShptItmHndlgUnitID and $projection.FldLogsReferenceDocumentNumber = _HandlingUnit.FldLogsReferenceDocumentNumber
[0..1] I_FldLogsPurOrdSpclStockDetail _PurOrdSpclStkDet $projection.ReferenceSDDocument = _PurOrdSpclStkDet.ReferenceSDDocument and $projection.PurchasingDocumentItem = _PurOrdSpclStkDet.PurchasingDocumentItem
[1..1] E_FieldLogisticsReturnedItem _ProcRetHdrExt $projection.FldLogsReturnHeaderUUID = _ProcRetHdrExt.FldLogsReturnHeaderUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Process Return Header view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY FldLogsReturnHeaderUUID FldLogsReturnHeaderUUID Return Header UUID
FldLogsContainerID FldLogsContainerID Container ID
DispatchedStartDate DispatchedStartDate Dispatch Date
FldLogsDispatchPlant FldLogsDispatchPlant Plant
NumberOfCtnTripsPerDay NumberOfCtnTripsPerDay Trip Counter
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID
Material Material Vehicle Model
ReceiptDate ReceiptDate Goods receipt date
FldLogsRetdQtyInOrderUnit FldLogsRetdQtyInOrderUnit Quantity
FldLogsQtyInProcess _Quantity FldLogsQtyInProcess Quantity
FldLogsRetdQtyOrderUnit FldLogsRetdQtyOrderUnit Order Unit
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
FldLogsCtnQuickAction FldLogsCtnQuickAction Handling Decision
FldLogsReturnedItemStatus FldLogsReturnedItemStatus Return Item Status
OrderID OrderID Order ID
FldLogsShptVoyageNumber FldLogsShptVoyageNumber Voyage Number
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocumentItem MaterialDocumentItem Material Document Item
FieldLogisticsProcessType FieldLogisticsProcessType Process Type
BatchelseBatchendasBatch
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
OutboundDeliveryendasOutboundDelivery
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
LastChangeDateTime LastChangeDateTime Timestamp
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
Operation Operation Transaction
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
FldLogsSrceStorLocID FldLogsSrceStorLocID Location
FldLogsDestStorLocID FldLogsDestStorLocID Location
FldLogsSrcePlnt FldLogsSrcePlnt Plant
FldLogsDestPlnt FldLogsDestPlnt Plant
WBSElementExternalID WBSElementExternalID WBS Element External ID
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
OrderCategory OrderCategory Order Category
_MaterialText _MaterialText
_SupplyProcessText _SupplyProcessText
_HandlingDecisionText _HandlingDecisionText
_StatusText _StatusText
_RecommendedActionText _RecommendedActionText
_PurOrdSpclStkDet _PurOrdSpclStkDet

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_FldLogsProcessReturnHeader.
-- 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.

CREATE VIEW I_FldLogsProcessReturnHeader AS
SELECT
  FldLogsReturnHeaderUUID,
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  Material,
  ReceiptDate,
  FldLogsRetdQtyInOrderUnit,
  _Quantity.FldLogsQtyInProcess AS FldLogsQtyInProcess,
  FldLogsRetdQtyOrderUnit,
  FldLogsSupplyProcess,
  FldLogsCtnQuickAction,
  FldLogsReturnedItemStatus,
  OrderID,
  FldLogsShptVoyageNumber,
  FldLogsRecommendedAction,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  FieldLogisticsProcessType,
  case when FldLogsShptItmHndlgUnitID is not initial then _HandlingUnit.Batch when _ShipmentItem.Batch is not initial then _ShipmentItem.Batch else Batch end as Batch AS BatchelseBatchendasBatch,
  FldLogsRefurbishmentOrder,
  case when FldLogsShptItmHndlgUnitID is not initial then _HandlingUnit.OutboundDelivery else _ShipmentItem.OutboundDelivery end as OutboundDelivery AS OutboundDeliveryendasOutboundDelivery,
  IsMarkedForDeletion,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  Operation,
  PurchaseOrder,
  PurchaseOrderItem,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSrcePlnt,
  FldLogsDestPlnt,
  WBSElementExternalID,
  InboundDelivery,
  InboundDeliveryItem,
  OrderCategory
FROM I_FldLogsProcReturnHeaderBasic
LEFT OUTER JOIN I_RecommendedActionText AS _RecommendedActionText ON _RecommendedActionText.FldLogsRecommendedAction = FldLogsRecommendedAction  -- association [0..*]
LEFT OUTER JOIN I_FldLogsCtnItmQuickActionTxt AS _HandlingDecisionText ON _HandlingDecisionText.FldLogsCtnQuickAction = FldLogsCtnQuickAction AND _HandlingDecisionText.FieldLogisticsProcessType = FieldLogisticsProcessType  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_FldLogsProcRetStatusText AS _StatusText ON FldLogsReturnedItemStatus = _StatusText.FldLogsReturnedItemStatus  -- association [0..*]
LEFT OUTER JOIN I_FldLogsProcReturnItemSum AS _Quantity ON _Quantity.FldLogsReturnHeaderUUID = FldLogsReturnHeaderUUID AND _Quantity.FldLogsRetdQtyOrderUnit = FldLogsRetdQtyOrderUnit  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplyProcessText AS _SupplyProcessText ON FldLogsSupplyProcess = _SupplyProcessText.FldLogsSupplyProcess  -- association [0..*]
LEFT OUTER JOIN I_FldLogsReceivedShipmentItem AS _ShipmentItem ON FldLogsShptItmHndlgUnitID is initial AND FldLogsContainerID = _ShipmentItem.FldLogsContainerID AND DispatchedStartDate = _ShipmentItem.DispatchedStartDate AND FldLogsDispatchPlant = _ShipmentItem.FldLogsDispatchPlant AND NumberOfCtnTripsPerDay = _ShipmentItem.NumberOfCtnTripsPerDay AND FldLogsReferenceDocumentNumber = _ShipmentItem.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRcvdHndlgUntItm AS _HandlingUnit ON FldLogsShptItmHndlgUnitID is not initial AND FldLogsShptItemUUID = _HandlingUnit.FldLogsShptItemUUID AND FldLogsShptItmHndlgUnitID = _HandlingUnit.FldLogsShptItmHndlgUnitID AND FldLogsReferenceDocumentNumber = _HandlingUnit.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPurOrdSpclStockDetail AS _PurOrdSpclStkDet ON ReferenceSDDocument = _PurOrdSpclStkDet.ReferenceSDDocument AND PurchasingDocumentItem = _PurOrdSpclStkDet.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_FieldLogisticsReturnedItem AS _ProcRetHdrExt ON FldLogsReturnHeaderUUID = _ProcRetHdrExt.FldLogsReturnHeaderUUID  -- association [1..1]
;

Learn More