I_BPCustomerWhgdTaxProcessTP

DDL: I_BPCUSTOMERWHGDTAXPROCESSTP Type: view_entity TRANSACTIONAL

BP Customer Partner Witholding Tax Process Data - TP

I_BPCustomerWhgdTaxProcessTP is a Transactional CDS View that provides data about "BP Customer Partner Witholding Tax Process Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerWhgdTaxProcess) and exposes 30 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, CompanyCode. It has 7 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerWhgdTaxProcess I_BPCustomerWhgdTaxProcess from

Associations (7)

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
[0..1] I_CoCodeWithholdingTaxType _WithholdingTaxType $projection.CompanyCode = _WithholdingTaxType.CompanyCode and $projection.WithholdingTaxType = _WithholdingTaxType.WithholdingTaxType
[0..1] I_CoCodeWithholdingTaxCode _WithholdingTaxCode $projection.CompanyCode = _WithholdingTaxCode.CompanyCode and $projection.WithholdingTaxType = _WithholdingTaxCode.WithholdingTaxType and $projection.WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode
[0..1] I_CoCodeWhgdTaxExemptionReason _ExemptionReason $projection.CompanyCode = _ExemptionReason.CompanyCode and $projection.ExemptionReason = _ExemptionReason.ExemptionReason

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BP Customer Partner Witholding Tax Process Data - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY CompanyCode CompanyCode
KEY WithholdingTaxType WithholdingTaxType
KEY BPAssignmentID BPAssignmentID
Customer Customer
WithholdingTaxCode WithholdingTaxCode
WithholdingTaxAgent WithholdingTaxAgent
ObligationDateBegin ObligationDateBegin
ObligationDateEnd ObligationDateEnd
WithholdingTaxNumber WithholdingTaxNumber
WithholdingTaxCertificate2 WithholdingTaxCertificate2
WithholdingTaxExmptPercent WithholdingTaxExmptPercent
ExemptionDateBegin ExemptionDateBegin
ExemptionDateEnd ExemptionDateEnd
ExemptionReason ExemptionReason
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_CustomerCompanyCode _CustomerCompanyCode
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_WithholdingTaxType _WithholdingTaxType
_WithholdingTaxCode _WithholdingTaxCode
_ExemptionReason _ExemptionReason 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BP Customer Partner Witholding Tax Process Data - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
define view entity I_BPCustomerWhgdTaxProcessTP
  as select from I_BPCustomerWhgdTaxProcess
  association        to parent I_BPCustomerCompanyProcessTP as _CustomerCompanyCode on  $projection.MasterDataChangeProcess = _CustomerCompanyCode.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessStep        = _CustomerCompanyCode.MDChgProcessStep
                                                                                    and $projection.MDChgProcessSrceSystem  = _CustomerCompanyCode.MDChgProcessSrceSystem
                                                                                    and $projection.MDChgProcessSrceObject  = _CustomerCompanyCode.MDChgProcessSrceObject
                                                                                    and $projection.BPAssignmentID          = _CustomerCompanyCode.BPAssignmentID
                                                                                    and $projection.CompanyCode             = _CustomerCompanyCode.CompanyCode

  association        to I_BPCustomerProcessTP               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 [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 [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

  association [0..1] to I_CoCodeWithholdingTaxType          as _WithholdingTaxType  on  $projection.CompanyCode        = _WithholdingTaxType.CompanyCode
                                                                                    and $projection.WithholdingTaxType = _WithholdingTaxType.WithholdingTaxType
  association [0..1] to I_CoCodeWithholdingTaxCode          as _WithholdingTaxCode  on  $projection.CompanyCode        = _WithholdingTaxCode.CompanyCode
                                                                                    and $projection.WithholdingTaxType = _WithholdingTaxCode.WithholdingTaxType
                                                                                    and $projection.WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode
  association [0..1] to I_CoCodeWhgdTaxExemptionReason      as _ExemptionReason     on  $projection.CompanyCode     = _ExemptionReason.CompanyCode
                                                                                    and $projection.ExemptionReason = _ExemptionReason.ExemptionReason



{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key CompanyCode,
  key WithholdingTaxType,
  key BPAssignmentID,
      Customer,
      WithholdingTaxCode,
      WithholdingTaxAgent,
      ObligationDateBegin,
      ObligationDateEnd,
      WithholdingTaxNumber,
      WithholdingTaxCertificate2,
      WithholdingTaxExmptPercent,
      ExemptionDateBegin,
      ExemptionDateEnd,
      ExemptionReason,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      _CustomerCompanyCode,
      _Customer,
      _BusinessPartner,
      _RecordType,
      _RecordMessages,
      _KPIUpdateStatusText,
      _WithholdingTaxType,
      _WithholdingTaxCode,
      _ExemptionReason

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERWHGDTAXPROCESS"
],
"ASSOCIATED":
[
"I_BPCUSTOMERCOMPANYPROCESSTP",
"I_BPCUSTOMERPROCESSTP",
"I_BPPROCESSKPIRECORDTYPE",
"I_BUSINESSPARTNERPROCESSTP",
"I_COCODEWHGDTAXEXEMPTIONREASON",
"I_COCODEWITHHOLDINGTAXCODE",
"I_COCODEWITHHOLDINGTAXTYPE",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More