What is I_SalesDocumentPricingElement in SAP S/4HANA?

I_SalesDocumentPricingElement is a basic CDS view in SAP S/4HANA. Sales Document Pricing Element It contains 67 fields.

Which tables does I_SalesDocumentPricingElement read from?

I_SalesDocumentPricingElement reads data from: I_PricingElement, I_SalesDocumentBasic.

What VDM layer is I_SalesDocumentPricingElement?

I_SalesDocumentPricingElement is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SalesDocumentPricingElement

DDL: I_SALESDOCUMENTPRICINGELEMENT Type: view BASIC

67 Fields 2 Data Sources

Sales Document Pricing Element

I_SalesDocumentPricingElement (Basic)

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

Sales

I_SalesDocumentPricingElement is a Basic CDS View that provides data about "Sales Document Pricing Element" in SAP S/4HANA. It reads from 2 data sources (I_PricingElement, I_SalesDocumentBasic) and exposes 67 fields with key fields SalesDocument, PricingProcedureStep, PricingProcedureCounter.

SAP API Hub

State	C1
Line of Business	Sales
Application Component	SD-SLS
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering questions about pricing elements at sales document header level. Example business questions could include:</p> <ul> <li><p>How often were discounts given in the last year?</p></li> <li><p>What was the price amount used for a sales document?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
I_PricingElement	PricingElement	from
I_SalesDocumentBasic	SalesDocument	inner

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Sales Document Pricing Element	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ISDSLSDOCPREL	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)

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

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_SalesDocumentPricingElement.
-- 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_SalesDocumentPricingElement AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  PricingElement.PricingDateTime AS PricingDateTime,
  PricingElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  PricingElement.ConditionBaseValue AS ConditionBaseValue,
  PricingElement.ConditionRateValue AS ConditionRateValue,
  PricingElement.ConditionCurrency AS ConditionCurrency,
  PricingElement.ConditionQuantity AS ConditionQuantity,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionCategory AS ConditionCategory,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.PricingScaleType AS PricingScaleType,
  PricingElement.IsRelevantForAccrual AS IsRelevantForAccrual,
  PricingElement.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  PricingElement.ConditionOrigin AS ConditionOrigin,
  PricingElement.IsGroupCondition AS IsGroupCondition,
  PricingElement.ConditionRecord AS ConditionRecord,
  PricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
  PricingElement.TaxCode AS TaxCode,
  PricingElement.WithholdingTaxCode AS WithholdingTaxCode,
  PricingElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionControl AS ConditionControl,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement.ConditionClass AS ConditionClass,
  PricingElement.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  PricingElement.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  PricingElement.StructureCondition AS StructureCondition,
  PricingElement.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  PricingElement.PricingScaleBasis AS PricingScaleBasis,
  PricingElement.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  PricingElement.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  PricingElement.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  PricingElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  PricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  PricingElement.VariantCondition AS VariantCondition,
  PricingElement.ConditionRateAmount AS ConditionRateAmount,
  PricingElement.ConditionRateRatio AS ConditionRateRatio,
  PricingElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PricingElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingElement.ConditionBaseQuantity AS ConditionBaseQuantity,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  PricingElement._ConditionApplication AS _ConditionApplication,
  PricingElement._PricingConditionType AS _PricingConditionType,
  PricingElement._ConditionCalculationType AS _ConditionCalculationType,
  PricingElement._ConditionCurrency AS _ConditionCurrency,
  PricingElement._Currency AS _Currency,
  PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
  PricingElement._ConditionCategory AS _ConditionCategory,
  PricingElement._ConditionOrigin AS _ConditionOrigin,
  PricingElement._ConditionControl AS _ConditionControl,
  PricingElement._ConditionInactiveReason AS _ConditionInactiveReason,
  PricingElement._ConditionClass AS _ConditionClass,
  PricingElement._PricingScaleBasis AS _PricingScaleBasis,
  PricingElement._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  PricingElement._ScaleCurrency AS _ScaleCurrency,
  PricingElement._VariantCondition AS _VariantCondition,
  PricingElement._StructureCondition AS _StructureCondition,
  PricingElement._ConditionRateRatioUnit AS _ConditionRateRatioUnit,
  SalesDocument._SDDocumentCategory AS _SDDocumentCategory
FROM I_PricingElement AS PricingElement
INNER JOIN I_SalesDocumentBasic AS SalesDocument ON /* join condition not captured in parsed metadata */
;

Depth:

I_SalesDocumentPricingElement view

I_PricingElement view
I_SalesDocumentBasic view