I_BusinessPartnerWhldgTaxTP

DDL: I_BUSINESSPARTNERWHLDGTAXTP SQL: IBUPAPWHLDGTAXTP Type: view TRANSACTIONAL
21 Fields 1 Data Sources 2 Associations

Company Code WithHolding Tax BOPF View

I_BusinessPartnerWhldgTaxTP is a Transactional CDS View that provides data about "Company Code WithHolding Tax BOPF View" in SAP S/4HANA. It reads from 1 data source (I_Businesspartnerwhldgtax) and exposes 21 fields with key fields WithholdingTaxType, CompanyCode, BusinessPartner. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Businesspartnerwhldgtax BusinessPartnerWhldgTax from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BusinessPartnerSuplrCoTP _BusinessPartnerSupplierCo $projection.BusinessPartner = _BusinessPartnerSupplierCo.BusinessPartner and $projection.CompanyCode = _BusinessPartnerSupplierCo.CompanyCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBUPAPWHLDGTAXTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Company Code WithHolding Tax BOPF View view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence WTHLD_TAX_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WithholdingTaxType I_Businesspartnerwhldgtax WithholdingTaxType WTax Type
KEY CompanyCode I_Businesspartnerwhldgtax CompanyCode Receiver Company Code
KEY BusinessPartner I_Businesspartnerwhldgtax BusinessPartner Issuing Authority
CountryCode I_Businesspartnerwhldgtax CountryCode Country/Reg.
Supplier I_Businesspartnerwhldgtax Supplier Supplier
WithholdingTaxTypeForEdit I_Businesspartnerwhldgtax WithholdingTaxType WTax Type
CompanyCodeForEdit I_Businesspartnerwhldgtax CompanyCode Receiver Company Code
BusinessPartnerForEdit I_Businesspartnerwhldgtax BusinessPartner Issuing Authority
BusinessPartnerUUID I_Businesspartnerwhldgtax BusinessPartnerUUID UUID
WithholdingTaxCode I_Businesspartnerwhldgtax WithholdingTaxCode WTax Code
IsWithholdingTaxSubject I_Businesspartnerwhldgtax IsWithholdingTaxSubject Subject to w/tx
RecipientType I_Businesspartnerwhldgtax RecipientType Recipient Type
WithholdingTaxNumber I_Businesspartnerwhldgtax WithholdingTaxNumber W/tax number
ExemptionDateBegin I_Businesspartnerwhldgtax ExemptionDateBegin Exempt From
ExemptionDateEnd I_Businesspartnerwhldgtax ExemptionDateEnd Exempt To
WithholdingTaxExmptPercent I_Businesspartnerwhldgtax WithholdingTaxExmptPercent Exemption Rate
WithholdingTaxCertificate I_Businesspartnerwhldgtax WithholdingTaxCertificate WHT Certificate
ExemptionReason I_Businesspartnerwhldgtax ExemptionReason Exempt. Reason
ExtendedWhldgTaxIsActive
_BusinessPartner _BusinessPartner
_BusinessPartnerSupplierCo _BusinessPartnerSupplierCo

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_BusinessPartnerWhldgTaxTP.
-- 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: IBUPAPWHLDGTAXTP

CREATE VIEW I_BusinessPartnerWhldgTaxTP AS
SELECT
  BusinessPartnerWhldgTax.WithholdingTaxType AS WithholdingTaxType,
  BusinessPartnerWhldgTax.CompanyCode AS CompanyCode,
  BusinessPartnerWhldgTax.BusinessPartner AS BusinessPartner,
  BusinessPartnerWhldgTax.CountryCode AS CountryCode,
  BusinessPartnerWhldgTax.Supplier AS Supplier,
  BusinessPartnerWhldgTax.WithholdingTaxType AS WithholdingTaxTypeForEdit,
  BusinessPartnerWhldgTax.CompanyCode AS CompanyCodeForEdit,
  BusinessPartnerWhldgTax.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerWhldgTax.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerWhldgTax.WithholdingTaxCode AS WithholdingTaxCode,
  BusinessPartnerWhldgTax.IsWithholdingTaxSubject AS IsWithholdingTaxSubject,
  BusinessPartnerWhldgTax.RecipientType AS RecipientType,
  BusinessPartnerWhldgTax.WithholdingTaxNumber AS WithholdingTaxNumber,
  BusinessPartnerWhldgTax.ExemptionDateBegin AS ExemptionDateBegin,
  BusinessPartnerWhldgTax.ExemptionDateEnd AS ExemptionDateEnd,
  BusinessPartnerWhldgTax.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  BusinessPartnerWhldgTax.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  BusinessPartnerWhldgTax.ExemptionReason AS ExemptionReason,
  BusinessPartnerWhldgTax._CompanyCode.ExtendedWhldgTaxIsActive AS ExtendedWhldgTaxIsActive
FROM I_Businesspartnerwhldgtax AS BusinessPartnerWhldgTax
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerSuplrCoTP AS _BusinessPartnerSupplierCo ON BusinessPartner = _BusinessPartnerSupplierCo.BusinessPartner AND CompanyCode = _BusinessPartnerSupplierCo.CompanyCode  -- association [1..1]
;

Learn More