I_BusPartMobilePhoneNumberTP_2

DDL: I_BUSPARTMOBILEPHONENUMBERTP_2 SQL: IBUPAMOBTELTP2 Type: view_entity TRANSACTIONAL Package: MDC_BUPA_BO

Transactional View for BP Mobile Number

I_BusPartMobilePhoneNumberTP_2 is a Transactional CDS View that provides data about "Transactional View for BP Mobile Number" in SAP S/4HANA. It reads from 1 data source (I_BPMobilePhoneNumber) and exposes 34 fields with key fields BusinessPartner, AddressNumber, Person, OrdinalNumber. It has 2 associations to related views. Part of development package MDC_BUPA_BO.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_BPMobilePhoneNumber BusinessPartnerMobileNumber from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_BusPartTelCountryPrefix _TelCountryPrefix $projection.MobilePhoneCountry = _TelCountryPrefix.Country

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Transactional View for BP Mobile Number view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressNumber AddressID
KEY Person Person
KEY OrdinalNumber OrdinalNumber
OrdinalNumberForEdit OrdinalNumber
MobilePhoneCountry MobilePhoneCountry
TelephoneCountryPrefix _TelCountryPrefix TelephoneCountryPrefix
IsDefaultPhoneNumber IsDefaultPhoneNumber
MobilePhoneNumber MobilePhoneNumber
CompleteTelephoneNumber CompleteTelephoneNumber
PhoneNumberType PhoneNumberType
ValidityEndDateTime ValidityEndDateTime
ValidityStartDateTime ValidityStartDateTime
datsendasValidityStartDate
datsendasValidityEndDate
AuthorizationGroup _BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
_BusinessPartner _BusinessPartner
_TelCountryPrefix _TelCountryPrefix
_BusinessPartnerAddress _BusinessPartnerAddress
_PhoneNumberCountry _PhoneNumberCountry
_PhoneNumberType _PhoneNumberType
_AuthorizationGroup _BusinessPartner _AuthorizationGroup 
//@AbapCatalog.sqlViewName: 'IBUPAMOBTELTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Transactional View for BP Mobile Number'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartMobilePhoneNumberTP_2
  as select from I_BPMobilePhoneNumber as BusinessPartnerMobileNumber


  association        to parent I_BusinessPartnerAddressTP_2 as _BusinessPartnerAddress on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                                       and $projection.AddressNumber   = _BusinessPartnerAddress.AddressNumber
//                                                                                       and $projection.BPDrftUUID   = _BusinessPartnerAddress.BPDrftUUID

//                                                                                       and $projection.BPAddressDrftUUID   = _BusinessPartnerAddress.BPAddressDrftUUID

  association [1..1] to I_BusinessPartnerTP_2               as _BusinessPartner        on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                                       and $projection.BPDrftUUID   = _BusinessPartner.BPDrftUUID

  association [0..1] to I_BusPartTelCountryPrefix           as _TelCountryPrefix       on  $projection.MobilePhoneCountry = _TelCountryPrefix.Country
{
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPAddressDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPMblPhNmbrDrftUUID,

  key BusinessPartner,
  key AddressID                                                     as AddressNumber,
  key Person,
  key OrdinalNumber,
      @ObjectModel.editableFieldFor: 'OrdinalNumber'
      OrdinalNumber as OrdinalNumberForEdit,
      MobilePhoneCountry,
      _TelCountryPrefix.TelephoneCountryPrefix                      as TelephoneCountryPrefix,
      IsDefaultPhoneNumber,
//      CommNumberIsNotUsed,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      MobilePhoneNumber,
      CompleteTelephoneNumber,
//      PhoneIsSMSEnabled,


      PhoneNumberType,
      ValidityEndDateTime,
      ValidityStartDateTime,
      @Semantics.businessDate.from: true
      case when ValidityStartDateTime != ''
      then cast ( (substring(ValidityStartDateTime,1,8) ) as abap.dats )
      else cast ( '00010101' as abap.dats )
      end                                                           as ValidityStartDate,
      @Semantics.businessDate.to: true
      case when ValidityEndDateTime != ''
      then cast ( (substring(ValidityEndDateTime,1,8) ) as abap.dats )
      else cast ( '99991231' as abap.dats )
      end                                                           as ValidityEndDate,
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet              as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1                as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2                as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3                as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4                as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5                as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6                as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7                as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8                as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9                as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10               as DataController10,
      _BusinessPartner,
      _TelCountryPrefix,
      _BusinessPartnerAddress,
      _PhoneNumberCountry,
      _PhoneNumberType,
      _BusinessPartner._AuthorizationGroup as _AuthorizationGroup
      //_BPDataControllerUsage

}

Learn More