C_BPAddlCustWhldgTax

DDL: C_BPADDLCUSTWHLDGTAX SQL: CBPADDCWT Type: view CONSUMPTION
23 Fields 1 Data Sources 6 Associations

C view for Cust Withholding Tax

C_BPAddlCustWhldgTax is a Consumption CDS View that provides data about "C view for Cust Withholding Tax" in SAP S/4HANA. It reads from 1 data source (I_BPAddlCustWhldgTaxTP) and exposes 23 fields with key fields CompanyCode, BusinessPartner, WithholdingTaxType, Customer. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPAddlCustWhldgTaxTP CustomerWhldgTax from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BPAddlCustCompanyCode _BPAddlCustCompanyCode $projection.BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner and $projection.CompanyCode = _BPAddlCustCompanyCode.CompanyCode and $projection.Customer = _BPAddlCustCompanyCode.Customer
[0..1] C_WhldgTaxTypeTextVHTemp _WhldgTaxTypeText $projection.WithholdingTaxTypeForEdit = _WhldgTaxTypeText.WithholdingTaxType and $projection.CountryCode = _WhldgTaxTypeText.CountryCode and _WhldgTaxTypeText.Language = $session.system_language
[1..*] C_WhldgTaxCodeTextVHTemp _WhldgTaxCodeText $projection.WithholdingTaxCode = _WhldgTaxCodeText.WithholdingTaxCode and $projection.WithholdingTaxType = _WhldgTaxCodeText.WithholdingTaxType and $projection.CountryCode = _WhldgTaxCodeText.CountryCode
[0..*] C_Exemptionreasontextvhtemp _ExemptionReasonText $projection.ExemptionReason = _ExemptionReasonText.ExemptionReason and $projection.CountryCode = _ExemptionReasonText.Country

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDCWT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label C view for Cust Withholding Tax view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Withholding Tax view
UI.headerInfo.typeNamePlural Withholding Taxes view
UI.headerInfo.title.label Withholding Tax Type Description view
UI.headerInfo.title.value WithholdingTaxTypeName view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_BPAddlCustWhldgTaxTP CompanyCode Receiver Company Code
KEY BusinessPartner I_BPAddlCustWhldgTaxTP BusinessPartner Issuing Authority
KEY WithholdingTaxType I_BPAddlCustWhldgTaxTP WithholdingTaxType WTax Type
KEY Customer I_BPAddlCustWhldgTaxTP Customer Sold-to Party
CountryCode I_BPAddlCustWhldgTaxTP CountryCode Country/Reg.
CompanyCodeForEdit I_BPAddlCustWhldgTaxTP CompanyCodeForEdit Company Code
WithholdingTaxTypeForEdit I_BPAddlCustWhldgTaxTP WithholdingTaxTypeForEdit WTax Type
WithholdingTaxTypeName _WhldgTaxTypeText WithholdingTaxTypeName
WithholdingTaxCode I_BPAddlCustWhldgTaxTP WithholdingTaxCode WTax Code
BusinessPartnerForEdit I_BPAddlCustWhldgTaxTP BusinessPartnerForEdit Busn. Partner
CustomerForEdit I_BPAddlCustWhldgTaxTP CustomerForEdit Customer
WithholdingTaxNumber I_BPAddlCustWhldgTaxTP WithholdingTaxNumber W/tax number
ExemptionDateBegin I_BPAddlCustWhldgTaxTP ExemptionDateBegin Exempt From
ExemptionDateEnd I_BPAddlCustWhldgTaxTP ExemptionDateEnd Exempt To
WithholdingTaxExmptPercent I_BPAddlCustWhldgTaxTP WithholdingTaxExmptPercent Exemption Rate
WithholdingTaxCertificate I_BPAddlCustWhldgTaxTP WithholdingTaxCertificate WHT Certificate
ExemptionReason I_BPAddlCustWhldgTaxTP ExemptionReason Exempt. Reason
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BPAddlCustCompanyCode _BPAddlCustCompanyCode
_WhldgTaxTypeText _WhldgTaxTypeText
_WhldgTaxCodeText _WhldgTaxCodeText
_ExemptionReasonText _ExemptionReasonText

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 C_BPAddlCustWhldgTax.
-- 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: CBPADDCWT

CREATE VIEW C_BPAddlCustWhldgTax AS
SELECT
  CustomerWhldgTax.CompanyCode AS CompanyCode,
  CustomerWhldgTax.BusinessPartner AS BusinessPartner,
  CustomerWhldgTax.WithholdingTaxType AS WithholdingTaxType,
  CustomerWhldgTax.Customer AS Customer,
  CustomerWhldgTax.CountryCode AS CountryCode,
  CustomerWhldgTax.CompanyCodeForEdit AS CompanyCodeForEdit,
  CustomerWhldgTax.WithholdingTaxTypeForEdit AS WithholdingTaxTypeForEdit,
  _WhldgTaxTypeText.WithholdingTaxTypeName AS WithholdingTaxTypeName,
  CustomerWhldgTax.WithholdingTaxCode AS WithholdingTaxCode,
  CustomerWhldgTax.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  CustomerWhldgTax.CustomerForEdit AS CustomerForEdit,
  CustomerWhldgTax.WithholdingTaxNumber AS WithholdingTaxNumber,
  CustomerWhldgTax.ExemptionDateBegin AS ExemptionDateBegin,
  CustomerWhldgTax.ExemptionDateEnd AS ExemptionDateEnd,
  CustomerWhldgTax.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  CustomerWhldgTax.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  CustomerWhldgTax.ExemptionReason AS ExemptionReason
FROM I_BPAddlCustWhldgTaxTP AS CustomerWhldgTax
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAddlCustCompanyCode AS _BPAddlCustCompanyCode ON BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner AND CompanyCode = _BPAddlCustCompanyCode.CompanyCode AND Customer = _BPAddlCustCompanyCode.Customer  -- association [1..1]
LEFT OUTER JOIN C_WhldgTaxTypeTextVHTemp AS _WhldgTaxTypeText ON WithholdingTaxTypeForEdit = _WhldgTaxTypeText.WithholdingTaxType AND CountryCode = _WhldgTaxTypeText.CountryCode AND _WhldgTaxTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_WhldgTaxCodeTextVHTemp AS _WhldgTaxCodeText ON WithholdingTaxCode = _WhldgTaxCodeText.WithholdingTaxCode AND WithholdingTaxType = _WhldgTaxCodeText.WithholdingTaxType AND CountryCode = _WhldgTaxCodeText.CountryCode  -- association [1..*]
LEFT OUTER JOIN C_Exemptionreasontextvhtemp AS _ExemptionReasonText ON ExemptionReason = _ExemptionReasonText.ExemptionReason AND CountryCode = _ExemptionReasonText.Country  -- association [0..*]
;

Learn More