P_MFGEXECEVENTHISTOPACTY

CDS View
44 Fields 1 CDS Views

Operation Activity Execution Event History

P_MFGEXECEVENTHISTOPACTY is a CDS View in S/4HANA. Operation Activity Execution Event History. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MfgExecEventHistOpActy2 view from COMPOSITE Operation Activity Execution Event History

Fields (44)

KeyField CDS FieldsUsed in Views
KEY ManufacturingExecutionDocument ManufacturingExecutionDocument 1
KEY MfgExecDocumentCategory MfgExecDocumentCategory 1
KEY MfgExecutionDocumentItem MfgExecutionDocumentItem 1
KEY MfgProcgExecAction MfgProcgExecAction 1
ActionIsSASAction ActionIsSASAction 1
AssembledBatch AssembledBatch 1
AssembledMfrSerialNumber AssembledMfrSerialNumber 1
AssembledSerialNumber AssembledSerialNumber 1
AssembledShopFloorItem AssembledShopFloorItem 1
BusinessProcessConfirmedQty BusinessProcessConfirmedQty 1
CompDisassemblyPermanence CompDisassemblyPermanence 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DefectInternalID DefectInternalID 1
Equipment Equipment 1
EventDateTime EventDateTime 1
InventoryUsabilityCode InventoryUsabilityCode 1
ManufacturingActionReasonCode ManufacturingActionReasonCode 1
MaterialComponent MaterialComponent 1
MaterialComponentHasReltdComp MaterialComponentHasReltdComp 1
MaterialComponentName MaterialComponentName 1
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 1
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1
MfgExecHistMsgVarblField1 MfgExecHistMsgVarblField1 1
MfgExecHistMsgVarblField2 MfgExecHistMsgVarblField2 1
MfgExecHistMsgVarblField3 MfgExecHistMsgVarblField3 1
MfgExecHistMsgVarblField4 MfgExecHistMsgVarblField4 1
MfgObjectLogEventType MfgObjectLogEventType 1
Notification Notification 1
NotificationItem NotificationItem 1
OpActyActualDurnInSeconds OpActyActualDurnInSeconds 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkInstance OpActyNtwkInstance 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
PostingIsRetroactive PostingIsRetroactive 1
ProductionUnit ProductionUnit 1
ReferenceDesignatorValue ReferenceDesignatorValue 1
ShopFloorExecutionUser ShopFloorExecutionUser 1
ShopFloorItem ShopFloorItem 1
SortField SortField 1
StatusAndActionSchema StatusAndActionSchema 1
StorageLocation StorageLocation 1
SystemMessageIdentification SystemMessageIdentification 1
SystemMessageNumber SystemMessageNumber 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.

-- Operation Activity Execution Event History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGEXECEVENTHISTOPACTY (
    MANUFACTURINGEXECUTIONDOCUMENT,
    MFGEXECDOCUMENTCATEGORY,
    MFGEXECUTIONDOCUMENTITEM,
    MFGPROCGEXECACTION,
    ACTIONISSASACTION,
    ASSEMBLEDBATCH,
    ASSEMBLEDMFRSERIALNUMBER,
    ASSEMBLEDSERIALNUMBER,
    ASSEMBLEDSHOPFLOORITEM,
    BUSINESSPROCESSCONFIRMEDQTY,
    COMPDISASSEMBLYPERMANENCE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEFECTINTERNALID,
    EQUIPMENT,
    EVENTDATETIME,
    INVENTORYUSABILITYCODE,
    MANUFACTURINGACTIONREASONCODE,
    MATERIALCOMPONENT,
    MATERIALCOMPONENTHASRELTDCOMP,
    MATERIALCOMPONENTNAME,
    MFGACTIONREASONCODEGROUP,
    MFGACTIONREASONCODEGROUPCTLG,
    MFGEXECHISTMSGVARBLFIELD1,
    MFGEXECHISTMSGVARBLFIELD2,
    MFGEXECHISTMSGVARBLFIELD3,
    MFGEXECHISTMSGVARBLFIELD4,
    MFGOBJECTLOGEVENTTYPE,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYACTUALDURNINSECONDS,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYSFIGROUP,
    POSTINGISRETROACTIVE,
    PRODUCTIONUNIT,
    REFERENCEDESIGNATORVALUE,
    SHOPFLOOREXECUTIONUSER,
    SHOPFLOORITEM,
    SORTFIELD,
    STATUSANDACTIONSCHEMA,
    STORAGELOCATION,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    PRIMARY KEY (MANUFACTURINGEXECUTIONDOCUMENT, MFGEXECDOCUMENTCATEGORY, MFGEXECUTIONDOCUMENTITEM, MFGPROCGEXECACTION)
);

Learn More