MPCR

Transparent Table Application Table
19 Fields 1 CDS Views

Preventive Maintenance Compliance

MPCR is an SAP database table in S/4HANA. Preventive Maintenance Compliance. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaintenanceCompliance view from BASIC Maintenance Compliance

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wapos wapos MaintItem
KEY cpnum cpnum Seq Num Compliance
ernam ernam Created By
erdat erdat Created On
aenam aenam Changed By
aedat aedat Changed On
changeddatetime changeddatetime Changed Date
cpgrp cpgrpoup Code Group
cmpcod cmpcod Compliance Code
cptyp cptyp Compliance Type
cpkat cpkat Compliance Catalog
cptxt cptxt Comp Descr.
indltx indltx Long text
qcpnum qcpnum Sort Number
zaehl paketzaehl Package
legal legal Legal Requirement
kzloesch kzloesch Delete
origin cmplrq_origin Origin

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.

-- Preventive Maintenance Compliance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPCR (
    MANDT,            -- Client [mandt]
    WAPOS,            -- MaintItem [wapos]
    CPNUM,            -- Seq Num Compliance [cpnum]
    ERNAM,            -- Created By [ernam]
    ERDAT,            -- Created On [erdat]
    AENAM,            -- Changed By [aenam]
    AEDAT,            -- Changed On [aedat]
    CHANGEDDATETIME,  -- Changed Date [changeddatetime]
    CPGRP,            -- Code Group [cpgrpoup]
    CMPCOD,           -- Compliance Code [cmpcod]
    CPTYP,            -- Compliance Type [cptyp]
    CPKAT,            -- Compliance Catalog [cpkat]
    CPTXT,            -- Comp Descr. [cptxt]
    INDLTX,           -- Long text [indltx]
    QCPNUM,           -- Sort Number [qcpnum]
    ZAEHL,            -- Package [paketzaehl]
    LEGAL,            -- Legal Requirement [legal]
    KZLOESCH,         -- Delete [kzloesch]
    ORIGIN,           -- Origin [cmplrq_origin]
    PRIMARY KEY (MANDT, WAPOS, CPNUM)
);

Learn More