P_TW_StRpNotRptdItem

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_TW_StRpNotRptdItem.
-- 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: PTWNOTRPTITEM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StatryRptRunType : srf_report_run_type

CREATE VIEW P_TW_StRpNotRptdItem AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.TaxItem AS TaxItem,
  AccountingDocumentItem => TaxItem key I_StRpTaxItem.FiscalYear AS FiscalYear,
  I_StRpTaxItemGrpg.TaxGroup AS TaxGroup,
  add the key TaxGroup as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) key I_StRpTaxItemGrpg.TaxBox AS TaxBox,
  add the key TaxBox as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) key I_StRpTaxItemGrpg.TaxDeclnAmountType AS TaxDeclnAmountType,
  add the key TaxDeclnAmountType as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) key I_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  add the key TransactionTypeDetermination as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) I_StRpTaxItem.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItem.TaxCode AS TaxCode,
  I_StRpTaxItem.TaxRate AS TaxRate,
  I_StRpTaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  TaxNumber1,
  DocumentReferenceID,
  BusinessPartner,
  TaxType,
  I_StRpTaxItem._AccountingDocument.IsReversal AS IsReversal,
  I_StRpTaxItem._AccountingDocument.IsReversed AS IsReversed,
  I_StRpTaxItem._AccountingDocument.ReverseDocument AS ReverseDocument,
  I_StRpTaxItem._AccountingDocument.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_StRpTaxItem._AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_StRpTaxItem._AccountingDocument.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxItem._AccountingDocument.NmbrOfPages AS NmbrOfPages,
  CompanyCodeCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  ReportingCountry,
  TaxItemGroupingVersion,
  I_StRpTaxItem._AccountingDocument AS _AccountingDocument,
  I_StRpTaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  I_StRpTaxItem._OneTimeAccountBP AS _OneTimeAccountBP,
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID,
  $parameters.P_StatryRptRunType AS StatryRptRunType
LEFT OUTER JOIN I_StRpTaxItemGrpg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TW_StRpRptdItem ON /* join condition not captured in parsed metadata */
;