P_MFGEXECEVENTHISTORDER

CDS View
98 Fields 1 CDS Views

Order Execution Event History

P_MFGEXECEVENTHISTORDER is a CDS View in S/4HANA. Order Execution Event History. It contains 98 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgExecEventHistory view from COMPOSITE Manufacturing Execution Event History

Fields (98)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocument ChangeDocument 1
KEY InspectionCharacteristic InspectionCharacteristic 1
KEY InspectionSubsetInternalID InspectionSubsetInternalID 1
KEY InspResultValueInternalID InspResultValueInternalID 1
KEY ManufacturingExecutionDocument ManufacturingExecutionDocument 1
KEY ManufacturingOrder ManufacturingOrder 1
KEY MfgExecDocumentCategory MfgExecDocumentCategory 1
KEY MfgExecutionDocumentItem MfgExecutionDocumentItem 1
KEY MfgProcgExecAction MfgProcgExecAction 1
KEY OrderOperationInternalID OrderOperationInternalID 1
AssembledBatch AssembledBatch 1
AssembledMfrSerialNumber AssembledMfrSerialNumber 1
AssembledSerialNumber AssembledSerialNumber 1
AssembledShopFloorItem AssembledShopFloorItem 1
BOMExplosionDate BOMExplosionDate 1
BusinessProcessConfirmedQty BusinessProcessConfirmedQty 1
ChangeDocNewFieldValue ChangeDocNewFieldValue 1
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 1
CharacteristicAttributeCode CharacteristicAttributeCode 1
CompDisassemblyPermanence CompDisassemblyPermanence 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
Defect Defect 1
DefectInternalID DefectInternalID 1
DefectText DefectText 1
Equipment Equipment 1
EventDateTime EventDateTime 1
InspectionResultMeanValue InspectionResultMeanValue 1
InspectionResultMeasuredValue InspectionResultMeasuredValue 1
InspectionSpecificationText InspectionSpecificationText 1
InspectionSpecificationUnit InspectionSpecificationUnit 1
InspectionValuationResult InspectionValuationResult 1
InspSpecDecimalPlaces InspSpecDecimalPlaces 1
InventoryUsabilityCode InventoryUsabilityCode 1
ManufacturingActionReasonCode ManufacturingActionReasonCode 1
ManufacturingObject ManufacturingObject 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderSequence ManufacturingOrderSequence 1
ManufacturingOrderText ManufacturingOrderText 1
ManufacturingOrderType ManufacturingOrderType 1
MaterialComponent MaterialComponent 1
MaterialComponentHasReltdComp MaterialComponentHasReltdComp 1
MaterialComponentName MaterialComponentName 1
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 1
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1
MfgBuyOffAction MfgBuyOffAction 1
MfgBuyOffAdhocStepDescription MfgBuyOffAdhocStepDescription 1
MfgBuyOffCycle MfgBuyOffCycle 1
MfgBuyOffDescription MfgBuyOffDescription 1
MfgBuyOffInternalID MfgBuyOffInternalID 1
MfgBuyOffReferencedStep MfgBuyOffReferencedStep 1
MfgExecHistMsgVarblField1 MfgExecHistMsgVarblField1 1
MfgExecHistMsgVarblField2 MfgExecHistMsgVarblField2 1
MfgExecHistMsgVarblField3 MfgExecHistMsgVarblField3 1
MfgExecHistMsgVarblField4 MfgExecHistMsgVarblField4 1
MfgExecutionDocumentNote MfgExecutionDocumentNote 1
MfgObjectLogEventType MfgObjectLogEventType 1
MfgOrderOperationText MfgOrderOperationText 1
MfgOrderSplitChildOrder MfgOrderSplitChildOrder 1
MfgProcgExecAttachmentName MfgProcgExecAttachmentName 1
MRPController MRPController 1
Notification Notification 1
NotificationItem NotificationItem 1
OpActyActualDurnInSeconds OpActyActualDurnInSeconds 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 1
OpActyNtwkInstance OpActyNtwkInstance 1
OpActyNtwkSegmentType OpActyNtwkSegmentType 1
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 1
OperationActivity OperationActivity 1
OperationActivityName OperationActivityName 1
OperationActivityNetwork OperationActivityNetwork 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
OperationActyVersionCounter OperationActyVersionCounter 1
OrderInternalID OrderInternalID 1
PostingIsRetroactive PostingIsRetroactive 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionUnit ProductionUnit 1
QltyTaskFollowUpAction QltyTaskFollowUpAction 1
ReferenceDesignatorValue ReferenceDesignatorValue 1
ReplacedBatch ReplacedBatch 1
ReplacedSerialNumber ReplacedSerialNumber 1
ReplacedShopFloorItem ReplacedShopFloorItem 1
RespyMgmtFunction RespyMgmtFunction 1
RespyMgmtTeamID RespyMgmtTeamID 1
ShopFloorExecutionUser ShopFloorExecutionUser 1
ShopFloorItem ShopFloorItem 1
SortField SortField 1
StatusAndActionSchema StatusAndActionSchema 1
StorageLocation StorageLocation 1
SystemMessageIdentification SystemMessageIdentification 1
SystemMessageNumber SystemMessageNumber 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterPlant WorkCenterPlant 1
WorkCenterTypeCode WorkCenterTypeCode 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.

