P_PH_Excd1PMTaxItemTDT

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_Excd1PMTaxItemTDT.
-- 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: PPHEX1PMTAXITMT
-- Parameters: P_CompanyCode : fis_bukrs, P_IsCurrentFiscalPeriod : fiph_iscurrent, P_ValidityStartFiscalYear : gjahr, P_ValidityStartFiscalPeriod : perbl, P_ValidityEndFiscalYear : gjahr, P_ValidityEndFiscalPeriod : perbl, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW P_PH_Excd1PMTaxItemTDT AS
SELECT
  P_PH_CapitalGoodsItem.CompanyCode AS CompanyCode,
  P_PH_CapitalGoodsItem.CompanyCode2 AS CompanyCode2,
  P_PH_CapitalGoodsItem.AccountingDocument AS AccountingDocument,
  P_PH_CapitalGoodsItem.FiscalYear AS FiscalYear,
  P_PH_CapitalGoodsItem.TaxItem AS TaxItem,
  P_PH_CapitalGoodsItem.TaxCode AS TaxCode,
  P_PH_CapitalGoodsItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_PH_CapitalGoodsItem.TaxBox AS TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  TaxBoxStrucValidityStartDate,
  TaxBoxStructureType,
  TaxGroup,
  UnifiedTaxBoxStructureType,
  TaxBoxStrucValidityEndDate,
  ReportingDate,
  P_PH_CapitalGoodsItem.PostingDate AS PostingDate,
  P_PH_CapitalGoodsItem.DocumentDate AS DocumentDate,
  TaxReportingDate,
  P_PH_CapitalGoodsItem.FiscalPeriod AS FiscalPeriod,
  P_PH_CapitalGoodsItem.TaxJurisdiction AS TaxJurisdiction,
  P_PH_CapitalGoodsItem.GLAccount AS GLAccount,
  TaxRate,
  TaxRateValidityStartDate,
  P_PH_CapitalGoodsItem.TaxType AS TaxType,
  P_PH_CapitalGoodsItem.TaxItemGroup AS TaxItemGroup,
  P_PH_CapitalGoodsItem.AccountingDocumentType AS AccountingDocumentType,
  P_PH_CapitalGoodsItem.AssetClass AS AssetClass,
  P_PH_CapitalGoodsItem.MasterFixedAsset AS MasterFixedAsset,
  AssetValueDate,
  P_PH_CapitalGoodsItem.FixedAsset AS FixedAsset,
  BusinessPlace,
  cast( PlannedUsefulLifeInPeriods as abap.int2 ) + cast (PlannedUsefulLifeInYears as abap.int2) * 12 AS PlannedUsefulLifeInPeriods,
  cast($parameters.P_ValidityStartFiscalYear as abap.int2 ) AS StartYear,
  cast($parameters.P_ValidityStartFiscalPeriod as abap.int2 ) AS StartPeriod,
  cast($parameters.P_ValidityEndFiscalYear as abap.int2 ) AS EndYear,
  cast($parameters.P_ValidityEndFiscalPeriod as abap.int2 ) AS EndPeriod,
  P_PH_CapitalGoodsItem.DocYear AS DocYear,
  P_PH_CapitalGoodsItem.DocMonth AS DocMonth,
  case $parameters.P_IsCurrentFiscalPeriod when 'X' then 0 else (cast($parameters.P_ValidityStartFiscalYear as abap.int2 ) - cast( P_PH_CapitalGoodsItem.FiscalYear as abap.int2)) *12 + (cast($parameters.P_ValidityStartFiscalPeriod as abap.int2 ) - cast( P_PH_CapitalGoodsItem.FiscalPeriod as abap.int2)) end as ExpiredUsefulLifeInPerds AS int2endasExpiredUsefulLifeInPerds,
  P_PH_CapitalGoodsItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  ReportingCountry,
  DocumentCurrency,
  P_PH_CapitalGoodsItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_PH_CapitalGoodsItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_PH_CapitalGoodsItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_PH_CapitalGoodsItem.TaxAmount AS TaxAmount,
  P_PH_CapitalGoodsItem._ReportedItemsLog AS _ReportedItemsLog,
  P_PH_CapitalGoodsItem._FixedAsset AS _FixedAsset
FROM P_PH_CapitalGoodsItemTDT
INNER JOIN P_PH_MonthExceeding1PMTDT ON /* join condition not captured in parsed metadata */
;