I_MFGORDEROPERATIONPRT

CDS View
87 Fields 9 CDS Views

Mfg Order Operation Production Resource Tool

I_MFGORDEROPERATIONPRT is a CDS View in S/4HANA. Mfg Order Operation Production Resource Tool. It contains 87 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
A_ProcessOrderProdnRsceTools_2 view_entity from COMPOSITE Process Order Production Resources Tools
A_ProductionRsceTools view_entity from COMPOSITE API Production Resource/Tools
A_ProductionRsceTools_2 view_entity from COMPOSITE Production Resources Tools
C_MfgOrderObjPgPRT view_entity from CONSUMPTION PRT for Orders
C_MfgOrderOperationPRT view_entity from CONSUMPTION Production Resource Tools for Order and Operation
I_MfgOrderOpPRTDataList view from COMPOSITE MfgOrder ProductionResourceTool DataList
I_MfgOrdOperationPRTWithStatus view_entity from COMPOSITE Manufacturing Order Operation PRT with Status
P_MFGOrderOpPRTAssignment view_entity from CONSUMPTION Aggregated View for PRTs on Operation Level
P_MFGOrderPRTAssignment view_entity from CONSUMPTION Aggregated View for PRTs on Order Level

Fields (87)

KeyField CDS FieldsUsed in Views
KEY MfgOrderInternalID MfgOrderInternalID,OrderInternalBillOfOperations 2
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
_BillOfOperationsGroup _BillOfOperationsGroup 1
_BillOfOperationsType _BillOfOperationsType 1
_ConfdProdnRsceToolUsgeQtyUnit _ConfdProdnRsceToolUsgeQtyUnit 1
_ConfirmedProdnRsceToolQtyUnit _ConfirmedProdnRsceToolQtyUnit 1
_CreatedByUser _CreatedByUser 1
_Language _Language 1
_LastChangedByUser _LastChangedByUser 1
_MfgOrder _MfgOrder 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderInternalID _MfgOrderInternalID 1
_MfgOrderOperation _MfgOrderOperation 1
_MfgOrderOperationBySemKey _MfgOrderOperationBySemKey 1
_MfgOrderSequence2 _MfgOrderSequence 1
_MfgOrderType _MfgOrderType 1
_OperationControlProfile _OperationControlProfile 1
_PlannedProdnRsceToolQtyUnit _PlannedProdnRsceToolQtyUnit 1
_PlndProdnRsceToolUsageQtyUnit _PlndProdnRsceToolUsageQtyUnit 1
_ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey 1
_ProdnRsceToolCategory_2 _ProdnRsceToolCategory 1
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile 1
_ProdnRsceToolMasterData _ProdnRsceToolMasterData 1
_ProdnRsceToolStdWorkQtyUnit _ProdnRsceToolStdWorkQtyUnit 1
_ProdnRsceToolUsageDurnUnit _ProdnRsceToolUsageDurnUnit 1
_ProdnRsceToolUsageQtyUnit _ProdnRsceToolUsageQtyUnit 1
_ProductionPlant _ProductionPlant 1
_ProductionResourceType _ProductionResourceType 1
_RemainingProdnRsceToolQtyUnit _RemainingProdnRsceToolQtyUnit 1
_RmngProdnRsceToolUsageQtyUnit _RmngProdnRsceToolUsageQtyUnit 1
ActualUsageEndDate ActualUsageEndDate 1
ActualUsageEndTime ActualUsageEndTime 1
ActualUsageStartDate ActualUsageStartDate 1
ActualUsageStartTime ActualUsageStartTime 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
ConfdProdnRsceToolUsageQtyUnit ConfdProdnRsceToolUsageQtyUnit 1
ConfirmedProdnRsceToolQty ConfirmedProdnRsceToolQty 1
ConfirmedProdnRsceToolQtyUnit ConfirmedProdnRsceToolQtyUnit 1
ConfirmedProdnRsceToolUsageQty ConfirmedProdnRsceToolUsageQty 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
EarliestSchedldUsageEndDate EarliestSchedldUsageEndDate 1
EarliestSchedldUsageEndTime EarliestSchedldUsageEndTime 1
EarliestSchedldUsageStartDate EarliestSchedldUsageStartDate 1
EarliestSchedldUsageStartTime EarliestSchedldUsageStartTime 1
IsDeleted IsDeleted 1
Language Language,LongTextLanguageCode 2
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LatestSchedldUsageEndDate LatestSchedldUsageEndDate 2
LatestSchedldUsageEndTime LatestSchedldUsageEndTime 1
LatestSchedldUsageStartDate LatestSchedldUsageStartDate 2
LatestSchedldUsageStartTime LatestSchedldUsageStartTime 1
ManufacturingOrder ManufacturingOrder 2
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderOperation_2 ManufacturingOrderOperation 1
ManufacturingOrderSequence ManufacturingOrderSequence 2
ManufacturingOrderType ManufacturingOrderType 1
MfgOrderOperationIsPhase MfgOrderOperationIsPhase 1
MfgOrderOpProdnRsceToolText MfgOrderOpProdnRsceToolText 2
OperationControlProfile OperationControlProfile 1
OrderOperationInternalID OrderIntBillOfOperationsItem,OrderOperationInternalID 2
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 2
PlannedProdnRsceToolUsageQty PlannedProdnRsceToolUsageQty 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 2
PlndProdnRsceToolUsageQtyUnit PlndProdnRsceToolUsageQtyUnit 1
ProdnRsceToolCategory_2 ProdnRsceToolCategory 1
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 2
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 1
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 1
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 1
ProdnRsceToolUsageDuration ProdnRsceToolUsageDuration 1
ProdnRsceToolUsageDurnUnit ProdnRsceToolUsageDurnUnit 1
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 1
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity 1
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit 1
ProductionPlant ProductionPlant 1
ProductionResourceInternalID ProductionResourceInternalID 2
ProductionResourceTool ProductionResourceTool 2
ProductionResourceType ProductionResourceType 2
RemainingProdnRsceToolQty RemainingProdnRsceToolQty 1
RemainingProdnRsceToolQtyUnit RemainingProdnRsceToolQtyUnit 1
RemainingProdnRsceToolUsageQty RemainingProdnRsceToolUsageQty 1
RmngProdnRsceToolUsageQtyUnit RmngProdnRsceToolUsageQtyUnit 1

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.

