I_BPCntctPersnFaxNumberProcTP

DDL: I_BPCNTCTPERSNFAXNUMBERPROCTP Type: view_entity TRANSACTIONAL

BP Wrkplace Addr Fax Number Proc Data - TP

I_BPCntctPersnFaxNumberProcTP is a Transactional CDS View that provides data about "BP Wrkplace Addr Fax Number Proc Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPContactPersonFaxNumberProc) and exposes 20 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 5 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BPContactPersonFaxNumberProc I_BPContactPersonFaxNumberProc from

Associations (5)

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_BusPartTelCountryPrefix _FaxCountryPrefix $projection.FaxCountry = _FaxCountryPrefix.Country
[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 BP Wrkplace Addr Fax Number Proc Data - 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
AddrCommunicationValidFromDate AddrCommunicationValidFromDate
IsDefaultFaxNumber IsDefaultFaxNumber
FaxCountry FaxCountry
AddressFaxNumber AddressFaxNumber
FaxNumberExtension FaxNumberExtension
InternationalFaxNumber InternationalFaxNumber
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_BPRelProcess _BPRelProcess
_WorkplaceAddress _WorkplaceAddress
_FaxCountryPrefix _FaxCountryPrefix
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BP Wrkplace Addr Fax Number Proc Data - TP'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity I_BPCntctPersnFaxNumberProcTP
  as select from I_BPContactPersonFaxNumberProc
  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_BusPartTelCountryPrefix             as _FaxCountryPrefix    on  $projection.FaxCountry = _FaxCountryPrefix.Country
  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,
      AddrCommunicationValidFromDate,
      IsDefaultFaxNumber,
      FaxCountry,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      AddressFaxNumber,
      FaxNumberExtension,
      InternationalFaxNumber,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      /* Record Identification */
      case
        when _WorkplaceAddress.BusinessPartnerFullName <> ''
          then
            case
              when _WorkplaceAddress.AddressNumber <> ''
                then
                concat_with_space(_WorkplaceAddress.BusinessPartnerFullName,
                  concat_with_space(
                    concat_with_space(
                      concat_with_space(
                        concat_with_space(_WorkplaceAddress.StreetName,_WorkplaceAddress.HouseNumber,1)
                      ,_WorkplaceAddress.PostalCode,1)
                    ,_WorkplaceAddress.CityName,1)
                  ,_WorkplaceAddress.Country,1),1)
              else _WorkplaceAddress.BusinessPartnerName
            end
        else ''
      end                                                            as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,

      _BPRelProcess,
      _WorkplaceAddress,
      _FaxCountryPrefix,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCONTACTPERSONADDRESSPROCTP",
"I_BPCONTACTPERSONFAXNUMBERPROC"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSPROCTP",
"I_BPRELSHPPROCESSKPIRECORDTYPE",
"I_BUSPARTRELATIONSHIPPROCESSTP",
"I_BUSPARTTELCOUNTRYPREFIX",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More