I_BPTaxNumberProcessTP

DDL: I_BPTAXNUMBERPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

View for tax numbers from BP (Process)

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

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_BPTaxNumberProcess I_BPTaxNumberProcess from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusPartTaxType _BusinessPartnerTaxType $projection.BPTaxType = _BusinessPartnerTaxType.BPTaxType
[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 (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label View for tax numbers from BP (Process) 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

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BPTaxType BPTaxType
BusinessPartner BusinessPartner
BPTaxNumber BPTaxNumber
BPTaxLongNumber BPTaxLongNumber
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
AddressLine1Text
_BusinessPartner _BusinessPartner
_BusinessPartnerTaxType _BusinessPartnerTaxType
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'View for tax numbers from BP (Process)'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPTaxNumberProcessTP
  as select from I_BPTaxNumberProcess

  association        to parent 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 [0..1] to I_BusinessPartner                 as _BusinessPartnerVH on  $projection.BusinessPartner = _BusinessPartnerVH.BusinessPartner

  association [0..1] to I_BusPartTaxType                  as _BusinessPartnerTaxType on  $projection.BPTaxType = _BusinessPartnerTaxType.BPTaxType
  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 BPTaxType,

      BusinessPartner,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      case when BPTaxNumber is not initial
        then cast( BPTaxNumber as bptaxnumxl )
        else BPTaxLongNumber
      end                                                            as BPTaxNumberForEditValue,
      BPTaxNumber,
      BPTaxLongNumber,
      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,
      _BusinessPartnerTaxType,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More