I_ADDRESSFAXNUMBER

CDS View

Address Fax Number

I_ADDRESSFAXNUMBER is a CDS View in S/4HANA. Address Fax Number. It contains 8 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/SCMTMS/CV_LocQuByPhysAdd view left_outer Helper View for Query By Phys. Address
A_AddressFaxNumber view from BASIC Fax Number
A_BPContactWorkPlaceFaxNumber view inner BASIC BP Contact Work Place Fax Number

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY OrdinalNumber OrdinalNumber 2
KEY Person Person 1
FaxCountry fax_country_code,FaxCountry 3
FaxNumber fax_subscriber_id,FaxNumber 2
FaxNumberExtension fax_extension_id,FaxNumberExtension 3
InternationalFaxNumber InternationalFaxNumber 2
IsDefaultFaxNumber IsDefaultFaxNumber 2 
@AbapCatalog.sqlViewName: 'IADDRFAXNUMBER'
@AbapCatalog.preserveKey:true 
@EndUserText.label: 'Address Fax Number'
@Analytics : {dataCategory: #DIMENSION}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.representativeKey: 'AddressID'

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

define view I_AddressFaxNumber as select from adr3

  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 = 'FAX'
                                                                                 and _AddressCommunicationRemark.CorrespondenceLanguage = $session.system_language
{
  key addrnumber as AddressID,
  key persnumber as Person,
  key consnumber as OrdinalNumber,
  adr3.flgdefault as IsDefaultFaxNumber,
  country    as FaxCountry,
  fax_number as FaxNumber,
  fax_extens as FaxNumberExtension,
  faxnr_long as InternationalFaxNumber,
  flg_nouse as CommNumberIsNotUsed,
  valid_from as ValidityStartDateTime,
  valid_to as ValidityEndDateTime,

  _AddressCommunicationRemark
}
where date_from = '00010101'

Learn More