MKALCONSTCYLOG
Production Version Consistency Log
MKALCONSTCYLOG is an SAP database table in S/4HANA. Production Version Consistency Log. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProductionVersionConstcyLog | view_entity | from | BASIC | Production Version Consistency Log |
| I_ProductionVersionConstcyLog | view_entity | union | BASIC | Production Version Consistency Log |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | matnr | matnr | Material | |||
| KEY | werks | werks_d | Plant | |||
| KEY | verid | verid | Prod. Version | |||
| KEY | issueid | pph_d_issueid | Issue Ident. No | |||
| issuetype | pph_d_issuetype | Issue Type | ||||
| occurreddatetime | cr_lastchange_datetime | Date and Time of Last Change | ||||
| eventresp | eventresp | Event responsible for Production Version | ||||
| eventbusobj | boresp | Business Object responsible for Production Version | ||||
| eventstatus | status_prv | Status for Production Version | ||||
| msgid | symsgid | Message Class | ||||
| msgno | symsgno | Message Number | ||||
| msgv1 | symsgv | Message Variable | ||||
| msgv2 | symsgv | Message Variable | ||||
| msgv3 | symsgv | Message Variable | ||||
| msgv4 | symsgv | Message Variable |
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.
-- Production Version Consistency Log
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MKALCONSTCYLOG (
MANDT, -- Client [mandt]
MATNR, -- Material [matnr]
WERKS, -- Plant [werks_d]
VERID, -- Prod. Version [verid]
ISSUEID, -- Issue Ident. No [pph_d_issueid]
ISSUETYPE, -- Issue Type [pph_d_issuetype]
OCCURREDDATETIME, -- Date and Time of Last Change [cr_lastchange_datetime]
EVENTRESP, -- Event responsible for Production Version [eventresp]
EVENTBUSOBJ, -- Business Object responsible for Production Version [boresp]
EVENTSTATUS, -- Status for Production Version [status_prv]
MSGID, -- Message Class [symsgid]
MSGNO, -- Message Number [symsgno]
MSGV1, -- Message Variable [symsgv]
MSGV2, -- Message Variable [symsgv]
MSGV3, -- Message Variable [symsgv]
MSGV4, -- Message Variable [symsgv]
PRIMARY KEY (MANDT, MATNR, WERKS, VERID, ISSUEID)
);
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