/PLMI/CHGRECD_H

Transparent Table Application Table
18 Fields 1 CDS Views

Change Record Header

/PLMI/CHGRECD_H is an SAP database table in S/4HANA. Change Record Header. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecHeader_2 view_entity from BASIC Change Record Header for DEX

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY db_key /plmi/cr_db_key
chrecd_id /plmi/chgrecd_id
chrecd_type /plmi/chgrecd_type
purpose_type /plmi/cr_purpose_typ Purpose Type
user_status /plmi/user_status
lcycle_cd /plmi/cr_lcycle_cd
auth_group /plmi/cr_auth_group
status_profile plm_status_profile
eng_effective_date /plmb/cr_eng_effctv_date Eng Effective Date
mfg_effective_date /plmb/cr_mfg_effctv_date Mfg Effective Date
expected_comp_dat /plmb/cr_expt_comp Exp Completion Date
archiving_cd /plmi/cr_archiving_cd
changenumber /plmi/cr_aennr Change Number
reasonforchange /plmb/cc_aegru Reason for Chge
item_change_allowed /plmi/cr_item_edit_mode Item Edit Mode
changenumberprofile /plmb/cc_profil Profile
changenumberstatus /plmb/ecn_status Status

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.

-- Change Record Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PLMI/CHGRECD_H (
    MANDT,                -- Client [mandt]
    DB_KEY,               -- /plmi/cr_db_key
    CHRECD_ID,            -- /plmi/chgrecd_id
    CHRECD_TYPE,          -- /plmi/chgrecd_type
    PURPOSE_TYPE,         -- Purpose Type [/plmi/cr_purpose_typ]
    USER_STATUS,          -- /plmi/user_status
    LCYCLE_CD,            -- /plmi/cr_lcycle_cd
    AUTH_GROUP,           -- /plmi/cr_auth_group
    STATUS_PROFILE,       -- plm_status_profile
    ENG_EFFECTIVE_DATE,   -- Eng Effective Date [/plmb/cr_eng_effctv_date]
    MFG_EFFECTIVE_DATE,   -- Mfg Effective Date [/plmb/cr_mfg_effctv_date]
    EXPECTED_COMP_DAT,    -- Exp Completion Date [/plmb/cr_expt_comp]
    ARCHIVING_CD,         -- /plmi/cr_archiving_cd
    CHANGENUMBER,         -- Change Number [/plmi/cr_aennr]
    REASONFORCHANGE,      -- Reason for Chge [/plmb/cc_aegru]
    ITEM_CHANGE_ALLOWED,  -- Item Edit Mode [/plmi/cr_item_edit_mode]
    CHANGENUMBERPROFILE,  -- Profile [/plmb/cc_profil]
    CHANGENUMBERSTATUS,   -- Status [/plmb/ecn_status]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More