P_OPERATIONACTYPRTASSIGNMENT

CDS View
32 Fields 3 CDS Views

Shop Floor Item At Operation Activity

P_OPERATIONACTYPRTASSIGNMENT is a CDS View in S/4HANA. Shop Floor Item At Operation Activity. It contains 32 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OperationActyPRTAssignment view from CONSUMPTION Shop Floor Item At Operation Activity
C_SFIOpActyPRTAssignment view from CONSUMPTION Shop Floor Item At Operation Activity
P_TrackToolUsageEquipPRTOpActy view from CONSUMPTION PRT NAMES ASSIGNED TO OA

Fields (32)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY OrderInternalID OrderInternalID 2
_Material _Material 2
_MfgOrderCategory _MfgOrderCategory 2
_MfgOrderType _MfgOrderType 2
_OpActyNtwkInstance _OpActyNtwkInstance 2
_OperationActivityInstance _OperationActivityInstance 2
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 2
_ProdnRsceToolCategory _ProdnRsceToolCategory 2
_ProductionPlant _ProductionPlant 2
_ProductionResourceType _ProductionResourceType 2
BOOOperationPRTInternalID BOOOperationPRTInternalID 2
DocumentInfoRecord DocumentInfoRecord 2
DocumentPart DocumentPart 2
DocumentType DocumentType 2
DocumentVersion DocumentVersion 2
ManufacturingOrderCategory ManufacturingOrderCategory 2
ManufacturingOrderType ManufacturingOrderType 2
Material Material 2
MiscProductionResourceTool MiscProductionResourceTool 2
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 2
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 2
ProdnRsceToolStandardWorkQty PlannedTotalProdnRsceToolQty 1
ProdnRsceToolStdWorkQtyUnit PlannedProdnRsceToolQtyUnit 1
ProductionPlant ProductionPlant 2
ProductionResourceType ProductionResourceType 2
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 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.

-- Shop Floor Item At Operation Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPERATIONACTYPRTASSIGNMENT (
    EQUIPMENT,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    _PRODNRSCETOOLCATEGORY,
    _PRODUCTIONPLANT,
    _PRODUCTIONRESOURCETYPE,
    BOOOPERATIONPRTINTERNALID,
    DOCUMENTINFORECORD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MISCPRODUCTIONRESOURCETOOL,
    PLANNEDPRODNRSCETOOLQTYUNIT,
    PLANNEDTOTALPRODNRSCETOOLQTY,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLREGNISALLOWED,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODUCTIONPLANT,
    PRODUCTIONRESOURCETYPE,
    PRTISUSEDASTESTEQUIPMENT,
    PRIMARY KEY (EQUIPMENT, MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID)
);

Learn More