I_TRACKTOOLUSAGEHISTORY

CDS View
5 Fields 4 CDS Views

Track Tool Usage: History for equipment

I_TRACKTOOLUSAGEHISTORY is a CDS View in S/4HANA. Track Tool Usage: History for equipment. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_TrackToolUsageHistoryData view from COMPOSITE Composite CDS to retrieve tool claim history
I_TrackToolUsageLastHistData view from COMPOSITE Track Tool Usage: The last record from historical data
P_TrackToolUsageHistoryMax view from COMPOSITE Composite CDS to retrieve tool claim history
P_TrackToolUsageTTUCLAIMED view inner COMPOSITE CLAIMED tools

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY EquipmentHistoryDocument EquipmentHistoryDocument 2
EquipmentClaimDateTime EquipLastClaimDateTime 1
EquipmentClaimType EquipmentClaimType 1
EquipmentUnclaimDateTime EquipLastUnclaimDateTime 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Track Tool Usage: History for equipment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRACKTOOLUSAGEHISTORY (
    EQUIPMENT,
    EQUIPMENTHISTORYDOCUMENT,
    EQUIPMENTCLAIMDATETIME,
    EQUIPMENTCLAIMTYPE,
    EQUIPMENTUNCLAIMDATETIME,
    PRIMARY KEY (EQUIPMENT, EQUIPMENTHISTORYDOCUMENT)
);

Learn More