C_FldLogsMaterialTrackingItem

DDL: C_FLDLOGSMATERIALTRACKINGITEM Type: view_entity CONSUMPTION
27 Fields

Material Tracking Item

C_FldLogsMaterialTrackingItem is a Consumption CDS View that provides data about "Material Tracking Item" in SAP S/4HANA.

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

Fields (27)

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
Plant Plant Valuation Area
MaterialName
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit
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
RequirementDate RequirementDate Requirement Date
FldLogsPlndArrivalRemoteDate FldLogsPlndArrivalRemoteDate Plnd. Date
FldLogsActualArrivalRemoteDate FldLogsActualArrivalRemoteDate Actl. Date
FldLogsLeadTimeRemoteDays FldLogsLeadTimeRemoteDays Lead Time
FldLogsPlannedArrivalBaseDate FldLogsPlannedArrivalBaseDate Plnd. Date
FldLogsActualArrivalBaseDate FldLogsActualArrivalBaseDate Actl. Date
FldLogsLeadTimeBaseDays FldLogsLeadTimeBaseDays Lead Time
FldLogsMatlTrckgUUID FldLogsMatlTrckgUUID MT UUID
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,
  Plant,
  cast('' as maktx ) AS MaterialName,
  RequirementQuantityInBaseUnit,
  BaseUnit,
  Reservation,
  ReservationItem,
  ReservationType,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess,
  PurchasingDocument,
  RequirementDate,
  FldLogsPlndArrivalRemoteDate,
  FldLogsActualArrivalRemoteDate,
  FldLogsLeadTimeRemoteDays,
  FldLogsPlannedArrivalBaseDate,
  FldLogsActualArrivalBaseDate,
  FldLogsLeadTimeBaseDays,
  FldLogsMatlTrckgUUID,
  _SupplyProcessText.FldLogsSupplyProcessText AS FldLogsSupplyProcessText
;

Learn More