I_ORDERPRODNRESOURCETOOL

CDS View
85 Fields 10 CDS Views

Order Production Resource Tool

I_ORDERPRODNRESOURCETOOL is a CDS View in S/4HANA. Order Production Resource Tool. It contains 85 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ObjPgMaintOrdOpProdnRsceTool view from CONSUMPTION Maintenance Order Operation Production Resources/Tools
C_OpActyInstceDocPRT view_entity inner CONSUMPTION Planned Documents at Operation Activity
C_QM_InspCharInfo view left_outer CONSUMPTION Characteristic details- More information
I_MfgOrderOperationPRT view from COMPOSITE Mfg Order Operation Production Resource Tool
I_OpActySFIGroupPRTDetail view inner COMPOSITE Detail of a PRT of a group of SFI at OA
I_ProductionOrderPRT view_entity from COMPOSITE PRT of a Production Order
P_MaintOrdOpNoOfProdnRsceTool view_entity from CONSUMPTION
P_MfgOrderPRTAssgmtDetail view_entity from COMPOSITE
P_OrderOperationPRTLongText view_entity from BASIC
P_TrackToolUsageOAPRTASSGNED view inner COMPOSITE

Fields (85)

KeyField CDS FieldsUsed in Views
KEY OrderInternalBillOfOperations MfgOrderInternalID,OrderInternalBillOfOperations,OrderInternalID 5
KEY OrderProdnRsceToolInternalID MfgOrderOpProdnRsceToolIntID,OrderProdnRsceToolInternalID 5
_BillOfOperationsGroup _BillOfOperationsGroup 2
_BillOfOperationsType _BillOfOperationsType 2
_ConfdProdnRsceToolUsgeQtyUnit _ConfdProdnRsceToolUsgeQtyUnit 2
_ConfirmedProdnRsceToolQtyUnit _ConfirmedProdnRsceToolQtyUnit 2
_CreatedByUser _CreatedByUser 2
_DocumentProdnRsceTool _DocumentProdnRsceTool 2
_EquipmentProdnRsceTool _EquipmentProdnRsceTool 2
_Language _Language 1
_LastChangedByUser _LastChangedByUser 2
_MaterialProdnRsceTool _MaterialProdnRsceTool 2
_MiscProdnRsceTool _MiscProdnRsceTool 2
_MsrgPointProdnRsceTool _MsrgPointProdnRsceTool 1
_Order _LogisticsOrder 1
_OrderCategory _OrderCategory 1
_OrderType _OrderType 1
_PlannedProdnRsceToolQtyUnit _PlannedProdnRsceToolQtyUnit 2
_Plant _Plant,_ProductionPlant 3
_PlndProdnRsceToolUsageQtyUnit _PlndProdnRsceToolUsageQtyUnit 2
_ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey 2
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile 2
_ProdnRsceToolMasterData _ProdnRsceToolMasterData 2
_ProdnRsceToolStdWorkQtyUnit _ProdnRsceToolStdWorkQtyUnit 2
_ProdnRsceToolUsageDurnUnit _ProdnRsceToolUsageDurnUnit 2
_ProdnRsceToolUsageQtyUnit _ProdnRsceToolUsageQtyUnit 2
_ProductionResourceType _ProductionResourceType 2
_RemainingProdnRsceToolQtyUnit _RemainingProdnRsceToolQtyUnit 2
_RmngProdnRsceToolUsageQtyUnit _RmngProdnRsceToolUsageQtyUnit 2
_StatusObject _StatusObject 2
ActualUsageEndDate ActualUsageEndDate 2
ActualUsageEndTime ActualUsageEndTime 2
ActualUsageStartDate ActualUsageStartDate 2
ActualUsageStartTime ActualUsageStartTime 2
BillOfOperationsGroup BillOfOperationsGroup 2
BillOfOperationsType BillOfOperationsType 2
BOOOperationPRTInternalID BOOOperationPRTInternalID 2
ConfdProdnRsceToolUsageQtyUnit ConfdProdnRsceToolUsageQtyUnit 2
ConfirmedProdnRsceToolQty ConfirmedProdnRsceToolQty 2
ConfirmedProdnRsceToolQtyUnit ConfirmedProdnRsceToolQtyUnit 2
ConfirmedProdnRsceToolUsageQty ConfirmedProdnRsceToolUsageQty 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
EarliestSchedldUsageEndDate EarliestSchedldUsageEndDate 2
EarliestSchedldUsageEndTime EarliestSchedldUsageEndTime 2
EarliestSchedldUsageStartDate EarliestSchedldUsageStartDate 2
EarliestSchedldUsageStartTime EarliestSchedldUsageStartTime 2
IsDeleted IsDeleted 2
Language Language,LongTextLanguage 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LatestSchedldUsageEndDate LatestSchedldUsageEndDate 2
LatestSchedldUsageEndTime LatestSchedldUsageEndTime 2
LatestSchedldUsageStartDate LatestSchedldUsageStartDate 2
LatestSchedldUsageStartTime LatestSchedldUsageStartTime 2
MRPController MRPController 1
ObjectInternalID ObjectInternalID 2
OrderCategory ManufacturingOrderCategory,OrderCategory 4
OrderID ManufacturingOrder,OrderID 2
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem,OrderOperationInternalID 3
OrderProdnRsceToolText MfgOrderOpProdnRsceToolText,OrderProdnRsceToolText,ProductionResourceToolText 6
OrderType ManufacturingOrderType,OrderType 3
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 5
PlannedProdnRsceToolUsageQty PlannedProdnRsceToolUsageQty 2
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 4
Plant ProductionPlant 2
PlndProdnRsceToolUsageQtyUnit PlndProdnRsceToolUsageQtyUnit 2
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 2
ProdnRsceToolHasLongText ProdnRsceToolHasLongText 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 5
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 2
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 4
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 4
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 3
ProdnRsceToolUsageDuration ProdnRsceToolUsageDuration 2
ProdnRsceToolUsageDurnUnit ProdnRsceToolUsageDurnUnit 2
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 2
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity 2
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit 2
ProductionResourceInternalID ProductionResourceInternalID 2
ProductionResourceType ProductionResourceType 2
RemainingProdnRsceToolQty RemainingProdnRsceToolQty 2
RemainingProdnRsceToolQtyUnit RemainingProdnRsceToolQtyUnit 2
RemainingProdnRsceToolUsageQty RemainingProdnRsceToolUsageQty 2
RmngProdnRsceToolUsageQtyUnit RmngProdnRsceToolUsageQtyUnit 2

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.

