I_ADDRESSFAXNUMBER_2

CDS View

Fax Number

I_ADDRESSFAXNUMBER_2 is a CDS View in S/4HANA. Fax Number. It contains 11 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 11 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_Arberp_Address view left_outer CONSUMPTION CDS View for Addresses
I_AddrCurDefaultFaxNumber view_entity from BASIC Current Default Fax Number
I_BPAddressIndependentFax view from BASIC BP Address independent Fax
I_BPContactFaxNmbrTP view inner TRANSACTIONAL BO view for BP contact Fax number
I_BPFaxNumber view from BASIC BP Fax number core view
I_BPRelshpCntctPersnFaxNmbrTP view_entity inner TRANSACTIONAL BO view for Contact Person Fax Number
R_AddressFaxNumberTP view_entity from Fax Number - TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY AddressPersonID Person 1
KEY CommMediumSequenceNumber OrdinalNumber,OrdinalNumberForEdit 3
_AddressCommunicationRemark _AddressCommunicationRemark 1
_FaxNumberCountry _FaxNumberCountry 1
CommLineNotForUnsolicitedCntct CommNumberIsNotUsed 2
FaxAreaCodeSubscriberNumber FaxNumber 3
FaxExtensionNumber FaxNumberExtension 3
FaxNumberCountry FaxCountry 3
FaxNumberIsCurrentDefault IsDefaultFaxNumber 3
InternationalFaxNumber InternationalFaxNumber 1 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_AddressCommunicationRemark', '_AddressCommunicationUsage']
@EndUserText.label: 'Fax Number'
//@Metadata.allowExtensions: true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel.representativeKey: 'AddressID'

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

define view entity I_AddressFaxNumber_2
  as select from adr3

  association [0..*] to I_AddressCommunicationRemark_2 as _AddressCommunicationRemark on  $projection.AddressID                               = _AddressCommunicationRemark.AddressID
                                                                                      and $projection.AddressPersonID                         = _AddressCommunicationRemark.AddressPersonID
                                                                                      and $projection.CommMediumSequenceNumber                = _AddressCommunicationRemark.CommMediumSequenceNumber
                                                                                      and _AddressCommunicationRemark.CommunicationMediumType = 'FAX'

  association [0..*] to I_AddressCommunicationUsage    as _AddressCommunicationUsage  on  $projection.AddressID                              = _AddressCommunicationUsage.AddressID
                                                                                      and $projection.AddressPersonID                        = _AddressCommunicationUsage.AddressPersonID
                                                                                      and $projection.CommMediumSequenceNumber               = _AddressCommunicationUsage.CommMediumSequenceNumber
                                                                                      and _AddressCommunicationUsage.CommunicationMediumType = 'FAX'

  association [0..1] to I_Country                      as _FaxNumberCountry           on  $projection.FaxNumberCountry = _FaxNumberCountry.Country

{
  key addrnumber                                         as AddressID,
  key persnumber                                         as AddressPersonID,
  key consnumber                                         as CommMediumSequenceNumber,
      @ObjectModel.foreignKey.association: '_FaxNumberCountry'
      country                                            as FaxNumberCountry,
      flg_nouse                                          as CommLineNotForUnsolicitedCntct,
      fax_number                                         as FaxAreaCodeSubscriberNumber,
      fax_extens                                         as FaxExtensionNumber,
      faxnr_long                                         as InternationalFaxNumber,
      cast (flgdefault as ad_faxcurdflt preserving type) as FaxNumberIsCurrentDefault,
      case valid_from
          when '' then '00010101'
          else cast( substring( valid_from,1,8) as abap.dats)
      end                                                as ValidityStartDate,
      case valid_to
          when '' then '99991231'
          else cast( substring( valid_to,1,8) as abap.dats)
      end                                                as ValidityEndDate,

      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _FaxNumberCountry
}
where
  date_from = '00010101'

Learn More