CDHDR
Change document header
CDHDR is an SAP database table in S/4HANA. Change document header. It contains 15 fields. 27 CDS views read from this table.
CDS Views using this table (27)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAC_CDS_UH_CD_VERSION | view | from | GAH Change log for Hierarchy Version | |
| Fclm_Bm_Bank_Docu | view | from | Change document for bank | |
| Fclm_Bm_Hbank_Docu | view | from | Create and delete change document for house bank | |
| Fclm_Bm_Hbank_Docu1 | view | from | update change document for house bank | |
| I_APJ_JOB_USR_HISTORY | view_entity | from | Job User Change History | |
| I_ChangeDocument | view | from | BASIC | Change document header |
| I_ChangeDocument_2 | view_entity | left_outer | BASIC | Change Documents |
| I_ChangeRecdStatusLogBsc | view | from | BASIC | Change Record Change Status Log |
| I_ChangeRecordHistoryBasic | view_entity | inner | BASIC | Change Record history |
| I_DFS_OrglMeasureChangeDoc | view | from | BASIC | Change document header |
| I_InvgCsMChangeLog | view | inner | BASIC | ICM Change Log |
| I_MDQltyBusRuleChangeDocument | view | from | BASIC | Master Data Quality Business Rule Change Document |
| ISU_C4C_AUDITLOG_V | view | from | CDS View for Audit Log | |
| ISU_C4C_V2_AUDIT_VIEW | view | from | Data definition for Audit log view | |
| P_CHNG_DOC_UNBLOCK_INVOICE | view | inner | BASIC | |
| suim_chdoc_get_identity | view_entity | from | SUIM | ChangeDocs Object Class IDENTITY | |
| suim_chdoc_get_identity | view_entity | union | SUIM | ChangeDocs Object Class IDENTITY | |
| SUIM_CHDOC_GET_IDENTITY_CUA | view_entity | from | SUIM | ChangeDocs Object Class IDENTITY | |
| SUIM_CHDOC_GET_IDENTITY_CUA | view_entity | union | SUIM | ChangeDocs Object Class IDENTITY | |
| suim_chdoc_usr_auth_agr | view_entity | from | Get User Assignment Changes (AGR_USERS) | |
| SUIM_CHDOC_USR_CREA_CDHDR | view_entity | from | SUIM|Generic ChangeDoc for User (Create) | |
| SUIM_CHDOC_USR_CREA_DELE | view_entity | from | SUIM User Changedocs for Create/Delete | |
| SUIM_CHDOC_USR_CREA_XX | view_entity | from | SUIM|ChangeDoc for User Creation (HView) | |
| SUIM_CHDOC_USR_DELE_X | view_entity | from | SUIM | ChangeDoc for User Creation | |
| SUIM_CHDOC_USR_HEAD_01 | view_entity | from | SUIM User Changedocs for Create/Delete | |
| SUIM_CHDOC_USR_PROF | view_entity | from | Get User Authorization Change Documents | |
| VFCLM_BAM_DDL_CDHDR | view | from |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandant | MANDT | Client | |||
| KEY | objectclas | CDOBJECTCL | Change Doc. Object | |||
| KEY | objectid | CDOBJECTV | Object Value | |||
| KEY | changenr | CDCHANGENR | Document Number | |||
| username | CDUSERNAME | User | ||||
| udate | CDDATUM | Date | ||||
| utime | CDUZEIT | Time | ||||
| tcode | CDTCODE | Transaction | ||||
| planchngnr | PLANCHNGNR | Change no. | ||||
| act_chngno | CD_CHNGNO | Document Number | ||||
| was_plannd | CD_PLANNED | Created | ||||
| change_ind | CDCHNGINDH | Object Change | ||||
| langu | LANGU | Language | ||||
| version | CHAR3 | 3-Byte field | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging |
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 document header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CDHDR (
MANDANT, -- Client [MANDT]
OBJECTCLAS, -- Change Doc. Object [CDOBJECTCL]
OBJECTID, -- Object Value [CDOBJECTV]
CHANGENR, -- Document Number [CDCHANGENR]
USERNAME, -- User [CDUSERNAME]
UDATE, -- Date [CDDATUM]
UTIME, -- Time [CDUZEIT]
TCODE, -- Transaction [CDTCODE]
PLANCHNGNR, -- Change no. [PLANCHNGNR]
ACT_CHNGNO, -- Document Number [CD_CHNGNO]
WAS_PLANND, -- Created [CD_PLANNED]
CHANGE_IND, -- Object Change [CDCHNGINDH]
LANGU, -- Language [LANGU]
VERSION, -- 3-Byte field [CHAR3]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PRIMARY KEY (MANDANT, OBJECTCLAS, OBJECTID, CHANGENR)
);
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