A_ProductionRsceTools_2

Production Resources Tools | view: APRODNTOOLS2 | Extraction: Not supported | Component: Enterprise Services

Tables used: AFVC, AFFH, CRVD_A, DRAW, CRVE_A, CRVM_A, CRVS_A, CRVP_A, IMPTT, TCF02, TCF03, CRFH, T006, T006A

🔑 Keys (2)
💰 Amounts
∑ Quantities (6)
📅 Dates (12)
☰ Categorical (1)
Other (17)
🔗 Relations (22)

Column Name	Description
OrderInternalBillOfOperations	Order Internal ID
MfgOrderOpProdnRsceToolIntID	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
📏 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

Column Name	Description
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
ManufacturingOrderCategory	Manufacturing Order Category	Show values

Column Name	Description	Domain name
ProductionResourceTool	Production Resource/Tool Number	FHMNR
ProdnRsceToolCategoryName	Language-dependent description of the PRT category	TEXT40
OrderOperationInternalID	Internal Identifier of an Operation or Activity	CO_APLZL
ManufacturingOrder	Production Order	AUFNR
ManufacturingOrderOperation	Operation or Phase Number	VDM_VORNR
ManufacturingOrderType	Manufacturing Order Type	AUFART
ProductionPlant	Production Plant	WERKS
BillOfOperationsGroup	Key for Task List Group	PLNNR
ProdnRsceToolUsageDuration	Duration of PRT Usage	CX_ZEIT
PRTUsageDurationUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
PRTStdWorkQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
PlannedPRTQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
ConfirmedPRTQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
PRTUsageQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
PlannedPRTUsageQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
ConfdPRTUsageQtyUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT
ProdnRsceToolBaseUnitSAPCode	Unit of Measurement, Internal SAP Code (No Conversion)	MEINSINT

Master Data Relations	Join Conditions
Task List Type Client Task List Type	`A_PRODUCTIONRSCETOOLS_2.MANDT == TCA01.MANDT` `A_PRODUCTIONRSCETOOLS_2.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Unit for Actual Usage Quantity of Production Resource/Tool Client Unit for Actual Usage Quantity of Production Resource/Tool	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRODNRSCETOOLUSAGEQTYUNIT == T006.MSEHI`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
Unit for Actual Quantity of Production Resource/Tool Client Unit for Actual Quantity of Production Resource/Tool	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRODNRSCETOOLQTYUNIT == T006.MSEHI`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
Unit for Total Planned Quantity of Production Resource/Tool Client Unit for Total Planned Quantity of Production Resource/Tool	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRODNRSCETOOLQTYUNIT == T006.MSEHI`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
Unit for Planned Usage Quantity of Production Resource/Tool Client Unit for Planned Usage Quantity of Production Resource/Tool	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PLNDPRODNRSCETOOLUSAGEQTYUNIT == T006.MSEHI`
Base Unit of Measure for Production Resources/Tools Client Base Unit of Measure for Production Resources/Tools	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNIT == T006.MSEHI`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
Production Resources/Tools Category	`A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLCATEGORY == TCF02.FHMAR`
Control Profile for Management of Production Resources/Tools Client Control Profile for Management of Production Resources/Tools	`A_PRODUCTIONRSCETOOLS_2.MANDT == TCF10.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF`
Plant Client Plant Production Plant ?	`A_PRODUCTIONRSCETOOLS_2.MANDT == MARC.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLPLANT == MARC.WERKS` `A_PRODUCTIONRSCETOOLS_2.PRODUCTIONPLANT == MARC.WERKS` `A_PRODUCTIONRSCETOOLS_2.[column in domain "MATNR"] == MARC.MATNR`
Unit for Quantity of Production Resources/Tools Client Unit for Quantity of Production Resources/Tools	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI`
Formula for Calculating the Total Quantity of PRT Client Formula for Calculating the Total Quantity of PRT	`A_PRODUCTIONRSCETOOLS_2.MANDT == TC25.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT`
Unit for Duration of PRT Usage Client Unit for Duration of PRT Usage	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLUSAGEDURNUNIT == T006.MSEHI`
Formula for Calculating the Total Usage Value of PRT Client Formula for Calculating the Total Usage Value of PRT	`A_PRODUCTIONRSCETOOLS_2.MANDT == TC25.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT`
Usage Value Unit of the Production Resource/Tool Client Usage Value Unit of the Production Resource/Tool	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006.MANDT` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`
ISO code for unit of measurement Client ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement ISO code for unit of measurement	`A_PRODUCTIONRSCETOOLS_2.MANDT == T006I.CLIENT` `A_PRODUCTIONRSCETOOLS_2.CONFDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRODNRSCETOOLBASEUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.CONFIRMEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEDURATIONUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTUSAGEQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PLANNEDPRTQTYUNITISOCODE == T006I.ISOCODE` `A_PRODUCTIONRSCETOOLS_2.PRTSTDWORKQTYUNITISOCODE == T006I.ISOCODE`