Rv_P_User

DDL: RV_P_USER SQL: RVPUSER Type: view
8 Fields 2 Data Sources

Rv_P_User is a CDS View of category Dimension in SAP S/4HANA. It reads from 2 data sources (adrp, usr21) and exposes 8 fields with key field userName.

Data Sources (2)

SourceAliasJoin Type
adrp adrp left_outer
usr21 usr21 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName RVPUSER view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey userName view
ClientDependent true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY userName usr21 bname User name
personNumber usr21 persnumber Person Number
description usr21 techdesc Description
lastName adrp name_last Last Name
fullName adrp name_text Full Name
firstNameUpper adrp mc_namefir First Name
lastNameUpper adrp mc_namelas Last Name
counter

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 Rv_P_User.
-- 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.
-- SQL view name: RVPUSER

CREATE VIEW Rv_P_User AS
SELECT
  usr21.bname AS userName,
  usr21.persnumber AS personNumber,
  usr21.techdesc AS description,
  adrp.name_last AS lastName,
  adrp.name_text AS fullName,
  adrp.mc_namefir AS firstNameUpper,
  adrp.mc_namelas AS lastNameUpper,
  cast(cast(1 as abap.int4) as rvcounter) AS counter
FROM usr21
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
;

Learn More