MPE_OBJECT_LOG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ManufacturingObjectLog | view | from | BASIC | Log of Manufacturing Objects |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA