I_PRODNRSCETOOLMASTERDATA

CDS View
25 Fields 10 CDS Views

Production Resource Tool Master Data

I_PRODNRSCETOOLMASTERDATA is a CDS View in S/4HANA. Production Resource Tool Master Data. It contains 25 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_DocumentPRTByInternalKey view_entity from BASIC Document PRT by internal key
I_EquipmentPRTByInternalKey view from BASIC Equipment PRT by internal key
I_MaterialPRTByInternalKey view from BASIC Material PRT by internal key
I_MiscPRTByInternalKey view from BASIC Miscellaneous PRT by Internal Key
I_MsrgPointPRTByInternalKey view from BASIC Measuring Point PRT by internal key
I_OpActySFIGroupPRTDetail view inner COMPOSITE Detail of a PRT of a group of SFI at OA
I_ProdnRsceToolByInternalKey view from COMPOSITE Production Resource Tool by Internal Key
P_MfgOrderPRTAssgmtDetail view_entity inner COMPOSITE Order PRT Assignment
P_TrackToolUsageOAPRTASSGNED view inner COMPOSITE PRT IDs ASSIGNED TO OA
R_MaintOrderOpProdnRsceToolTP view_entity inner TRANSACTIONAL Maintenance Order Operation PRT TP

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ProductionResourceInternalID ProductionResourceInternalID 9
KEY ProductionResourceType ProductionResourceType 9
_CreatedByUser _CreatedByUser 1
_LastChangedByUser _LastChangedByUser 1
_ProdnRsceToolCategory _ProdnRsceToolCategory 3
_ProdnRsceToolCategory_2 _ProdnRsceToolCategory_2 1
_ProdnRsceToolCategory_3 _ProdnRsceToolCategory_3 1
_ProductionResourceType _ProductionResourceType 4
ChangeNumber ChangeNumber 4
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MiscPRTAuthorizationGroup MiscPRTAuthorizationGroup 1
ProdnRsceToolBaseUnit ProdnRsceToolBaseUnit 1
ProdnRsceToolCategory ProdnRsceToolCategory 1
ProdnRsceToolCategory_2 ProdnRsceToolCategory_2 1
ProdnRsceToolIsDeleted ProdnRsceToolIsDeleted 1
ProdnRsceToolPlntLoc ProdnRsceToolPlntLoc 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 4
ProductionResourceToolGroup2 ProductionResourceToolGroup2 4
ProductionResourceToolLocation ProductionResourceToolLocation 1
ProductionResourceToolStatus ProductionResourceToolStatus 1
ProductionResourceUsage ProductionResourceUsage 4
ShopFloorRtgPRTIsRegistrable ShopFloorRtgPRTIsRegistrable 3

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.

-- Production Resource Tool Master Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNRSCETOOLMASTERDATA (
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    _CREATEDBYUSER,
    _LASTCHANGEDBYUSER,
    _PRODNRSCETOOLCATEGORY,
    _PRODNRSCETOOLCATEGORY_2,
    _PRODNRSCETOOLCATEGORY_3,
    _PRODUCTIONRESOURCETYPE,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MISCPRTAUTHORIZATIONGROUP,
    PRODNRSCETOOLBASEUNIT,
    PRODNRSCETOOLCATEGORY,
    PRODNRSCETOOLCATEGORY_2,
    PRODNRSCETOOLISDELETED,
    PRODNRSCETOOLPLNTLOC,
    PRODUCTIONRESOURCETOOLGROUP1,
    PRODUCTIONRESOURCETOOLGROUP2,
    PRODUCTIONRESOURCETOOLLOCATION,
    PRODUCTIONRESOURCETOOLSTATUS,
    PRODUCTIONRESOURCEUSAGE,
    SHOPFLOORRTGPRTISREGISTRABLE,
    PRIMARY KEY (PRODUCTIONRESOURCEINTERNALID, PRODUCTIONRESOURCETYPE)
);

Learn More