MPE_OBJECT_LOG

Transparent Table Application Table

Log for Buisness Objects

MPE_OBJECT_LOG is an SAP database table in S/4HANA. Log for Buisness Objects. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ManufacturingObjectLog view from BASIC Log of Manufacturing Objects

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY log_id MPE_LOG_ID Log ID
object MPE_LOG_OBJECT Log Object
event MPE_LOG_EVENT Log Event
event_time MPE_TIMESTAMPL Time Stamp
event_user MPE_LOG_USER Done by User
msg_id MSGID Message ID
msg_nmbr MSGNO Message Number
msg_varbl1 MPE_LOG_VARIABLE1 Log Variable 1
msg_varbl2 MPE_LOG_VARIABLE2 Log Variable 2
msg_varbl3 MPE_LOG_VARIABLE3 Log Variable 3
msg_varbl4 MPE_LOG_VARIABLE4 Log Variable 4
katalogart QKATART Catalog
codegruppe QCODEGRP Code Group
code QCODE Code
version QVERSNR Version
matnr MATNR Material
total_qty MPE_LOG_TOTAL_QTY Total Qty
scrap_qty MPE_LOG_SCRAP_QTY Scrap Qty
unit MPE_LOG_UNIT Unit
aufnr CO_AUFNR Order
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CO_APLZL Counter
sfi_id MPE_SFI_ID Serial.Mat. ID
oan_instance_id MPE_OAN_INSTANCE_ID Instance ID
oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number
filename MPE_FILE_NAME File Name
child_aufnr SPLIT_CAUFNR Child Order
split_qty MPE_LOG_SPLIT_QTY Split Qty
explosion_date CO_AUFLD BOM Expl. Date

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.

-- Log for Buisness Objects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OBJECT_LOG (
    MANDT,               -- Client [MANDT]
    LOG_ID,              -- Log ID [MPE_LOG_ID]
    OBJECT,              -- Log Object [MPE_LOG_OBJECT]
    EVENT,               -- Log Event [MPE_LOG_EVENT]
    EVENT_TIME,          -- Time Stamp [MPE_TIMESTAMPL]
    EVENT_USER,          -- Done by User [MPE_LOG_USER]
    MSG_ID,              -- Message ID [MSGID]
    MSG_NMBR,            -- Message Number [MSGNO]
    MSG_VARBL1,          -- Log Variable 1 [MPE_LOG_VARIABLE1]
    MSG_VARBL2,          -- Log Variable 2 [MPE_LOG_VARIABLE2]
    MSG_VARBL3,          -- Log Variable 3 [MPE_LOG_VARIABLE3]
    MSG_VARBL4,          -- Log Variable 4 [MPE_LOG_VARIABLE4]
    KATALOGART,          -- Catalog [QKATART]
    CODEGRUPPE,          -- Code Group [QCODEGRP]
    CODE,                -- Code [QCODE]
    VERSION,             -- Version [QVERSNR]
    MATNR,               -- Material [MATNR]
    TOTAL_QTY,           -- Total Qty [MPE_LOG_TOTAL_QTY]
    SCRAP_QTY,           -- Scrap Qty [MPE_LOG_SCRAP_QTY]
    UNIT,                -- Unit [MPE_LOG_UNIT]
    AUFNR,               -- Order [CO_AUFNR]
    AUFPL,               -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,               -- Counter [CO_APLZL]
    SFI_ID,              -- Serial.Mat. ID [MPE_SFI_ID]
    OAN_INSTANCE_ID,     -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_ELEMENT_NUMBER,  -- Element Number [MPE_OAN_ELEMENT_NUMBER]
    FILENAME,            -- File Name [MPE_FILE_NAME]
    CHILD_AUFNR,         -- Child Order [SPLIT_CAUFNR]
    SPLIT_QTY,           -- Split Qty [MPE_LOG_SPLIT_QTY]
    EXPLOSION_DATE,      -- BOM Expl. Date [CO_AUFLD]
    PRIMARY KEY (MANDT, LOG_ID)
);