-- Order Production Resource Tool
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERPRODNRESOURCETOOL (
    ORDERINTERNALBILLOFOPERATIONS,
    ORDERPRODNRSCETOOLINTERNALID,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _CONFDPRODNRSCETOOLUSGEQTYUNIT,
    _CONFIRMEDPRODNRSCETOOLQTYUNIT,
    _CREATEDBYUSER,
    _DOCUMENTPRODNRSCETOOL,
    _EQUIPMENTPRODNRSCETOOL,
    _LANGUAGE,
    _LASTCHANGEDBYUSER,
    _MATERIALPRODNRSCETOOL,
    _MISCPRODNRSCETOOL,
    _MSRGPOINTPRODNRSCETOOL,
    _ORDER,
    _ORDERCATEGORY,
    _ORDERTYPE,
    _PLANNEDPRODNRSCETOOLQTYUNIT,
    _PLANT,
    _PLNDPRODNRSCETOOLUSAGEQTYUNIT,
    _PRODNRSCETOOLBYINTERNALKEY,
    _PRODNRSCETOOLCONTROLPROFILE,
    _PRODNRSCETOOLMASTERDATA,
    _PRODNRSCETOOLSTDWORKQTYUNIT,
    _PRODNRSCETOOLUSAGEDURNUNIT,
    _PRODNRSCETOOLUSAGEQTYUNIT,
    _PRODUCTIONRESOURCETYPE,
    _REMAININGPRODNRSCETOOLQTYUNIT,
    _RMNGPRODNRSCETOOLUSAGEQTYUNIT,
    _STATUSOBJECT,
    ACTUALUSAGEENDDATE,
    ACTUALUSAGEENDTIME,
    ACTUALUSAGESTARTDATE,
    ACTUALUSAGESTARTTIME,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BOOOPERATIONPRTINTERNALID,
    CONFDPRODNRSCETOOLUSAGEQTYUNIT,
    CONFIRMEDPRODNRSCETOOLQTY,
    CONFIRMEDPRODNRSCETOOLQTYUNIT,
    CONFIRMEDPRODNRSCETOOLUSAGEQTY,
    CREATEDBYUSER,
    CREATIONDATE,
    EARLIESTSCHEDLDUSAGEENDDATE,
    EARLIESTSCHEDLDUSAGEENDTIME,
    EARLIESTSCHEDLDUSAGESTARTDATE,
    EARLIESTSCHEDLDUSAGESTARTTIME,
    ISDELETED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LATESTSCHEDLDUSAGEENDDATE,
    LATESTSCHEDLDUSAGEENDTIME,
    LATESTSCHEDLDUSAGESTARTDATE,
    LATESTSCHEDLDUSAGESTARTTIME,
    MRPCONTROLLER,
    OBJECTINTERNALID,
    ORDERCATEGORY,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERPRODNRSCETOOLTEXT,
    ORDERTYPE,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDPRODNRSCETOOLUSAGEQTY,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PLANT,
    PLNDPRODNRSCETOOLUSAGEQTYUNIT,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLHASLONGTEXT,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLREGNISALLOWED,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEDURATION,
    PRODNRSCETOOLUSAGEDURNUNIT,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODNRSCETOOLUSAGEQUANTITY,
    PRODNRSCETOOLUSAGEQUANTITYUNIT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    REMAININGPRODNRSCETOOLQTY,
    REMAININGPRODNRSCETOOLQTYUNIT,
    REMAININGPRODNRSCETOOLUSAGEQTY,
    RMNGPRODNRSCETOOLUSAGEQTYUNIT,
    PRIMARY KEY (ORDERINTERNALBILLOFOPERATIONS, ORDERPRODNRSCETOOLINTERNALID)
);

Learn More