C_MngSettlmtDocsSuplrPrcgElmnt

DDL: C_MNGSETTLMTDOCSSUPLRPRCGELMNT Type: view_entity CONSUMPTION

Mng Settlmt Doc Suplr Pricing Element

C_MngSettlmtDocsSuplrPrcgElmnt is a Consumption CDS View that provides data about "Mng Settlmt Doc Suplr Pricing Element" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocSuplrPrcgElmntTP) and exposes 51 fields with key fields SettlmtDoc, PricingProcedureStep, PricingProcedureCounter.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocSuplrPrcgElmntTP R_SettlmtDocSuplrPrcgElmntTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Mng Settlmt Doc Suplr Pricing Element view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.query.implementedBy ABAP:CL_WLF_SDOC_F3254_PRCG_HDR_SUP view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionType ConditionType Condition type
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionRateRatio Ratio
ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity Quantity
ConditionQuantity ConditionQuantity Pricing Unit
ConditionAmount ConditionAmount Condition Value
IsRelevantForAccrual IsRelevantForAccrual Accruals
ConditionCurrency ConditionCurrency Currency
TransactionCurrency TransactionCurrency Transaction Currency
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics ConditionIsForStatistics Statistical
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason ConditionInactiveReason Inactive
int1
virtualUICT_CndPricingUnitHiddenboolean
virtualUICT_ValueIsHiddenboolean
virtualUICT_BaseAmountIsHiddenboolean
virtualUICT_BaseQuantityIsHiddenboolean
ConditionApplication ConditionApplication Application
ConditionClass ConditionClass Condition Class
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionCategory ConditionCategory Condit.Category
ConditionControl ConditionControl Cond.Control
ConditionOrigin ConditionOrigin Condit.Origin
TaxCode TaxCode Tax Code
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy Cumulative Condition Value
ConditionApplicationNamelocalized
ConditionCalculationTypeNamelocalized
ConditionCategoryNamelocalized
ConditionClassNamelocalized
ConditionControlNamelocalized
ConditionOriginNamelocalized
ConditionInactiveReasonNamelocalized
virtualTaxCodeNamefis_mwskz_name
_ConditionApplication _ConditionApplication
_ConditionCalculationType _ConditionCalculationType
_ConditionCategory _ConditionCategory
_ConditionClass _ConditionClass
_ConditionControl _ConditionControl
_ConditionCurrency _ConditionCurrency
_ConditionInactiveReason _ConditionInactiveReason
_ConditionQuantityUnit _ConditionQuantityUnit
_ConditionOrigin _ConditionOrigin
_Currency _Currency
_PricingConditionType _PricingConditionType
_RatioUnitOfMeasure _RatioUnitOfMeasure

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 C_MngSettlmtDocsSuplrPrcgElmnt.
-- 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 C_MngSettlmtDocsSuplrPrcgElmnt AS
SELECT
  SettlmtDoc,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionType,
  ConditionRateAmount,
  cast( ConditionRateRatio as wlf_prcg_element_ratio preserving type ) AS ConditionRateRatio,
  cast( ConditionBaseAmount as wlf_prcg_element_base_amount preserving type ) AS ConditionBaseAmount,
  cast ( ConditionBaseQuantity as wlf_prcg_element_base_quantity preserving type ) AS ConditionBaseQuantity,
  ConditionQuantity,
  ConditionAmount,
  IsRelevantForAccrual,
  ConditionCurrency,
  TransactionCurrency,
  ConditionQuantityUnit,
  ConditionRateRatioUnit,
  ConditionIsForStatistics,
  ConditionIsManuallyChanged,
  ConditionInactiveReason,
  virtual UICT_ConditionTypeCriticality : abap.int1 AS int1,
  virtual UICT_CndPricingUnitHidden : boolean AS virtualUICT_CndPricingUnitHiddenboolean,
  virtual UICT_ValueIsHidden : boolean AS virtualUICT_ValueIsHiddenboolean,
  virtual UICT_BaseAmountIsHidden : boolean AS virtualUICT_BaseAmountIsHiddenboolean,
  virtual UICT_BaseQuantityIsHidden : boolean AS virtualUICT_BaseQuantityIsHiddenboolean,
  ConditionApplication,
  ConditionClass,
  ConditionCalculationType,
  ConditionCategory,
  ConditionControl,
  ConditionOrigin,
  TaxCode,
  ConditionAmountInLocalCrcy,
  _ConditionApplication._Text.ConditionApplicationName : localized AS ConditionApplicationNamelocalized,
  _ConditionCalculationType._Text.ConditionCalculationTypeName : localized AS ConditionCalculationTypeNamelocalized,
  _ConditionCategory._Text.ConditionCategoryName : localized AS ConditionCategoryNamelocalized,
  _ConditionClass._Text.ConditionClassName : localized AS ConditionClassNamelocalized,
  _ConditionControl._Text.ConditionControlName : localized AS ConditionControlNamelocalized,
  _ConditionOrigin._Text.ConditionOriginName : localized AS ConditionOriginNamelocalized,
  _ConditionInactiveReason._Text.ConditionInactiveReasonName : localized AS ConditionInactiveReasonNamelocalized,
  virtual TaxCodeName : fis_mwskz_name AS virtualTaxCodeNamefis_mwskz_name
FROM R_SettlmtDocSuplrPrcgElmntTP
;