P_TH_StRpTaxPaymentItem

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_TH_StRpTaxPaymentItem.
-- 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: PTHSTRPTAXPITEM

CREATE VIEW P_TH_StRpTaxPaymentItem AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  I_StRpTaxItemBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  ReportingDate,
  I_StRpTaxItemBoxCube.PostingDate AS PostingDate,
  I_StRpTaxItemBoxCube.DocumentDate AS DocumentDate,
  I_StRpTaxItemBoxCube.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItemBoxCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItemBoxCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItemBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItemBoxCube.ExchangeRate AS ExchangeRate,
  P_DebtorCreditorRblsPyblsItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_DebtorCreditorRblsPyblsItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntry AS ClearingJournalEntry,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.ExchangeRate AS SupplierPaytCurrencyExchRate,
  P_DebtorCreditorRblsPyblsItem.DocumentItemText AS PaymentNote,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  BusinessPartnerCountry,
  cast( TaxRate as btaux ) AS TaxRate,
  I_StRpTaxItemBoxCube.IsReversal AS IsReversal,
  I_StRpTaxItemBoxCube.IsReversed AS IsReversed,
  I_StRpTaxItemBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxItemBoxCube.GLAccount AS GLAccount,
  I_StRpTaxItemBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemBoxCube.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.Building AS Building,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.RoomNumber AS RoomNumber,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.Floor AS Floor,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.StreetSuffixName1 AS StreetSuffixName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.HouseNumber AS HouseNumber,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.StreetPrefixName1 AS StreetPrefixName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.StreetPrefixName2 AS AdditionalStreetPrefixName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.StreetName AS StreetName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.VillageName AS HomeCityName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.DistrictName AS District,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.CityName AS CityName,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.PostalCode AS PostalCode,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation.Country AS Country,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  I_StRpTaxItemBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  I_StRpTaxItemBoxCube.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItemBoxCube.AdditionalCurrency2 AS AdditionalCurrency2,
  AmountInReportingCurrency,
  cast( I_StRpTaxItemBoxCube.AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  cast ( I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy as hwbas_bses ) AS TaxBaseAmountInCoCodeCrcy,
  cast ( I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy as hwste) AS TaxAmountInCoCodeCrcy,
  cast( I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy as fwbas_bses ) AS TaxBaseAmountInTransCrcy,
  cast( I_StRpTaxItemBoxCube.TaxAmount as fwste ) AS TaxAmount,
  cast( TaxBaseAmountInRptgCrcy as glo_taxbase_amount_rptg_crcy) AS TaxBaseAmountInRptgCrcy,
  cast( TaxAmountInRptgCrcy as glo_tax_amount_rptg_crcy ) AS TaxAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  I_StRpTaxItemBoxCube.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxIsNotDeductible,
  _DebtorCreditorRblsPyblsItem._Supplier._AddressRepresentation._Country AS _Country,
  I_StRpTaxItemBoxCube._GLAccount AS _GLAccount
FROM I_StRpTaxItemBoxCube
LEFT OUTER JOIN P_DebtorCreditorRblsPyblsItem ON /* join condition not captured in parsed metadata */
;