I_FldLogsReturnItem

DDL: I_FLDLOGSRETURNITEM SQL: IFLRETURNITEM Type: view COMPOSITE Package: FLOG_RETURN
52 Fields 1 Data Sources 2 Associations

Field Logistics Return Stock

I_FldLogsReturnItem is a Composite CDS View that provides data about "Field Logistics Return Stock" in SAP S/4HANA. It reads from 1 data source (I_FldLogsFlogReturnBasic) and exposes 52 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder. It has 2 associations to related views. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsFlogReturnBasic I_FldLogsFlogReturnBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FldLogsEWMMngdStorLocation _EWMActive $projection.FldLogsRemotePlant = _EWMActive.FldLogsRemotePlant and $projection.RemoteStorageLocation = _EWMActive.RemoteStorageLocation
[0..1] I_FldLogsPurOrdSpclStockDetail _WBSElement $projection.FldLogsReferenceDocumentNumber = _WBSElement.ReferenceSDDocument and $projection.StockTransportOrderItem = _WBSElement.PurchasingDocumentItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLRETURNITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field Logistics Return Stock view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY FldLogsRemotePlant FldLogsRemotePlant Plant
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder Order
KEY RemoteStorageLocation RemoteStorageLocation Location
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
FldLogsReturnStatus FldLogsReturnStatus Return Status
RetblQtyInBaseUnit RetblQtyInBaseUnit Quantity in Base Uni
RetblQtyBaseUnit RetblQtyBaseUnit UoM
RetblQtyInOrderUnit RetblQtyInOrderUnit Order Qty.
RetblQtyOrderUnit RetblQtyOrderUnit Order Unit
LoadingQtyInOrderUnit LoadingQtyInOrderUnit Load Quantity
DispatchedStartDate DispatchedStartDate Dispatch Date
SupplyingStorageLocation SupplyingStorageLocation Location
RequestedShippingDate RequestedShippingDate Shipping Date
RequestedShippingTime RequestedShippingTime Shipping Time
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
ReferenceOrder ReferenceOrder Reference Order
ReferencePurchasingDocument ReferencePurchasingDocument Purchasing Doc.
FldLogsContainerID FldLogsContainerID Container ID
InventoryUsabilityCode InventoryUsabilityCode Stock Type
FldLogsItemType FldLogsItemType Type
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
ReturnRecordCreationDateTime ReturnRecordCreationDateTime Time Stamp
ReturnRecordChangeDateTime ReturnRecordChangeDateTime Time Stamp
FieldLogisticsTransferPlant FieldLogisticsTransferPlant Plant
FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
FldLogsContainerUUID FldLogsContainerUUID Container UUID
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
FldLogsRetOutbDelivIsCreated FldLogsRetOutbDelivIsCreated Checkbox
FieldLogisticsStorageBin FieldLogisticsStorageBin Storage Bin
EWMWarehouse _EWMActive EWMWarehouse Warehouse No.
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
StockTransportOrderItem StockTransportOrderItem STO Item
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
OrderOperation OrderOperation Operation or Phase
BillOfMaterialItemNumber BillOfMaterialItemNumber 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_FldLogsReturnItem.
-- 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: IFLRETURNITEM

CREATE VIEW I_FldLogsReturnItem AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  FldLogsReferenceDocCategory,
  FldLogsReturnStatus,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  LoadingQtyInOrderUnit,
  DispatchedStartDate,
  SupplyingStorageLocation,
  RequestedShippingDate,
  RequestedShippingTime,
  FldLogsRecommendedAction,
  FldLogsSupplyProcess,
  ReferenceOrder,
  ReferencePurchasingDocument,
  FldLogsContainerID,
  InventoryUsabilityCode,
  FldLogsItemType,
  Batch,
  ValuationType,
  SerialNumber,
  ReturnRecordCreationDateTime,
  ReturnRecordChangeDateTime,
  FieldLogisticsTransferPlant,
  FldLogsSuplrItemUUID,
  FldLogsContainerUUID,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsRetOutbDelivIsCreated,
  FieldLogisticsStorageBin,
  _EWMActive.EWMWarehouse AS EWMWarehouse,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsRefurbishmentOrder,
  PurchaseOrderItem,
  IsMarkedForDeletion,
  InboundDelivery,
  InboundDeliveryItem,
  MaterialDocument,
  MaterialDocumentItem,
  Reservation,
  ReservationItem,
  StockTransportOrderItem,
  FldLogsVoyageDestStage,
  OrderOperation,
  BillOfMaterialItemNumber
FROM I_FldLogsFlogReturnBasic
LEFT OUTER JOIN I_FldLogsEWMMngdStorLocation AS _EWMActive ON FldLogsRemotePlant = _EWMActive.FldLogsRemotePlant AND RemoteStorageLocation = _EWMActive.RemoteStorageLocation  -- association [1..1]
LEFT OUTER JOIN I_FldLogsPurOrdSpclStockDetail AS _WBSElement ON FldLogsReferenceDocumentNumber = _WBSElement.ReferenceSDDocument AND StockTransportOrderItem = _WBSElement.PurchasingDocumentItem  -- association [0..1]
;

Learn More