I_EQUIPMENTPRTBYINTERNALKEY

CDS View
8 Fields 10 CDS Views

Equipment PRT by internal key

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_EquipProdnRsceToolVH view_entity from CONSUMPTION PRT related Equipments
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
P_SFIOperationActivityPRTUnion view_entity inner CONSUMPTION
P_TrackToolUsageOAPRT view from COMPOSITE
P_TrackToolUsageTTUCLAIMED view from COMPOSITE
P_UnplndRegnProdnRsceTool view_entity inner COMPOSITE
R_ProdnRtgOpEquipPRTAssgmtTP view_entity inner TRANSACTIONAL Equipment PRT Assignment
R_ProdnRtgOpEquipPRTAssgmtTP_2 view_entity inner TRANSACTIONAL Equipment PRT Assignment

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 5
KEY ProductionResourceInternalID ProductionResourceInternalID 2
KEY ProductionResourceType ProductionResourceType 2
_EquipmentProdnRsceTool _EquipmentProdnRsceTool 1
ChangeNumber ChangeNumber 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 1
ProductionResourceToolGroup2 ProductionResourceToolGroup2 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,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    _EQUIPMENTPRODNRSCETOOL,
    CHANGENUMBER,
    PRODUCTIONRESOURCETOOLGROUP1,
    PRODUCTIONRESOURCETOOLGROUP2,
    PRODUCTIONRESOURCEUSAGE,
    PRIMARY KEY (EQUIPMENT, PRODUCTIONRESOURCEINTERNALID, PRODUCTIONRESOURCETYPE)
);

Learn More