I_OPERATIONACTYPRTASSIGNMENT

CDS View
7 Fields 8 CDS Views

Operation Activity Instance PRT Assign

I_OPERATIONACTYPRTASSIGNMENT is a CDS View in S/4HANA. Operation Activity Instance PRT Assign. It contains 7 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_OpActySFIGroupPRTDetail view inner COMPOSITE Detail of a PRT of a group of SFI at OA
I_SFIOpActyNonTrcblUsedPRT view_entity inner COMPOSITE SFI used non traceable PRT
I_SFOOpActyNonTrcblUsedPRT view_entity from COMPOSITE Shop floor order used non traceable PRT
P_OpActyProdnRsceToolAssAgg view from COMPOSITE Number of PRTs assigned to an OA
P_OpActyProdnRsceToolAssAgg2 view from CONSUMPTION Aggregated assignment of PRTs to OAs
P_OperationActyPRTAssignment2 view_entity from CONSUMPTION Shop Floor Item At Operation Activity
P_OperationProdnRsceToolAssAgg view from CONSUMPTION Number of PRTs assigned to an operation
P_TrackToolUsageOAPRTASSGNED view from COMPOSITE PRT IDs ASSIGNED TO OA

Fields (7)

KeyField CDS FieldsUsed in Views
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 3
KEY OpActyNtwkElement OpActyNtwkElement 4
KEY OpActyNtwkInstance OpActyNtwkInstance 4
KEY OrderInternalID OrderInternalID 3
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 3
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 4

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.

-- Operation Activity Instance PRT Assign
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPERATIONACTYPRTASSIGNMENT (
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    PRTISUSEDASTESTEQUIPMENT,
    PRIMARY KEY (MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID)
);

Learn More