C_BusinessPartnerCustWhdgTax

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_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: CBUPACUSTWHT

CREATE VIEW C_BusinessPartnerCustWhdgTax AS
SELECT
  BusinessPartnerCustWhdgTax.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustWhdgTax.CompanyCode AS CompanyCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxType AS WithholdingTaxType,
  BusinessPartnerCustWhdgTax.Customer AS Customer,
  BusinessPartnerCustWhdgTax.WithholdingTaxTypeForEdit AS WithholdingTaxTypeForEdit,
  BusinessPartnerCustWhdgTax.CompanyCodeForEdit AS CompanyCodeForEdit,
  BusinessPartnerCustWhdgTax.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerCustWhdgTax.CountryCode AS CountryCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxCode AS WithholdingTaxCode,
  BusinessPartnerCustWhdgTax.WithholdingTaxAgent AS WithholdingTaxAgent,
  BusinessPartnerCustWhdgTax.ObligationDateBegin AS ObligationDateBegin,
  BusinessPartnerCustWhdgTax.ObligationDateEnd AS ObligationDateEnd,
  BusinessPartnerCustWhdgTax.WithholdingTaxNumber AS WithholdingTaxNumber,
  BusinessPartnerCustWhdgTax.WithholdingTaxCertificate2 AS WithholdingTaxCertificate2,
  BusinessPartnerCustWhdgTax.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  BusinessPartnerCustWhdgTax.ExemptionDateBegin AS ExemptionDateBegin,
  BusinessPartnerCustWhdgTax.ExemptionDateEnd AS ExemptionDateEnd,
  BusinessPartnerCustWhdgTax.RecipientType AS RecipientType,
  BusinessPartnerCustWhdgTax.ExemptionReason AS ExemptionReason,
  BusinessPartnerCustWhdgTax.ExtendedWhldgTaxIsActive AS ExtendedWhldgTaxIsActive,
  _BusinessPartnerCustomerCo.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartnerCustomerCo.Country AS Country
FROM I_BusinessPartnerCustWhdgTaxTP AS BusinessPartnerCustWhdgTax
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_BusinessPartnerCustCo AS _BusinessPartnerCustomerCo ON BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner AND CompanyCode = _BusinessPartnerCustomerCo.CompanyCode  -- association [1..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_WhldgTaxTypeTextVHTemp AS _WhldgTaxTypeText ON WithholdingTaxTypeForEdit = _WhldgTaxTypeText.WithholdingTaxType AND CountryCode = _WhldgTaxTypeText.CountryCode AND _WhldgTaxTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_Exemptionreasontextvhtemp AS _ExemptionReasonText ON ExemptionReason = _ExemptionReasonText.ExemptionReason AND CountryCode = _ExemptionReasonText.Country  -- association [0..*]
LEFT OUTER JOIN I_WithholdingTaxRcpntTypeText AS _RecipientTypeText ON RecipientType = _RecipientTypeText.RecipientType AND CountryCode = _RecipientTypeText.CountryCode AND WithholdingTaxType = _RecipientTypeText.WithholdingTaxType  -- association [1..*]
;