I_AddressPhoneNumber

DDL: I_ADDRESSPHONENUMBER SQL: IADDRPHONENUMBER Type: view BASIC Package: VDM_MD_BP_BASE

Address Phone Number

I_AddressPhoneNumber is a Basic CDS View (Dimension) that provides data about "Address Phone Number" in SAP S/4HANA. It reads from 1 data source (adr2) and exposes 14 fields with key fields AddressID, Person, OrdinalNumber. It has 1 association to related views. Part of development package VDM_MD_BP_BASE.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
adr2 adr2 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AddressCommunicationRemark _AddressCommunicationRemark $projection.AddressID = _AddressCommunicationRemark.AddressID and $projection.Person = _AddressCommunicationRemark.Person and $projection.OrdinalNumber = _AddressCommunicationRemark.OrdinalNumber and _AddressCommunicationRemark.CommunicationMediumType = 'TEL' and _AddressCommunicationRemark.CorrespondenceLanguage = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IADDRPHONENUMBER view
AbapCatalog.preserveKey true view
EndUserText.label Address Phone Number view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey AddressID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY AddressID addrnumber
KEY Person persnumber
KEY OrdinalNumber consnumber
DestinationLocationCountry country
IsDefaultPhoneNumber flgdefault
CommNumberIsNotUsed flg_nouse
PhoneNumber tel_number
PhoneNumberExtension tel_extens
InternationalPhoneNumber telnr_long
PhoneIsSMSEnabled dft_receiv
PhoneNumberType r3_user
ValidityStartDateTime valid_from
ValidityEndDateTime valid_to
_AddressCommunicationRemark _AddressCommunicationRemark 
@AbapCatalog.sqlViewName: 'IADDRPHONENUMBER'
@AbapCatalog.preserveKey:true 
@EndUserText.label: 'Address Phone Number'
@Analytics : {dataCategory: #DIMENSION}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
//@AccessControl.privilegedAssociations: '_AddressCommunicationRemark'

@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_AddressPhoneNumber as select from adr2

  association [0..1] to I_AddressCommunicationRemark as _AddressCommunicationRemark on $projection.AddressID = _AddressCommunicationRemark.AddressID
                                                                                 and $projection.Person = _AddressCommunicationRemark.Person
                                                                                 and $projection.OrdinalNumber = _AddressCommunicationRemark.OrdinalNumber
                                                                                 and _AddressCommunicationRemark.CommunicationMediumType = 'TEL'
                                                                                 and _AddressCommunicationRemark.CorrespondenceLanguage = $session.system_language
{    
    key addrnumber as AddressID,
    key persnumber as Person,
//   , date_from as 

    key consnumber as OrdinalNumber,
    country as DestinationLocationCountry,
    flgdefault as IsDefaultPhoneNumber,
    flg_nouse as CommNumberIsNotUsed,
//  , home_flag as IsHomePhoneNumber

    tel_number as PhoneNumber,
    tel_extens as PhoneNumberExtension,
    telnr_long as InternationalPhoneNumber,
//  , telnr_call : system generated normalized number

    dft_receiv as PhoneIsSMSEnabled,
    r3_user as PhoneNumberType,   
    valid_from as ValidityStartDateTime,
    valid_to as ValidityEndDateTime,
  
    _AddressCommunicationRemark
    
} where date_from = '00010101'

Learn More