I_TRACKTOOLUSAGETP

CDS View

Composite view for manage (track) tools application

I_TRACKTOOLUSAGETP is a CDS View in S/4HANA. Composite view for manage (track) tools application. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_TrackToolUsageTP view from CONSUMPTION Track Tool Usage

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
AuthorizationGroup AuthorizationGroup 1
EquipClaimDurationInSeconds EquipClaimDurationInSeconds 1
EquipmentCategory EquipmentCategory 1
MaintenancePlant MaintenancePlant 1
MaintObjectInternalID MaintObjectInternalID 1
Material Material 1
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 1
Operation Operation 1
OperationActivityName OperationActivityName 1
OrderID OrderID 1
Plant Plant 1
SerialNumber SerialNumber 1
StorageLocation StorageLocation 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 view for manage (track) tools application
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRACKTOOLUSAGETP (
    EQUIPMENT,
    AUTHORIZATIONGROUP,
    EQUIPCLAIMDURATIONINSECONDS,
    EQUIPMENTCATEGORY,
    MAINTENANCEPLANT,
    MAINTOBJECTINTERNALID,
    MATERIAL,
    OPACTYNTWKELEMENTEXTERNALID,
    OPERATION,
    OPERATIONACTIVITYNAME,
    ORDERID,
    PLANT,
    SERIALNUMBER,
    STORAGELOCATION,
    WORKCENTERINTERNALID,
    PRIMARY KEY (EQUIPMENT)
);