I_OrderProdnResourceTool

Order Production Resource Tool | view: IORDPRODNRSCTOOL | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP

Tables used: AFFH

🔑 Keys (2)
💰 Amounts
∑ Quantities (8)
📅 Dates (14)
☰ Categorical (3)
Other (12)
🔗 Relations (15)

Column Name	Description
OrderInternalBillOfOperations	Order Internal ID
OrderProdnRsceToolInternalID	Item Counter for Production Resources/Tools

Column Name	Description

Column Name	Description
📏 Unit for Quantity of Production Resources/Tools (ProdnRsceToolStdWorkQtyUnit):
ProdnRsceToolStandardWorkQty	Standard Value for Quantity of Production Resources/Tools
📏 Unit for Total Planned Quantity of Production Resource/Tool (PlannedProdnRsceToolQtyUnit):
PlannedTotalProdnRsceToolQty	Total Planned Quantity of Production Resource/Tool
📏 Unit for Actual Quantity of Production Resource/Tool (ConfirmedProdnRsceToolQtyUnit):
ConfirmedProdnRsceToolQty	Actual Quantity of Production Resource/Tool
📏 Unit for Remaining Quantity of Production Resource/Tool (RemainingProdnRsceToolQtyUnit):
RemainingProdnRsceToolQty	Remaining Quantity of the Production Resource/Tool
📏 Usage Value Unit of the Production Resource/Tool (ProdnRsceToolUsageQuantityUnit):
ProdnRsceToolUsageQuantity	Standard Usage Value for Production Resources/Tools
📏 Unit for Planned Usage Quantity of Production Resource/Tool (PlndProdnRsceToolUsageQtyUnit):
PlannedProdnRsceToolUsageQty	Total Planned Usage Value of Production Resource/Tool
📏 Unit for Actual Usage Quantity of Production Resource/Tool (ConfdProdnRsceToolUsageQtyUnit):
ConfirmedProdnRsceToolUsageQty	Actual Usage Value for Production Resource/Tool
📏 Unit for Remaining Usage Quantity of Production Res./Tool (RmngProdnRsceToolUsageQtyUnit):
RemainingProdnRsceToolUsageQty	Remaining Usage Value of the Production Resource/Tool

Column Name	Description
CreationDate	Date Record Created On
LastChangeDate	Last Changed On
EarliestSchedldUsageStartDate	Earliest Scheduled Start Date for PRT Usage
EarliestSchedldUsageStartTime	Earliest Scheduled Start Time for PRT Usage
EarliestSchedldUsageEndDate	Earliest Scheduled End Date of PRT Usage
EarliestSchedldUsageEndTime	Earliest Scheduled End Time of PRT Usage
LatestSchedldUsageStartDate	Latest Scheduled Start Date for PRT Usage
LatestSchedldUsageStartTime	Latest Scheduled Start Time for PRT Usage
LatestSchedldUsageEndDate	Latest Scheduled End Date for PRT Usage
LatestSchedldUsageEndTime	Latest Scheduled End Time for PRT Usage
ActualUsageStartDate	Actual start date of PRT usage
ActualUsageStartTime	Actual start time of PRT usage
ActualUsageEndDate	Actual end date of PRT usage
ActualUsageEndTime	Actual end time of PRT usage

Column Name	Description
IsDeleted	Deletion Indicator	Show values
OrderCategory	Order Category	Show values
ProductionResourceType	Object types of the CIM resource	Show values

Column Name	Description	Domain name
CreatedByUser	User who created record	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
OrderProdnRsceToolText	First Line of Text for Production Resources/Tools	TEXT40
OrderID	Order Number	AUFNR
OrderType	Order Type	AUFART
Plant	Plant	WERKS
OrderIntBillOfOperationsItem	Internal Identifier of an Operation or Activity	CO_APLZL
MRPController	MRP controller for the order	DISPO
ProdnRsceToolItemNumber	Item Number for Production Resource/Tool	PSNFH
BillOfOperationsGroup	Key for Task List Group	PLNNR
ProdnRsceToolUsageDuration	Duration of PRT Usage	CX_ZEIT
ProdnRsceToolRegnIsAllowed	Specifies that the PRT can be Registered in Execution

Master Data Relations	Join Conditions
Task List Type Task List Type Client	`I_ORDERPRODNRESOURCETOOL.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `I_ORDERPRODNRESOURCETOOL.MANDT == TCA01.MANDT`
Unit for Actual Usage Quantity of Production Resource/Tool Client Unit for Actual Usage Quantity of Production Resource/Tool	`I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT` `I_ORDERPRODNRESOURCETOOL.CONFDPRODNRSCETOOLUSAGEQTYUNIT == T006.MSEHI`
Unit for Actual Quantity of Production Resource/Tool Unit for Actual Quantity of Production Resource/Tool Client	`I_ORDERPRODNRESOURCETOOL.CONFIRMEDPRODNRSCETOOLQTYUNIT == T006.MSEHI` `I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT`
Language Key	`I_ORDERPRODNRESOURCETOOL.LANGUAGE == T002.SPRAS`
Unit for Total Planned Quantity of Production Resource/Tool Client Unit for Total Planned Quantity of Production Resource/Tool	`I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT` `I_ORDERPRODNRESOURCETOOL.PLANNEDPRODNRSCETOOLQTYUNIT == T006.MSEHI`
Unit for Planned Usage Quantity of Production Resource/Tool Unit for Planned Usage Quantity of Production Resource/Tool Client	`I_ORDERPRODNRESOURCETOOL.PLNDPRODNRSCETOOLUSAGEQTYUNIT == T006.MSEHI` `I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT`
Control Profile for Management of Production Resources/Tools Control Profile for Management of Production Resources/Tools Client	`I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF` `I_ORDERPRODNRESOURCETOOL.MANDT == TCF10.MANDT`
Unit for Quantity of Production Resources/Tools Client Unit for Quantity of Production Resources/Tools	`I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT` `I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI`
Formula for Calculating the Total Quantity of PRT Client Formula for Calculating the Total Quantity of PRT	`I_ORDERPRODNRESOURCETOOL.MANDT == TC25.MANDT` `I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT`
Unit for Duration of PRT Usage Unit for Duration of PRT Usage Client	`I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLUSAGEDURNUNIT == T006.MSEHI` `I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT`
Formula for Calculating the Total Usage Value of PRT Client Formula for Calculating the Total Usage Value of PRT	`I_ORDERPRODNRESOURCETOOL.MANDT == TC25.MANDT` `I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT`
Usage Value Unit of the Production Resource/Tool Usage Value Unit of the Production Resource/Tool Client	`I_ORDERPRODNRESOURCETOOL.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI` `I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT`
Object ID of the resource Object types of the CIM resource Client Object ID of the resource	`I_ORDERPRODNRESOURCETOOL.PRODUCTIONRESOURCETYPE == CRID.OBJTY` `I_ORDERPRODNRESOURCETOOL.MANDT == CRID.MANDT` `I_ORDERPRODNRESOURCETOOL.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID`
Unit for Remaining Quantity of Production Resource/Tool Client Unit for Remaining Quantity of Production Resource/Tool	`I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT` `I_ORDERPRODNRESOURCETOOL.REMAININGPRODNRSCETOOLQTYUNIT == T006.MSEHI`
Unit for Remaining Usage Quantity of Production Res./Tool Unit for Remaining Usage Quantity of Production Res./Tool Client	`I_ORDERPRODNRESOURCETOOL.RMNGPRODNRSCETOOLUSAGEQTYUNIT == T006.MSEHI` `I_ORDERPRODNRESOURCETOOL.MANDT == T006.MANDT`