P_MY_StRpTxItmWithOriglDoc

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_MY_StRpTxItmWithOriglDoc.
-- 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: PSRTXITMWORIDOC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_MY_StRpTxItmWithOriglDoc AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxBox AS TaxBox,
  I_StRpTaxItemBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.ValidFrom AS ValidFrom,
  I_StRpTaxItemBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxItemBoxCube.TaxGroup AS TaxGroup,
  TaxBoxAggregationOperation,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  coalesce(P_DEFTAX_ITEM. AccountingDocument, '') AS TaxTransferDocument,
  coalesce(P_DEFTAX_ITEM. FiscalYear, '') AS TaxTransferDocumentYear,
  coalesce(P_DEFTAX_ITEM.TaxCode, '') AS TargetTaxCode,
  P_DEFTAX_ITEM.GrossAmtInLocalCrcy AS GrossAmtInLocalCrcy,
  P_DEFTAX_ITEM.GrossAmtInNationalCrcy AS GrossAmtInNationalCrcy,
  P_DEFTAX_ITEM.PartialGrossAmtInLocalCrcy AS PartialGrossAmtInLocalCrcy,
  P_DEFTAX_ITEM.PartialGrossAmtInNationalCrcy AS PartialGrossAmtInNationalCrcy,
  division(P_DEFTAX_ITEM.PartialGrossAmtInLocalCrcy, P_DEFTAX_ITEM.GrossAmtInLocalCrcy, 8 ) * 100 AS PartialTransferRatio,
  TaxRate,
  TaxRateValidityStartDate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  ReportingCountry,
  CompanyCodeCountry,
  CountryCurrency,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  I_StRpTaxItemBoxCube.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItemBoxCube.AmountInReportingCurrency AS AmountInReportingCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxItemBoxCube.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItemBoxCube.TaxAmount AS TaxAmount,
  CompanyCodeCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  AdditionalCurrency1,
  AmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2
FROM I_StRpTaxReturnBoxCube
LEFT OUTER JOIN P_DEFTAX_ITEM ON /* join condition not captured in parsed metadata */
;