P_Ph_StRpTaxItemQ

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_StRpTaxItemQ.
-- 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: PSRPHTAXITEMQ
-- Parameters: P_Language : sylangu, P_ThirdPartySupplierRefKey : vndrrefkey, P_DiscountAccountFrom : vonkt_011z, P_DiscountAccountTo : biskt_011z

CREATE VIEW P_Ph_StRpTaxItemQ AS
SELECT
  P_PH_STRPTaxItems.CompanyCode AS CompanyCode,
  P_PH_STRPTaxItems.AccountingDocument AS AccountingDocument,
  P_PH_STRPTaxItems.FiscalYear AS FiscalYear,
  P_PH_STRPTaxItems.TaxCode AS TaxCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  P_PH_STRPTaxItems.PostingDate AS PostingDate,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxBox,
  TaxGroup,
  DocumentDate,
  ReportingDate,
  TaxReportingDate,
  FiscalPeriod,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  P_PH_STRPTaxItems.BusinessPartner AS BusinessPartner,
  P_PH_STRPTaxItems.BusinessPartnerCountry AS BusinessPartnerCountry,
  P_PH_STRPTaxItems.TaxNumber1 AS TaxNumber1,
  P_PH_STRPTaxItems.TaxNumber2 AS TaxNumber2,
  P_PH_STRPTaxItems.TaxNumber3 AS TaxNumber3,
  P_PH_STRPTaxItems.BusinessPartnerName AS BusinessPartnerName,
  CustomerSupplierAddress,
  BusinessPlace,
  TaxType,
  TaxRate,
  ExchangeRate,
  P_PH_STRPTaxItems.TaxCalculationProcedure AS TaxCalculationProcedure,
  TransactionTypeDetermination,
  GLAccount,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  cast( P_PH_STRPTaxItems.Supplier as fiph_lifnr ) AS Supplier,
  cast( I_Supplier.TaxNumber1 as fiph_stcd1 ) AS SupplierTaxID1,
  cast (I_Supplier.TaxNumber2 as fiph_stcd2 ) AS SupplierTaxID2,
  cast (I_Supplier.TaxNumber3 as fiph_stcd3 ) AS SupplierTaxID3,
  cast( I_Supplier.BPSupplierName as suppliername_2) AS SupplierName,
  ReportingCurrency,
  P_PH_STRPTaxItems.CompanyCodeCurrency AS CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCountry,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  GrossAmountInCoCodeCurrency,
  cast ( _TaxTypeText[1:Language = $parameters.P_Language].TaxTypeName as fis_mwart ) AS TaxTypeName,
  _TaxCodeText[1:Language = $parameters.P_Language].TaxCodeName AS TaxCodeName
FROM P_PH_STRPTaxItems
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;