I_SetlMgmtDocSuplrPrcgElmnt

DDL: I_SETLMGMTDOCSUPLRPRCGELMNT Type: view BASIC
68 Fields 2 Data Sources 1 Associations

Settlmt Mgmt Doc Suplr Pricing Element

I_SetlMgmtDocSuplrPrcgElmnt is a Basic CDS View that provides data about "Settlmt Mgmt Doc Suplr Pricing Element" in SAP S/4HANA. It reads from 2 data sources (I_PricingElement, I_SettlmtMgmtDoc) and exposes 68 fields with key fields SettlmtMgmtDoc, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PricingElement PricingElement from
I_SettlmtMgmtDoc SetlMgmtDoc inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SettlmtMgmtDoc _SettlmtMgmtDoc $projection.SettlmtMgmtDoc = _SettlmtMgmtDoc.SettlmtMgmtDoc

Annotations (14)

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

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY SettlmtMgmtDoc I_SettlmtMgmtDoc SettlmtMgmtDoc Document Number
KEY PricingProcedureStep I_PricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter
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
ConditionQuantityendasConditionQuantity
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
FactorForConditionBasisValue
StructureCondition I_PricingElement StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue
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
SettlmtMgmtDocCat I_SettlmtMgmtDoc SettlmtMgmtDocCat Doc. Category
SettlmtPartnerCat I_SettlmtMgmtDoc SettlmtPartnerCat Settlmt Part Cat
SettlmtBusProcCat I_SettlmtMgmtDoc SettlmtBusProcCat Use Case Type
ConditionRateAmount I_PricingElement ConditionRateAmount Condition Amount
ConditionBaseAmount I_PricingElement ConditionBaseAmount Condition Basis Amount
ConditionRateRatio I_PricingElement ConditionRateRatio Ratio
ConditionRateRatioUnit I_PricingElement ConditionRateRatioUnit Unit of Measure
ConditionScaleBaseAmount I_PricingElement ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity I_PricingElement ConditionScaleBaseQuantity Scale Base Qu.
_SettlmtMgmtDoc _SettlmtMgmtDoc
_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

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_SetlMgmtDocSuplrPrcgElmnt.
-- 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_SetlMgmtDocSuplrPrcgElmnt AS
SELECT
  SetlMgmtDoc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  cast( PricingElement.PricingProcedureCounter as wlf_vfprc_cond_count preserving type ) 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,
  case when PricingElement.ConditionQuantityUnit is initial then 0 else PricingElement.ConditionQuantity end as ConditionQuantity AS ConditionQuantityendasConditionQuantity,
  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,
  cast( PricingElement.PrcgProcedureCounterForHeader as wlf_vfprc_cond_count_head preserving type ) AS PrcgProcedureCounterForHeader,
  cast( PricingElement.FactorForConditionBasisValue as wlf_kfaktor preserving type ) AS FactorForConditionBasisValue,
  PricingElement.StructureCondition AS StructureCondition,
  cast( PricingElement.PeriodFactorForCndnBasisValue as wlf_kfaktor1 preserving type ) 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,
  SetlMgmtDoc.SettlmtMgmtDocCat AS SettlmtMgmtDocCat,
  SetlMgmtDoc.SettlmtPartnerCat AS SettlmtPartnerCat,
  SetlMgmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
  PricingElement.ConditionRateAmount AS ConditionRateAmount,
  PricingElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingElement.ConditionRateRatio AS ConditionRateRatio,
  PricingElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PricingElement.ConditionScaleBaseAmount AS ConditionScaleBaseAmount,
  PricingElement.ConditionScaleBaseQuantity AS ConditionScaleBaseQuantity,
  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
FROM I_PricingElement AS PricingElement
INNER JOIN I_SettlmtMgmtDoc AS SetlMgmtDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SettlmtMgmtDoc AS _SettlmtMgmtDoc ON SettlmtMgmtDoc = _SettlmtMgmtDoc.SettlmtMgmtDoc  -- association [1..1]
;

Learn More