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_DE_StRpWithholdingTaxItemC.
-- 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.
CREATE VIEW I_DE_StRpWithholdingTaxItemC AS
SELECT
doc.CompanyCode AS CompanyCode,
doc.AccountingDocument AS AccountingDocument,
doc.FiscalYear AS FiscalYear,
doc.AccountingDocumentItem AS AccountingDocumentItem,
doc.WithholdingTaxType AS WithholdingTaxType,
doc.StatryRptgEntity AS StatryRptgEntity,
doc.StatryRptCategory AS StatryRptCategory,
doc.StatryRptRunID AS StatryRptRunID,
doc.Creditor AS Creditor,
doc.Debtor AS Debtor,
doc.BusinessPartner AS BusinessPartner,
doc.BusinessPartnerNumber AS BusinessPartnerNumber,
_Supplier.AddressID AS AddressID,
doc.BusinessPlace AS BusinessPlace,
doc.FinancialAccountType AS FinancialAccountType,
doc.PostingDate AS PostingDate,
doc.DocumentDate AS DocumentDate,
doc.SupplierRecipientType AS SupplierRecipientType,
doc.Country AS Country,
doc1.WithholdingTaxType AS DerivedWithholdingTaxType,
doc.WithholdingTaxPercent AS WithholdingTaxPercent,
doc.ClearingDate AS ClearingDate,
doc.ReportingCurrency AS ReportingCurrency,
cast( doc.WhldgTaxBaseAmtInCoCodeCrcy as fis_qsshh) AS WhldgTaxBaseAmtInCoCodeCrcy,
cast( doc.WhldgTaxAmtInCoCodeCrcy as fis_qbshh) AS WhldgTaxAmtInCoCodeCrcy,
cast( doc1.WhldgTaxAmtInCoCodeCrcy as fis_qbshb) AS WithholdingTaxAmount,
case lfbw.ExemptionReason when 'DT' then replace(cast( cast(doc.WithholdingTaxPercent as abap.dec( 6, 2 )) as char10), ',' , '.' ) else '' end as TaxRateAsText AS elseendasTaxRateAsText,
doc.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
doc.WhldgTaxDocumentType AS WhldgTaxDocumentType,
doc.WhldgTaxBaseIsInherited AS WhldgTaxBaseIsInherited,
doc.DependencyNmbrOfWhldgTaxType AS DependencyNmbrOfWhldgTaxType,
doc.SqntlNmbrOfWhldgTaxType AS SqntlNmbrOfWhldgTaxType,
doc.Name AS SupplierName,
doc.BusinessPartnerCountry AS SupplierCountry,
doc.CityName AS CityName,
cast(doc.CityName as ad_city3) AS AdditionalCityName,
doc.IsNaturalPerson AS IsNaturalPerson,
doc.IsReversed AS IsReversed,
doc.IsReversal AS IsReversal,
case when doc._Onetime.AccountingDocument is null then doc._Supplier._StandardAddress.CityCode else '' end as BusinessPartnerCityCode AS CityCodeelseendasBusinessPartnerCityCode,
doc.StreetName AS StreetName,
case when doc._Onetime.AccountingDocument is null then cast (replace(doc.HouseNumber, ',','.') as ad_hsnm1 ) else '' end as HouseNumber AS asad_hsnm1elseendasHouseNumber,
case when doc._Onetime.AccountingDocument is null then replace(doc.HouseNumberSupplementText,',','.') else '' end as HouseNumberSupplementText AS elseendasHouseNumberSupplementText,
doc.Region AS Region,
case when doc._Onetime.AccountingDocument is null then doc.EmailAddress else '' end as EmailAddress AS EmailAddresselseendasEmailAddress,
doc.POBox AS POBox,
case when doc._Onetime.AccountingDocument is null then doc._Supplier._StandardAddress.PhoneNumber else '' end as PhoneNumber AS PhoneNumberelseendasPhoneNumber,
case lfbw.ExemptionReason when 'DT' then case doc.OfficialWhldgTaxCode when '5008' then replace( cast(par_5008.ReportingCatLatestParamValue as char10 ), ',' , '.' ) when '5009' then replace( cast(par_5009.ReportingCatLatestParamValue as char10 ), ',' , '.' ) when '5010' then replace( cast(par_5010.ReportingCatLatestParamValue as char10 ), ',' , '.' ) when '5011' then replace( cast(par_5011.ReportingCatLatestParamValue as char10 ), ',' , '.' ) end else cast( cast(doc.WithholdingTaxPercent as abap.dec( 6, 2 )) as char10) end as TaxRateInPercentAsText AS dec62aschar10endasTaxRateInPercentAsText,
lfbw.ExemptionDateEnd AS ExemptionDateEnd,
doc.WithholdingTaxPercent AS TaxRate,
lfbw.ExemptionReason AS ExemptionReason,
case when doc.BusinessPartnerCountry = 'DE' then doc.PostalCode else '' end as PostalCode AS PostalCodeelseendasPostalCode,
case when doc.BusinessPartnerCountry <> 'DE' then doc.PostalCode else '' end as SupplierPostalCode AS PostalCodeelseendasSupplierPostalCode,
case when doc.BusinessPartnerCountry = 'DE' then doc.POBoxPostalCode else '' end as POBoxPostalCode AS POBoxPostalCodeelseendasPOBoxPostalCode,
cast( doc.POBoxPostalCode as abap.char(12) ) AS AddressCityPostBoxCode,
cast('E' as spras) AS Language,
case when doc.SupplierRecipientType = 'N' then bp.FirstName else case when lfbw.RecipientType = 'N' then bp.FirstName else '' end end as DE_GivenName AS FirstNameelseendendasDE_GivenName,
case when doc.SupplierRecipientType = 'N' then bp.LastName else case when lfbw.RecipientType = 'N' then bp.LastName else '' end end as DE_FamilyName AS LastNameelseendendasDE_FamilyName,
doc.PostalCode AS RecipientPostalCode,
lfbw.ExemptionDateBegin AS ExemptionDateBegin,
doc._WithholdingTaxCode.WithholdingTaxPostingRule AS WithholdingTaxPostingRule
FROM I_StRpWhldgTaxItem AS doc
LEFT OUTER JOIN I_OfficialWhldgTaxKeyDesc AS offwtax ON doc.Country = offwtax.Country AND doc.Language = offwtax.Language AND doc.OfficialWhldgTaxCode = offwtax.OfficialWhldgTaxCode -- association [1..1]
LEFT OUTER JOIN I_OfficialWhldgTaxKeyDesc AS offwtaxEN ON doc.Country = offwtaxEN.Country AND offwtaxEN.Language = 'E' AND doc.OfficialWhldgTaxCode = offwtaxEN.OfficialWhldgTaxCode -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS bp ON doc.BusinessPartnerNumber = bp.BusinessPartner -- association [1..1]
LEFT OUTER JOIN I_StRpWhldgTaxItem AS doc1 ON ( doc1.CompanyCode = doc.CompanyCode AND doc1.AccountingDocument = doc.AccountingDocument AND doc1.AccountingDocumentItem = doc.AccountingDocumentItem AND doc1.FiscalYear = doc.FiscalYear AND doc1.DependencyNmbrOfWhldgTaxType = doc.SqntlNmbrOfWhldgTaxType AND doc.DependencyNmbrOfWhldgTaxType = '000' AND doc1.StatryRptgEntity = doc.StatryRptgEntity AND doc1.StatryRptCategory = doc.StatryRptCategory AND doc1.StatryRptRunID = doc.StatryRptRunID ) -- association [1..*]
LEFT OUTER JOIN I_Businesspartnerwhldgtax AS lfbw ON lfbw.BusinessPartner = doc.BusinessPartnerNumber AND lfbw.Supplier = doc.Supplier AND lfbw.CompanyCode = doc.CompanyCode AND lfbw.WithholdingTaxType = doc.WithholdingTaxType -- association [1..1]
LEFT OUTER JOIN P_StRpCategoryParameter AS par_5008 ON par_5008.ReportingCategory = doc.StatryRptCategory AND par_5008.ReportingEntity = doc.StatryRptgEntity AND par_5008.ReportingCategoryParamName = 'DE_WHT_50A_5008_STD_RATE' -- association [1..1]
LEFT OUTER JOIN P_StRpCategoryParameter AS par_5009 ON par_5009.ReportingCategory = doc.StatryRptCategory AND par_5009.ReportingEntity = doc.StatryRptgEntity AND par_5009.ReportingCategoryParamName = 'DE_WHT_50A_5009_STD_RATE' -- association [1..1]
LEFT OUTER JOIN P_StRpCategoryParameter AS par_5010 ON par_5010.ReportingCategory = doc.StatryRptCategory AND par_5010.ReportingEntity = doc.StatryRptgEntity AND par_5010.ReportingCategoryParamName = 'DE_WHT_50A_5010_STD_RATE' -- association [1..1]
LEFT OUTER JOIN P_StRpCategoryParameter AS par_5011 ON par_5011.ReportingCategory = doc.StatryRptCategory AND par_5011.ReportingEntity = doc.StatryRptgEntity AND par_5011.ReportingCategoryParamName = 'DE_WHT_50A_5011_STD_RATE' -- association [1..1]
;