P_UserAddress002

DDL: P_USERADDRESS002 SQL: PUSADDR002 Type: view
22 Fields 1 Data Sources

Adresse für alle Benutzer inc. BP

P_UserAddress002 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 22 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 PUSADDR002 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Adresse für alle Benutzer inc. BP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY bname bname User name
name_first _adrp name_first First Name
name_last _adrp name_last Last Name
NAME_TEXTC _adrp name_text Full Name
tel_extens _adcp tel_extens Extension
kostl kostl Substitute CC
building _adcp building Building code
roomnumber _adcp roomnumber Room Number
department _adcp department Department
INHOUSE_ML _adcp ih_mail Internal mail
name1 _adrc name1 PA text
city1 _adrc city1 City
post_code1 _adrc post_code1 Postal Code
mc_namefir _adrp mc_namefir First Name
mc_namelas _adrp mc_namelas Last Name
mc_name1 _adrc mc_name1 Name 1/Last Nme
mc_city1 _adrc mc_city1 City
idadtype idadtype Identity Add. Type
partner _but000 partner With Partner
smtp_addr _adr6 smtp_addr E-Mail Address
class class User Group

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_UserAddress002.
-- 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: PUSADDR002

CREATE VIEW P_UserAddress002 AS
SELECT
  mandt,
  bname,
  _adrp.name_first AS name_first,
  _adrp.name_last AS name_last,
  _adrp.name_text AS NAME_TEXTC,
  _adcp.tel_extens AS tel_extens,
  kostl,
  _adcp.building AS building,
  _adcp.roomnumber AS roomnumber,
  _adcp.department AS department,
  _adcp.ih_mail AS INHOUSE_ML,
  _adrc.name1 AS name1,
  _adrc.city1 AS city1,
  _adrc.post_code1 AS post_code1,
  _adrp.mc_namefir AS mc_namefir,
  _adrp.mc_namelas AS mc_namelas,
  _adrc.mc_name1 AS mc_name1,
  _adrc.mc_city1 AS mc_city1,
  idadtype,
  _but000.partner AS partner,
  _adr6.smtp_addr AS smtp_addr,
  class
FROM P_UserAddress
;

Learn More