I_MATERIALPRTBYINTERNALKEY

CDS View
12 Fields 15 CDS Views

Material PRT by internal key

I_MATERIALPRTBYINTERNALKEY is a CDS View in S/4HANA. Material PRT by internal key. It contains 12 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_MatlProdnRsceToolVH view_entity from CONSUMPTION PRT related Materials
I_BOOOpMaterialPRTChangeState view inner COMPOSITE BOO Operation Material Production Resource/Tool Change State
I_MaterialProdnRsceTool view from BASIC Material Production Resource Tool
I_ProductPRTByInternalKeyTP view from TRANSACTIONAL BO Node : Product Resource Tool
P_MaterialPRTPlantRegnControl view_entity from COMPOSITE
P_MfgExecEventHistOpActy view inner COMPOSITE
P_MstrRcpOpMatlPRTAssgmt view_entity inner COMPOSITE
P_OpActyInstceTestPRTUnion view_entity inner CONSUMPTION
P_PRTEquipmentAssignment view_entity union_all COMPOSITE
P_SFIAtOpActyTestEquipPRTUnion view_entity inner CONSUMPTION
P_SFIOpActyTrcblUsedPRTUnion view_entity inner CONSUMPTION
P_SFOOpActyTrcblUsedPRTUnion view_entity inner CONSUMPTION
P_TrackToolUsageOAPRT view union_all COMPOSITE
R_ProdnRtgOpMatlPRTAssgmtTP view_entity inner TRANSACTIONAL Material PRT Assignment
R_ProdnRtgOpMatlPRTAssgmtTP_2 view_entity inner TRANSACTIONAL Material PRT Assignment

Fields (12)

KeyField CDS FieldsUsed in Views
KEY Plant Plant,PlantForEdit,ProdnRsceToolPlant 8
KEY ProductionResourceInternalID ProductionResourceInternalID 4
KEY ProductionResourceType ProductionResourceType 3
_Material _Material 1
_Plant _Plant 1
ChangeNumber ChangeNumber 1
Equipment Equipment 1
Material Material,MaterialComponent 10
Product Product 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 2
ProductionResourceToolGroup2 ProductionResourceToolGroup2 2
ProductionResourceUsage ProductionResourceUsage 4

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.

-- Material PRT by internal key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALPRTBYINTERNALKEY (
    PLANT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    _MATERIAL,
    _PLANT,
    CHANGENUMBER,
    EQUIPMENT,
    MATERIAL,
    PRODUCT,
    PRODUCTIONRESOURCETOOLGROUP1,
    PRODUCTIONRESOURCETOOLGROUP2,
    PRODUCTIONRESOURCEUSAGE,
    PRIMARY KEY (PLANT, PRODUCTIONRESOURCEINTERNALID, PRODUCTIONRESOURCETYPE)
);

Learn More