C_QTNPricingElementWD

DDL: C_QTNPRICINGELEMENTWD SQL: CQTNPRICINGWD Type: view CONSUMPTION
42 Fields 1 Data Sources 7 Associations

Supplier Quotation Pricing with Draft

C_QTNPricingElementWD is a Consumption CDS View that provides data about "Supplier Quotation Pricing with Draft" in SAP S/4HANA. It reads from 1 data source (I_QTNPricingElementWD) and exposes 42 fields with key fields PricingDocument, PricingDocumentItem, PricingProcedureStep, PricingProcedureCounter, SupplierQuotation. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QTNPricingElementWD I_QTNPricingElementWD from

Associations (7)

CardinalityTargetAliasCondition
[1..1] C_SuplrQuotationEnhWD _SuplrQuotationEnhWD _SuplrQuotationEnhWD.SupplierQuotation = $projection.SupplierQuotation
[1..1] C_SuplrQuotationItemEnhWD _SuplrQuotationItemEnhWD _SuplrQuotationItemEnhWD.SupplierQuotation = $projection.SupplierQuotation and _SuplrQuotationItemEnhWD.SupplierQuotationItem = $projection.SupplierQuotationItem
[1..1] C_PricingElement _PricingElement $projection.PricingDocument = _PricingElement.PricingDocument and $projection.PricingDocumentItem = _PricingElement.PricingDocumentItem and $projection.PricingProcedureStep = _PricingElement.PricingProcedureStep and $projection.PricingProcedureCounter = _PricingElement.PricingProcedureCounter
[0..*] C_PricingConditionType_VH _PricingConditionTypeVH $projection.ConditionType = _PricingConditionTypeVH.ConditionType
[0..1] C_PricingConditionTypeName_VH _PricingConditionTypeName_VH $projection.ConditionType = _PricingConditionTypeName_VH.ConditionType and $projection.ConditionApplication = _PricingConditionTypeName_VH.ConditionApplication and $projection.conditiontypename = _PricingConditionTypeName_VH.ConditionTypeName
[0..1] C_ConditionRateValueUnit_VH _ConditionRateValueUnitVH $projection.ConditionRateValueUnit = _ConditionRateValueUnitVH.ConditionRateValueUnit
[0..1] C_ConditionQuantityUnit_VH _ConditionQuantityUnitVH $projection.ConditionQuantityUnit = _ConditionQuantityUnitVH.ConditionQuantityUnit

Annotations (13)

NameValueLevelField
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CQTNPRICINGWD view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier Quotation Pricing with Draft view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument I_QTNPricingElementWD PricingDocument Document Condition
KEY PricingDocumentItem I_QTNPricingElementWD PricingDocumentItem Item
KEY PricingProcedureStep I_QTNPricingElementWD PricingProcedureStep Step Number
KEY PricingProcedureCounter I_QTNPricingElementWD PricingProcedureCounter Pricing Procedure Counter
KEY SupplierQuotation I_QTNPricingElementWD SupplierQuotation RFQ
KEY SupplierQuotationItem I_QTNPricingElementWD SupplierQuotationItem Supplier Quotation Item
ConditionApplication I_QTNPricingElementWD ConditionApplication Application
ConditionType I_QTNPricingElementWD ConditionType Condition type
ConditionCalculationType I_QTNPricingElementWD ConditionCalculationType Calculat.Type
ConditionRateValue
ConditionRateValueUnit I_QTNPricingElementWD ConditionCurrency Currency
ConditionQuantity I_QTNPricingElementWD ConditionQuantity Pricing Unit
ConditionQuantityUnit I_QTNPricingElementWD ConditionQuantityUnit Unit of Measure
ConditionAmount I_QTNPricingElementWD ConditionAmount Condition Value
ConditionTypeName _PricingElement ConditionTypeName Name
PricingDateTime _PricingElement PricingDateTime
ConditionBaseValue _PricingElement ConditionBaseValue Cond.Basis
ConditionBaseValueIntlUnit _PricingElement ConditionBaseValueIntlUnit Currency
ConditionBaseValueUnit _PricingElement ConditionBaseValueUnit Unit
ConditionRateValueIntlUnit _PricingElement ConditionRateValueIntlUnit Currency
ConditionIsForStatistics _PricingElement ConditionIsForStatistics Statistical
IsGroupCondition _PricingElement IsGroupCondition Group Condition
TaxCode _PricingElement TaxCode Tax Code
TaxCodeName _PricingElement TaxCodeName Tax Code Name
TransactionCurrency _PricingElement TransactionCurrency Transaction Currency
ConditionInactiveReason _PricingElement ConditionInactiveReason Inactive
ConditionInactiveReasonName _PricingElement ConditionInactiveReasonName Inactive
ConditionIsManuallyChanged _PricingElement ConditionIsManuallyChanged Changed Manual.
ConditionIsDeletable _PricingElement ConditionIsDeletable
PricingProcedure _PricingElement PricingProcedure Procedure
SuperordinateDocument _PricingElement SuperordinateDocument
SuperordinateDocumentItem _PricingElement SuperordinateDocumentItem
_SuplrQuotationEnhWD _SuplrQuotationEnhWD
_SuplrQuotationItemEnhWD _SuplrQuotationItemEnhWD
_PricingConditionTypeVH _PricingConditionTypeVH
_ConditionQuantityUnitVH _ConditionQuantityUnitVH
_ConditionRateValueUnitVH _ConditionRateValueUnitVH
_PricingConditionType I_QTNPricingElementWD _PricingConditionType
_ConditionQuantityUnit I_QTNPricingElementWD _ConditionQuantityUnit
_ConditionApplication I_QTNPricingElementWD _ConditionApplication
_ConditionCurrency I_QTNPricingElementWD _ConditionCurrency
_PricingConditionTypeName_VH _PricingConditionTypeName_VH

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_QTNPricingElementWD.
-- 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: CQTNPRICINGWD

