OPERATIONACTYPRTASSIGNMENT

OPERATIONACTYPRTASSIGNMENT is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
_Material _Material 2
_MfgOrderCategory _MfgOrderCategory 2
_MfgOrderType _MfgOrderType 2
_MiscProdnRsceToolText _MiscProdnRsceToolText 2
_ProductionPlant _ProductionPlant 2
DocumentInfoRecord DocumentInfoRecord 6
DocumentPart DocumentPart 6
DocumentType DocumentType 4
DocumentVersion DocumentVersion 6
ManufacturingOrderType ManufacturingOrderType 2
Material Material 2
MiscProductionResourceTool MiscProductionResourceTool 2
ProdnRsceToolCategory ProdnRsceToolCategory 4
ProductionPlant ProductionPlant 2
ProductionResourceInternalID ProductionResourceInternalID 2
ProductionResourceType ProductionResourceType 2
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 4
PRTRegistrationControl PRTRegistrationControl 2
ShopFloorRtgPRTIsRegistrable ShopFloorRtgPRTIsRegistrable 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OPERATIONACTYPRTASSIGNMENT (
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _MISCPRODNRSCETOOLTEXT,
    _PRODUCTIONPLANT,
    DOCUMENTINFORECORD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MISCPRODUCTIONRESOURCETOOL,
    PRODNRSCETOOLCATEGORY,
    PRODUCTIONPLANT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    PRTISUSEDASTESTEQUIPMENT,
    PRTREGISTRATIONCONTROL,
    SHOPFLOORRTGPRTISREGISTRABLE
);