What is A_BusSolnOrdItmRateElmntPrcElm in SAP S/4HANA?

A_BusSolnOrdItmRateElmntPrcElm is a composite CDS view in SAP S/4HANA. Item Rate Element Price Element It contains 12 fields.

Which tables does A_BusSolnOrdItmRateElmntPrcElm read from?

A_BusSolnOrdItmRateElmntPrcElm reads data from: I_ServiceDocumentEnhcd, I_PricingElement, I_BusSolnOrderItemRateElement.

What VDM layer is A_BusSolnOrdItmRateElmntPrcElm?

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

A_BusSolnOrdItmRateElmntPrcElm

DDL: A_BUSSOLNORDITMRATEELMNTPRCELM Type: view COMPOSITE

12 Fields 3 Data Sources 2 Associations

Item Rate Element Price Element

A_BusSolnOrdItmRateElmntPrcElm is a Composite CDS View that provides data about "Item Rate Element Price Element" in SAP S/4HANA. It reads from 3 data sources (I_ServiceDocumentEnhcd, I_PricingElement, I_BusSolnOrderItemRateElement) and exposes 12 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, SubscriptionRateElement, PricingProcedureStep, PricingProcedureCounter. It has 2 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_ServiceDocumentEnhcd	BusinessSolutionOrder	inner
I_PricingElement	PricingElement	from
I_BusSolnOrderItemRateElement	RateElements	inner

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_BusinessSolutionOrder	_BusinessSolutionOrder	`$projection.BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder`
[0..*]	A_BusSolnOrdItmRateElement	_SubscriptionRateElements	`$projection.BusinessSolutionOrder = _SubscriptionRateElements.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _SubscriptionRateElements.BusinessSolutionOrderItem and $projection.SubscriptionRateElement = _SubscriptionRateElements.SubscriptionRateElement`

Annotations (12)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Item Rate Element Price Element	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AbapCatalog.sqlViewName	ABSOITMRTELPRCEL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (12)

Key	Field	Source Table	Source Field	Description
KEY	BusinessSolutionOrder	I_ServiceDocumentEnhcd	ServiceDocument	Transaction ID
KEY	BusinessSolutionOrderItem	I_BusSolnOrderItemRateElement	BusinessSolutionOrderItem	Solution Order Item
KEY	SubscriptionRateElement	I_BusSolnOrderItemRateElement	SubscriptionRateElement	Simulated Product ID
KEY	PricingProcedureStep	I_PricingElement	PricingProcedureStep	Step Number
KEY	PricingProcedureCounter	I_PricingElement	PricingProcedureCounter	Pricing Procedure Counter
	ConditionType	I_PricingElement	ConditionType	Condition type
	ConditionRateValue	I_PricingElement	ConditionRateValue	Condition Rate Value
	ConditionCurrency	I_PricingElement	ConditionCurrency	Currency
	ConditionQuantity	I_PricingElement	ConditionQuantity	Pricing Unit
	ConditionQuantityUnit	I_PricingElement	ConditionQuantityUnit	Unit of Measure
	_SubscriptionRateElements		_SubscriptionRateElements
	_BusinessSolutionOrder		_BusinessSolutionOrder

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 A_BusSolnOrdItmRateElmntPrcElm.
-- 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.

CREATE VIEW A_BusSolnOrdItmRateElmntPrcElm AS
SELECT
  BusinessSolutionOrder.ServiceDocument AS BusinessSolutionOrder,
  RateElements.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  RateElements.SubscriptionRateElement AS SubscriptionRateElement,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingElement.ConditionType AS ConditionType,
  PricingElement.ConditionRateValue AS ConditionRateValue,
  PricingElement.ConditionCurrency AS ConditionCurrency,
  PricingElement.ConditionQuantity AS ConditionQuantity,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit
FROM I_PricingElement AS PricingElement
INNER JOIN I_ServiceDocumentEnhcd AS BusinessSolutionOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusSolnOrderItemRateElement AS RateElements ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_BusinessSolutionOrder AS _BusinessSolutionOrder ON BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder  -- association [1..1]
LEFT OUTER JOIN A_BusSolnOrdItmRateElement AS _SubscriptionRateElements ON BusinessSolutionOrder = _SubscriptionRateElements.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SubscriptionRateElements.BusinessSolutionOrderItem AND SubscriptionRateElement = _SubscriptionRateElements.SubscriptionRateElement  -- association [0..*]
;

Depth:

A_BusSolnOrdItmRateElmntPrcElm view