I_TRACKTOOLUSAGEHISTOPACTY

CDS View

Track Tool Usage: History for equipment by claim type OA

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_TrackToolUsageCountForDoc view union COMPOSITE Counter of claimed objects for the document
I_TrackToolUsgeHistOpActyByDoc view from COMPOSITE Track Tool Usage: History for equipment by claim type OA
P_TrackToolUsageOpActyMin view from COMPOSITE Composite CDS to retrieve tool claim history
P_TrackToolUsageOpActyMinInst view from COMPOSITE Composite CDS to retrieve tool claim history
P_TrackToolUsageSingleOpActy view from COMPOSITE Composite CDS to retrieve tool claim history

Fields (4)

KeyField CDS FieldsUsed in Views
KEY EquipmentHistoryDocument EquipmentHistoryDocument 4
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 2
ShopFloorItem ShopFloorItem 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 by claim type OA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRACKTOOLUSAGEHISTOPACTY (
    EQUIPMENTHISTORYDOCUMENT,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    SHOPFLOORITEM,
    PRIMARY KEY (EQUIPMENTHISTORYDOCUMENT, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);