R_TrdgDocItmSlsPrcgElmnt

DDL: R_TRDGDOCITMSLSPRCGELMNT Type: view_entity COMPOSITE
86 Fields 3 Data Sources 1 Associations

Sales Pricing Element of Trading Doc Itm

R_TrdgDocItmSlsPrcgElmnt is a Composite CDS View that provides data about "Sales Pricing Element of Trading Doc Itm" in SAP S/4HANA. It reads from 3 data sources (R_TrdgDocItemBasic, I_PricingElement, R_TrdgDocHeaderBasic) and exposes 86 fields with key fields TradingDocument, TradingDocumentItem, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
R_TrdgDocItemBasic DocItem from
I_PricingElement PricingElement inner
R_TrdgDocHeaderBasic TrdgDocHeader inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgDoc _TrdgDoc $projection.TradingDocument = _TrdgDoc.TradingDocument

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Pricing Element of Trading Doc Itm view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.technicalName RITMSLSPRCGELMNT view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY TradingDocument R_TrdgDocItemBasic TradingDocument Trading Contract
KEY TradingDocumentItem R_TrdgDocItemBasic TradingDocumentItem Item Number
KEY PricingProcedureStep I_PricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter
PricingDocumentItem
PricingDocument I_PricingElement PricingDocument Document Condition
ConditionApplication I_PricingElement ConditionApplication Application
ConditionType I_PricingElement ConditionType Condition type
PriceConditionDeterminationDte
ConditionCalculationType I_PricingElement ConditionCalculationType Calculat.Type
ConditionBaseAmount
ConditionRateAmount I_PricingElement ConditionRateAmount Condition Amount
ConditionRateRatio
ConditionRateRatioUnit
ConditionCurrency
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit Unit of Measure
ConditionCategory I_PricingElement ConditionCategory Condit.Category
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics Statistical
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
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionControl I_PricingElement ConditionControl Cond.Control
ConditionInactiveReason I_PricingElement ConditionInactiveReason Inactive
ConditionClass I_PricingElement ConditionClass Condition Class
PrcgProcedureCounterForHeader
FactorForConditionBasisValue
StructureCondition I_PricingElement StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue
PricingScaleType I_PricingElement PricingScaleType Scale Type
PricingScaleBasis I_PricingElement PricingScaleBasis Scale Basis
ConditionScaleBaseAmount I_PricingElement ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity I_PricingElement ConditionScaleBaseQuantity Scale Base Qu.
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
ConditionBasisLimitExceeded I_PricingElement ConditionBasisLimitExceeded Max Basis Value
ConditionAmountLimitExceeded I_PricingElement ConditionAmountLimitExceeded Maximum Amount
CndnIsRelevantForLimitValue I_PricingElement CndnIsRelevantForLimitValue Condit. Update
TaxCountry I_PricingElement TaxCountry Tax Ctry/Reg.
ConditionToBaseQtyNmrtr I_PricingElement ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr I_PricingElement ConditionToBaseQtyDnmntr Denominator
CndnIsAcctDetnRelevant I_PricingElement CndnIsAcctDetnRelevant Acct Detn Relevant
AccountKeyForGLAccount I_PricingElement AccountKeyForGLAccount Account Key
GLAccount I_PricingElement GLAccount General Ledger
AcctKeyForAccrualsGLAccount I_PricingElement AcctKeyForAccrualsGLAccount Accruals
AccrualsGLAccount I_PricingElement AccrualsGLAccount Accruals Acc.
ConditionAlternativeCurrency
ConditionAmountInLocalCrcy
ExpenseSupplier
PriceDetnExchangeRate
_TrdgDoc _TrdgDoc
OrganizationDivision R_TrdgDocHeaderBasic OrganizationDivision Org. Division
SoldToParty R_TrdgDocHeaderBasic SoldToParty Sold-to Party
DistributionChannel R_TrdgDocHeaderBasic DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization R_TrdgDocHeaderBasic SalesOrganization Sales Organization
_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
_ConditionBasisLimitExceeded I_PricingElement _ConditionBasisLimitExceeded
_ConditionAmountLimitExceeded I_PricingElement _ConditionAmountLimitExceeded
_ConditionAlternativeCurrency I_PricingElement _ConditionAlternativeCurrency
_Supplier I_PricingElement _Supplier

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 R_TrdgDocItmSlsPrcgElmnt.
-- 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 R_TrdgDocItmSlsPrcgElmnt AS
SELECT
  DocItem.TradingDocument AS TradingDocument,
  DocItem.TradingDocumentItem AS TradingDocumentItem,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  cast( PricingElement.PricingProcedureCounter as wlf_vfprc_cond_count preserving type ) AS PricingProcedureCounter,
  cast(PricingElement.PricingDocumentItem as wb2_trading_contract_item preserving type) AS PricingDocumentItem,
  PricingElement.PricingDocument AS PricingDocument,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  cast( PricingElement.PriceConditionDeterminationDte as wb2_cond_prc_date preserving type ) AS PriceConditionDeterminationDte,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  cast( PricingElement.ConditionBaseAmount as wb2_cond_base_amount preserving type ) AS ConditionBaseAmount,
  PricingElement.ConditionRateAmount AS ConditionRateAmount,
  cast( PricingElement.ConditionRateRatio as wb2_cond_rate_ratio preserving type ) AS ConditionRateRatio,
  cast( PricingElement.ConditionRateRatioUnit as wb2_cond_ratio_unit preserving type ) AS ConditionRateRatioUnit,
  cast( PricingElement.ConditionCurrency as wb2_cond_currency preserving type ) AS ConditionCurrency,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionCategory AS ConditionCategory,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  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,
  cast( PricingElement.ConditionAmount as wb2_cond_amount ) AS ConditionAmount,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionControl AS ConditionControl,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement.ConditionClass AS ConditionClass,
  cast( PricingElement.PrcgProcedureCounterForHeader as wb2_cond_count_head preserving type ) AS PrcgProcedureCounterForHeader,
  cast( PricingElement.FactorForConditionBasisValue as wb2_cond_base_val_factor preserving type ) AS FactorForConditionBasisValue,
  PricingElement.StructureCondition AS StructureCondition,
  cast( PricingElement.PeriodFactorForCndnBasisValue as wb2_cond_base_val_per_factor preserving type ) AS PeriodFactorForCndnBasisValue,
  PricingElement.PricingScaleType AS PricingScaleType,
  PricingElement.PricingScaleBasis AS PricingScaleBasis,
  PricingElement.ConditionScaleBaseAmount AS ConditionScaleBaseAmount,
  PricingElement.ConditionScaleBaseQuantity AS ConditionScaleBaseQuantity,
  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.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  PricingElement.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  PricingElement.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  PricingElement.TaxCountry AS TaxCountry,
  PricingElement.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  PricingElement.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  PricingElement.CndnIsAcctDetnRelevant AS CndnIsAcctDetnRelevant,
  PricingElement.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  PricingElement.GLAccount AS GLAccount,
  PricingElement.AcctKeyForAccrualsGLAccount AS AcctKeyForAccrualsGLAccount,
  PricingElement.AccrualsGLAccount AS AccrualsGLAccount,
  cast( PricingElement.ConditionAlternativeCurrency as wb2_cndn_crcy preserving type ) AS ConditionAlternativeCurrency,
  cast( PricingElement.ConditionAmountInLocalCrcy as wb2_cond_amount_lcl_currency preserving type ) AS ConditionAmountInLocalCrcy,
  cast( PricingElement.FreightSupplier as wb2_expense_supplier preserving type ) AS ExpenseSupplier,
  cast( PricingElement.PriceDetnExchangeRate as wb2_cond_ext_rate preserving type ) AS PriceDetnExchangeRate,
  TrdgDocHeader.OrganizationDivision AS OrganizationDivision,
  TrdgDocHeader.SoldToParty AS SoldToParty,
  TrdgDocHeader.DistributionChannel AS DistributionChannel,
  TrdgDocHeader.SalesOrganization AS SalesOrganization,
  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._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  PricingElement._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  PricingElement._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  PricingElement._Supplier AS _Supplier
FROM R_TrdgDocItemBasic AS DocItem
INNER JOIN R_TrdgDocHeaderBasic AS TrdgDocHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_PricingElement AS PricingElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;

Learn More