A_AddressPhoneNumber

DDL: A_ADDRESSPHONENUMBER SQL: AADDRPHONENUMBER Type: view BASIC

Phone Number

A_AddressPhoneNumber is a Basic CDS View that provides data about "Phone Number" in SAP S/4HANA. It reads from 2 data sources (I_AddressPhoneNumber, I_BusPartAddress) and exposes 15 fields with key fields AddressID, Person, OrdinalNumber. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_AddressPhoneNumber I_AddressPhoneNumber from
I_BusPartAddress I_BusPartAddress inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BPProtectedAddress _BPProtectedAddress $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner and $projection.AddressID = _BPProtectedAddress.AddressID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AADDRPHONENUMBER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Phone Number view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_AddressPhoneNumber AddressID
KEY Person I_AddressPhoneNumber Person
KEY OrdinalNumber I_AddressPhoneNumber OrdinalNumber
DestinationLocationCountry I_AddressPhoneNumber DestinationLocationCountry
IsDefaultPhoneNumber I_AddressPhoneNumber IsDefaultPhoneNumber
PhoneNumber I_AddressPhoneNumber PhoneNumber
PhoneNumberExtension I_AddressPhoneNumber PhoneNumberExtension
InternationalPhoneNumber I_AddressPhoneNumber InternationalPhoneNumber
PhoneNumberType I_AddressPhoneNumber PhoneNumberType
AddressCommunicationRemarkText
IsBusinessPurposeCompleted I_BusPartAddress IsBusinessPurposeCompleted
BusinessPartner I_BusPartAddress BusinessPartner
AuthorizationGroup I_BusPartAddress AuthorizationGroup
_BPProtectedAddress _BPProtectedAddress
_BusinessPartner I_BusPartAddress _BusinessPartner 
@AbapCatalog.sqlViewName: 'AADDRPHONENUMBER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Phone Number'
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_AddressPhoneNumber as select from I_AddressPhoneNumber
inner join I_BusPartAddress on I_AddressPhoneNumber.AddressID = I_BusPartAddress.AddressID

association [0..1] to I_BPProtectedAddress as _BPProtectedAddress on  $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
                                                                  and $projection.AddressID = _BPProtectedAddress.AddressID

{  
  key I_AddressPhoneNumber.AddressID, 
  key I_AddressPhoneNumber.Person, 
  key I_AddressPhoneNumber.OrdinalNumber, 
      I_AddressPhoneNumber.DestinationLocationCountry, 
      I_AddressPhoneNumber.IsDefaultPhoneNumber, 
      I_AddressPhoneNumber.PhoneNumber, 
      I_AddressPhoneNumber.PhoneNumberExtension, 
      @ObjectModel.readOnly: true
      I_AddressPhoneNumber.InternationalPhoneNumber, 
      I_AddressPhoneNumber.PhoneNumberType,
      I_AddressPhoneNumber._AddressCommunicationRemark.AddressCommunicationRemarkText,
      @Consumption.hidden: true
      I_BusPartAddress.IsBusinessPurposeCompleted,
      @Consumption.hidden: true
      I_BusPartAddress.BusinessPartner,
      @Consumption.hidden: true
      I_BusPartAddress.AuthorizationGroup,
      @Consumption.hidden: true
      _BPProtectedAddress,
      @Consumption.hidden: true
      I_BusPartAddress._BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSCOMMUNICATIONREMARK",
"I_ADDRESSPHONENUMBER",
"I_BUSPARTADDRESS"
],
"ASSOCIATED":
[
"I_BPPROTECTEDADDRESS",
"I_BUSINESSPARTNER"
],
"BASE":
[
"I_BUSPARTADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More