I_ADDRESSPHONENUMBER

CDS View

Address Phone Number

I_ADDRESSPHONENUMBER is a CDS View in S/4HANA. Address Phone Number. It contains 9 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 9 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_AddressPhoneNumber view from BASIC Phone Number
A_BPContactPersonMblNmbr view_entity inner BASIC Contact Person Mobile Number
A_BPContactPersonTelNmbr view_entity inner BASIC Contact Person Telephone Number
A_BPContactWrkPlacePhoneNumber view inner BASIC BP Contact Work Place Phone Number

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY OrdinalNumber OrdinalNumber 4
KEY Person Person 1
DestinationLocationCountry DestinationLocationCountry 4
InternationalPhoneNumber InternationalPhoneNumber 4
IsDefaultPhoneNumber IsDefaultPhoneNumber 4
PhoneNumber MobilePhoneNumber,PhoneNumber 4
PhoneNumberExtension PhoneNumberExtension 4
PhoneNumberType PhoneNumberType 4 
@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