I_FldLogsFlogReturnBasic

DDL: I_FLDLOGSFLOGRETURNBASIC SQL: IFLFLOGRETURN Type: view BASIC Package: FLOG_RETURN
51 Fields 1 Data Sources

Field Logistics Return Table

I_FldLogsFlogReturnBasic is a Basic CDS View that provides data about "Field Logistics Return Table" in SAP S/4HANA. It reads from 1 data source (flog_return) and exposes 51 fields with key fields Material, FldLogsRemotePlant, FldLogsMaintenanceOrder, FldLogsReferenceDocumentNumber, ReferenceDocumentItem. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
flog_return _FlogReturn from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLFLOGRETURN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field Logistics Return Table view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY Material flog_return matnr Vehicle Model
KEY FldLogsRemotePlant flog_return plant Valuation Area
KEY FldLogsMaintenanceOrder flog_return work_order Order
KEY FldLogsReferenceDocumentNumber flog_return ref_doc Reference Key
KEY ReferenceDocumentItem flog_return ref_docitem Ref. Doc. Item
KEY RemoteStorageLocation flog_return remote_lgort Location
FldLogsReferenceDocCategory ref_doctyp Document Type
FldLogsReturnStatus ret_status Return Status
RetblQtyInBaseUnit ret_quantity Quantity in Base Uni
RetblQtyBaseUnit unit UoM
RetblQtyInOrderUnit retqtyinorderunit Order Qty.
RetblQtyOrderUnit retqtyorderunit Order Unit
LoadingQtyInOrderUnit load_quantity Load Quantity
DispatchedStartDate dispatchdat Dispatch Date
SupplyingStorageLocation supply_lgort Supply SLoc
RequestedShippingDate shipdate Shipping Date
RequestedShippingTime shiptime Shipping Time
FldLogsRecommendedAction rec_action Recommended Action
FldLogsSupplyProcess fldlogssupplyprocess Supply Process
ReferenceOrder ref_wrk_order Order
ReferencePurchasingDocument ref_po Purchasing Doc.
FldLogsContainerID cont_id Container ID
FldLogsContainerUnitUUID fldlogscontainerunituuid Container Unit ID
FldLogsContainerUUID fldlogscontaineruuid Container UUID
InventoryUsabilityCode ret_stock_typ Return Stock Type
Batch batch Lot No.
ValuationType valuation_typ Valuation type
SerialNumber serialno Serial Number
ReturnRecordCreationDateTime createdat Time Stamp
ReturnRecordChangeDateTime changedat Time Stamp
IsMarkedForDeletion flog_return del_flag Deletion Ind.
FldLogsSuplrItemUUID fldlogssuplritemuuid Suplr Item UUID
FldLogsRetOutbDelivIsCreated fldlogsretoutbdeliviscreated Checkbox
FldLogsItemType item_type Type
FieldLogisticsTransferPlant fieldlogisticstransferplant Plant
FldLogsShptItemUUID fldlogsshptitemuuid Shipment Item ID
OutboundDelivery outbounddelivery LE Delivery
OutboundDeliveryItem outbounddeliveryitem Logistics Execution Delivery Item
FieldLogisticsStorageBin fieldlogisticsstoragebin Storage Bin
FldLogsRefurbishmentOrder fldlogsrefurbishmentorder Order
PurchaseOrderItem purchaseorderitem Purchasing Document Item
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
BillOfMaterialItemNumber

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_FldLogsFlogReturnBasic.
-- 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: IFLFLOGRETURN

CREATE VIEW I_FldLogsFlogReturnBasic AS
SELECT
  _FlogReturn.matnr AS Material,
  _FlogReturn.plant AS FldLogsRemotePlant,
  _FlogReturn.work_order AS FldLogsMaintenanceOrder,
  _FlogReturn.ref_doc AS FldLogsReferenceDocumentNumber,
  _FlogReturn.ref_docitem AS ReferenceDocumentItem,
  _FlogReturn.remote_lgort AS RemoteStorageLocation,
  ref_doctyp AS FldLogsReferenceDocCategory,
  ret_status AS FldLogsReturnStatus,
  ret_quantity AS RetblQtyInBaseUnit,
  unit AS RetblQtyBaseUnit,
  retqtyinorderunit AS RetblQtyInOrderUnit,
  retqtyorderunit AS RetblQtyOrderUnit,
  load_quantity AS LoadingQtyInOrderUnit,
  dispatchdat AS DispatchedStartDate,
  supply_lgort AS SupplyingStorageLocation,
  shipdate AS RequestedShippingDate,
  shiptime AS RequestedShippingTime,
  rec_action AS FldLogsRecommendedAction,
  FldLogsSupplyProcess,
  ref_wrk_order AS ReferenceOrder,
  ref_po AS ReferencePurchasingDocument,
  cont_id AS FldLogsContainerID,
  FldLogsContainerUnitUUID,
  FldLogsContainerUUID,
  ret_stock_typ AS InventoryUsabilityCode,
  Batch,
  valuation_typ AS ValuationType,
  serialno AS SerialNumber,
  createdat AS ReturnRecordCreationDateTime,
  changedat AS ReturnRecordChangeDateTime,
  _FlogReturn.del_flag AS IsMarkedForDeletion,
  FldLogsSuplrItemUUID,
  FldLogsRetOutbDelivIsCreated,
  item_type AS FldLogsItemType,
  FieldLogisticsTransferPlant,
  FldLogsShptItemUUID,
  OutboundDelivery,
  OutboundDeliveryItem,
  FieldLogisticsStorageBin,
  FldLogsRefurbishmentOrder,
  PurchaseOrderItem,
  InboundDelivery,
  InboundDeliveryItem,
  MaterialDocument,
  MaterialDocumentItem,
  Reservation,
  ReservationItem,
  StockTransportOrderItem,
  FldLogsVoyageDestStage,
  cast(_FlogReturn.orderoperation as vdm_vornr preserving type) AS OrderOperation,
  cast(_FlogReturn.billofmaterialitemnumber as vdm_sposn preserving type) AS BillOfMaterialItemNumber
FROM flog_return AS _FlogReturn
;

Learn More