P_RO_StRpTaxItemLog

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

CREATE VIEW P_RO_StRpTaxItemLog AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  cast( '' as opbel_kk) AS CADocumentNumber,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxBoxStrucValidityStartDate,
  TaxItemGroupingVersion,
  TaxBoxStructureType,
  cast('FI' as firo_dspl_document_origin ) AS RO_DocumentOrigin,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  TaxGroup,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  FiscalPeriod,
  OriginalFiscalPeriod,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  TaxCountry,
  _OneTimeAccountBP001.Country AS OneTimeCountry,
  ReportingDate,
  ExchangeRate,
  TaxRate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxCalculationProcedure,
  TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  _DebtorCreditorRblsPyblsItem.Supplier AS Supplier,
  _DebtorCreditorRblsPyblsItem.Customer AS Customer,
  CustomerSupplierAddress,
  DebitCreditCode,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  Ledger,
  LedgerGroup,
  IsReversal,
  IsReversed,
  cast( '' as storb_gfn_kk ) AS CAReversalDocumentNumber,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  ConditionType,
  TaxType,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInReportingCurrency,
  AmountInTransactionCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxIsNotDeductible,
  substring(_DebtorCreditorRblsPyblsItem.VATRegistration, 1, 2) AS RPItemVATRegistrationCountry,
  TaxGroupFreeClassification,
  P_StatryRptCategory : $parameters.P_StatryRptCategory AS P_StatryRptCategory,
  BusinessPartnerName
FROM I_StRpTaxReturnBoxCube
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP001 ON _OneTimeAccountBP001.CompanyCode = I_StRpTaxReturnBoxCube.CompanyCode AND _OneTimeAccountBP001.AccountingDocument = I_StRpTaxReturnBoxCube.AccountingDocument AND _OneTimeAccountBP001.FiscalYear = I_StRpTaxReturnBoxCube.FiscalYear AND _OneTimeAccountBP001.AccountingDocumentItem = '001'  -- association [0..1]
-- UNION with additional select branch(es): P_RO_CAStRpTaxItemLog
;