P_UserAddress

DDL: P_USERADDRESS SQL: PUSERADDRESS Type: view BASIC

Allegmeine CDS View für Adresse

P_UserAddress is a Basic CDS View that provides data about "Allegmeine CDS View für Adresse" in SAP S/4HANA. It reads from 2 data sources (usr02, usr21) and exposes 15 fields with key fields mandt, bname. It has 6 associations to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
usr02 usr02 from
usr21 usr21 inner

Associations (6)

CardinalityTargetAliasCondition
[0..1] adrp _adrp _adrp.persnumber = usr21.persnumber and _adrp.nation = '' and _adrp.date_from = '00010101'
[0..1] adcp _adcp _adcp.persnumber = usr21.persnumber and _adcp.addrnumber = usr21.addrnumber and _adcp.nation = '' and _adcp.date_from = '00010101'
[0..1] uscompany _uscompany _uscompany.addrnumber = usr21.addrnumber or _uscompany.addrnumber = usr21.template_orgaddr
[0..1] adrc _adrc _adrc.addrnumber = usr21.addrnumber and _adrc.nation = '' and _adrc.date_from = '00010101'
[0..1] adr6 _adr6 _adr6.persnumber = usr21.persnumber and _adr6.addrnumber = usr21.addrnumber and _adr6.date_from = '00010101' and _adr6.flgdefault = 'X'
[0..1] but000 _but000 _but000.persnumber = usr21.persnumber and _but000.partner_guid = usr21.bpperson

Annotations (6)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSERADDRESS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allegmeine CDS View für Adresse view
VDM.viewType #BASIC view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY mandt usr21 mandt
KEY bname usr21 bname
kostl usr21 kostl
idadtype usr21 idadtype
persnumber usr21 persnumber
addrnumber usr21 addrnumber
bpperson usr21 bpperson
techdesc usr21 techdesc
class usr02 class
_adrp _adrp
_adcp _adcp
_uscompany _uscompany
_adrc _adrc
_adr6 _adr6
_but000 _but000 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSERADDRESS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allegmeine CDS View für Adresse'
@VDM.viewType: #BASIC
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view P_UserAddress
  as select from usr02
    inner join   usr21 on usr02.bname = usr21.bname
  association [0..1] to adrp      as _adrp      on  _adrp.persnumber      = usr21.persnumber
                                                and _adrp.nation          = ''
                                                and _adrp.date_from       = '00010101'
  association [0..1] to adcp      as _adcp      on  _adcp.persnumber      = usr21.persnumber
                                                and _adcp.addrnumber      = usr21.addrnumber
                                                and _adcp.nation          = ''
                                                and _adcp.date_from       = '00010101'
  association [0..1] to uscompany as _uscompany on  _uscompany.addrnumber = usr21.addrnumber
                                                or  _uscompany.addrnumber = usr21.template_orgaddr // Use company or template_company

  association [0..1] to adrc      as _adrc      on  _adrc.addrnumber      = usr21.addrnumber
                                                and _adrc.nation          = ''
                                                and _adrc.date_from       = '00010101'
  association [0..1] to adr6      as _adr6      on  _adr6.persnumber      = usr21.persnumber
                                                and _adr6.addrnumber      = usr21.addrnumber
                                                and _adr6.date_from       = '00010101'
                                                and _adr6.flgdefault      = 'X'
  association [0..1] to but000    as _but000    on  _but000.persnumber    = usr21.persnumber
                                                and _but000.partner_guid  = usr21.bpperson
{
  key usr21.mandt,
  key usr21.bname,
      usr21.kostl,
      usr21.idadtype,
      usr21.persnumber,
      usr21.addrnumber,
      usr21.bpperson,
      usr21.template_orgaddr,
      usr21.techdesc,
      @Consumption.hidden: true
      usr02.class, // Do not export usergroup!

      _adrp,
      _adcp,
      _uscompany,
      _adrc,
      _adr6,
      _but000
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR02",
"USR21"
],
"ASSOCIATED":
[
"ADCP",
"ADR6",
"ADRC",
"ADRP",
"BUT000",
"USCOMPANY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More