A_BPContactWrkPlacePhoneNumber

DDL: A_BPCONTACTWRKPLACEPHONENUMBER SQL: ABPCONTACTPHONE Type: view BASIC

BP Contact Work Place Phone Number

A_BPContactWrkPlacePhoneNumber is a Basic CDS View that provides data about "BP Contact Work Place Phone Number" in SAP S/4HANA. It reads from 2 data sources (I_BpContactToAddress, I_AddressPhoneNumber) and exposes 16 fields with key fields BusinessPartnerCompany, BusinessPartnerPerson, RelationshipNumber, AddressID, ValidityEndDate. It has 3 associations to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_BpContactToAddress ContactPerson from
I_AddressPhoneNumber PhoneNumber inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartnerCompany $projection.BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner
[1..1] A_BusinessPartner _BusinessPartnerPerson $projection.BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner
[1..1] A_BPContactToAddress _BPContactAddress $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber and $projection.BusinessPartnerCompany = _BPContactAddress.BusinessPartnerCompany and $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartnerPerson and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate and $projection.AddressID = _BPContactAddress.AddressID

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ABPCONTACTPHONE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label BP Contact Work Place 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 (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerCompany I_BpContactToAddress BusinessPartnerCompany
KEY BusinessPartnerPerson I_BpContactToAddress BusinessPartnerPerson
KEY RelationshipNumber I_BpContactToAddress RelationshipNumber
KEY AddressID I_BpContactToAddress AddressID
KEY ValidityEndDate I_BpContactToAddress ValidityEndDate
KEY OrdinalNumber I_AddressPhoneNumber OrdinalNumber
IsDefaultPhoneNumber I_AddressPhoneNumber IsDefaultPhoneNumber
DestinationLocationCountry I_AddressPhoneNumber DestinationLocationCountry
PhoneNumber I_AddressPhoneNumber PhoneNumber
PhoneNumberExtension I_AddressPhoneNumber PhoneNumberExtension
InternationalPhoneNumber I_AddressPhoneNumber InternationalPhoneNumber
PhoneNumberType I_AddressPhoneNumber PhoneNumberType
AddressCommunicationRemarkText
_BusinessPartnerCompany _BusinessPartnerCompany
_BusinessPartnerPerson _BusinessPartnerPerson
_BPContactAddress _BPContactAddress 
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'ABPCONTACTPHONE'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'BP Contact Work Place 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_BPContactWrkPlacePhoneNumber as select from I_BpContactToAddress as ContactPerson
inner join I_AddressPhoneNumber as PhoneNumber on ContactPerson.AddressID = PhoneNumber.AddressID and
                                                  ContactPerson.PersonNumber = PhoneNumber.Person

  association [1..1] to A_BusinessPartner as _BusinessPartnerCompany on $projection.BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner
  
  association [1..1] to A_BusinessPartner as _BusinessPartnerPerson on $projection.BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner

  association [1..1] to A_BPContactToAddress as _BPContactAddress on  $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber
                                                                  and $projection.BusinessPartnerCompany = _BPContactAddress.BusinessPartnerCompany
                                                                  and $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartnerPerson
                                                                  and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate
                                                                  and $projection.AddressID = _BPContactAddress.AddressID
                                                                     
{
  key ContactPerson.BusinessPartnerCompany as BusinessPartnerCompany,
  key ContactPerson.BusinessPartnerPerson  as BusinessPartnerPerson,
  key ContactPerson.RelationshipNumber,
  key ContactPerson.AddressID,
  key ContactPerson.ValidityEndDate,
  key PhoneNumber.OrdinalNumber,
      PhoneNumber.IsDefaultPhoneNumber,
      PhoneNumber.DestinationLocationCountry,
      PhoneNumber.PhoneNumber,
      PhoneNumber.PhoneNumberExtension,
      @ObjectModel.readOnly: true
      PhoneNumber.InternationalPhoneNumber,
      PhoneNumber.PhoneNumberType,
      PhoneNumber._AddressCommunicationRemark.AddressCommunicationRemarkText,
      _BusinessPartnerCompany,
      _BusinessPartnerPerson,
      _BPContactAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSCOMMUNICATIONREMARK",
"I_ADDRESSPHONENUMBER",
"I_BPCONTACTTOADDRESS"
],
"ASSOCIATED":
[
"A_BPCONTACTTOADDRESS",
"A_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More