P_CO_DIANStRpWhldgTaxItem

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 P_CO_DIANStRpWhldgTaxItem.
-- 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: PSRCOWHLDGTXITMC

CREATE VIEW P_CO_DIANStRpWhldgTaxItem AS
SELECT
  WhldgTaxItem.CompanyCode AS CompanyCode,
  WhldgTaxItem.AccountingDocument AS AccountingDocument,
  cast( WhldgTaxItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  cast( WhldgTaxItem.AccountingDocumentItem as taxitem preserving type ) AS TaxItem,
  DIANItemType.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIANItemType.CO_DIANReportItemType AS CO_DIANReportItemType,
  WhldgTaxItem.WithholdingTaxType AS WithholdingTaxType,
  DIANWhtTaxCode.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  WhldgTaxItem.WithholdingTaxCode AS WithholdingTaxCode,
  WhldgTaxItem.FinancialAccountType AS FinancialAccountType,
  WhldgTaxItem.PostingDate AS PostingDate,
  WhldgTaxItem.DocumentDate AS DocumentDate,
  WhldgTaxItem.ReportingDate AS ReportingDate,
  WhldgTaxItem.GLAccount AS GLAccount,
  cast(WhldgTaxItem.BusinessPlace as farp_bupla preserving type) AS BusinessPlace,
  WhldgTaxItem.AccountingDocumentType AS AccountingDocumentType,
  cast(WhldgTaxItem.Debtor as kunnr preserving type) AS Customer,
  cast(WhldgTaxItem.Creditor as lifnr preserving type) AS Supplier,
  WhldgTaxItem.TaxNumberType AS TaxNumberType,
  cast( WhldgTaxItem.TaxNumber1 as stcd1 preserving type) AS TaxNumber1,
  cast( WhldgTaxItem.TaxNumber2 as stcd2 preserving type) AS TaxNumber2,
  cast( WhldgTaxItem.TaxNumber3 as stcd3 preserving type) AS TaxNumber3,
  cast( WhldgTaxItem.TaxNumber4 as stcd4 preserving type) AS TaxNumber4,
  cast( WhldgTaxItem.TaxNumber5 as stcd5 preserving type) AS TaxNumber5,
  cast( WhldgTaxItem.VATRegistration as stceg preserving type) AS VATRegistration,
  cast(WhldgTaxItem.BusinessPartnerCountry as land1 preserving type) AS BusinessPartnerCountry,
  cast(WhldgTaxItem.Region as regio preserving type) AS Region,
  cast(WhldgTaxItem.CityName as ad_city1 preserving type) AS CityName,
  cast(WhldgTaxItem.StreetName as ad_street preserving type) AS StreetName,
  WhldgTaxItem.ReportingCurrency AS CompanyCodeCurrency,
  WhldgTaxItem.TransactionCurrency AS TransactionCurrency,
  cast( 'COP' as ficodian_reporting_currency ) AS ReportingCurrency,
  cast( WhldgTaxItem.WhldgTaxBaseAmtInCoCodeCrcy as fis_qsshh ) AS WhldgTaxBaseAmtInCoCodeCrcy,
  cast( WhldgTaxItem.WhldgTaxAmtInCoCodeCrcy as fis_qbshh ) AS WhldgTaxAmtInCoCodeCrcy,
  cast( WhldgTaxItem.WhldgTaxBaseAmtInTransacCrcy as fis_qsshb ) AS WhldgTaxBaseAmtInTransacCrcy,
  cast( WhldgTaxItem.WhldgTaxAmtInTransacCrcy as fis_qbshb ) AS WhldgTaxAmtInTransacCrcy,
  WhldgTaxItem.WhldgTaxExmptAmtInCoCodeCrcy AS WhldgTaxExmptAmtInCoCodeCrcy,
  WhldgTaxItem.WhldgTaxExmptAmtInTransacCrcy AS WhldgTaxExmptAmtInTransacCrcy,
  WhldgTaxItem._CompanyCode AS _CompanyCode,
  WhldgTaxItem.Country AS Country,
  WhldgTaxItem._WithholdingTaxCode AS _WithholdingTaxCode,
  WhldgTaxItem._Customer AS _Customer,
  WhldgTaxItem._Supplier AS _Supplier
FROM P_StRpWhldgTaxItem AS WhldgTaxItem
INNER JOIN I_CO_DIANItemType AS DIANItemType ON /* join condition not captured in parsed metadata */
INNER JOIN I_CO_DIANWithholdingTaxCode AS DIANWhtTaxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CO_DIANOneTimeAccountBP AS _Onetime ON CompanyCode = _Onetime.CompanyCode AND AccountingDocument = _Onetime.AccountingDocument AND FiscalYear = _Onetime.FiscalYear  -- association [0..1]
;