I_BPCUSTADDRDEPDNTTAXINDPROC

CDS View

Customer Address Dependant Tax Indicator

I_BPCUSTADDRDEPDNTTAXINDPROC is a CDS View in S/4HANA. Customer Address Dependant Tax Indicator. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCustAddrDepdntTaxIndProcTP view_entity from TRANSACTIONAL Address Dependant Tax Indicator - TP
I_BPCustAddrDepdntTaxProcChgs view_entity from TRANSACTIONAL Address Dependant Tax Indicator Changes
I_BPCustAddrDepdntTaxProcChgs view_entity union_all TRANSACTIONAL Address Dependant Tax Indicator Changes

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY BPAssignmentID BPAssignmentID 1
KEY CustomerTaxCategory CustomerTaxCategory 1
KEY DepartureCountry DepartureCountry 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Customer Address Dependant Tax Indicator'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustAddrDepdntTaxIndProc
  as select from knvi_addr_prc
  association [0..1] to I_BPCustomerProcess           as _Customer           on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
                                                                             and $projection.BPAssignmentID          = _Customer.BPAssignmentID
  association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress on  $projection.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
                                                                             and $projection.AddressNumber           = _BPProtectedAddress.AddressNumber

{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key source_addrnumber        as AddressNumber,
  key aland                    as DepartureCountry,
  key tatyp                    as CustomerTaxCategory,
  key '000000000002'           as BPAssignmentID, //asigment_id

      kunnr                    as Customer,
      //      adrnr                    as Adrnr,

      taxkd                    as CustomerTaxClassification,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      _Customer,
      _BPProtectedAddress

}