I_BusSolnOrderItemRateElement

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 I_BusSolnOrderItemRateElement.
-- 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 I_BusSolnOrderItemRateElement AS
SELECT
  object_id AS BusinessSolutionOrder,
  number_int AS BusinessSolutionOrderItem,
  rate_element_no AS SubscriptionRateElementNumber,
  product_id AS SubscriptionRateElement,
  rating_type AS SubscriptionRateElementType,
  _SubscrpnRateElementTypeText.SubscrpnRateElementTypeText AS SubscrpnRateElementTypeText,
  _SubscriptionBillingItem.TransactionCurrency AS Currency,
  net_value AS SubscrpnRateElementNetAmount,
  gross_value AS SubscrpnRateElementGrossAmount,
  tax_amount AS SubscrpnRateElementTaxAmount
FROM crms4d_ratelem_i
LEFT OUTER JOIN I_ServiceDocumentItem AS _SubscriptionBillingItem ON _SubscriptionBillingItem.ServiceObjectType = 'BUS2000172' AND _SubscriptionBillingItem.ServiceDocument = BusinessSolutionOrder AND _SubscriptionBillingItem.ServiceDocumentItem = BusinessSolutionOrderItem  -- association [1..1]
LEFT OUTER JOIN I_SrvcSubscrpnRateElmntType AS _SubscriptionRateElementType ON SubscriptionRateElementType = _SubscriptionRateElementType.SubscriptionRateElementType  -- association [1..1]
LEFT OUTER JOIN I_SrvcSubscrpnRateElmntTypeTxt AS _SubscrpnRateElementTypeText ON SubscriptionRateElementType = _SubscrpnRateElementTypeText.SubscriptionRateElementType AND _SubscrpnRateElementTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON Currency = _TransactionCurrency.Currency  -- association [0..1]
;