I_SalesOrderItemPricingElement

DDL: I_SALESORDERITEMPRICINGELEMENT Type: view BASIC
67 Fields 1 Data Sources

Sales Order Item Pricing Element

I_SalesOrderItemPricingElement (Basic)

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

Sales

I_SalesOrderItemPricingElement is a Basic CDS View that provides data about "Sales Order Item Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_SalesDocItemPricingElement) and exposes 67 fields with key fields SalesOrder, SalesOrderItem, PricingProcedureStep, PricingProcedureCounter.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-SO
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about pricing elements at sales order item level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItemPricingElement PricingElement from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Item Pricing Element view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSORDITMPREL 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

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SD Document
KEY SalesOrderItem Sales Document Item
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 the 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
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_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
_ConditionRateRatioUnit _ConditionRateRatioUnit

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_SalesOrderItemPricingElement.
-- 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_SalesOrderItemPricingElement AS
SELECT
  cast(SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  cast(SalesDocumentItem as sales_order_item preserving type) AS SalesOrderItem,
  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_SalesDocItemPricingElement AS PricingElement
;

Learn More