C_FldLogsSerialItems

DDL: C_FLDLOGSSERIALITEMS Type: view_entity CONSUMPTION Package: FLOG_RETURN
23 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

FL Returns Serial items

C_FldLogsSerialItems is a Consumption CDS View that provides data about "FL Returns Serial items" in SAP S/4HANA. It reads from 1 data source (R_FldLogsSerialItemsTP) and exposes 23 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder. It is exposed through 1 OData service (UI_RETURNSINITIATION). It is used in 1 Fiori application: Initiate Returns - By product. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
R_FldLogsSerialItemsTP R_FldLogsSerialItemsTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FL Returns Serial items view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RETURNSINITIATION UI_RETURNSINITIATION V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F4252 Initiate Returns - By product Transactional An application to initiate Returns from a remote location in Field Logistics via the Product List View

Initiate Returns - By product

Business Role: Warehouse Clerk (Oil & Gas)

Fields (23)

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
KEY RemoteStorageLocation RemoteStorageLocation
KEY Batch Batch Lot No.
KEY ValuationType ValuationType Valuation Type
KEY SerialNumber SerialNumber Serial Number
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
FldLogsRemoteQuantity FldLogsRemoteQuantity
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
FldLogsRecommendedActionTextlocalized
RetblQtyInOrderUnit RetblQtyInOrderUnit
RetblQtyOrderUnit RetblQtyOrderUnit
RetblQtyBaseUnit RetblQtyBaseUnit Unit of Measure
FldLogsReturnStatus FldLogsReturnStatus
FldLogsReturnStatusTextlocalized
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
PlantName _PlantText PlantName Plant Name
StorageLocationName _RemoteStorageLocationText StorageLocationName Storage Loc. Name
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
_StockredirectedtoparentC_FldLogsStock

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_FldLogsSerialItems.
-- 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 C_FldLogsSerialItems AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  Batch,
  ValuationType,
  SerialNumber,
  WBSElementInternalID,
  FldLogsRemoteQuantity,
  FldLogsRecommendedAction,
  _ActionText.FldLogsRecommendedActionText : localized AS FldLogsRecommendedActionTextlocalized,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyBaseUnit,
  FldLogsReturnStatus,
  _RetStatText.FldLogsReturnStatusText : localized AS FldLogsReturnStatusTextlocalized,
  FldLogsSupplyProcess,
  _PlantText.PlantName AS PlantName,
  _RemoteStorageLocationText.StorageLocationName AS StorageLocationName,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID
FROM R_FldLogsSerialItemsTP
;

Learn More