SUIM_CHDOC_GET_ALL
Get User Change Documents (All Types)
SUIM_CHDOC_GET_ALL is a CDS View in S/4HANA. Get User Change Documents (All Types). It contains 21 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SUIM_CHDOC_GET_ALL_ADR | view_entity | from | Get User Change Documents (All Types) | |
| SUIM_CHDOC_GET_ALL_TX_X | view_entity | from | User Change Documents with Texts |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | bname | bname | 2 |
| KEY | fname | fname | 2 |
| KEY | modbe | modbe | 2 |
| KEY | modda | modda | 2 |
| KEY | modti | modti | 2 |
| KEY | tabname | tabname | 2 |
| KEY | tstmp | tstmp | 2 |
| c_prof | c_prof | 2 | |
| c_role | c_role | 2 | |
| changenr | changenr | 2 | |
| chngind | chngind | 2 | |
| from_dat | from_dat | 2 | |
| new_value | new_value | 2 | |
| old_value | old_value | 2 | |
| row_num | row_num | 2 | |
| src_nam | src_nam | 2 | |
| src_typ | src_typ | 2 | |
| subsystem | subsystem | 2 | |
| to_dat | to_dat | 2 | |
| x_prof | x_prof | 2 | |
| x_role | x_role | 2 |
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.
-- Get User Change Documents (All Types)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUIM_CHDOC_GET_ALL (
BNAME,
FNAME,
MODBE,
MODDA,
MODTI,
TABNAME,
TSTMP,
C_PROF,
C_ROLE,
CHANGENR,
CHNGIND,
FROM_DAT,
NEW_VALUE,
OLD_VALUE,
ROW_NUM,
SRC_NAM,
SRC_TYP,
SUBSYSTEM,
TO_DAT,
X_PROF,
X_ROLE,
PRIMARY KEY (BNAME, FNAME, MODBE, MODDA, MODTI, TABNAME, TSTMP)
);
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