I_TrackToolUsage

DDL: I_TRACKTOOLUSAGE SQL: ITTUTRACKTOOLS Type: view COMPOSITE
36 Fields 1 Data Sources 2 Associations

Track Tool Usage

I_TrackToolUsage is a Composite CDS View that provides data about "Track Tool Usage" in SAP S/4HANA. It reads from 1 data source (I_TrackToolUsageEquipment) and exposes 36 fields with key field Equipment. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TrackToolUsageEquipment UsageEquipment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrackToolUsageCountForDoc _TrackToolUsageCountForDoc $projection.equipmenthistorydocument = _TrackToolUsageCountForDoc.EquipmentHistoryDocument and $projection.equipmentclaimtype = _TrackToolUsageCountForDoc.EquipmentClaimType
[0..1] I_WorkCenter _WorkCenter $projection.workcenterinternalid = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITTUTRACKTOOLS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Track Tool Usage view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_TrackToolUsageEquipment Equipment Equipment check
MaintObjectInternalID _Equipment MaintObjectInternalID Object number
EquipmentCategory _Equipment EquipmentCategory EquipCategory
CreatedByUser _Equipment CreatedByUser User Name
SerialNumber _Equipment SerialNumber Serial Number
Material _Equipment Material Vehicle Model
UniqueItemIdentifier _Equipment UniqueItemIdentifier UII
EquipmentClaimType _UsageHistDataLast EquipmentClaimType
Plant
MaintenancePlant
StorageLocationendasStorageLocation
EquipLastClaimDateTime
EquipLastUnclaimDateTime
EquipmentHistoryDocument _UsageHistDataLast EquipmentHistoryDocument
OperationActivityName _UsageHistDataLast OperationActivityName
OpActyNtwkElementExternalID _UsageHistDataLast OpActyNtwkElementExternalID Op. Activity
WorkCenterInternalID _UsageHistDataLast WorkCenterInternalID Work Center
BusinessPartner _UsageHistDataLast BusinessPartner Issuing Authority
Operation _UsageHistDataLast Operation Transaction
OrderID _UsageHistDataLast OrderID Order ID
fltpendasEquipClaimDurationInSeconds
LastChangedByUser _Equipment LastChangedByUser User Name
AuthorizationGroup _Equipment AuthorizationGroup AuthorizGroup
_TrackToolUsageCountForDoc _TrackToolUsageCountForDoc
_Equipment _Equipment
_Status _Equipment _Status
_TrackToolUsageClaimType _UsageHistDataLast _TrackToolUsageClaimType
_CreatedByUser _Equipment _CreatedByUser
_LastChangedByUser _Equipment _LastChangedByUser
_EquipmentProdnRsceTool _EquipmentProdnRsceTool
_EquipmentCategory _Equipment _EquipmentCategory
_Material _Equipment _Material
_Plant
_Order _UsageHistDataLast _Order
_MaintenancePlanningPlant
_WorkCenter _WorkCenter

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_TrackToolUsage.
-- 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: ITTUTRACKTOOLS

CREATE VIEW I_TrackToolUsage AS
SELECT
  UsageEquipment.Equipment AS Equipment,
  _Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  _Equipment.EquipmentCategory AS EquipmentCategory,
  _Equipment.CreatedByUser AS CreatedByUser,
  _Equipment.SerialNumber AS SerialNumber,
  _Equipment.Material AS Material,
  _Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  _UsageHistDataLast.EquipmentClaimType AS EquipmentClaimType,
  _Equipment._SerialNumberStockSegment.Plant AS Plant,
  _Equipment._CurrentTimeSegment.MaintenancePlanningPlant AS MaintenancePlant,
  case when _Equipment._SerialNumberStockSegment.StorageLocation is not initial then _Equipment._SerialNumberStockSegment.StorageLocation when _Equipment.StorageLocation is not initial then _Equipment.StorageLocation end as StorageLocation AS StorageLocationendasStorageLocation,
  cast (_UsageHistDataLast.EquipLastClaimDateTime as timestamp) AS EquipLastClaimDateTime,
  cast (_UsageHistDataLast.EquipLastUnclaimDateTime as timestamp) AS EquipLastUnclaimDateTime,
  _UsageHistDataLast.EquipmentHistoryDocument AS EquipmentHistoryDocument,
  _UsageHistDataLast.OperationActivityName AS OperationActivityName,
  _UsageHistDataLast.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _UsageHistDataLast.WorkCenterInternalID AS WorkCenterInternalID,
  _UsageHistDataLast.BusinessPartner AS BusinessPartner,
  _UsageHistDataLast.Operation AS Operation,
  _UsageHistDataLast.OrderID AS OrderID,
  case when _UsageHistDataLast.EquipLastClaimDateTime is not initial and _UsageHistDataLast.EquipLastClaimDateTime > _UsageHistDataLast.EquipLastUnclaimDateTime then cast( TSTMP_SECONDS_BETWEEN(_UsageHistDataLast.EquipLastClaimDateTime, tstmp_current_utctimestamp(), 'NULL') as abap.fltp ) end as EquipClaimDurationInSeconds AS fltpendasEquipClaimDurationInSeconds,
  _Equipment.LastChangedByUser AS LastChangedByUser,
  _Equipment.AuthorizationGroup AS AuthorizationGroup,
  _Equipment._Status AS _Status,
  _UsageHistDataLast._TrackToolUsageClaimType AS _TrackToolUsageClaimType,
  _Equipment._CreatedByUser AS _CreatedByUser,
  _Equipment._LastChangedByUser AS _LastChangedByUser,
  _Equipment._EquipmentCategory AS _EquipmentCategory,
  _Equipment._Material AS _Material,
  _Equipment._SerialNumberStockSegment._Plant AS _Plant,
  _UsageHistDataLast._Order AS _Order,
  _Equipment._CurrentTimeSegment._MaintenancePlanningPlant AS _MaintenancePlanningPlant
FROM I_TrackToolUsageEquipment AS UsageEquipment
LEFT OUTER JOIN I_TrackToolUsageCountForDoc AS _TrackToolUsageCountForDoc ON equipmenthistorydocument = _TrackToolUsageCountForDoc.EquipmentHistoryDocument AND equipmentclaimtype = _TrackToolUsageCountForDoc.EquipmentClaimType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON workcenterinternalid = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
;

Learn More