C_FldLogsMaterialTrackingItem

DDL: C_FLDLOGSMATERIALTRACKINGITEM Type: view_entity CONSUMPTION Package: FLOG_COMMON_MT
21 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Material Tracking Item

C_FldLogsMaterialTrackingItem is a Consumption CDS View that provides data about "Material Tracking Item" in SAP S/4HANA. It reads from 1 data source (I_FldLogsMatlTrckgItemRecord) and exposes 21 fields with key fields FldLogsMatlTrckgRefDocID1, FldLogsMatlTrckgRefDocID2, FldLogsMatlTrckgRefDocID3, FldLogsMaterialTrackingGroupID. It is exposed through 1 OData service (UI_MATERIALTRACKING). It is used in 1 Fiori application: Logistics Tracking. Part of development package FLOG_COMMON_MT.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsMatlTrckgItemRecord I_FldLogsMatlTrckgItemRecord from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Material Tracking Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MATERIALTRACKING UI_MATERIALTRACKING V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F7382 Logistics Tracking Transactional Logistics Tracking monitor all the logistics items which meet the demand originating from the maintenance orders. You can track them throughout the whole supply chain, that is, logistics from vendor to the base, from base to remote location, and return back to the base.

Logistics Tracking

Business Role: Supply Chain Analyst (Oil & Gas)

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY FldLogsMatlTrckgRefDocID1 FldLogsMatlTrckgRefDocID1 Ref Document ID1
KEY FldLogsMatlTrckgRefDocID2 FldLogsMatlTrckgRefDocID2 Ref Document ID2
KEY FldLogsMatlTrckgRefDocID3 FldLogsMatlTrckgRefDocID3 Ref Document ID3
KEY FldLogsMaterialTrackingGroupID FldLogsMaterialTrackingGroupID Group ID
FldLogsMatlTrckgDocumentID FldLogsMatlTrckgDocumentID Reference Document Number
FldLogsMatlTrckgDocTypeID FldLogsMatlTrckgDocTypeID Document Type ID
Material
MaterialName
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit Value
BaseUnit BaseUnit Unit of Measure
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
ReservationType ReservationType Reservation Type
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore Hold On-Shore
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
PurchasingDocument PurchasingDocument Purchasing Document
FldLogsContainerID FldLogsContainerID Container ID
FldLogsShptVoyageNumber FldLogsShptVoyageNumber Voyage Number
RequirementDate RequirementDate Requirement Date
FldLogsSupplyProcessText _SupplyProcessText FldLogsSupplyProcessText
_Milestone _Milestone

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_FldLogsMaterialTrackingItem.
-- 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_FldLogsMaterialTrackingItem AS
SELECT
  FldLogsMatlTrckgRefDocID1,
  FldLogsMatlTrckgRefDocID2,
  FldLogsMatlTrckgRefDocID3,
  FldLogsMaterialTrackingGroupID,
  FldLogsMatlTrckgDocumentID,
  FldLogsMatlTrckgDocTypeID,
  cast('' as matnr) AS Material,
  cast('' as maktx ) AS MaterialName,
  RequirementQuantityInBaseUnit,
  BaseUnit,
  Reservation,
  ReservationItem,
  ReservationType,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess,
  PurchasingDocument,
  FldLogsContainerID,
  FldLogsShptVoyageNumber,
  RequirementDate,
  _SupplyProcessText.FldLogsSupplyProcessText AS FldLogsSupplyProcessText
FROM I_FldLogsMatlTrckgItemRecord
;

Learn More