C_PurOrdPricingElementTP

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_PurOrdPricingElementTP.
-- 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: CPOPRICINGTP

CREATE VIEW C_PurOrdPricingElementTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.PricingDocument AS PricingDocument,
  Document.PricingDocumentItem AS PricingDocumentItem,
  Document.PricingProcedureStep AS PricingProcedureStep,
  Document.PricingProcedureCounter AS PricingProcedureCounter,
  Document.ConditionApplication AS ConditionApplication,
  Document.ConditionType AS ConditionType,
  _PricingElement.ConditionTypeName AS ConditionTypeName,
  _PricingElement.PricingDateTime AS PricingDateTime,
  Document.ConditionCalculationType AS ConditionCalculationType,
  _PricingElement.ConditionBaseValue AS ConditionBaseValue,
  _PricingElement.ConditionBaseValueIntlUnit AS ConditionBaseValueIntlUnit,
  _PricingElement.ConditionBaseValueUnit AS ConditionBaseValueUnit,
  Document.ConditionRateValue AS ConditionRateValue,
  _PricingElement.ConditionRateValueIntlUnit AS ConditionRateValueIntlUnit,
  Document.ConditionRateValueUnit AS ConditionRateValueUnit,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  _PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  _PricingElement.IsGroupCondition AS IsGroupCondition,
  _PricingElement.TaxCode AS TaxCode,
  _PricingElement.TaxCodeName AS TaxCodeName,
  Document.ConditionAmount AS ConditionAmount,
  _PricingElement.TransactionCurrency AS TransactionCurrency,
  _PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  _PricingElement.ConditionInactiveReasonName AS ConditionInactiveReasonName,
  _PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  _PricingElement.ConditionIsDeletable AS ConditionIsDeletable,
  _PricingElement.PricingProcedure AS PricingProcedure,
  _PricingElement.SuperordinateDocument AS SuperordinateDocument,
  _PricingElement.SuperordinateDocumentItem AS SuperordinateDocumentItem
FROM I_PurOrdPricingElementTP AS Document
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON _PricingElement.PricingDocument = PricingDocument AND _PricingElement.PricingDocumentItem = PricingDocumentItem AND _PricingElement.PricingProcedureStep = PricingProcedureStep AND _PricingElement.PricingProcedureCounter = PricingProcedureCounter  -- association [1..1]
LEFT OUTER JOIN C_PricingConditionType_VH AS _PricingConditionTypeVH ON ConditionType = _PricingConditionTypeVH.ConditionType  -- association [0..*]
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]
;