Which tables does P_RTPCOrdWIPOffstOnCostElmnt read from?

P_RTPCOrdWIPOffstOnCostElmnt reads data from: acdoca, I_Ledger.

What VDM layer is P_RTPCOrdWIPOffstOnCostElmnt?

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

P_RTPCOrdWIPOffstOnCostElmnt

Q: What is P_RTPCOrdWIPOffstOnCostElmnt in SAP S/4HANA?

P_RTPCOrdWIPOffstOnCostElmnt is a composite CDS view in SAP S/4HANA. It contains 15 fields.

DDL: P_RTPCORDWIPOFFSTONCOSTELMNT SQL: PFIRTPCWIPCEOFF Type: view COMPOSITE

15 Fields 2 Data Sources

P_RTPCOrdWIPOffstOnCostElmnt is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (acdoca, I_Ledger) and exposes 15 fields with key fields OrderID, OrderItem, CompanyCode, Ledger, FiscalYearPeriod.

Data Sources (2)

Source	Alias	Join Type
acdoca	_item	from
I_Ledger	_ledger	inner

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PFIRTPCWIPCEOFF	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.status	#DEPRECATED	view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	OrderID	acdoca	aufnr	SettlementOrder
KEY	OrderItem	acdoca	aufps	Order item no.
KEY	CompanyCode	acdoca	rbukrs	Company Code
KEY	Ledger	acdoca	rldnr	Ledger (Compat.)
KEY	FiscalYearPeriod	acdoca	fiscyearper	Period/Year
	hsl
	ksl
	osl
	vsl
	bsl
	csl
	dsl
	esl
	fsl
	gsl

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_RTPCOrdWIPOffstOnCostElmnt.
-- 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: PFIRTPCWIPCEOFF

CREATE VIEW P_RTPCOrdWIPOffstOnCostElmnt AS
SELECT
  _item.aufnr AS OrderID,
  _item.aufps AS OrderItem,
  _item.rbukrs AS CompanyCode,
  _item.rldnr AS Ledger,
  _item.fiscyearper AS FiscalYearPeriod,
  -sum( hsl ) AS hsl,
  -sum( ksl ) AS ksl,
  -sum( osl ) AS osl,
  -sum( vsl ) AS vsl,
  -sum( bsl ) AS bsl,
  -sum( csl ) AS csl,
  -sum( dsl ) AS dsl,
  -sum( esl ) AS esl,
  -sum( fsl ) AS fsl,
  -sum( gsl ) AS gsl
FROM acdoca AS _item
INNER JOIN I_Ledger AS _ledger ON /* join condition not captured in parsed metadata */
;

Depth:

P_RTPCOrdWIPOffstOnCostElmnt view

acdoca
I_Ledger view