What is P_PH_CapitalGoodsItem in SAP S/4HANA?

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

Which tables does P_PH_CapitalGoodsItem read from?

P_PH_CapitalGoodsItem reads data from: I_StRpTaxItemBoxCube, P_PH_AssetDocItem.

What VDM layer is P_PH_CapitalGoodsItem?

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

P_PH_CapitalGoodsItem

DDL: P_PH_CAPITALGOODSITEM SQL: PPHGOODSITEM Type: view COMPOSITE

46 Fields 2 Data Sources

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

Data Sources (2)

Source	Alias	Join Type
I_StRpTaxItemBoxCube	I_StRpTaxItemBoxCube	from
P_PH_AssetDocItem	P_PH_AssetDocItem	left_outer

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PPHGOODSITEM	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	TaxReceivablesPayablesItem	CompanyCode	Receiver Company Code
KEY	CompanyCode2	I_StRpTaxItemBoxCube	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxItemBoxCube	AccountingDocument	Journal Entry
KEY	TaxItem	I_StRpTaxItemBoxCube	TaxItem	Tax Item
KEY	FiscalYear	I_StRpTaxItemBoxCube	FiscalYear	G/L Fiscal Year
KEY	TaxCode	I_StRpTaxItemBoxCube	TaxCode	Tax Code
KEY	TransactionTypeDetermination	I_StRpTaxItemBoxCube	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	I_StRpTaxItemBoxCube	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	I_StRpTaxItemBoxCube	PostingDate	Posting Date for GR
	DocumentDate	I_StRpTaxItemBoxCube	DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	FiscalPeriod	I_StRpTaxItemBoxCube	FiscalPeriod	Tax period
	TaxJurisdiction	I_StRpTaxItemBoxCube	TaxJurisdiction	Tax Jurisdiction
	GLAccount	I_StRpTaxItemBoxCube	GLAccount	General Ledger
	TaxRate		TaxRate	Tax Rate
	TaxType	I_StRpTaxItemBoxCube	TaxType	Tax Type
	TaxItemGroup	I_StRpTaxItemBoxCube	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	I_StRpTaxItemBoxCube	AccountingDocumentType	Journal Entry Type
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	AssetClass	TaxReceivablesPayablesItem	AssetClass	Asset Class
	MasterFixedAsset	TaxReceivablesPayablesItem	MasterFixedAsset	Fixed Asset
	AssetValueDate	TaxReceivablesPayablesItem	AssetValueDate	Reference date
	FixedAsset	TaxReceivablesPayablesItem	FixedAsset	Sub-number
	BusinessPlace	I_StRpTaxItemBoxCube	BusinessPlace	Business place
	CompanyCodeCurrency	I_StRpTaxItemBoxCube	CompanyCodeCurrency	Local Currency
	DocYear
	DocMonth
	DocumentCurrency		DocumentCurrency	Document Currency
	TaxBaseAmountInCoCodeCrcy	I_StRpTaxItemBoxCube	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	I_StRpTaxItemBoxCube	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	ReportingCountry		ReportingCountry
	ReportingCurrency		ReportingCurrency	Currency
	TaxBaseAmountInRptgCrcy	I_StRpTaxItemBoxCube	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	I_StRpTaxItemBoxCube	TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInTransCrcy	I_StRpTaxItemBoxCube	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	I_StRpTaxItemBoxCube	TaxAmount	Tax Amt in Rptg Crcy
	_FixedAsset	TaxReceivablesPayablesItem	_FixedAsset
	_MasterFixedAsset	TaxReceivablesPayablesItem	_MasterFixedAsset
	_ReportedItemsLog		_ReportedItemsLog

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_CapitalGoodsItem.
-- 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: PPHGOODSITEM

CREATE VIEW P_PH_CapitalGoodsItem AS
SELECT
  TaxReceivablesPayablesItem.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode2,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxBox AS TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  ReportingDate,
  I_StRpTaxItemBoxCube.PostingDate AS PostingDate,
  I_StRpTaxItemBoxCube.DocumentDate AS DocumentDate,
  TaxReportingDate,
  I_StRpTaxItemBoxCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItemBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItemBoxCube.GLAccount AS GLAccount,
  TaxRate,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  I_StRpTaxItemBoxCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItemBoxCube.AccountingDocumentType AS AccountingDocumentType,
  BusinessPartner,
  BusinessPartnerName,
  TaxReceivablesPayablesItem.AssetClass AS AssetClass,
  TaxReceivablesPayablesItem.MasterFixedAsset AS MasterFixedAsset,
  TaxReceivablesPayablesItem.AssetValueDate AS AssetValueDate,
  TaxReceivablesPayablesItem.FixedAsset AS FixedAsset,
  I_StRpTaxItemBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( cast( left(cast( I_StRpTaxItemBoxCube.ReportingDate as char8), 4 ) as abap.numc(4)) as abap.int2 ) AS DocYear,
  cast ( cast ( substring (cast(I_StRpTaxItemBoxCube.ReportingDate as char8), 5, 2 ) as abap.numc(2)) as abap.int2) AS DocMonth,
  DocumentCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  ReportingCountry,
  ReportingCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItemBoxCube.TaxAmount AS TaxAmount,
  TaxReceivablesPayablesItem._FixedAsset AS _FixedAsset,
  TaxReceivablesPayablesItem._MasterFixedAsset AS _MasterFixedAsset
FROM I_StRpTaxItemBoxCube
LEFT OUTER JOIN P_PH_AssetDocItem ON /* join condition not captured in parsed metadata */
;

Depth:

P_PH_CapitalGoodsItem view

I_StRpTaxItemBoxCube view
P_PH_AssetDocItem view