I_BPAddressTextProcessTP

DDL: I_BPADDRESSTEXTPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

BP Address Text (Process Data)

I_BPAddressTextProcessTP is a Transactional CDS View that provides data about "BP Address Text (Process Data)" in SAP S/4HANA. It reads from 1 data source (I_BPAddressTextProcess) and exposes 20 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) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BPAddressTextProcess I_BPAddressTextProcess 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 (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label BP Address Text (Process Data) view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY AddressRepresentationCode AddressRepresentationCode
KEY Language Language
AddressValidFromDate AddressValidFromDate
AddressRemarkNote AddressRemarkNote
DataAgingObject DataAgingObject
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressLine1Text
_BusinessPartner _BusinessPartner
_BusinessPartnerAddress _BusinessPartnerAddress
_BPProtectedAddress _BPProtectedAddress
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'BP Address Text (Process Data)'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPAddressTextProcessTP
  as select from I_BPAddressTextProcess

  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_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 AddressRepresentationCode,
  key Language,

      AddressValidFromDate,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      AddressRemarkNote,
      DataAgingObject,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,

      /* 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,

      /* Associations */
      _BusinessPartner,
      _BusinessPartnerAddress,
      _BPProtectedAddress,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages

}

Learn More