I_OPERATIONACTYPRTASSIGNMENT

CDS View
8 Fields 13 CDS Views

Operation Activity Instance PRT Assign

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

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_OpActyInstceDocPRT view_entity from CONSUMPTION Planned Documents at Operation Activity
C_OpActyInstcePlndPRTNoDoc view_entity from CONSUMPTION Planned SFI at OA excluding Documents
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_OpActyInstceTestPRTUnion view_entity from CONSUMPTION
P_OpActyProdnRsceToolAssAgg view from COMPOSITE
P_OpActyProdnRsceToolAssAgg2 view from CONSUMPTION
P_OperationActyPlannedPRT view_entity from CONSUMPTION
P_OperationProdnRsceToolAssAgg view from CONSUMPTION
P_SFIAtOpActyTestEquipPRTUnion view_entity from CONSUMPTION
P_SFIOperationActivityPlndPRT view_entity from CONSUMPTION
P_TrackToolUsageOAPRTASSGNED view from COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 5
KEY OpActyNtwkElement OpActyNtwkElement 10
KEY OpActyNtwkInstance OpActyNtwkInstance 10
KEY OrderInternalID OrderInternalID 7
_OperationActivityInstance _OperationActivityInstance 4
_OrderProdnResourceTool _OrderProdnResourceTool 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 6
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 6

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,
    _ORDERPRODNRESOURCETOOL,
    _ORDINTERNALBILLOFOPERATIONS,
    PRTISUSEDASTESTEQUIPMENT,
    PRIMARY KEY (MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID)
);

Learn More