What is P_PH_Excd1PMTaxItem in SAP S/4HANA?

P_PH_Excd1PMTaxItem is a composite CDS view in SAP S/4HANA. It contains 46 fields.

Which tables does P_PH_Excd1PMTaxItem read from?

P_PH_Excd1PMTaxItem reads data from: I_AssetValuationForLedger, P_PH_CapitalGoodsItem, P_PH_MonthExceeding1PM.

What VDM layer is P_PH_Excd1PMTaxItem?

P_PH_Excd1PMTaxItem is classified as a Composite view that combines data from multiple basic views.

P_PH_Excd1PMTaxItem

DDL: P_PH_EXCD1PMTAXITEM SQL: PPHEX1PMTAXITM Type: view COMPOSITE

46 Fields 3 Data Sources

P_PH_Excd1PMTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AssetValuationForLedger, P_PH_CapitalGoodsItem, P_PH_MonthExceeding1PM) and exposes 46 fields with key fields CompanyCode, CompanyCode2, AccountingDocument, FiscalYear, TaxItem.

Data Sources (3)

Source	Alias	Join Type
I_AssetValuationForLedger	I_AssetValuationForLedger	left_outer
P_PH_CapitalGoodsItem	P_PH_CapitalGoodsItem	from
P_PH_MonthExceeding1PM	P_PH_MonthExceeding1PM	inner

Parameters (6)

Name	Type	Default
P_CompanyCode	fis_bukrs
P_IsCurrentFiscalPeriod	fiph_iscurrent
P_ValidityStartFiscalYear	gjahr
P_ValidityStartFiscalPeriod	perbl
P_ValidityEndFiscalYear	gjahr
P_ValidityEndFiscalPeriod	perbl

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PPHEX1PMTAXITM	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#P	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_PH_CapitalGoodsItem	CompanyCode	Receiver Company Code
KEY	CompanyCode2	P_PH_CapitalGoodsItem	CompanyCode2	Receiver Company Code
KEY	AccountingDocument	P_PH_CapitalGoodsItem	AccountingDocument	Journal Entry
KEY	FiscalYear	P_PH_CapitalGoodsItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_PH_CapitalGoodsItem	TaxItem	Tax Item
KEY	TaxCode	P_PH_CapitalGoodsItem	TaxCode	Tax Code
KEY	TransactionTypeDetermination	P_PH_CapitalGoodsItem	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	P_PH_CapitalGoodsItem	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType		TaxDeclnAmountType
KEY	TaxItemGroupingVersion		TaxItemGroupingVersion	Tax Grping Ver.
KEY	ValidFrom		ValidFrom	Vers.Valid From
KEY	TaxBoxStructureType		TaxBoxStructureType
KEY	TaxGroup		TaxGroup	Tax Group
	ReportingDate		ReportingDate
	PostingDate	P_PH_CapitalGoodsItem	PostingDate	Posting Date for GR
	DocumentDate	P_PH_CapitalGoodsItem	DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	FiscalPeriod	P_PH_CapitalGoodsItem	FiscalPeriod	Tax period
	TaxJurisdiction	P_PH_CapitalGoodsItem	TaxJurisdiction	Tax Jurisdiction
	GLAccount	P_PH_CapitalGoodsItem	GLAccount	General Ledger
	TaxRate		TaxRate	Tax Rate
	TaxType	P_PH_CapitalGoodsItem	TaxType	Tax Type
	TaxItemGroup	P_PH_CapitalGoodsItem	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	P_PH_CapitalGoodsItem	AccountingDocumentType	Journal Entry Type
	AssetClass	P_PH_CapitalGoodsItem	AssetClass	Asset Class
	MasterFixedAsset	P_PH_CapitalGoodsItem	MasterFixedAsset	Fixed Asset
	AssetValueDate		AssetValueDate	Reference date
	FixedAsset	P_PH_CapitalGoodsItem	FixedAsset	Sub-number
	BusinessPlace		BusinessPlace	Business place
	PlannedUsefulLifeInPeriods
	StartYear
	StartPeriod
	EndYear
	EndPeriod
	DocYear	P_PH_CapitalGoodsItem	DocYear	Ref. Doc. Year
	DocMonth	P_PH_CapitalGoodsItem	DocMonth
	int2endasExpiredUsefulLifeInPerds
	CompanyCodeCurrency	P_PH_CapitalGoodsItem	CompanyCodeCurrency	Local Currency
	ReportingCountry		ReportingCountry
	DocumentCurrency		DocumentCurrency	Document Currency
	TaxBaseAmountInCoCodeCrcy	P_PH_CapitalGoodsItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_PH_CapitalGoodsItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	P_PH_CapitalGoodsItem	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	P_PH_CapitalGoodsItem	TaxAmount	Tax Amt in Rptg Crcy
	_ReportedItemsLog	P_PH_CapitalGoodsItem	_ReportedItemsLog
	_FixedAsset	P_PH_CapitalGoodsItem	_FixedAsset

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_Excd1PMTaxItem.
-- 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: PPHEX1PMTAXITM
-- Parameters: P_CompanyCode : fis_bukrs, P_IsCurrentFiscalPeriod : fiph_iscurrent, P_ValidityStartFiscalYear : gjahr, P_ValidityStartFiscalPeriod : perbl, P_ValidityEndFiscalYear : gjahr, P_ValidityEndFiscalPeriod : perbl

CREATE VIEW P_PH_Excd1PMTaxItem 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,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  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,
  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_CapitalGoodsItem
INNER JOIN P_PH_MonthExceeding1PM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssetValuationForLedger ON /* join condition not captured in parsed metadata */
;

Depth:

P_PH_Excd1PMTaxItem view

P_PH_EXCD1PMTAXITEM1 view