I_BPCUSTOMERWHGDTAXPROCESS

CDS View

BP Customer Partner Witholding Tax Process Data

I_BPCUSTOMERWHGDTAXPROCESS is a CDS View in S/4HANA. BP Customer Partner Witholding Tax Process Data. It contains 7 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 7 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPCustomerWhgdTaxProcChanges view_entity from TRANSACTIONAL BP Cust Withholding Tax Proc Changes
I_BPCustomerWhgdTaxProcChanges view_entity union_all TRANSACTIONAL BP Cust Withholding Tax Proc Changes
I_BPCustomerWhgdTaxProcessTP view_entity from TRANSACTIONAL BP Customer Partner Witholding Tax Process Data - TP
I_BPCustomerWhldgTaxGov view_entity from COMPOSITE BP Customer Withholding Tax Data Gov

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY WithholdingTaxType WithholdingTaxType 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BP Customer Partner Witholding Tax Process Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_BPCustomerWhgdTaxProcess
  as select from knbw_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
{

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

  key bukrs                    as CompanyCode,
  key witht                    as WithholdingTaxType,
  key assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      wt_withcd                as WithholdingTaxCode,
      wt_agent                 as WithholdingTaxAgent,
      wt_agtdf                 as ObligationDateBegin,
      wt_agtdt                 as ObligationDateEnd,
      wt_wtstcd                as WithholdingTaxNumber,
      wt_exnr                  as WithholdingTaxCertificate2,
      wt_exrt                  as WithholdingTaxExmptPercent,
      wt_exdf                  as ExemptionDateBegin,
      wt_exdt                  as ExemptionDateEnd,
      wt_wtexrs                as ExemptionReason,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      
      _Customer
}
where
     assignment_id = '000000000002'
  or assignment_id is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNBW_PRC"
],
"ASSOCIATED":
[
"I_BPCUSTOMERPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More