I_MAINTORDEROPPRODNRSCETOOL

CDS View
33 Fields 2 CDS Views

Maintenance Order Operation PRT

I_MAINTORDEROPPRODNRSCETOOL is a CDS View in S/4HANA. Maintenance Order Operation PRT. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintOrdOpProdnRsceToolText view_entity from BASIC Maint Order Operation PRT Long Text
R_MaintOrderOpProdnRsceToolTP view_entity from TRANSACTIONAL Maintenance Order Operation PRT TP

Fields (33)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 1
KEY MaintenanceOrderOperation MaintenanceOrderOperation 1
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 1
KEY ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ConfdProdnRsceToolUsageQtyUnit ConfdProdnRsceToolUsageQtyUnit 1
ConfirmedProdnRsceToolQty ConfirmedProdnRsceToolQty 1
ConfirmedProdnRsceToolQtyUnit ConfirmedProdnRsceToolQtyUnit 1
ConfirmedProdnRsceToolUsageQty ConfirmedProdnRsceToolUsageQty 1
ObjectInternalID ObjectInternalID 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 1
OrderOperationText OrderOperationText 1
OrderProdnRsceToolInternalID OrderProdnRsceToolInternalID 1
OrderProdnRsceToolText OrderProdnRsceToolText 1
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedProdnRsceToolUsageQty PlannedProdnRsceToolUsageQty 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
PlndProdnRsceToolUsageQtyUnit PlndProdnRsceToolUsageQtyUnit 1
ProdnRsceToolCategory ProdnRsceToolCategory 1
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 1
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode 1
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 1
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 1
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 1
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 1
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity 1
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit 1
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceType ProductionResourceType 1
RemainingProdnRsceToolQty RemainingProdnRsceToolQty 1
RemainingProdnRsceToolQtyUnit RemainingProdnRsceToolQtyUnit 1
RemainingProdnRsceToolUsageQty RemainingProdnRsceToolUsageQty 1
RmngProdnRsceToolUsageQtyUnit RmngProdnRsceToolUsageQtyUnit 1
TextObjectKey TextObjectKey 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.

-- Maintenance Order Operation PRT
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTORDEROPPRODNRSCETOOL (
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    PRODNRSCETOOLITEMNUMBER,
    CONFDPRODNRSCETOOLUSAGEQTYUNIT,
    CONFIRMEDPRODNRSCETOOLQTY,
    CONFIRMEDPRODNRSCETOOLQTYUNIT,
    CONFIRMEDPRODNRSCETOOLUSAGEQTY,
    OBJECTINTERNALID,
    ORDERINTERNALBILLOFOPERATIONS,
    ORDEROPERATIONTEXT,
    ORDERPRODNRSCETOOLINTERNALID,
    ORDERPRODNRSCETOOLTEXT,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDPRODNRSCETOOLUSAGEQTY,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PLNDPRODNRSCETOOLUSAGEQTYUNIT,
    PRODNRSCETOOLCATEGORY,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLSTANDARDTEXTCODE,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODNRSCETOOLUSAGEQUANTITY,
    PRODNRSCETOOLUSAGEQUANTITYUNIT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    REMAININGPRODNRSCETOOLQTY,
    REMAININGPRODNRSCETOOLQTYUNIT,
    REMAININGPRODNRSCETOOLUSAGEQTY,
    RMNGPRODNRSCETOOLUSAGEQTYUNIT,
    TEXTOBJECTKEY,
    PRIMARY KEY (MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, PRODNRSCETOOLITEMNUMBER)
);

Learn More