PLMCRMAT_D

Transparent Table Application Table
34 Fields 1 CDS Views

Draft table for entity R_CHGRECDREFMATTP

PLMCRMAT_D is an SAP database table in S/4HANA. Draft table for entity R_CHGRECDREFMATTP. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChgRecdRefMatDraft view_entity from BASIC Query View for Material Item Draft

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY changerecordreferenceuuid /bobf/conf_key NodeID
changerecorduuid /bobf/conf_key NodeID
changerecordreferencetype /iam/type Object Type
changerecordreferencesubtype /iam/subtype Subtype
chgrecrefinternalkey1 /iam/internal_id Key
parentchangerecordrefuuid /iam/conf_key Node ID
ismainreference /iam/main_ref_ind Main Reference
changerecordreference /iam/ref_id Ref. Object ID
createdbyuser /bofu/user_id_created_by Created By
creationdatetime tzntstmps Time Stamp
lastchangedbyuser /bofu/user_id_changed_by Changed By
lastchangedatetime tzntstmps Time Stamp
changerecordvirtualrefind /iam/virtual_ref_ind Virtual Reference
changerecorditemrelevance /iam/cr_itemrel Relevance
changerecorditemprocgstatus /plmb/cr_item_proc_status Processing Status
chgrecdnextitemprocgstatus /plmb/cr_item_proc_status Processing Status
chgrecditmtgtsts /plmb/cr_item_tgt_proc_status Tgt Proc. Sts
chgrecditmdsgntr /plmb/cr_i_dgsign Itm. Dgt. Sign.
chgrecdreasonforchange /plmb/cc_aegru Reason for Chge
expdcompltndte /plmb/cr_expt_comp Exp Completion Date
chgrecdauthzngrptext /iam/auth_group Authoriz. Group
chgstatus /plmb/ecn_status Status
chgrecdnmbrchgsts /plmb/ecn_status Status
material matnr Material
product matnr Material
productname productdescription Description
materialtype mtart Material Type
materialbaseunit /plmb/cr_mat_base_unit Material Base Unit
crossplantstatus crossplantstatus CrossPlantStat
changerecordtype /plmb/cr_type Record Type
partner /plmb/cr_chg_responsible Chg Responsible
changerecordlifecyclestatus /iam/issue_lcycle_stat_cd Issue Lifecycle
changerecorditemtype /plmi/chg_itm_type

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.

-- Draft table for entity R_CHGRECDREFMATTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMCRMAT_D (
    MANDT,                         -- Client [mandt]
    CHANGERECORDREFERENCEUUID,     -- NodeID [/bobf/conf_key]
    CHANGERECORDUUID,              -- NodeID [/bobf/conf_key]
    CHANGERECORDREFERENCETYPE,     -- Object Type [/iam/type]
    CHANGERECORDREFERENCESUBTYPE,  -- Subtype [/iam/subtype]
    CHGRECREFINTERNALKEY1,         -- Key [/iam/internal_id]
    PARENTCHANGERECORDREFUUID,     -- Node ID [/iam/conf_key]
    ISMAINREFERENCE,               -- Main Reference [/iam/main_ref_ind]
    CHANGERECORDREFERENCE,         -- Ref. Object ID [/iam/ref_id]
    CREATEDBYUSER,                 -- Created By [/bofu/user_id_created_by]
    CREATIONDATETIME,              -- Time Stamp [tzntstmps]
    LASTCHANGEDBYUSER,             -- Changed By [/bofu/user_id_changed_by]
    LASTCHANGEDATETIME,            -- Time Stamp [tzntstmps]
    CHANGERECORDVIRTUALREFIND,     -- Virtual Reference [/iam/virtual_ref_ind]
    CHANGERECORDITEMRELEVANCE,     -- Relevance [/iam/cr_itemrel]
    CHANGERECORDITEMPROCGSTATUS,   -- Processing Status [/plmb/cr_item_proc_status]
    CHGRECDNEXTITEMPROCGSTATUS,    -- Processing Status [/plmb/cr_item_proc_status]
    CHGRECDITMTGTSTS,              -- Tgt Proc. Sts [/plmb/cr_item_tgt_proc_status]
    CHGRECDITMDSGNTR,              -- Itm. Dgt. Sign. [/plmb/cr_i_dgsign]
    CHGRECDREASONFORCHANGE,        -- Reason for Chge [/plmb/cc_aegru]
    EXPDCOMPLTNDTE,                -- Exp Completion Date [/plmb/cr_expt_comp]
    CHGRECDAUTHZNGRPTEXT,          -- Authoriz. Group [/iam/auth_group]
    CHGSTATUS,                     -- Status [/plmb/ecn_status]
    CHGRECDNMBRCHGSTS,             -- Status [/plmb/ecn_status]
    MATERIAL,                      -- Material [matnr]
    PRODUCT,                       -- Material [matnr]
    PRODUCTNAME,                   -- Description [productdescription]
    MATERIALTYPE,                  -- Material Type [mtart]
    MATERIALBASEUNIT,              -- Material Base Unit [/plmb/cr_mat_base_unit]
    CROSSPLANTSTATUS,              -- CrossPlantStat [crossplantstatus]
    CHANGERECORDTYPE,              -- Record Type [/plmb/cr_type]
    PARTNER,                       -- Chg Responsible [/plmb/cr_chg_responsible]
    CHANGERECORDLIFECYCLESTATUS,   -- Issue Lifecycle [/iam/issue_lcycle_stat_cd]
    CHANGERECORDITEMTYPE,          -- /plmi/chg_itm_type
    PRIMARY KEY (MANDT, CHANGERECORDREFERENCEUUID)
);

Learn More