I_BusPartWebsiteURLTP_2

DDL: I_BUSPARTWEBSITEURLTP_2 SQL: IBUPAWEBURLTP2 Type: view_entity TRANSACTIONAL Package: MDC_BUPA_BO

Transactional View for BP Website with RAP

I_BusPartWebsiteURLTP_2 is a Transactional CDS View that provides data about "Transactional View for BP Website with RAP" in SAP S/4HANA. It reads from 1 data source (I_BPWebsiteURL_2) and exposes 26 fields with key fields BusinessPartner, AddressNumber, Person, OrdinalNumber. It has 1 association to related views. Part of development package MDC_BUPA_BO.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_BPWebsiteURL_2 I_BPWebsiteURL_2 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C 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 Website with RAP view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressNumber AddressID
KEY Person Person
KEY OrdinalNumber OrdinalNumber
OrdinalNumberForEdit OrdinalNumber
IsDefaultURLAddress IsDefaultURLAddress
SearchURLAddress SearchURLAddress
URLFieldLength URLFieldLength
WebsiteURL WebsiteURL
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
_BusinessPartnerAddress _BusinessPartnerAddress
_BPProtectedAddress _BPProtectedAddress
AuthorizationGroup _BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
_AuthorizationGroup _BusinessPartner _AuthorizationGroup 
//@AbapCatalog.sqlViewName: 'IBUPAWEBURLTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@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 Website with RAP'
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartWebsiteURLTP_2
  as select from I_BPWebsiteURL_2 //I_BPWebsiteURL

  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

{
//  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 BPWebsiteURLDrftUUID,

  key BusinessPartner,
  key AddressID as AddressNumber,
  key Person,
  key OrdinalNumber,
      @ObjectModel.editableFieldFor: 'OrdinalNumber'
      OrdinalNumber as OrdinalNumberForEdit,
      //  key ValidityStartDate,   it is filtered in lowest view (= 00010101)

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      IsDefaultURLAddress,
      SearchURLAddress,
//      CommNumberIsNotUsed,

//      UniformResourceIdentifierType,

     // cast( URLFieldLength as abap.int4 ) as URLFieldLength, 

       URLFieldLength,
       WebsiteURL,
       @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,
      _BusinessPartnerAddress,
      _BPProtectedAddress,
      
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner.IsBusinessPurposeCompleted,
      
      _BusinessPartner._AuthorizationGroup as _AuthorizationGroup
//      _BPDataControllerUsage    

}

Learn More