CREATE VIEW C_QTNPricingElementWD AS
SELECT
  I_QTNPricingElementWD.PricingDocument AS PricingDocument,
  I_QTNPricingElementWD.PricingDocumentItem AS PricingDocumentItem,
  I_QTNPricingElementWD.PricingProcedureStep AS PricingProcedureStep,
  I_QTNPricingElementWD.PricingProcedureCounter AS PricingProcedureCounter,
  I_QTNPricingElementWD.SupplierQuotation AS SupplierQuotation,
  I_QTNPricingElementWD.SupplierQuotationItem AS SupplierQuotationItem,
  I_QTNPricingElementWD.ConditionApplication AS ConditionApplication,
  I_QTNPricingElementWD.ConditionType AS ConditionType,
  I_QTNPricingElementWD.ConditionCalculationType AS ConditionCalculationType,
  cast( I_QTNPricingElementWD.ConditionRateValue as vfprc_rate_value_in_curr ) AS ConditionRateValue,
  I_QTNPricingElementWD.ConditionCurrency AS ConditionRateValueUnit,
  I_QTNPricingElementWD.ConditionQuantity AS ConditionQuantity,
  I_QTNPricingElementWD.ConditionQuantityUnit AS ConditionQuantityUnit,
  I_QTNPricingElementWD.ConditionAmount AS ConditionAmount,
  _PricingElement.ConditionTypeName AS ConditionTypeName,
  _PricingElement.PricingDateTime AS PricingDateTime,
  _PricingElement.ConditionBaseValue AS ConditionBaseValue,
  _PricingElement.ConditionBaseValueIntlUnit AS ConditionBaseValueIntlUnit,
  _PricingElement.ConditionBaseValueUnit AS ConditionBaseValueUnit,
  _PricingElement.ConditionRateValueIntlUnit AS ConditionRateValueIntlUnit,
  _PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  _PricingElement.IsGroupCondition AS IsGroupCondition,
  _PricingElement.TaxCode AS TaxCode,
  _PricingElement.TaxCodeName AS TaxCodeName,
  _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,
  I_QTNPricingElementWD._PricingConditionType AS _PricingConditionType,
  I_QTNPricingElementWD._ConditionQuantityUnit AS _ConditionQuantityUnit,
  I_QTNPricingElementWD._ConditionApplication AS _ConditionApplication,
  I_QTNPricingElementWD._ConditionCurrency AS _ConditionCurrency
FROM I_QTNPricingElementWD
LEFT OUTER JOIN C_SuplrQuotationEnhWD AS _SuplrQuotationEnhWD ON _SuplrQuotationEnhWD.SupplierQuotation = SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN C_SuplrQuotationItemEnhWD AS _SuplrQuotationItemEnhWD ON _SuplrQuotationItemEnhWD.SupplierQuotation = SupplierQuotation AND _SuplrQuotationItemEnhWD.SupplierQuotationItem = SupplierQuotationItem  -- association [1..1]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON PricingDocument = _PricingElement.PricingDocument AND PricingDocumentItem = _PricingElement.PricingDocumentItem AND PricingProcedureStep = _PricingElement.PricingProcedureStep AND PricingProcedureCounter = _PricingElement.PricingProcedureCounter  -- association [1..1]
LEFT OUTER JOIN C_PricingConditionType_VH AS _PricingConditionTypeVH ON ConditionType = _PricingConditionTypeVH.ConditionType  -- association [0..*]
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]
;

Learn More