I_BPFaxNumberTextProcTP

DDL: I_BPFAXNUMBERTEXTPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

BP Address-Depend Fax Text (Process)

I_BPFaxNumberTextProcTP is a Transactional CDS View that provides data about "BP Address-Depend Fax Text (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPFaxNumberTextProc) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 4 associations to related views. Part of development package MDC_BUPA_GOV_BO.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_BPFaxNumberTextProc I_BPFaxNumberTextProc from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcessTP _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[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-Depend Fax Text (Process) 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 (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY OrdinalNumber OrdinalNumber
KEY Language Language
AddrCommunicationValidFromDate AddrCommunicationValidFromDate
CommunicationRemarkText CommunicationRemarkText
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressFaxNumber _BusinessPartnerFaxNumber AddressFaxNumber
_BPProtectedAddress _BPProtectedAddress
_BusinessPartner _BusinessPartner
_BusinessPartnerFaxNumber _BusinessPartnerFaxNumber
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Address-Depend Fax Text (Process)'
@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_BPFaxNumberTextProcTP
  as select from I_BPFaxNumberTextProc

  association [1..1] 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_BPFaxNumberProcessTP as _BusinessPartnerFaxNumber on  $projection.MasterDataChangeProcess = _BusinessPartnerFaxNumber.MasterDataChangeProcess
                                                                                   and $projection.MDChgProcessStep        = _BusinessPartnerFaxNumber.MDChgProcessStep
                                                                                   and $projection.MDChgProcessSrceSystem  = _BusinessPartnerFaxNumber.MDChgProcessSrceSystem
                                                                                   and $projection.MDChgProcessSrceObject  = _BusinessPartnerFaxNumber.MDChgProcessSrceObject
                                                                                   and $projection.AddressNumber           = _BusinessPartnerFaxNumber.AddressNumber
                                                                                   and $projection.OrdinalNumber           = _BusinessPartnerFaxNumber.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 AddressNumber,
  key OrdinalNumber,
  key Language,
      AddrCommunicationValidFromDate,
      @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,
      _BusinessPartnerFaxNumber.AddressFaxNumber as AddressFaxNumber,

      /* Associations */
      _BPProtectedAddress,
      _BusinessPartner,
      _BusinessPartnerFaxNumber,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More