P_StRpTaxReturn

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_StRpTaxReturn.
-- 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: PSRTAXRETURN

CREATE VIEW P_StRpTaxReturn AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  TaxItem,
  I_StRpTaxItem.TaxCode AS TaxCode,
  TransactionTypeDetermination,
  DebitCreditCode,
  I_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  P_CndnTypeTaxClassification.ConditionRecord AS ConditionRecord,
  TaxAmountInCoCodeCrcy AS CalculatedTxAmtInCoCodeCrcy,
  TaxAmount AS CalculatedTaxAmountInTransCrcy,
  case when I_StRpTaxItem.TaxReturnCountry is null or I_StRpTaxItem.TaxReturnCountry = ' ' then CompanyCodeCountry else I_StRpTaxItem.TaxReturnCountry end as Country AS TaxReturnCountryendasCountry,
  I_StRpTaxItem.EUTaxClassification AS EUTaxClassification,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  I_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItem.TaxCountry AS TaxCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  _AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  _DebtorCreditorRblsPyblsItem._Customer.Customer AS Customer,
  I_StRpTaxItem.TaxType AS TaxType,
  I_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  SupplierAccountGroup,
  I_StRpTaxItem.ConditionType AS ConditionType,
  TaxIsNotDeductible,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID
FROM I_StRpTaxItem
INNER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RndRulesForCoCodeAndCrcy AS _CCCurrency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RndRulesForCoCodeAndCrcy AS _DocCurrency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RefundRelatedTaxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CndnTypeTaxClassification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_BaseAmtForNegativeCharge AS _NegCharge ON CompanyCode = _NegCharge.CompanyCode AND AccountingDocument = _NegCharge.AccountingDocument AND FiscalYear = _NegCharge.FiscalYear AND ReportingDate = _NegCharge.ReportingDate  -- association [1..*]
;