C_FldLogsProdReturnHistory

DDL: C_FLDLOGSPRODRETURNHISTORY SQL: CFLPRODRETHISTRY Type: view CONSUMPTION Package: FLOG_RETURN_WOV
17 Fields 1 Data Sources 4 Associations 2 OData Services 1 Fiori Apps

Return history of a Product

C_FldLogsProdReturnHistory is a Consumption CDS View that provides data about "Return history of a Product" in SAP S/4HANA. It reads from 1 data source (I_FldLogsReturnItem) and exposes 17 fields with key fields Material, FldLogsRemotePlant, FldLogsMaintenanceOrder, RemoteStorageLocation, FldLogsReferenceDocumentNumber. It has 4 associations to related views. It is exposed through 2 OData services (ASQL_F4682, UI_RETURNSWORKORDERVIEW). It is used in 1 Fiori application: Initiate Returns - By order. Part of development package FLOG_RETURN_WOV.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsReturnItem I_FldLogsReturnItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Plant _PlantText $projection.FldLogsRemotePlant = _PlantText.Plant
[0..1] I_StorageLocation _RemoteStorageLocationText $projection.RemoteStorageLocation = _RemoteStorageLocationText.StorageLocation and $projection.FldLogsRemotePlant = _RemoteStorageLocationText.Plant
[0..1] I_RecommendedActionText _RecActionText $projection.FldLogsRecommendedAction = _RecActionText.FldLogsRecommendedAction
[0..1] I_FldLogsReturnStatusT _RetStatText $projection.FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFLPRODRETHISTRY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Return history of a Product view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4682 ASQL_F4682 C2 NOT_RELEASED
UI_RETURNSWORKORDERVIEW UI_RETURNSWORKORDERVIEW V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F4682 Initiate Returns - By order Transactional An application to initiate Returns from a remote location in Field Logistics via the Maintenance Order List View.

Initiate Returns - By order

Business Role: Warehouse Clerk (Oil & Gas)

This feature enables you as a warehouse clerk (IOG) to post the products back to remote stock, which can then be returned. This is allowed for a single reservation as well as for multiple products assigned to a particular maintenance order.

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY FldLogsRemotePlant FldLogsRemotePlant Plant
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder
KEY RemoteStorageLocation RemoteStorageLocation
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
FldLogsReturnStatus FldLogsReturnStatus
FldLogsReturnStatusText _RetStatText FldLogsReturnStatusText
RetblQtyInOrderUnit RetblQtyInOrderUnit
RetblQtyOrderUnit RetblQtyOrderUnit
FldLogsRecommendedActionText _RecActionText FldLogsRecommendedActionText
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
ReturnRecordChangeDateTime ReturnRecordChangeDateTime
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
PlantName _PlantText PlantName Plant Name
StorageLocationName _RemoteStorageLocationText StorageLocationName Storage Loc. Name

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 C_FldLogsProdReturnHistory.
-- 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: CFLPRODRETHISTRY

CREATE VIEW C_FldLogsProdReturnHistory AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsReferenceDocCategory,
  FldLogsReturnStatus,
  _RetStatText.FldLogsReturnStatusText AS FldLogsReturnStatusText,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  _RecActionText.FldLogsRecommendedActionText AS FldLogsRecommendedActionText,
  FldLogsRecommendedAction,
  ReturnRecordChangeDateTime,
  IsMarkedForDeletion,
  _PlantText.PlantName AS PlantName,
  _RemoteStorageLocationText.StorageLocationName AS StorageLocationName
FROM I_FldLogsReturnItem
LEFT OUTER JOIN I_Plant AS _PlantText ON FldLogsRemotePlant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _RemoteStorageLocationText ON RemoteStorageLocation = _RemoteStorageLocationText.StorageLocation AND FldLogsRemotePlant = _RemoteStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_RecommendedActionText AS _RecActionText ON FldLogsRecommendedAction = _RecActionText.FldLogsRecommendedAction  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnStatusT AS _RetStatText ON FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus  -- association [0..1]
;

Learn More