PLMCRDOC_D

Transparent Table Application Table

Draft table for entity R_ChgRecdRefDocTP

PLMCRDOC_D is an SAP database table in S/4HANA. Draft table for entity R_ChgRecdRefDocTP. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChgRecdRefDocDraft view_entity from BASIC Query View for Document Item Draft

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY changerecordreferenceuuid /bobf/conf_key NodeID
chgrecrefinternalkey1 /iam/internal_id Key
chgrecrefinternalkey2 /iam/internal_id Key
chgrecrefinternalkey3 /iam/internal_id Key
chgrecrefinternalkey4 /iam/internal_id Key
documenttype dokar Document Type
documentinforecord doknr Document
documentversion dokvr Doc. Version
documentpart doktl_d Document Part
changerecorduuid /bobf/conf_key NodeID
changerecordtype /plmb/cr_type Record Type
changerecordreferencetype /iam/type Object Type
changerecordreferencesubtype /iam/subtype Subtype
changerecordreference /iam/ref_id Ref. Object ID
parentchangerecordrefuuid /iam/conf_key Node ID
ismainreference /iam/main_ref_ind Main Reference
createdbyuser /bofu/user_id_created_by Created By
creationdatetime tzntstmps Time Stamp
lastchangedbyuser /bofu/user_id_changed_by Changed By
lastchangedatetime tzntstmps Time Stamp
changerecorditemrelevance /iam/cr_itemrel Relevance
changerecordvirtualrefind /iam/virtual_ref_ind Virtual Reference
changerecorditemprocgstatus /plmb/cr_item_proc_status Processing Status
chgrecdnextitemprocgstatus /plmb/cr_item_proc_status Processing Status
chgstatus /plmb/ecn_status Status
chgrecdnmbrchgsts /plmb/ecn_status Status
partner /plmb/cr_chg_responsible Chg Responsible
changerecordlifecyclestatus /iam/issue_lcycle_stat_cd Issue Lifecycle
changerecorditemtype /plmi/chg_itm_type
internaldocumentstatus dokst Document Status
externaldocumentstatus dokst Document Status
documentstatusname dostx Status Text

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_ChgRecdRefDocTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMCRDOC_D (
    MANDT,                         -- Client [mandt]
    CHANGERECORDREFERENCEUUID,     -- NodeID [/bobf/conf_key]
    CHGRECREFINTERNALKEY1,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY2,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY3,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY4,         -- Key [/iam/internal_id]
    DOCUMENTTYPE,                  -- Document Type [dokar]
    DOCUMENTINFORECORD,            -- Document [doknr]
    DOCUMENTVERSION,               -- Doc. Version [dokvr]
    DOCUMENTPART,                  -- Document Part [doktl_d]
    CHANGERECORDUUID,              -- NodeID [/bobf/conf_key]
    CHANGERECORDTYPE,              -- Record Type [/plmb/cr_type]
    CHANGERECORDREFERENCETYPE,     -- Object Type [/iam/type]
    CHANGERECORDREFERENCESUBTYPE,  -- Subtype [/iam/subtype]
    CHANGERECORDREFERENCE,         -- Ref. Object ID [/iam/ref_id]
    PARENTCHANGERECORDREFUUID,     -- Node ID [/iam/conf_key]
    ISMAINREFERENCE,               -- Main Reference [/iam/main_ref_ind]
    CREATEDBYUSER,                 -- Created By [/bofu/user_id_created_by]
    CREATIONDATETIME,              -- Time Stamp [tzntstmps]
    LASTCHANGEDBYUSER,             -- Changed By [/bofu/user_id_changed_by]
    LASTCHANGEDATETIME,            -- Time Stamp [tzntstmps]
    CHANGERECORDITEMRELEVANCE,     -- Relevance [/iam/cr_itemrel]
    CHANGERECORDVIRTUALREFIND,     -- Virtual Reference [/iam/virtual_ref_ind]
    CHANGERECORDITEMPROCGSTATUS,   -- Processing Status [/plmb/cr_item_proc_status]
    CHGRECDNEXTITEMPROCGSTATUS,    -- Processing Status [/plmb/cr_item_proc_status]
    CHGSTATUS,                     -- Status [/plmb/ecn_status]
    CHGRECDNMBRCHGSTS,             -- Status [/plmb/ecn_status]
    PARTNER,                       -- Chg Responsible [/plmb/cr_chg_responsible]
    CHANGERECORDLIFECYCLESTATUS,   -- Issue Lifecycle [/iam/issue_lcycle_stat_cd]
    CHANGERECORDITEMTYPE,          -- /plmi/chg_itm_type
    INTERNALDOCUMENTSTATUS,        -- Document Status [dokst]
    EXTERNALDOCUMENTSTATUS,        -- Document Status [dokst]
    DOCUMENTSTATUSNAME,            -- Status Text [dostx]
    PRIMARY KEY (MANDT, CHANGERECORDREFERENCEUUID)
);