P_PH_STRPTaxItems_TDT

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_PH_STRPTaxItems_TDT.
-- 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: PPHSPTAXITMSTDT
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_ThirdPartySupplierRefKey : vndrrefkey, P_DiscountAccountFrom : vonkt_011z, P_DiscountAccountTo : biskt_011z

CREATE VIEW P_PH_STRPTaxItems_TDT AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxCode AS TaxCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxItem.PostingDate AS PostingDate,
  TaxItem,
  SupplierAccountGroup,
  TaxItem.AccountingDocumentType AS AccountingDocumentType,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxBoxStrucValidityStartDate,
  UnifiedTaxBoxStructureType,
  TaxBox,
  TaxItemGroupingVersion,
  TaxBoxStructureType,
  TaxBoxStrucValidityEndDate,
  TaxRateValidityStartDate,
  TaxItem.DocumentDate AS DocumentDate,
  TaxReportingDate,
  ReportingDate,
  TaxItem.FiscalPeriod AS FiscalPeriod,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  TaxItem.BusinessPartner AS BusinessPartner,
  TaxItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxItem.BusinessPartnerName AS BusinessPartnerName,
  CustomerSupplierAddress,
  TaxItem.BusinessPlace AS BusinessPlace,
  TaxItem.TaxType AS TaxType,
  TaxRate,
  IPITaxRate,
  ExchangeRate,
  TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  ReportingCountry,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  TaxItem.TaxAmount AS TaxAmount,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxItem.TaxAmountInRptgCrcy + TaxItem.TaxBaseAmountInRptgCrcy AS GrossAmountInCoCodeCurrency,
  DiscAmtInCoCdCrcy AS DiscountBaseAmtInCoCodeCrcy,
  DiscAmtInCoCdCrcy * cast ( ( 1 + division ( TaxRate ,100, 2 ) ) as abap.dec(10, 4) ) AS DiscountAmtInCoCodeCrcy,
  $session.client AS SystemClient
FROM I_StRpTaxReturnBoxCube
;