SUIM_CHDOC_USR_CREA

DDL: SUIM_CHDOC_USR_CREA Type: view_entity Package: SUIM_CHDOC
13 Fields

SUIM | ChangeDoc for User Creation

SUIM_CHDOC_USR_CREA is a CDS View that provides data about "SUIM | ChangeDoc for User Creation" in SAP S/4HANA. Part of development package SUIM_CHDOC.

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 (13)

KeyFieldSource TableSource FieldDescription
KEY bname x bname User name
KEY modda x modda Modification date
KEY modti x modti Modification time
KEY tstmp x tstmp Time Stamp
KEY modbe x modbe Changed By
KEY tabname x tabname Table/Constant Value
KEY fname
changenr x changenr Document Number
repidthenPROGelseendassrc_typ
chngind
row_num
old_value
new_value

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.
-- 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 AS
SELECT
  x.bname AS bname,
  x.modda AS modda,
  x.modti AS modti,
  x.tstmp AS tstmp,
  x.modbe AS modbe,
  x.tabname AS tabname,
  cast( 'CREATE_USER' as fieldname ) AS fname,
  x.changenr AS changenr,
  case when x.tabname = 'USR04' then x.src_typ when h02.tcode > '' then 'TRAN' when h02.repid > '' then 'PROG' else '' end as src_typ AS repidthenPROGelseendassrc_typ,
  'I' AS chngind,
  cast( 99 as abap.int2 ) AS row_num,
  cast( '' as cdfldvalo ) AS old_value,
  cast( x.bname as cdfldvaln ) AS new_value
;

Learn More