R_AddressFaxNumberTP

DDL: R_ADDRESSFAXNUMBERTP Type: view_entity

Fax Number - TP

R_AddressFaxNumberTP is a CDS View that provides data about "Fax Number - TP" in SAP S/4HANA. It reads from 1 data source (I_ADDRESSFAXNUMBER_2) and exposes 15 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
I_ADDRESSFAXNUMBER_2 I_ADDRESSFAXNUMBER_2 from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fax Number - TP view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID AddressPersonID
KEY CommMediumSequenceNumber CommMediumSequenceNumber
FaxNumberCountry FaxNumberCountry
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber
FaxExtensionNumber FaxExtensionNumber
InternationalFaxNumber InternationalFaxNumber
FaxNumberIsCurrentDefault FaxNumberIsCurrentDefault
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_FaxNumberCountry _FaxNumberCountry
_OrganizationAddress _OrganizationAddress
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fax Number - TP'
define view entity R_AddressFaxNumberTP
  as select from I_ADDRESSFAXNUMBER_2
  association to parent R_OrganizationAddressTP as _OrganizationAddress on $projection.AddressID = _OrganizationAddress.AddressID
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      FaxNumberCountry,
      CommLineNotForUnsolicitedCntct,
      FaxAreaCodeSubscriberNumber,
      FaxExtensionNumber,
      InternationalFaxNumber,
      FaxNumberIsCurrentDefault,
      ValidityStartDate,
      ValidityEndDate,
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _FaxNumberCountry,
      _OrganizationAddress
}