-- Mfg Order Operation Production Resource Tool
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONPRT (
    MFGORDERINTERNALID,
    MFGORDEROPPRODNRSCETOOLINTID,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _CONFDPRODNRSCETOOLUSGEQTYUNIT,
    _CONFIRMEDPRODNRSCETOOLQTYUNIT,
    _CREATEDBYUSER,
    _LANGUAGE,
    _LASTCHANGEDBYUSER,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERINTERNALID,
    _MFGORDEROPERATION,
    _MFGORDEROPERATIONBYSEMKEY,
    _MFGORDERSEQUENCE2,
    _MFGORDERTYPE,
    _OPERATIONCONTROLPROFILE,
    _PLANNEDPRODNRSCETOOLQTYUNIT,
    _PLNDPRODNRSCETOOLUSAGEQTYUNIT,
    _PRODNRSCETOOLBYINTERNALKEY,
    _PRODNRSCETOOLCATEGORY_2,
    _PRODNRSCETOOLCONTROLPROFILE,
    _PRODNRSCETOOLMASTERDATA,
    _PRODNRSCETOOLSTDWORKQTYUNIT,
    _PRODNRSCETOOLUSAGEDURNUNIT,
    _PRODNRSCETOOLUSAGEQTYUNIT,
    _PRODUCTIONPLANT,
    _PRODUCTIONRESOURCETYPE,
    _REMAININGPRODNRSCETOOLQTYUNIT,
    _RMNGPRODNRSCETOOLUSAGEQTYUNIT,
    ACTUALUSAGEENDDATE,
    ACTUALUSAGEENDTIME,
    ACTUALUSAGESTARTDATE,
    ACTUALUSAGESTARTTIME,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    CONFDPRODNRSCETOOLUSAGEQTYUNIT,
    CONFIRMEDPRODNRSCETOOLQTY,
    CONFIRMEDPRODNRSCETOOLQTYUNIT,
    CONFIRMEDPRODNRSCETOOLUSAGEQTY,
    CREATEDBYUSER,
    CREATIONDATE,
    EARLIESTSCHEDLDUSAGEENDDATE,
    EARLIESTSCHEDLDUSAGEENDTIME,
    EARLIESTSCHEDLDUSAGESTARTDATE,
    EARLIESTSCHEDLDUSAGESTARTTIME,
    ISDELETED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LATESTSCHEDLDUSAGEENDDATE,
    LATESTSCHEDLDUSAGEENDTIME,
    LATESTSCHEDLDUSAGESTARTDATE,
    LATESTSCHEDLDUSAGESTARTTIME,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDEROPERATION_2,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MFGORDEROPERATIONISPHASE,
    MFGORDEROPPRODNRSCETOOLTEXT,
    OPERATIONCONTROLPROFILE,
    ORDEROPERATIONINTERNALID,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDPRODNRSCETOOLUSAGEQTY,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PLNDPRODNRSCETOOLUSAGEQTYUNIT,
    PRODNRSCETOOLCATEGORY_2,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEDURATION,
    PRODNRSCETOOLUSAGEDURNUNIT,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODNRSCETOOLUSAGEQUANTITY,
    PRODNRSCETOOLUSAGEQUANTITYUNIT,
    PRODUCTIONPLANT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETOOL,
    PRODUCTIONRESOURCETYPE,
    REMAININGPRODNRSCETOOLQTY,
    REMAININGPRODNRSCETOOLQTYUNIT,
    REMAININGPRODNRSCETOOLUSAGEQTY,
    RMNGPRODNRSCETOOLUSAGEQTYUNIT,
    PRIMARY KEY (MFGORDERINTERNALID, MFGORDEROPPRODNRSCETOOLINTID)
);

Learn More