I_SalesQuotationPrcgElmnt

DDL: I_SALESQUOTATIONPRCGELMNT Type: view BASIC Package: VDM_SD_SLS_QUT
64 Fields 1 Data Sources 1 OData Services

Sales Quotation Pricing Element

I_SalesQuotationPrcgElmnt (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SalesQuotationPrcgElmnt is a Basic CDS View that provides data about "Sales Quotation Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPricingElement) and exposes 64 fields with key fields SalesQuotation, PricingProcedureStep, PricingProcedureCounter. It is exposed through 1 OData service (ASQL_F6381). Part of development package VDM_SD_SLS_QUT.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-SLS-QUT-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering questions about pricing elements at sales quotation header level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPricingElement PricingElement from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Quotation Pricing Element view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSQTNPREL view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6381 ASQL_F6381 C2 NOT_RELEASED

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation Sales Quotation
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
PricingDateTime PricingDateTime Timestamp for Pricing
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType ConditionCalculationType Calculation Type for Condition
ConditionBaseValue ConditionBaseValue Condition Basis
ConditionRateValue ConditionRateValue Condition Amount or Percentage
ConditionCurrency ConditionCurrency Currency Key
ConditionQuantity ConditionQuantity Condition Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Condition Unit in the Document
ConditionCategory ConditionCategory Condition Category (Examples: Tax, Freight, Price, Cost)
ConditionIsForStatistics ConditionIsForStatistics Condition is used for statistics
PricingScaleType PricingScaleType Scale Type
IsRelevantForAccrual IsRelevantForAccrual Condition is Relevant for Accrual (e.g. Freight)
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin ConditionOrigin Origin of the Condition
IsGroupCondition IsGroupCondition Group Condition
ConditionRecord ConditionRecord Number of Condition Record
ConditionSequentialNumber ConditionSequentialNumber Sequential Number of the Condition
TaxCode TaxCode Tax on Sales/Purchases Code
WithholdingTaxCode WithholdingTaxCode Withholding Tax Code
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount Rounding-Off Difference of a Condition
ConditionAmount ConditionAmount Condition Value
TransactionCurrency TransactionCurrency Transaction Currency
ConditionControl ConditionControl Condition Control
ConditionInactiveReason ConditionInactiveReason Condition is Inactive
ConditionClass ConditionClass Condition Class
PrcgProcedureCounterForHeader PrcgProcedureCounterForHeader Pricing Procedure Counter for Header
FactorForConditionBasisValue FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition StructureCondition Structure Condition
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleBasis PricingScaleBasis Scale Basis Indicator
ConditionScaleBasisValue ConditionScaleBasisValue Scale Base Value
ConditionScaleBasisUnit ConditionScaleBasisUnit Condition Scale Unit of Measure
ConditionScaleBasisCurrency ConditionScaleBasisCurrency Scale Currency
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling Condition for Intercompany Billing
ConditionIsManuallyChanged ConditionIsManuallyChanged Condition Changed Manually
ConditionIsForConfiguration ConditionIsForConfiguration Condition Used for Variant Configuration
VariantCondition VariantCondition Variant Condition Key
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionRateRatio ConditionRateRatio Condition Ratio (in Percent or Per Mille)
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measurement
ConditionBaseAmount ConditionBaseAmount Amount of the Condition Basis
ConditionBaseQuantity ConditionBaseQuantity Quantity of the Condition Basis
_SalesQuotation _SalesQuotation
_ConditionApplication _ConditionApplication
_PricingConditionType _PricingConditionType
_ConditionCalculationType _ConditionCalculationType
_ConditionCurrency _ConditionCurrency
_Currency _Currency
_ConditionQuantityUnit _ConditionQuantityUnit
_ConditionCategory _ConditionCategory
_ConditionOrigin _ConditionOrigin
_ConditionControl _ConditionControl
_ConditionInactiveReason _ConditionInactiveReason
_ConditionClass _ConditionClass
_PricingScaleBasis _PricingScaleBasis
_ScaleUnitOfMeasure _ScaleUnitOfMeasure
_ScaleCurrency _ScaleCurrency
_VariantCondition _VariantCondition
_StructureCondition _StructureCondition

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_SalesQuotationPrcgElmnt.
-- 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_SalesQuotationPrcgElmnt AS
SELECT
  cast(SalesDocument as sales_quotation preserving type) AS SalesQuotation,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  PricingDateTime,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  ConditionBaseValue,
  ConditionRateValue,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionCategory,
  ConditionIsForStatistics,
  PricingScaleType,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  ConditionRecord,
  ConditionSequentialNumber,
  TaxCode,
  WithholdingTaxCode,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  ConditionInactiveReason,
  ConditionClass,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleBasis,
  ConditionScaleBasisValue,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  CndnIsRelevantForIntcoBilling,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionBaseAmount,
  ConditionBaseQuantity
FROM I_SalesDocumentPricingElement AS PricingElement
;

Learn More