C_PricingElement

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 C_PricingElement.
-- 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: CPRICINGELEMENT

CREATE VIEW C_PricingElement AS
SELECT
  PricingElement.PricingDocument AS PricingDocument,
  PricingElement.PricingDocumentItem AS PricingDocumentItem,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  _PricingConditionTypeName_VH.ConditionTypeName AS ConditionTypeName,
  PricingElement.PricingDateTime AS PricingDateTime,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  cast( PricingElement.ConditionBaseValue as vfprc_value_in_curr ) AS ConditionBaseValue,
  cast( PricingElement.ConditionRateValue as vfprc_rate_value_in_curr ) AS ConditionRateValue,
  PricingElement.ConditionCurrency AS ConditionRateValueUnit,
  PricingElement.ConditionQuantity AS ConditionQuantity,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.IsGroupCondition AS IsGroupCondition,
  PricingElement.TaxCode AS TaxCode,
  cast(' ' as price_element_tax_code_descr) AS TaxCodeName,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement._ConditionInactiveReason._Text[ 1: Language = $session.system_language ].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  cast(' ' as abap.char( 1 )) AS ConditionIsDeletable,
  cast(' ' as kalsm_d ) AS PricingProcedure,
  cast(' ' as abap.char ( 32 )) AS SuperordinateDocument,
  cast(' ' as abap.char ( 70 )) AS SuperordinateDocumentItem,
  PricingElement._PricingConditionType AS _PricingConditionType,
  PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit
FROM I_PricingElement AS PricingElement
LEFT OUTER JOIN I_Currency AS tcurx_waers ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PricingConditionType_VH AS _PricingConditionType_VH ON ConditionType = _PricingConditionType_VH.ConditionType AND ConditionApplication = _PricingConditionType_VH.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN C_PricingConditionTypeName_VH AS _PricingConditionTypeName_VH ON ConditionType = _PricingConditionTypeName_VH.ConditionType AND ConditionApplication = _PricingConditionTypeName_VH.ConditionApplication AND ConditionTypeName = _PricingConditionTypeName_VH.ConditionTypeName  -- association [0..1]
LEFT OUTER JOIN C_ConditionRateValueUnit_VH AS _ConditionRateValueUnitVH ON ConditionRateValueUnit = _ConditionRateValueUnitVH.ConditionRateValueUnit  -- association [0..1]
LEFT OUTER JOIN C_ConditionQuantityUnit_VH AS _ConditionQuantityUnitVH ON ConditionQuantityUnit = _ConditionQuantityUnitVH.ConditionQuantityUnit  -- association [0..1]
;