P_USER002

DDL: P_USER002 SQL: PUSER002 Type: view
19 Fields 1 Data Sources

Adresse für alle Benutzer inc. BP

P_USER002 is a CDS View that provides data about "Adresse für alle Benutzer inc. BP" in SAP S/4HANA. It reads from 1 data source (P_UserAddress) and exposes 19 fields with key fields mandt, bname.

Data Sources (1)

SourceAliasJoin Type
P_UserAddress P_UserAddress from

Annotations (5)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSER002 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Adresse für alle Benutzer inc. BP view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY bname bname User name
class class User Group
name_text _adrp name_text Full Name
kostl kostl Substitute CC
department _adcp department Department
function _adcp function Unit Func.
building _adcp building Building code
floor _adcp floor Floor
roomnumber _adcp roomnumber Room Number
tel_number _adcp tel_number Telephone
tel_extens _adcp tel_extens Extension
INHOUSE_ML _adcp ih_mail Internal mail
name1 _adrc name1 PA text
city1 _adrc city1 City
post_code1 _adrc post_code1 Postal Code
street _adrc street Street Code
country _adrc country Venue: Ctry/Reg
smtp_addr _adr6 smtp_addr E-Mail Address

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 P_USER002.
-- 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: PUSER002

CREATE VIEW P_USER002 AS
SELECT
  mandt,
  bname,
  class,
  _adrp.name_text AS name_text,
  kostl,
  _adcp.department AS department,
  _adcp.function AS function,
  _adcp.building AS building,
  _adcp.floor AS floor,
  _adcp.roomnumber AS roomnumber,
  _adcp.tel_number AS tel_number,
  _adcp.tel_extens AS tel_extens,
  _adcp.ih_mail AS INHOUSE_ML,
  _adrc.name1 AS name1,
  _adrc.city1 AS city1,
  _adrc.post_code1 AS post_code1,
  _adrc.street AS street,
  _adrc.country AS country,
  _adr6.smtp_addr AS smtp_addr
FROM P_UserAddress
;

Learn More