I_BPCntctPersnWebsiteURLProcTP

DDL: I_BPCNTCTPERSNWEBSITEURLPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BP_REL_GOV_BO

Business Partner Workplace Website Proc - TP

I_BPCntctPersnWebsiteURLProcTP is a Transactional CDS View that provides data about "Business Partner Workplace Website Proc - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCntctPersnWebsiteURLProc) and exposes 20 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 4 associations to related views. Part of development package MDC_BP_REL_GOV_BO.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCntctPersnWebsiteURLProc I_BPCntctPersnWebsiteURLProc from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusPartRelationshipProcessTP _BPRelProcess $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess and $projection.MDChgProcessStep = _BPRelProcess.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BPRelProcess.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BPRelProcess.MDChgProcessSrceObject
[0..1] I_BPRelshpProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Workplace Website Proc - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY OrdinalNumber OrdinalNumber
IsDefaultURLAddress IsDefaultURLAddress
CommNumberIsNotUsed CommNumberIsNotUsed
UniformResourceIdentifierType UniformResourceIdentifierType
SearchURLAddress SearchURLAddress
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressLine1Text
URLFieldLength URLFieldLength
WebsiteURL WebsiteURL
_BPRelProcess _BPRelProcess
_WorkplaceAddress _WorkplaceAddress
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Workplace Website Proc - TP'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCntctPersnWebsiteURLProcTP
  as select from I_BPCntctPersnWebsiteURLProc
  
  association [1..1] to I_BusPartRelationshipProcessTP        as _BPRelProcess        on  $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BPRelProcess.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BPRelProcess.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BPRelProcess.MDChgProcessSrceObject
  association        to parent I_BPContactPersonAddressProcTP as _WorkplaceAddress    on  $projection.MasterDataChangeProcess = _WorkplaceAddress.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _WorkplaceAddress.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _WorkplaceAddress.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _WorkplaceAddress.MDChgProcessSrceObject
                                                                                      and $projection.AddressNumber           = _WorkplaceAddress.AddressNumber
  association [0..1] to I_BPRelshpProcessKPIRecordType        as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH             as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages             as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key OrdinalNumber,
      IsDefaultURLAddress,
      CommNumberIsNotUsed,
      UniformResourceIdentifierType,
      SearchURLAddress,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      /* Record Identification */
      cast( '' as abap.char(209) ) as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,
      URLFieldLength,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      WebsiteURL,

      _BPRelProcess,
      _WorkplaceAddress,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More