P_MFGEXECEVENTHISTORDHDRHOLD

CDS View
24 Fields 1 CDS Views

P_MFGEXECEVENTHISTORDHDRHOLD is a CDS View in S/4HANA. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MfgExecEventHistOrderPrep view from COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 1
KEY MfgProcgExecAction MfgProcgExecAction 1
KEY ProductionHold ManufacturingExecutionDocument 1
KEY ProductionHoldItem MfgExecutionDocumentItem 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DefectInternalID DefectInternalID 1
EventDateTime EventDateTime 1
ManufacturingActionReasonCode ManufacturingActionReasonCode 1
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 1
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1
MfgExecHistMsgVarblField1 MfgExecHistMsgVarblField1 1
MfgExecHistMsgVarblField2 MfgExecHistMsgVarblField2 1
MfgExecHistMsgVarblField3 MfgExecHistMsgVarblField3 1
Notification Notification 1
NotificationItem NotificationItem 1
OpActyActualDurnInSeconds OpActyActualDurnInSeconds 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkInstance OpActyNtwkInstance 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
ShopFloorExecutionUser ShopFloorExecutionUser 1
ShopFloorItem ShopFloorItem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGEXECEVENTHISTORDHDRHOLD (
    MANUFACTURINGORDER,
    MFGPROCGEXECACTION,
    PRODUCTIONHOLD,
    PRODUCTIONHOLDITEM,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEFECTINTERNALID,
    EVENTDATETIME,
    MANUFACTURINGACTIONREASONCODE,
    MFGACTIONREASONCODEGROUP,
    MFGACTIONREASONCODEGROUPCTLG,
    MFGEXECHISTMSGVARBLFIELD1,
    MFGEXECHISTMSGVARBLFIELD2,
    MFGEXECHISTMSGVARBLFIELD3,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYACTUALDURNINSECONDS,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYSFIGROUP,
    SHOPFLOOREXECUTIONUSER,
    SHOPFLOORITEM,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    PRIMARY KEY (MANUFACTURINGORDER, MFGPROCGEXECACTION, PRODUCTIONHOLD, PRODUCTIONHOLDITEM)
);

Learn More