I_TrackToolUsageTP

DDL: I_TRACKTOOLUSAGETP SQL: ITTUTRACKTOOLSTP Type: view TRANSACTIONAL Package: MPE_EXEC_TRACKABLE_TOOLS
36 Fields 1 Data Sources

Composite view for manage (track) tools application

I_TrackToolUsageTP is a Transactional CDS View that provides data about "Composite view for manage (track) tools application" in SAP S/4HANA. It reads from 1 data source (I_TrackToolUsage) and exposes 36 fields with key field Equipment. Part of development package MPE_EXEC_TRACKABLE_TOOLS.

Data Sources (1)

SourceAliasJoin Type
I_TrackToolUsage I_TrackToolUsage from

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ITTUTRACKTOOLSTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Composite view for manage (track) tools application view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.writeActivePersistence ITTUTRACKTOOLSTP view
ObjectModel.representativeKey Equipment view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (36)

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

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_TrackToolUsageTP.
-- 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: ITTUTRACKTOOLSTP

CREATE VIEW I_TrackToolUsageTP AS
SELECT
  Equipment,
  MaintObjectInternalID,
  EquipmentCategory,
  CreatedByUser,
  SerialNumber,
  Material,
  UniqueItemIdentifier,
  EquipmentClaimType,
  Plant,
  MaintenancePlant,
  StorageLocation,
  EquipLastClaimDateTime,
  EquipLastUnclaimDateTime,
  EquipmentHistoryDocument,
  OperationActivityName,
  OpActyNtwkElementExternalID,
  Operation,
  OrderID,
  WorkCenterInternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  BusinessPartner,
  EquipClaimDurationInSeconds,
  EquipmentIsClaimed,
  EquipmentIsOnHold,
  AuthorizationGroup
FROM I_TrackToolUsage
;

Learn More