P_OPERATIONACTYPRTASSIGNMENT

CDS View
33 Fields 3 CDS Views

P_OPERATIONACTYPRTASSIGNMENT is a CDS View in S/4HANA. It contains 33 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OperationActyPRTAssignment view from CONSUMPTION
P_OperationActyPRTAssignment2 view from CONSUMPTION
P_TrackToolUsageEquipPRTOpActy view from CONSUMPTION

Fields (33)

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
KEY ProductionResourceInternalID ProductionResourceInternalID 1
KEY ProductionResourceType ProductionResourceType 1
_Material _Material 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 1
_ProdnRsceToolCategory _ProdnRsceToolCategory 1
_ProductionPlant _ProductionPlant 1
_ProductionResourceType _ProductionResourceType 1
BaseUnit BaseUnit 1
BOOOperationPRTInternalID BOOOperationPRTInternalID 1
DocumentInfoRecord DocumentInfoRecord 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MiscProductionResourceTool MiscProductionResourceTool 1
NumberOfActvEquipRegistrations NumberOfActvEquipRegistrations 1
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 1
ProductionPlant ProductionPlant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 1
PRTRegistrationControl PRTRegistrationControl 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.

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

Learn More