A_ProcessOrderProdnRsceTools_2

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