P_StRpCalTaxReturn

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_StRpCalTaxReturn.
-- 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: PSRCALTAXRET

CREATE VIEW P_StRpCalTaxReturn AS
SELECT
  P_StRpTaxReturn.CompanyCode AS CompanyCode,
  P_StRpTaxReturn.AccountingDocument AS AccountingDocument,
  P_StRpTaxReturn.FiscalYear AS FiscalYear,
  P_StRpTaxReturn.TaxItem AS TaxItem,
  P_StRpTaxReturn.TaxCode AS TaxCode,
  P_StRpTaxReturn.TransactionTypeDetermination AS TransactionTypeDetermination,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  P_StRpTaxReturn.DebitCreditCode AS DebitCreditCode,
  TaxCalculationProcedure,
  P_StRpTaxReturn.TaxRate AS TaxRate,
  case when P_StRpTaxReturn.TransactionTypeDetermination = 'ESE' and ( P_StRpTaxReturn.TaxRate = 100.00 or P_StRpTaxReturn.TaxRate = -100.00 ) then cast(cast(-_NegCharge.TaxRate as abap.dec(11,2)) as char16) when P_StRpTaxReturn.TransactionTypeDetermination = 'ESA' and ( P_StRpTaxReturn.TaxRate = 100.00 or P_StRpTaxReturn.TaxRate = -100.00 ) then cast(cast(-P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else case when _GetNVV.AccountingDocument is not null or _GetNVV.AccountingDocument <> '' then cast(cast(_GetNVV.TaxRate + P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else case when P_StRpTaxReturn.TaxRate < 0 then cast(cast(-P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else cast(cast(P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) end end end as IPITaxRate AS dec112aschar16endendendasIPITaxRate,
  P_StRpTaxReturn.TaxRate AS AdditionalTax1Rate,
  P_ConditionsItem.ConditionAmount AS ConditionAmount,
  case when P_StRpTaxReturn.Customer = '' or P_StRpTaxReturn.Customer = ' ' then I_BillingDocument.PayerParty else P_StRpTaxReturn.Customer end as Customer AS CustomerendasCustomer,
  TaxNumber1,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  P_StRpTaxReturn.AccountingDocumentType AS AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  P_StRpTaxReturn.ConditionRecord AS ConditionRecord,
  RoundingDecimalPlaces,
  P_StRpTaxReturn.DocumentReferenceID AS DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  P_StRpTaxReturn.ReportingDate AS ReportingDate,
  P_StRpTaxReturn.FiscalPeriod AS FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  TaxCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  P_StRpTaxReturn.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_StRpTaxReturn.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_StRpTaxReturn.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_StRpTaxReturn.TaxAmount AS TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  CalculatedTxAmtInCoCodeCrcy - P_StRpTaxReturn.TaxAmountInCoCodeCrcy AS DifferenceTaxAmtInCoCodeCrcy,
  CalcdTxBaseAmtInCoCodeCrcy - P_StRpTaxReturn.TaxBaseAmountInCoCodeCrcy AS DiffTaxBaseAmountInCoCodeCrcy,
  TaxType,
  TargetTaxCode,
  TaxNumber2,
  ActiveTaxType,
  TaxNumber3,
  NmbrOfChmlCmplncMktCountries,
  BusinessPartner,
  cast (P_StRpTaxReturn.TaxAmountInCoCodeCrcy as deductible_amt) AS DcblVATIncrdCostInRptgCrcy,
  BusinessPartnerName,
  CustomerSupplierAddress,
  ItemRelevantForReporting,
  OriginalReferenceDocument,
  P_StRpTaxReturn.TaxIsNotDeductible AS TaxIsNotDeductible,
  ConditionType,
  P_StRpTaxReturn._AccountingDocument AS _AccountingDocument
LEFT OUTER JOIN P_ConditionsItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CountCountry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GetNonDeductibleDocItem AS _GetNVV ON /* join condition not captured in parsed metadata */
;