P_StRpBPTaxItemX

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

CREATE VIEW P_StRpBPTaxItemX AS
SELECT
  P_TaxItem.CompanyCode AS CompanyCode,
  P_TaxItem.AccountingDocument AS AccountingDocument,
  P_TaxItem.FiscalYear AS FiscalYear,
  P_TaxItem.TaxItem AS TaxItem,
  P_JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  P_TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_TaxItem.TaxCode AS TaxCode,
  P_TaxItem.GLAccount AS GLAccount,
  P_TaxItem.TaxType AS TaxType,
  P_TaxItem.TaxResultManualModification AS TaxResultManualModification,
  P_TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_TaxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  P_TaxItem.VATRegistration AS VATRegistration,
  P_TaxItem.TaxJurisdiction AS TaxJurisdiction,
  P_TaxItem.ConditionType AS ConditionType,
  division(P_TaxItem.TaxRate,10,2) AS TaxRate,
  P_TaxItem.TaxReturnCountry AS TaxReturnCountry,
  P_TaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  P_TaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  P_TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  P_TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_JournalEntry.DocumentDate AS DocumentDate,
  I_JournalEntry.PostingDate AS PostingDate,
  cast( substring( I_JournalEntry.FiscalPeriod, 2, 2 ) as monat ) AS PostingFiscalPeriod,
  I_JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  I_JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  I_JournalEntry.ReverseDocument AS ReverseDocument,
  I_JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
  I_JournalEntry.TaxReportingDate AS TaxReportingDate,
  I_JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  I_JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  I_JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  I_JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  I_JournalEntry.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  I_JournalEntry.JrnlEntryCntrySpecificDate1 AS JrnlEntryCntrySpecificDate1,
  I_JournalEntry.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  I_JournalEntry.JrnlEntryCntrySpecificDate2 AS JrnlEntryCntrySpecificDate2,
  I_JournalEntry.JrnlEntryCntrySpecificRef3 AS JrnlEntryCntrySpecificRef3,
  I_JournalEntry.JrnlEntryCntrySpecificDate3 AS JrnlEntryCntrySpecificDate3,
  I_JournalEntry.JrnlEntryCntrySpecificRef4 AS JrnlEntryCntrySpecificRef4,
  I_JournalEntry.JrnlEntryCntrySpecificDate4 AS JrnlEntryCntrySpecificDate4,
  I_JournalEntry.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  I_JournalEntry.JrnlEntryCntrySpecificDate5 AS JrnlEntryCntrySpecificDate5,
  I_JournalEntry.JrnlEntryCntrySpecificBP1 AS JrnlEntryCntrySpecificBP1,
  I_JournalEntry.JrnlEntryCntrySpecificBP2 AS JrnlEntryCntrySpecificBP2,
  P_JournalEntryItem.InvoiceReference AS InvoiceReference,
  P_JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  cast( left(I_JournalEntry.OriginalReferenceDocument,10) as char10 ) AS ReferenceDocument,
  cast( substring(I_JournalEntry.OriginalReferenceDocument,11,10) as char10 ) AS ReferenceDocumentContext,
  P_JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  P_JournalEntryItem.Supplier AS Supplier,
  P_JournalEntryItem.Customer AS Customer,
  P_TaxItem.ReportingCountry AS ReportingCountry,
  ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemsLog.StatryRptRunID AS StatryRptRunID
FROM P_StRpBPTaxItem1 AS P_TaxItem
INNER JOIN I_StRpJournalEntryLog AS ReportedItemsLog ON /* join condition not captured in parsed metadata */
;