SUIM_CHDOC_USR_CURR_ADR

DDL: SUIM_CHDOC_USR_CURR_ADR Type: view_entity
7 Fields 1 Data Sources

SUIM|Current Address for UserID

SUIM_CHDOC_USR_CURR_ADR is a CDS View that provides data about "SUIM|Current Address for UserID" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 7 fields with key field bname.

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM|Current Address for UserID view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY bname usr21 bname User name
GivenName adrp name_first First Name
FamilyName adrp name_last Last Name
InhouseMail adcp ih_mail Internal mail
WorkplaceDepartmentName adcp department Department
WorkplaceFunctionalTitleName adcp function Unit Func.
company uscompany company Owner

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_CURR_ADR.
-- 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_CURR_ADR AS
SELECT
  usr21.bname AS bname,
  adrp.name_first AS GivenName,
  adrp.name_last AS FamilyName,
  adcp.ih_mail AS InhouseMail,
  adcp.department AS WorkplaceDepartmentName,
  adcp.function AS WorkplaceFunctionalTitleName,
  uscompany.company AS company
FROM usr21
;

Learn More