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)

SourceAliasJoin Type
I_StRpTaxItemBoxCube I_StRpTaxItemBoxCube from
P_PH_AssetDocItem P_PH_AssetDocItem left_outer

Parameters (1)

NameTypeDefault
P_CompanyCode fis_bukrs

Annotations (8)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
-- Parameters: P_CompanyCode : fis_bukrs

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 */
;

Learn More