I_SalesDocItemPricingElement

DDL: I_SALESDOCITEMPRICINGELEMENT Type: view BASIC
69 Fields 2 Data Sources

Sales Document Item Pricing Element

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

Data Sources (2)

SourceAliasJoin Type
I_PricingElement PricingElement from
I_SalesDocumentBasic SalesDocument inner

Annotations (11)

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

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentBasic SalesDocument SD Document
KEY SalesDocumentItem Item
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
PriceConditionDeterminationDte I_PricingElement PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType I_PricingElement ConditionCalculationType Calculat.Type
ConditionBaseValue I_PricingElement ConditionBaseValue Cond.Basis
ConditionRateValue I_PricingElement ConditionRateValue Condition Rate Value
ConditionCurrency I_PricingElement ConditionCurrency Currency
ConditionQuantity I_PricingElement ConditionQuantity Pricing Unit
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit Unit of Measure
ConditionCategory I_PricingElement ConditionCategory Condit.Category
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics Statistical
PricingScaleType I_PricingElement PricingScaleType Scale Type
IsRelevantForAccrual I_PricingElement IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList I_PricingElement CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin I_PricingElement ConditionOrigin Condit.Origin
IsGroupCondition I_PricingElement IsGroupCondition Group Condition
ConditionRecord I_PricingElement ConditionRecord Cond.Record No.
ConditionSequentialNumber I_PricingElement ConditionSequentialNumber SequNo of Cond.
TaxCode I_PricingElement TaxCode Tax Code
WithholdingTaxCode I_PricingElement WithholdingTaxCode WTax Code
CndnRoundingOffDiffAmount I_PricingElement CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmount I_PricingElement ConditionAmount Condition Value
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionControl I_PricingElement ConditionControl Cond.Control
ConditionInactiveReason I_PricingElement ConditionInactiveReason 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 Cond.
PeriodFactorForCndnBasisValue I_PricingElement PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleBasis I_PricingElement PricingScaleBasis Scale Basis
ConditionScaleBasisValue I_PricingElement ConditionScaleBasisValue Scale Base Val.
ConditionScaleBasisUnit I_PricingElement ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency I_PricingElement ConditionScaleBasisCurrency Scale Currency
CndnIsRelevantForIntcoBilling I_PricingElement CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionIsManuallyChanged I_PricingElement ConditionIsManuallyChanged Changed Manual.
ConditionIsForConfiguration I_PricingElement ConditionIsForConfiguration UsedfVarConfig
VariantCondition I_PricingElement VariantCondition Variant Key
ConditionRateAmount I_PricingElement ConditionRateAmount Condition Amount
ConditionRateRatio I_PricingElement ConditionRateRatio Ratio
ConditionRateRatioUnit I_PricingElement ConditionRateRatioUnit Unit of Measure
ConditionBaseAmount I_PricingElement ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity I_PricingElement ConditionBaseQuantity Quantity
SDDocumentCategory I_SalesDocumentBasic SDDocumentCategory Document Cat.
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_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_SalesDocItemPricingElement.
-- 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_SalesDocItemPricingElement AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  cast(PricingDocumentItem as posnr_va preserving type) AS SalesDocumentItem,
  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 */
;

Learn More