I_BusPartFaxNumberTP_2

DDL: I_BUSPARTFAXNUMBERTP_2 SQL: IBUPAFAXTP2 Type: view_entity TRANSACTIONAL Package: MDC_BUPA_BO

Transactional View For I_BPFaxNumber

I_BusPartFaxNumberTP_2 is a Transactional CDS View that provides data about "Transactional View For I_BPFaxNumber" in SAP S/4HANA. It reads from 1 data source (I_BPFaxNumber) 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_BPFaxNumber I_BPFaxNumber from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_BusPartTelCountryPrefix _FaxCountryPrefix $projection.FaxCountry = _FaxCountryPrefix.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.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transactional View For I_BPFaxNumber view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressNumber AddressID
KEY Person Person
KEY OrdinalNumber OrdinalNumber
OrdinalNumberForEdit OrdinalNumber
FaxCountry FaxCountry
TelephoneCountryPrefix _FaxCountryPrefix TelephoneCountryPrefix
IsDefaultFaxNumber IsDefaultFaxNumber
FaxNumber FaxNumber
FaxNumberExtension FaxNumberExtension
InternationalFaxNumber InternationalFaxNumber
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
datsendasValidityStartDate
datsendasValidityEndDate
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
_BPProtectedAddress _BPProtectedAddress
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartner _BusinessPartner
_FaxCountryPrefix _FaxCountryPrefix
_AuthorizationGroup _BusinessPartner _AuthorizationGroup
_FaxNumberCountry _FaxNumberCountry
AuthorizationGroup _BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted 
//@AbapCatalog.sqlViewName: 'IBUPAFAXTP2'

//@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.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Transactional View For I_BPFaxNumber'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartFaxNumberTP_2
  as select from I_BPFaxNumber

  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 _FaxCountryPrefix       on  $projection.FaxCountry = _FaxCountryPrefix.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 BPFaxNmbrDrftUUID,

  key BusinessPartner,
  key AddressID                                as AddressNumber,
  key Person,
  key OrdinalNumber,
      @ObjectModel.editableFieldFor: 'OrdinalNumber'
      OrdinalNumber as OrdinalNumberForEdit,
      FaxCountry,
      _FaxCountryPrefix.TelephoneCountryPrefix as TelephoneCountryPrefix,
      IsDefaultFaxNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      FaxNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      FaxNumberExtension,
      InternationalFaxNumber,
//      CommNumberIsNotUsed,

      ValidityStartDateTime,
      ValidityEndDateTime,
      @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,
      @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,
      /* Associations */
      _BPProtectedAddress,
      _BusinessPartnerAddress,
      _BusinessPartner,
      _FaxCountryPrefix,
      _BusinessPartner._AuthorizationGroup,
      _FaxNumberCountry,
      
       _BusinessPartner.AuthorizationGroup,
       _BusinessPartner.IsBusinessPurposeCompleted
     // _BPDataControllerUsage

      
}

Learn More