-- Order Execution Event History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGEXECEVENTHISTORDER (
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCUMENT,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONSUBSETINTERNALID,
    INSPRESULTVALUEINTERNALID,
    MANUFACTURINGEXECUTIONDOCUMENT,
    MANUFACTURINGORDER,
    MFGEXECDOCUMENTCATEGORY,
    MFGEXECUTIONDOCUMENTITEM,
    MFGPROCGEXECACTION,
    ORDEROPERATIONINTERNALID,
    ASSEMBLEDBATCH,
    ASSEMBLEDMFRSERIALNUMBER,
    ASSEMBLEDSERIALNUMBER,
    ASSEMBLEDSHOPFLOORITEM,
    BOMEXPLOSIONDATE,
    BUSINESSPROCESSCONFIRMEDQTY,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHARACTERISTICATTRIBUTECODE,
    COMPDISASSEMBLYPERMANENCE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEFECT,
    DEFECTINTERNALID,
    DEFECTTEXT,
    EQUIPMENT,
    EVENTDATETIME,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTMEASUREDVALUE,
    INSPECTIONSPECIFICATIONTEXT,
    INSPECTIONSPECIFICATIONUNIT,
    INSPECTIONVALUATIONRESULT,
    INSPSPECDECIMALPLACES,
    INVENTORYUSABILITYCODE,
    MANUFACTURINGACTIONREASONCODE,
    MANUFACTURINGOBJECT,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTEXT,
    MANUFACTURINGORDERTYPE,
    MATERIALCOMPONENT,
    MATERIALCOMPONENTHASRELTDCOMP,
    MATERIALCOMPONENTNAME,
    MFGACTIONREASONCODEGROUP,
    MFGACTIONREASONCODEGROUPCTLG,
    MFGBUYOFFACTION,
    MFGBUYOFFADHOCSTEPDESCRIPTION,
    MFGBUYOFFCYCLE,
    MFGBUYOFFDESCRIPTION,
    MFGBUYOFFINTERNALID,
    MFGBUYOFFREFERENCEDSTEP,
    MFGEXECHISTMSGVARBLFIELD1,
    MFGEXECHISTMSGVARBLFIELD2,
    MFGEXECHISTMSGVARBLFIELD3,
    MFGEXECHISTMSGVARBLFIELD4,
    MFGEXECUTIONDOCUMENTNOTE,
    MFGOBJECTLOGEVENTTYPE,
    MFGORDEROPERATIONTEXT,
    MFGORDERSPLITCHILDORDER,
    MFGPROCGEXECATTACHMENTNAME,
    MRPCONTROLLER,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYACTUALDURNINSECONDS,
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKINSTANCE,
    OPACTYNTWKSEGMENTTYPE,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITY,
    OPERATIONACTIVITYNAME,
    OPERATIONACTIVITYNETWORK,
    OPERATIONACTIVITYSFIGROUP,
    OPERATIONACTYVERSIONCOUNTER,
    ORDERINTERNALID,
    POSTINGISRETROACTIVE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    QLTYTASKFOLLOWUPACTION,
    REFERENCEDESIGNATORVALUE,
    REPLACEDBATCH,
    REPLACEDSERIALNUMBER,
    REPLACEDSHOPFLOORITEM,
    RESPYMGMTFUNCTION,
    RESPYMGMTTEAMID,
    SHOPFLOOREXECUTIONUSER,
    SHOPFLOORITEM,
    SORTFIELD,
    STATUSANDACTIONSCHEMA,
    STORAGELOCATION,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    WORKCENTERINTERNALID,
    WORKCENTERPLANT,
    WORKCENTERTYPECODE,
    PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCUMENT, INSPECTIONCHARACTERISTIC, INSPECTIONSUBSETINTERNALID, INSPRESULTVALUEINTERNALID, MANUFACTURINGEXECUTIONDOCUMENT, MANUFACTURINGORDER, MFGEXECDOCUMENTCATEGORY, MFGEXECUTIONDOCUMENTITEM, MFGPROCGEXECACTION, ORDEROPERATIONINTERNALID)
);

Learn More