P_US_StRpFrgnVndrWhldgTax

DDL: P_US_STRPFRGNVNDRWHLDGTAX SQL: PBPWLDGTAXCHP Type: view COMPOSITE Package: GLO_FIN_IS_WHT_US
17 Fields 2 Data Sources 2 Associations

US 1042S chapter 3 & 4 WHT exemption

P_US_StRpFrgnVndrWhldgTax is a Composite CDS View that provides data about "US 1042S chapter 3 & 4 WHT exemption" in SAP S/4HANA. It reads from 2 data sources (I_Extendedwhldgtaxcode, I_Extendedwhldgtaxcode) and exposes 17 fields with key fields BusinessPartner, Supplier, CompanyCode, WithholdingTaxType, Supplier. It has 2 associations to related views. Part of development package GLO_FIN_IS_WHT_US.

Data Sources (2)

SourceAliasJoin Type
I_Extendedwhldgtaxcode _ExtendedTaxCode from
I_Extendedwhldgtaxcode _ExtendedTaxCodeCust union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Businesspartnerwhldgtax Businesspartnerwhldgtax Businesspartnerwhldgtax.CountryCode = _ExtendedTaxCode.Country and Businesspartnerwhldgtax.WithholdingTaxType = _ExtendedTaxCode.WithholdingTaxType and Businesspartnerwhldgtax.WithholdingTaxCode = _ExtendedTaxCode.WithholdingTaxCode
[1..1] I_BusinessPartnerCustWhdgTax Businesspartnercustwhldgtax Businesspartnercustwhldgtax.CountryCode = _ExtendedTaxCodeCust.Country and Businesspartnercustwhldgtax.WithholdingTaxType = _ExtendedTaxCodeCust.WithholdingTaxType and Businesspartnercustwhldgtax.WithholdingTaxCode = _ExtendedTaxCodeCust.WithholdingTaxCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PBPWLDGTAXCHP view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label US 1042S chapter 3 & 4 WHT exemption view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner Businesspartnerwhldgtax BusinessPartner Issuing Authority
KEY Supplier Businesspartnerwhldgtax Supplier Sold-to Party
KEY CompanyCode Businesspartnerwhldgtax CompanyCode Receiver Company Code
KEY WithholdingTaxType Businesspartnerwhldgtax WithholdingTaxType WTax Type
WithholdingTaxCode Businesspartnerwhldgtax WithholdingTaxCode WTax Code
IsWithholdingTaxSubject Businesspartnerwhldgtax IsWithholdingTaxSubject WTax Agent
RecipientType Businesspartnerwhldgtax RecipientType Recipient Type
ExemptionReason Businesspartnerwhldgtax ExemptionReason Exempt. Reason
BusinessPartnerasBusinessPartner
KEY Supplier Businesspartnercustwhldgtax Customer Sold-to Party
KEY CompanyCode Businesspartnercustwhldgtax CompanyCode Receiver Company Code
KEY WithholdingTaxType Businesspartnercustwhldgtax WithholdingTaxType WTax Type
WithholdingTaxCode Businesspartnercustwhldgtax WithholdingTaxCode WTax Code
IsWithholdingTaxSubject Businesspartnercustwhldgtax WithholdingTaxAgent WTax Agent
RecipientType Businesspartnercustwhldgtax RecipientType Recipient Type
ExemptionReason Businesspartnercustwhldgtax ExemptionReason Exempt. Reason
WithholdingTaxPercent I_Extendedwhldgtaxcode WithholdingTaxPercent WTax Rate

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 P_US_StRpFrgnVndrWhldgTax.
-- 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: PBPWLDGTAXCHP

CREATE VIEW P_US_StRpFrgnVndrWhldgTax AS
SELECT
  Businesspartnerwhldgtax.BusinessPartner AS BusinessPartner,
  Businesspartnerwhldgtax.Supplier AS Supplier,
  Businesspartnerwhldgtax.CompanyCode AS CompanyCode,
  Businesspartnerwhldgtax.WithholdingTaxType AS WithholdingTaxType,
  Businesspartnerwhldgtax.WithholdingTaxCode AS WithholdingTaxCode,
  Businesspartnerwhldgtax.IsWithholdingTaxSubject AS IsWithholdingTaxSubject,
  Businesspartnerwhldgtax.RecipientType AS RecipientType,
  Businesspartnerwhldgtax.ExemptionReason AS ExemptionReason,
  _ExtendedTaxCode.WithholdingTaxPercent AS BusinessPartnerasBusinessPartner,
  _ExtendedTaxCodeCust.WithholdingTaxPercent AS WithholdingTaxPercent
FROM I_Extendedwhldgtaxcode AS _ExtendedTaxCode
LEFT OUTER JOIN I_Businesspartnerwhldgtax AS Businesspartnerwhldgtax ON Businesspartnerwhldgtax.CountryCode = _ExtendedTaxCode.Country AND Businesspartnerwhldgtax.WithholdingTaxType = _ExtendedTaxCode.WithholdingTaxType AND Businesspartnerwhldgtax.WithholdingTaxCode = _ExtendedTaxCode.WithholdingTaxCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerCustWhdgTax AS Businesspartnercustwhldgtax ON Businesspartnercustwhldgtax.CountryCode = _ExtendedTaxCodeCust.Country AND Businesspartnercustwhldgtax.WithholdingTaxType = _ExtendedTaxCodeCust.WithholdingTaxType AND Businesspartnercustwhldgtax.WithholdingTaxCode = _ExtendedTaxCodeCust.WithholdingTaxCode  -- association [1..1]
-- UNION ALL with additional select branch(es): I_Extendedwhldgtaxcode
;

Learn More