I_BPIndepWebsiteTextProcTP

DDL: I_BPINDEPWEBSITETEXTPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

BP Address Independent Website Text

I_BPIndepWebsiteTextProcTP is a Transactional CDS View that provides data about "BP Address Independent Website Text" in SAP S/4HANA. It reads from 1 data source (I_BPIndepWebsiteTextProc) and exposes 18 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, OrdinalNumber. It has 3 associations to related views. Part of development package MDC_BUPA_GOV_BO.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_BPIndepWebsiteTextProc I_BPIndepWebsiteTextProc from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _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 (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label BP Address Independent Website Text view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY OrdinalNumber OrdinalNumber
KEY Language Language
AddrCommunicationValidFromDate AddrCommunicationValidFromDate
AddressNumber AddressNumber
CommunicationRemarkText CommunicationRemarkText
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
IndepSearchURLAddress _BPIndepWebSiteURL SearchURLAddress
_BusinessPartner _BusinessPartner
_BPIndepWebSiteURL _BPIndepWebSiteURL
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Address Independent Website Text'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPIndepWebsiteTextProcTP
  as select from I_BPIndepWebsiteTextProc

  association        to I_BusinessPartnerProcessTP       as _BusinessPartner     on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                 and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                 and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                 and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

  association        to parent I_BPIndepWebsiteURLProcTP as _BPIndepWebSiteURL   on  $projection.MasterDataChangeProcess = _BPIndepWebSiteURL.MasterDataChangeProcess
                                                                                 and $projection.MDChgProcessStep        = _BPIndepWebSiteURL.MDChgProcessStep
                                                                                 and $projection.MDChgProcessSrceSystem  = _BPIndepWebSiteURL.MDChgProcessSrceSystem
                                                                                 and $projection.MDChgProcessSrceObject  = _BPIndepWebSiteURL.MDChgProcessSrceObject
                                                                                 and $projection.OrdinalNumber           = _BPIndepWebSiteURL.OrdinalNumber

  association [0..1] to I_BPProcessKPIRecordType         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 OrdinalNumber,
  key Language,
      AddrCommunicationValidFromDate,
      AddressNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      CommunicationRemarkText,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,

      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified) as MDChgProcKPIUpdateStatus,
        _BPIndepWebSiteURL.SearchURLAddress as IndepSearchURLAddress,

      /* Associations */
      _BusinessPartner,
      _BPIndepWebSiteURL,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More