I_EQUIPMENTPRTBYINTERNALKEY

CDS View
7 Fields 7 CDS Views

Equipment PRT by internal key

I_EQUIPMENTPRTBYINTERNALKEY is a CDS View in S/4HANA. Equipment PRT by internal key. It contains 7 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_BOOOpEquipmentPRTChangeState view inner COMPOSITE BOO Operation Equipment Prod. Resource/Tool Change State
I_EquipmentProdnRsceTool view from BASIC Equipment Production Resource Tool
P_MstrRcpOpEquipPRTAssgmt view_entity inner COMPOSITE Equipment PRT Assignment
P_TrackToolUsageOAPRT view from COMPOSITE PRT NAMES ASSIGNED TO OA
P_TrackToolUsageTTUCLAIMED view from COMPOSITE CLAIMED tools
R_ProdnRtgOpEquipPRTAssgmtTP view_entity inner TRANSACTIONAL Equipment PRT Assignment
R_ProdnRtgOpEquipPRTAssgmtTP_2 view_entity inner TRANSACTIONAL Equipment PRT Assignment

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 4
ChangeNumber ChangeNumber 1
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 1
ProductionResourceToolGroup2 ProductionResourceToolGroup2 1
ProductionResourceType ProductionResourceType 1
ProductionResourceUsage ProductionResourceUsage 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.

-- Equipment PRT by internal key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EQUIPMENTPRTBYINTERNALKEY (
    EQUIPMENT,
    CHANGENUMBER,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETOOLGROUP1,
    PRODUCTIONRESOURCETOOLGROUP2,
    PRODUCTIONRESOURCETYPE,
    PRODUCTIONRESOURCEUSAGE,
    PRIMARY KEY (EQUIPMENT)
);

Learn More