I_BPTAXNUMBERPROCESS

CDS View

Shows Tax number data for BP (Process)

I_BPTAXNUMBERPROCESS is a CDS View in S/4HANA. Shows Tax number data for BP (Process). It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPTaxNumberProcessChanges view from TRANSACTIONAL BP Tax Process Changes
I_BPTaxNumberProcessChanges view union_all TRANSACTIONAL BP Tax Process Changes
I_BPTaxNumberProcessTP view_entity from TRANSACTIONAL View for tax numbers from BP (Process)
I_BusPartTaxNumberGov view from COMPOSITE BP Tax Number Governance

Fields (6)

KeyField CDS FieldsUsed in Views
KEY BPTaxType BPTaxType 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Shows Tax number data for BP (Process)'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPTaxNumberProcess
  as select from dfkkbptaxnum_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  dfkkbptaxnum_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and dfkkbptaxnum_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and dfkkbptaxnum_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and dfkkbptaxnum_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
{

  key   process_id               as MasterDataChangeProcess,
  key   process_step_no          as MDChgProcessStep,
  key   source_system            as MDChgProcessSrceSystem,
  key   source_id                as MDChgProcessSrceObject,
  key   taxtype                  as BPTaxType,

        partner                  as BusinessPartner,
        taxnum                   as BPTaxNumber,
        taxnumxl                 as BPTaxLongNumber,
        source_modified          as MDChgProcessSourceModified,
        source_modification_blip as MDChgProcessSourceModifBinary,
        source_recency           as MDChgProcSrceLastChgdDateTime,
        //        _BusinessPartner.AuthorizationGroup,

        _BusinessPartner

}