What is P_PCCCostEstimateItem in SAP S/4HANA?

P_PCCCostEstimateItem is a composite CDS view in SAP S/4HANA. It contains 56 fields.

Which tables does P_PCCCostEstimateItem read from?

P_PCCCostEstimateItem reads data from: I_MfgOrdPlngCat, I_FinancialPlanningEntryItem.

What VDM layer is P_PCCCostEstimateItem?

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

P_PCCCostEstimateItem

DDL: P_PCCCOSTESTIMATEITEM SQL: PPCCCSTESTIT Type: view COMPOSITE

56 Fields 2 Data Sources

P_PCCCostEstimateItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrdPlngCat, I_FinancialPlanningEntryItem) and exposes 56 fields with key fields Ledger, FiscalYear, FiscalPeriod, FiscalYearPeriod, ProducedProduct.

Data Sources (2)

Source	Alias	Join Type
I_MfgOrdPlngCat	_MfgOrdPlngCat	inner
I_FinancialPlanningEntryItem	_PlanningEntryItem	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PPCCCSTESTIT	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	Ledger		Ledger	Ledger
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	FiscalYearPeriod		FiscalYearPeriod	Period/Year
KEY	ProducedProduct		ProducedProduct	Product
KEY	GLAccount		GLAccount	General Ledger
KEY	CompanyCode	I_FinancialPlanningEntryItem	CompanyCode	Receiver Company Code
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Material		Material	Vehicle Model
KEY	CostOriginGroup		CostOriginGroup	Origin Group
KEY	Plant		Plant	Valuation Area
KEY	OriginCostCenter		OriginCostCenter	OrigCCtr
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType	OrigAct.
KEY	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
KEY	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Partner Cost Center Activity Type
KEY	PlanningCategory	I_FinancialPlanningEntryItem	PlanningCategory	Plan Category
KEY	PlnCatIsForSalesOrderCostEst		PlnCatIsForSalesOrderCostEst	Cat. for Sales Ord
KEY	PlngCatIsForMatlCostEstPlnCost		PlngCatIsForMatlCostEstPlnCost	Cat. for mat st cost
KEY	BusinessTransactionType		BusinessTransactionType	Bus.transaction
KEY	CostEstimateValidityStartDate		CostEstimateValidityStartDate	Cstg Date From
KEY	CostEstimateValidityEndDate		CostEstimateValidityEndDate	Costing Date To
KEY	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
KEY	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
KEY	IsLotSizeIndependent		IsLotSizeIndependent	LotSzIndep.Ind.
KEY	CostSourceUnit		CostSourceUnit	Valuation UoM
KEY	SalesOrder		SalesOrder	SD Document
KEY	SalesOrderItem		SalesOrderItem	Sales Order Item
KEY	OrderID		OrderID	Order ID
	WIPSourceAccountCategory		WIPSourceAccountCategory
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	CostingLotSize		CostingLotSize	Cstg Lot Size
	LotSizeUnit		LotSizeUnit	Lot Size Unit
	AmountInGlobalCurrency
	FixedAmountInGlobalCurrency
	AmountInCompanyCodeCurrency
	AmountInFreeDefinedCurrency1
	AmountInFreeDefinedCurrency2
	AmountInFreeDefinedCurrency3
	AmountInFreeDefinedCurrency4
	AmountInFreeDefinedCurrency5
	AmountInFreeDefinedCurrency6
	AmountInFreeDefinedCurrency7
	AmountInFreeDefinedCurrency8
	TotalQuantity

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_PCCCostEstimateItem.
-- 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: PPCCCSTESTIT

CREATE VIEW P_PCCCostEstimateItem AS
SELECT
  Ledger,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ProducedProduct,
  GLAccount,
  _PlanningEntryItem.CompanyCode AS CompanyCode,
  ControllingArea,
  WorkCenterInternalID,
  OrderOperation,
  Material,
  CostOriginGroup,
  Plant,
  OriginCostCenter,
  OriginCostCtrActivityType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  _PlanningEntryItem.PlanningCategory AS PlanningCategory,
  PlnCatIsForSalesOrderCostEst,
  PlngCatIsForMatlCostEstPlnCost,
  BusinessTransactionType,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  AccountAssignmentType,
  ControllingDebitCreditCode,
  PartnerAccountAssignmentType,
  GlobalCurrency,
  CompanyCodeCurrency,
  IsLotSizeIndependent,
  CostSourceUnit,
  SalesOrder,
  SalesOrderItem,
  OrderID,
  WIPSourceAccountCategory,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  CostingLotSize,
  LotSizeUnit,
  sum(AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(FixedAmountInGlobalCrcy) AS FixedAmountInGlobalCurrency,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(AmountInFreeDefinedCurrency1) AS AmountInFreeDefinedCurrency1,
  sum(AmountInFreeDefinedCurrency2) AS AmountInFreeDefinedCurrency2,
  sum(AmountInFreeDefinedCurrency3) AS AmountInFreeDefinedCurrency3,
  sum(AmountInFreeDefinedCurrency4) AS AmountInFreeDefinedCurrency4,
  sum(AmountInFreeDefinedCurrency5) AS AmountInFreeDefinedCurrency5,
  sum(AmountInFreeDefinedCurrency6) AS AmountInFreeDefinedCurrency6,
  sum(AmountInFreeDefinedCurrency7) AS AmountInFreeDefinedCurrency7,
  sum(AmountInFreeDefinedCurrency8) AS AmountInFreeDefinedCurrency8,
  sum(ValuationQuantity) AS TotalQuantity
FROM I_FinancialPlanningEntryItem AS _PlanningEntryItem
INNER JOIN I_MfgOrdPlngCat AS _MfgOrdPlngCat ON /* join condition not captured in parsed metadata */
;

Depth:

P_PCCCostEstimateItem view

I_FinancialPlanningEntryItem view
I_MfgOrdPlngCat view