I_BPAddlCustWhldgTaxTP

DDL: I_BPADDLCUSTWHLDGTAXTP SQL: IBPADDCWTTP Type: view TRANSACTIONAL Package: VDM_MD_BP
21 Fields 2 Data Sources 4 Associations

BO view for Withholding Tax of Customers

I_BPAddlCustWhldgTaxTP is a Transactional CDS View that provides data about "BO view for Withholding Tax of Customers" in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, I_CustomerWithTax) and exposes 21 fields with key fields BusinessPartner, Customer, CompanyCode, WithholdingTaxType. It has 4 associations to related views. Part of development package VDM_MD_BP.

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment BPMultipleAssignment inner
I_CustomerWithTax BusinessPartnerCustWhdgTax from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAdditionalCustomerTP _BPAdditionalCustomer $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner and $projection.Customer = _BPAdditionalCustomer.Customer
[1..1] I_BPAddlCustCompanyCodeTP _BusinessPartnerCustomerCo $projection.BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner and $projection.Customer = _BusinessPartnerCustomerCo.Customer and $projection.CompanyCode = _BusinessPartnerCustomerCo.CompanyCode
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDCWTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for Withholding Tax of Customers view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.writeDraftPersistence BPADDCWT_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner Issuing Authority
KEY Customer I_CustomerWithTax Customer Sold-to Party
KEY CompanyCode I_CustomerWithTax CompanyCode Receiver Company Code
KEY WithholdingTaxType I_CustomerWithTax WithholdingTaxType WTax Type
WithholdingTaxTypeForEdit I_CustomerWithTax WithholdingTaxType WTax Type
CompanyCodeForEdit I_CustomerWithTax CompanyCode Receiver Company Code
CustomerForEdit I_CustomerWithTax Customer Sold-to Party
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner Issuing Authority
CountryCode _CompanyCode Country Venue: Ctry/Reg
WithholdingTaxCode I_CustomerWithTax WithholdingTaxCode WTax Code
WithholdingTaxAgent I_CustomerWithTax WithholdingTaxAgent WTax Agent
ObligationDateBegin I_CustomerWithTax ObligationDateBegin W/Tax Obligated Frm
ObligationDateEnd I_CustomerWithTax ObligationDateEnd Oblig.to W/Tax Until
WithholdingTaxNumber I_CustomerWithTax WithholdingTaxNumber W/tax number
WithholdingTaxCertificate I_CustomerWithTax WithholdingTaxCertificate WHT Certificate
WithholdingTaxExmptPercent I_CustomerWithTax WithholdingTaxExmptPercent Exemption Rate
ExemptionDateBegin I_CustomerWithTax ExemptionDateBegin Exempt From
ExemptionDateEnd I_CustomerWithTax ExemptionDateEnd Exempt To
ExemptionReason I_CustomerWithTax ExemptionReason Exempt. Reason
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomerCo _BusinessPartnerCustomerCo

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_BPAddlCustWhldgTaxTP.
-- 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.
-- SQL view name: IBPADDCWTTP

CREATE VIEW I_BPAddlCustWhldgTaxTP AS
SELECT
  BPMultipleAssignment.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustWhdgTax.Customer AS Customer,
  BusinessPartnerCustWhdgTax.CompanyCode AS CompanyCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxType AS WithholdingTaxType,
  BusinessPartnerCustWhdgTax.WithholdingTaxType AS WithholdingTaxTypeForEdit,
  BusinessPartnerCustWhdgTax.CompanyCode AS CompanyCodeForEdit,
  BusinessPartnerCustWhdgTax.Customer AS CustomerForEdit,
  BPMultipleAssignment.BusinessPartner AS BusinessPartnerForEdit,
  _CompanyCode.Country AS CountryCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxCode AS WithholdingTaxCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxAgent AS WithholdingTaxAgent,
  BusinessPartnerCustWhdgTax.ObligationDateBegin AS ObligationDateBegin,
  BusinessPartnerCustWhdgTax.ObligationDateEnd AS ObligationDateEnd,
  BusinessPartnerCustWhdgTax.WithholdingTaxNumber AS WithholdingTaxNumber,
  BusinessPartnerCustWhdgTax.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  BusinessPartnerCustWhdgTax.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  BusinessPartnerCustWhdgTax.ExemptionDateBegin AS ExemptionDateBegin,
  BusinessPartnerCustWhdgTax.ExemptionDateEnd AS ExemptionDateEnd,
  BusinessPartnerCustWhdgTax.ExemptionReason AS ExemptionReason
FROM I_CustomerWithTax AS BusinessPartnerCustWhdgTax
INNER JOIN I_BPMultipleAssignment AS BPMultipleAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPAdditionalCustomerTP AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner AND Customer = _BPAdditionalCustomer.Customer  -- association [1..1]
LEFT OUTER JOIN I_BPAddlCustCompanyCodeTP AS _BusinessPartnerCustomerCo ON BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner AND Customer = _BusinessPartnerCustomerCo.Customer AND CompanyCode = _BusinessPartnerCustomerCo.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More