PLMCRDOC_D
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_ChgRecdRefDocDraft | view_entity | from | BASIC | Query View for Document Item Draft |
Fields (33)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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