I_BPFaxNumberProcessTP

DDL: I_BPFAXNUMBERPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

View for fax numbers from BP (Process)

I_BPFaxNumberProcessTP is a Transactional CDS View that provides data about "View for fax numbers from BP (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPFaxNumberProcess) and exposes 24 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 6 associations to related views. Part of development package MDC_BUPA_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPFaxNumberProcess I_BPFaxNumberProcess from

Associations (6)

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_BusPartTelCountryPrefix _FaxCountryPrefix $projection.FaxCountry = _FaxCountryPrefix.Country
[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
[0..*] I_BPFaxNumberTextProcTP _BPFaxNumberTextProcTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label View for fax numbers from BP (Process) view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY OrdinalNumber OrdinalNumber
AddrCommunicationValidFromDate AddrCommunicationValidFromDate
IsDefaultFaxNumber IsDefaultFaxNumber
FaxCountry FaxCountry
AddressFaxNumber AddressFaxNumber
FaxNumberExtension FaxNumberExtension
InternationalFaxNumber InternationalFaxNumber
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
AddressLine1Text
_BusinessPartner _BusinessPartner
_BusinessPartnerAddress _BusinessPartnerAddress
_BPFaxNumberTextProcTP _BPFaxNumberTextProcTP
_BPProtectedAddress _BPProtectedAddress
_FaxCountryPrefix _FaxCountryPrefix
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'View for fax numbers from BP (Process)'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPFaxNumberProcessTP
  as select from I_BPFaxNumberProcess  

  composition [0..*] of I_BPFaxNumberTextProcTP               as _BPFaxNumberTextProcTP
  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_BusinessPartnerAddressProcTP as _BusinessPartnerAddress on  $projection.MasterDataChangeProcess = _BusinessPartnerAddress.MasterDataChangeProcess
                                                                                         and $projection.MDChgProcessStep        = _BusinessPartnerAddress.MDChgProcessStep
                                                                                         and $projection.MDChgProcessSrceSystem  = _BusinessPartnerAddress.MDChgProcessSrceSystem
                                                                                         and $projection.MDChgProcessSrceObject  = _BusinessPartnerAddress.MDChgProcessSrceObject
                                                                                         and $projection.AddressNumber           = _BusinessPartnerAddress.AddressNumber
  association [0..1] to I_BusPartTelCountryPrefix             as _FaxCountryPrefix       on  $projection.FaxCountry = _FaxCountryPrefix.Country
  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,
      AddrCommunicationValidFromDate,
      IsDefaultFaxNumber,
      FaxCountry,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      AddressFaxNumber,
      FaxNumberExtension,
      InternationalFaxNumber,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      
      /* Record Identification */
      /* Has been moved to a virtual field in the projection layer, therefore the dummy entry */
      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,

      _BusinessPartner,
      _BusinessPartnerAddress,
      _BPFaxNumberTextProcTP,
      _BPProtectedAddress,
      _FaxCountryPrefix,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}