R_SettlmtDocItmCustPrcgElmnt

DDL: R_SETTLMTDOCITMCUSTPRCGELMNT Type: view COMPOSITE
86 Fields 1 Data Sources 3 Associations

Settlmt Doc Item Cust Pricing Element

R_SettlmtDocItmCustPrcgElmnt is a Composite CDS View that provides data about "Settlmt Doc Item Cust Pricing Element" in SAP S/4HANA. It reads from 1 data source (R_SetlMgmtDocItmCustPrcgElmnt) and exposes 86 fields with key fields SettlmtDoc, SettlmtDocItem, PricingProcedureStep, PricingProcedureCounter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SetlMgmtDocItmCustPrcgElmnt R_SetlMgmtDocItmCustPrcgElmnt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_SettlmtDoc _SettlmtDoc $projection.SettlmtDoc = _SettlmtDoc.SettlmtDoc
[1..1] R_SettlmtDocItem _SettlmtDocItem $projection.SettlmtDoc = _SettlmtDocItem.SettlmtDoc and $projection.SettlmtDocItem = _SettlmtDocItem.SettlmtDocItem
[0..1] I_UnitOfMeasure _RatioUnitOfMeasure $projection.ConditionRateRatioUnit = _RatioUnitOfMeasure.UnitOfMeasure

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RWLFSMTDCITCPREL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Settlmt Doc Item Cust Pricing Element view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc Document Number
KEY SettlmtDocItem Item
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionCurrency ConditionCurrency Currency
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionCategory ConditionCategory Condit.Category
ConditionIsForStatistics ConditionIsForStatistics Statistical
PricingScaleType PricingScaleType Scale Type
IsRelevantForAccrual IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin ConditionOrigin Condit.Origin
IsGroupCondition IsGroupCondition Group Condition
ConditionRecord ConditionRecord Cond.Record No.
ConditionSequentialNumber ConditionSequentialNumber SequNo of Cond.
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmount ConditionAmount Condition Value
TransactionCurrency TransactionCurrency Transaction Currency
ConditionControl ConditionControl Cond.Control
ConditionInactiveReason ConditionInactiveReason Inactive
ConditionClass ConditionClass Condition Class
PrcgProcedureCounterForHeader PrcgProcedureCounterForHeader Pricing Procedure Counter for Header
FactorForConditionBasisValue FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleBasis PricingScaleBasis Scale Basis
ConditionScaleBasisUnit ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency ConditionScaleBasisCurrency Scale Currency
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionIsForConfiguration ConditionIsForConfiguration UsedfVarConfig
VariantCondition VariantCondition Variant Key
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionBaseAmount ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity ConditionBaseQuantity Quantity
ConditionRateRatio ConditionRateRatio Ratio
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionScaleBaseAmount ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity ConditionScaleBaseQuantity Scale Base Qu.
ConditionBasisLimitExceeded ConditionBasisLimitExceeded Max Basis Value
ConditionAmountLimitExceeded ConditionAmountLimitExceeded Maximum Amount
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue Condit. Update
TaxCountry TaxCountry Tax Ctry/Reg.
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
CndnIsAcctDetnRelevant CndnIsAcctDetnRelevant Acct Detn Relevant
AccountKeyForGLAccount AccountKeyForGLAccount Account Key
GLAccount GLAccount General Ledger
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount Accruals
AccrualsGLAccount AccrualsGLAccount Accruals Acc.
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy Cumulative Condition Value
ExpenseSupplier ExpenseSupplier Expense Supplier
ExpenseCustomer ExpenseCustomer Expense Customer
PriceDetnExchangeRate PriceDetnExchangeRate Exchange Rate
_SettlmtDoc _SettlmtDoc
_SettlmtDocItem _SettlmtDocItem
_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
_RatioUnitOfMeasure _RatioUnitOfMeasure
_ConditionBasisLimitExceeded _ConditionBasisLimitExceeded
_ConditionAmountLimitExceeded _ConditionAmountLimitExceeded
_ConditionAlternativeCurrency _ConditionAlternativeCurrency
_Supplier _Supplier
_Customer _Customer

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_SettlmtDocItmCustPrcgElmnt.
-- 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_SettlmtDocItmCustPrcgElmnt AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_zr preserving type ) AS SettlmtDoc,
  cast( SettlmtMgmtDocItem as wposnr_lf preserving type ) AS SettlmtDocItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  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,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  CndnIsRelevantForIntcoBilling,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  ConditionRateAmount,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionBasisLimitExceeded,
  ConditionAmountLimitExceeded,
  CndnIsRelevantForLimitValue,
  TaxCountry,
  ConditionToBaseQtyDnmntr,
  ConditionToBaseQtyNmrtr,
  CndnIsAcctDetnRelevant,
  AccountKeyForGLAccount,
  GLAccount,
  AcctKeyForAccrualsGLAccount,
  AccrualsGLAccount,
  ConditionAlternativeCurrency,
  ConditionAmountInLocalCrcy,
  ExpenseSupplier,
  ExpenseCustomer,
  PriceDetnExchangeRate
FROM R_SetlMgmtDocItmCustPrcgElmnt
LEFT OUTER JOIN R_SettlmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [1..1]
LEFT OUTER JOIN R_SettlmtDocItem AS _SettlmtDocItem ON SettlmtDoc = _SettlmtDocItem.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItem.SettlmtDocItem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RatioUnitOfMeasure ON ConditionRateRatioUnit = _RatioUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More