I_AddressFaxNumber

DDL: I_ADDRESSFAXNUMBER SQL: IADDRFAXNUMBER Type: view BASIC Package: VDM_MD_BP_BASE

Address Fax Number

I_AddressFaxNumber is a Basic CDS View (Dimension) that provides data about "Address Fax Number" in SAP S/4HANA. It reads from 1 data source (adr3) and exposes 12 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) 12 fields

Data Sources (1)

SourceAliasJoin Type
adr3 adr3 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 = 'FAX' and _AddressCommunicationRemark.CorrespondenceLanguage = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IADDRFAXNUMBER view
AbapCatalog.preserveKey true view
EndUserText.label Address Fax 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 (12)

KeyFieldSource TableSource FieldDescription
KEY AddressID addrnumber
KEY Person persnumber
KEY OrdinalNumber consnumber
IsDefaultFaxNumber adr3 flgdefault
FaxCountry country
FaxNumber fax_number
FaxNumberExtension fax_extens
InternationalFaxNumber faxnr_long
CommNumberIsNotUsed flg_nouse
ValidityStartDateTime valid_from
ValidityEndDateTime valid_to
_AddressCommunicationRemark _AddressCommunicationRemark 
@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