I_SFOOPACTYNONTRCBLUSEDPRT

CDS View
15 Fields 1 CDS Views

Shop floor order used non traceable PRT

I_SFOOPACTYNONTRCBLUSEDPRT is a CDS View in S/4HANA. Shop floor order used non traceable PRT. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SFOOpActyNonTrcblUsedPRT view_entity from CONSUMPTION Shop floor order used non traceable PRT

Fields (15)

KeyField CDS FieldsUsed in Views
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OrderInternalID OrderInternalID 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 1
_ProdnRsceToolCategory _ProdnRsceToolCategory 1
Equipment Equipment 1
Material Material 1
MiscProductionResourceTool MiscProductionResourceTool 1
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
Plant Plant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 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.

-- Shop floor order used non traceable PRT
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SFOOPACTYNONTRCBLUSEDPRT (
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    _PRODNRSCETOOLCATEGORY,
    EQUIPMENT,
    MATERIAL,
    MISCPRODUCTIONRESOURCETOOL,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PLANT,
    PRTISUSEDASTESTEQUIPMENT,
    PRIMARY KEY (MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID)
);

Learn More