I_BusinessPartnerCustWhdgTax

DDL: I_BUSINESSPARTNERCUSTWHDGTAX SQL: IBUPACUSTWHT Type: view BASIC
20 Fields 1 Data Sources 3 Associations

Customer Withholding tax core view

I_BusinessPartnerCustWhdgTax is a Basic CDS View that provides data about "Customer Withholding tax core view" in SAP S/4HANA. It reads from 1 data source (knbw) and exposes 20 fields with key fields BusinessPartner, Customer, CompanyCode, WithholdingTaxType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
knbw BusinessPartnerCustWhdgTax from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Customer_to_BusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer
[1..1] I_CustomerCompany _CustomerCo $projection.CompanyCode = _CustomerCo.CompanyCode and $projection.Customer = _CustomerCo.Customer

Annotations (10)

NameValueLevelField
EndUserText.label Customer Withholding tax core view view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName IBUPACUSTWHT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY Customer knbw kunnr Stock customer
KEY CompanyCode knbw bukrs Value
KEY WithholdingTaxType knbw witht WTax Type
CountryCode _CompanyCode Country Venue: Ctry/Reg
WithholdingTaxCode knbw wt_withcd W/Tax Code
WithholdingTaxAgent knbw wt_agent WTax Agent
ObligationDateBegin knbw wt_agtdf W/Tax Obligated Frm
ObligationDateEnd knbw wt_agtdt Oblig.to W/Tax Until
WithholdingTaxNumber knbw wt_wtstcd W/tax number
WithholdingTaxCertificate knbw wt_exnr Exemption Number
WithholdingTaxCertificate2 knbw wt_exnr Exemption Number
WithholdingTaxExmptPercent knbw wt_exrt Exemption Rate
ExemptionDateBegin knbw wt_exdf Exempt From
ExemptionDateEnd knbw wt_exdt Exempt To
ExemptionReason knbw wt_wtexrs Exempt. Reason
RecipientType knbw qsrec Recipient Type
_CompanyCode _CompanyCode
_CustomerToBusinessPartner _CustomerToBusinessPartner
_CustomerCo _CustomerCo

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_BusinessPartnerCustWhdgTax.
-- 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: IBUPACUSTWHT

CREATE VIEW I_BusinessPartnerCustWhdgTax AS
SELECT
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustWhdgTax.kunnr AS Customer,
  BusinessPartnerCustWhdgTax.bukrs AS CompanyCode,
  BusinessPartnerCustWhdgTax.witht AS WithholdingTaxType,
  _CompanyCode.Country AS CountryCode,
  BusinessPartnerCustWhdgTax.wt_withcd AS WithholdingTaxCode,
  BusinessPartnerCustWhdgTax.wt_agent AS WithholdingTaxAgent,
  BusinessPartnerCustWhdgTax.wt_agtdf AS ObligationDateBegin,
  BusinessPartnerCustWhdgTax.wt_agtdt AS ObligationDateEnd,
  BusinessPartnerCustWhdgTax.wt_wtstcd AS WithholdingTaxNumber,
  BusinessPartnerCustWhdgTax.wt_exnr AS WithholdingTaxCertificate,
  BusinessPartnerCustWhdgTax.wt_exnr AS WithholdingTaxCertificate2,
  BusinessPartnerCustWhdgTax.wt_exrt AS WithholdingTaxExmptPercent,
  BusinessPartnerCustWhdgTax.wt_exdf AS ExemptionDateBegin,
  BusinessPartnerCustWhdgTax.wt_exdt AS ExemptionDateEnd,
  BusinessPartnerCustWhdgTax.wt_wtexrs AS ExemptionReason,
  BusinessPartnerCustWhdgTax.qsrec AS RecipientType
FROM knbw AS BusinessPartnerCustWhdgTax
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [1..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCo ON CompanyCode = _CustomerCo.CompanyCode AND Customer = _CustomerCo.Customer  -- association [1..1]
;

Learn More