P_StRpTaxItem

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_StRpTaxItem.
-- 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: PSRTAXITEM

CREATE VIEW P_StRpTaxItem AS
SELECT
  I_TaxItem.CompanyCode AS CompanyCode,
  I_TaxItem.AccountingDocument AS AccountingDocument,
  I_TaxItem.FiscalYear AS FiscalYear,
  I_TaxItem.TaxItem AS TaxItem,
  I_TaxItem.TaxItemUUID AS TaxItemUUID,
  I_TaxItem.TAXCODE AS TaxCode,
  I_TaxItem.TaxItemGroup AS TaxItemGroup,
  I_TaxItem.TRANSACTIONTYPEDETERMINATION AS TransactionTypeDetermination,
  I_TaxItem.TAXRATE AS TaxRate,
  I_TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_TaxItem.GLACCOUNT AS GLAccount,
  I_TaxItem.BusinessPlace AS BusinessPlace,
  I_TaxItem.TAXJURISDICTION AS TaxJurisdiction,
  I_TaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_TaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_TaxItem.TAXAMOUNTINCOCODECRCY AS TaxAmountInCoCodeCrcy,
  I_TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_TaxItem.TAXAMOUNT AS TaxAmount,
  I_TaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_TaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_TaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_TaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_TaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_TaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_TaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_TaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  cast (I_TaxItem.AlternativeReferenceDocument as figen_alt_ref_doc_num) AS AlternativeReferenceDocument,
  I_TaxItem.ReverseDocument AS ReverseDocument,
  I_TaxItem.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_TaxItem.Ledger AS Ledger,
  I_TaxItem.LedgerGroup AS LedgerGroup,
  I_TaxItem.PostingDate AS PostingDate,
  I_TaxItem.DocumentDate AS DocumentDate,
  I_TaxItem.TaxReportingDate AS TaxReportingDate,
  I_TaxItem.ReportingDate AS ReportingDate,
  I_TaxItem.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  I_TaxItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  I_TaxItem.IsReversal AS IsReversal,
  I_TaxItem.IsReversed AS IsReversed,
  I_TaxItem.FiscalPeriod AS FiscalPeriod,
  I_TaxItem.ExchangeRate AS ExchangeRate,
  I_TaxItem.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_TaxItem.DocumentReferenceID AS DocumentReferenceID,
  I_TaxItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_TaxItem.ConditionType AS ConditionType,
  I_TaxItem.DocumentCurrency AS DocumentCurrency,
  I_TaxItem.CountryCurrency AS CountryCurrency,
  I_TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_TaxItem.DebitCreditCode AS DebitCreditCodeCalc,
  I_TaxItem.ReportingCountry AS ReportingCountry,
  I_TaxItem.ReportingCurrency AS ReportingCurrency,
  P_T007B_GLO.stazf AS TaxIsNotDeductible,
  I_TaxItem.SenderCompanyCode AS SenderCompanyCode,
  I_TaxItem.SenderAccountingDocument AS SenderAccountingDocument,
  I_TaxItem.SenderFiscalYear AS SenderFiscalYear,
  I_TaxItem.SenderLogicalSystem AS SenderLogicalSystem,
  I_TaxItem.TaxCountry AS TaxCountry,
  I_TaxItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_TaxItem.TaxDataSource AS TaxDataSource
FROM P_StRpTaxItemDebitCreditCode
LEFT OUTER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND AccountingDocument = _AccountingDocument.AccountingDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxReturnCountry ON TaxReturnCountry = _TaxReturnCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _DebtorCreditorRblsPyblsItem ON CompanyCode = _DebtorCreditorRblsPyblsItem.CompanyCode AND FiscalYear = _DebtorCreditorRblsPyblsItem.FiscalYear AND AccountingDocument = _DebtorCreditorRblsPyblsItem.AccountingDocument AND ( TaxCode = _DebtorCreditorRblsPyblsItem.TaxCode OR _DebtorCreditorRblsPyblsItem.TaxCode = '**' OR _DebtorCreditorRblsPyblsItem.TaxCode = '' ) AND TaxCountry = _DebtorCreditorRblsPyblsItem.TaxCountry AND TaxJurisdiction = _DebtorCreditorRblsPyblsItem.TaxJurisdiction AND( _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'D' OR _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'K' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _TaxReceivablesPayablesItem ON CompanyCode = _TaxReceivablesPayablesItem.CompanyCode AND FiscalYear = _TaxReceivablesPayablesItem.FiscalYear AND AccountingDocument = _TaxReceivablesPayablesItem.AccountingDocument AND TaxItemGroup = _TaxReceivablesPayablesItem.TaxItemGroup AND TaxCode = _TaxReceivablesPayablesItem.TaxCode AND TaxCountry = _TaxReceivablesPayablesItem.TaxCountry AND TaxJurisdiction = _TaxReceivablesPayablesItem.TaxJurisdiction AND ( _TaxReceivablesPayablesItem.TaxType = 'A' OR _TaxReceivablesPayablesItem.TaxType = 'V' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ReceivablesPayablesItem ON CompanyCode = _ReceivablesPayablesItem.CompanyCode AND FiscalYear = _ReceivablesPayablesItem.FiscalYear AND AccountingDocument = _ReceivablesPayablesItem.AccountingDocument  -- association [0..*]
;