SUIM_CHDOC_USR_CREA_X

DDL: SUIM_CHDOC_USR_CREA_X Type: view_entity Package: SUIM_CHDOC
18 Fields 2 Data Sources

SUIM | ChangeDoc for User Creation

SUIM_CHDOC_USR_CREA_X is a CDS View that provides data about "SUIM | ChangeDoc for User Creation" in SAP S/4HANA. It reads from 2 data sources (SUIM_GET_USH04, SUIM_CHDOC_USR_CREA_XX) and exposes 18 fields with key fields bname, modda, modti, tstmp, modbe. Part of development package SUIM_CHDOC.

Data Sources (2)

SourceAliasJoin Type
SUIM_GET_USH04 SUIM_GET_USH04 union
SUIM_CHDOC_USR_CREA_XX xx from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM | ChangeDoc for User Creation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY bname SUIM_CHDOC_USR_CREA_XX bname User name
KEY modda SUIM_CHDOC_USR_CREA_XX modda Modification date
KEY modti SUIM_CHDOC_USR_CREA_XX modti Modification time
KEY tstmp SUIM_CHDOC_USR_CREA_XX tstmp Time Stamp
KEY modbe SUIM_CHDOC_USR_CREA_XX modbe Changed By
KEY tabname
KEY fname
changenr
src_typ
KEY modda modda Modification date
KEY modti modti Modification time
KEY tstmp Time Stamp
KEY modbe modbe Changed By
KEY tabname
KEY fname
changenr
src_typ
src_nam

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SUIM_CHDOC_USR_CREA_X.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW SUIM_CHDOC_USR_CREA_X AS
SELECT
  xx.bname AS bname,
  xx.modda AS modda,
  xx.modti AS modti,
  xx.tstmp AS tstmp,
  xx.modbe AS modbe,
  cast( 'USR04' as tabname ) AS tabname,
  cast( 'CREATE_USER' as fieldname ) AS fname,
  coalesce( appl.changenr, '' ) AS changenr,
  coalesce( appl.src_typ, '' ) AS src_typ,
  '' AS src_nam
FROM SUIM_CHDOC_USR_CREA_XX AS xx
-- UNION with additional select branch(es): SUIM_GET_USH04
;

Learn More