I_BPCustomerWhgdTaxProcessTP

DDL: I_BPCUSTOMERWHGDTAXPROCESSTP Type: view_entity TRANSACTIONAL
30 Fields 1 Data Sources 7 Associations

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.

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 Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY WithholdingTaxType WithholdingTaxType WTax Type
KEY BPAssignmentID BPAssignmentID Assignment ID
Customer Customer Sold-to Party
WithholdingTaxCode WithholdingTaxCode WTax Code
WithholdingTaxAgent WithholdingTaxAgent WTax Agent
ObligationDateBegin ObligationDateBegin W/Tax Obligated Frm
ObligationDateEnd ObligationDateEnd Oblig.to W/Tax Until
WithholdingTaxNumber WithholdingTaxNumber W/tax number
WithholdingTaxCertificate2 WithholdingTaxCertificate2 Exemption Number
WithholdingTaxExmptPercent WithholdingTaxExmptPercent Exemption Rate
ExemptionDateBegin ExemptionDateBegin Exempt From
ExemptionDateEnd ExemptionDateEnd Exempt To
ExemptionReason ExemptionReason Exempt. Reason
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime Last Changed On
_CustomerCompanyCode _CustomerCompanyCode
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_WithholdingTaxType _WithholdingTaxType
_WithholdingTaxCode _WithholdingTaxCode
_ExemptionReason _ExemptionReason

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPCustomerWhgdTaxProcessTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BPCustomerWhgdTaxProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  WithholdingTaxType,
  BPAssignmentID,
  Customer,
  WithholdingTaxCode,
  WithholdingTaxAgent,
  ObligationDateBegin,
  ObligationDateEnd,
  WithholdingTaxNumber,
  WithholdingTaxCertificate2,
  WithholdingTaxExmptPercent,
  ExemptionDateBegin,
  ExemptionDateEnd,
  ExemptionReason,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime
FROM I_BPCustomerWhgdTaxProcess
LEFT OUTER JOIN I_BusinessPartnerProcessTP AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_CoCodeWithholdingTaxType AS _WithholdingTaxType ON CompanyCode = _WithholdingTaxType.CompanyCode AND WithholdingTaxType = _WithholdingTaxType.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWithholdingTaxCode AS _WithholdingTaxCode ON CompanyCode = _WithholdingTaxCode.CompanyCode AND WithholdingTaxType = _WithholdingTaxCode.WithholdingTaxType AND WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWhgdTaxExemptionReason AS _ExemptionReason ON CompanyCode = _ExemptionReason.CompanyCode AND ExemptionReason = _ExemptionReason.ExemptionReason  -- association [0..1]
;

Learn More