P_PH_EXCD1PMTAXITEM4TDT

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_EXCD1PMTAXITEM4TDT.
-- 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: PPHEX1PMTAXITM4T
-- Parameters: P_Language : sylangu, P_CompanyCode : fis_bukrs, P_IsCurrentFiscalPeriod : fiph_iscurrent, P_ValidityStartFiscalYear : gjahr, P_ValidityEndFiscalYear : gjahr, P_ValidityStartFiscalPeriod : perbl, 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_EXCD1PMTAXITEM4TDT AS
SELECT
  CompanyCode,
  CompanyCode2,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  TaxBoxStrucValidityStartDate,
  TaxBoxStructureType,
  TaxGroup,
  UnifiedTaxBoxStructureType,
  TaxBox,
  TaxBoxStrucValidityEndDate,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  TaxJurisdiction,
  GLAccount,
  TaxRate,
  TaxRateValidityStartDate,
  TaxType,
  TaxItemGroup,
  AccountingDocumentType,
  _FixedAsset.AssetClass AS AssetClass,
  MasterFixedAsset,
  AssetValueDate,
  FixedAsset,
  _FixedAsset._AssetClass._Text[1:Language = $parameters.P_Language].AssetClassName AS AssetClassName,
  BusinessPlace,
  cast ( ltrim (right(cast (PlannedUsefulLifeInPeriods as abap.char(20)), 3) , '0' ) as ndurp) AS PlannedUsefulLifeInPeriods,
  ExpiredUsefulLifeInPerds,
  cast ( ltrim ( right(cast (RemainingLifeinPeriods as abap.char(20)), 3), '0' ) as ndper) AS RemainingLifeinPeriods,
  TaxPlannedUsefulLifeInPeriods,
  NumberOfMonthsInPeriod,
  CompanyCodeCurrency,
  ReportingCountry,
  DocumentCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy - division ( TaxAmountInCoCodeCrcy , TaxPlannedUsefulLifeInPeriods, 2 ) * ExpiredUsefulLifeInPerds AS PrevPerdsTaxBalAmtInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount
FROM P_PH_EXCD1PMTAXITEM3TDT
;