I_TRACKTOOLUSAGEHISTORYDATA

CDS View
11 Fields 1 CDS Views

Composite CDS to retrieve tool claim history

I_TRACKTOOLUSAGEHISTORYDATA is a CDS View in S/4HANA. Composite CDS to retrieve tool claim history. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_TrackToolUsageHistoryData view from CONSUMPTION Consumption CDS for history data

Fields (11)

KeyField CDS FieldsUsed in Views
KEY EquipmentHistoryDocument EquipmentHistoryDocument 1
BusinessPartner BusinessPartner 1
EquipClaimDurationInSeconds EquipClaimDurationInSeconds 1
Equipment Equipment 1
EquipmentClaimDateTime EquipmentClaimDateTime 1
EquipmentClaimedByUser EquipmentClaimedByUser 1
EquipmentClaimType EquipmentClaimType 1
EquipmentUnclaimDateTime EquipmentUnclaimDateTime 1
EquipmentUnclaimedByUser EquipmentUnclaimedByUser 1
NmbrOfObjectsClaimingEquipment NmbrOfObjectsClaimingEquipment 1
WorkCenterInternalID WorkCenterInternalID 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.

-- Composite CDS to retrieve tool claim history
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRACKTOOLUSAGEHISTORYDATA (
    EQUIPMENTHISTORYDOCUMENT,
    BUSINESSPARTNER,
    EQUIPCLAIMDURATIONINSECONDS,
    EQUIPMENT,
    EQUIPMENTCLAIMDATETIME,
    EQUIPMENTCLAIMEDBYUSER,
    EQUIPMENTCLAIMTYPE,
    EQUIPMENTUNCLAIMDATETIME,
    EQUIPMENTUNCLAIMEDBYUSER,
    NMBROFOBJECTSCLAIMINGEQUIPMENT,
    WORKCENTERINTERNALID,
    PRIMARY KEY (EQUIPMENTHISTORYDOCUMENT)
);

Learn More