I_FldLogsSerialItemRecord

DDL: I_FLDLOGSSERIALITEMRECORD Type: view_entity COMPOSITE

Field logistics serial item record

I_FldLogsSerialItemRecord is a Composite CDS View that provides data about "Field logistics serial item record" in SAP S/4HANA. It reads from 1 data source (I_FldLogsBatchSrlNmbrItmsEnhcd) and exposes 16 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsBatchSrlNmbrItmsEnhcd I_FldLogsBatchSrlNmbrItmsEnhcd from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field logistics serial item record view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

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 WBSElementInternalID WBSElementInternalID WBS Internal ID
FldLogsRemoteQuantity FldLogsRemoteQuantity
RetblQtyInOrderUnit RetblQtyInOrderUnit
RetblQtyOrderUnit RetblQtyOrderUnit
BaseUnit BaseUnit Unit of Measure
FldLogsReturnStatus FldLogsReturnStatus
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action

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_FldLogsSerialItemRecord.
-- 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_FldLogsSerialItemRecord AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  Batch,
  ValuationType,
  WBSElementInternalID,
  FldLogsRemoteQuantity,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  BaseUnit,
  FldLogsReturnStatus,
  FldLogsSupplyProcess,
  FldLogsRecommendedAction
FROM I_FldLogsBatchSrlNmbrItmsEnhcd
;