C_MngSettlmtDocsSuplrPrcgElmnt
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)
| Source | Alias | Join Type |
|---|---|---|
| R_SettlmtDocSuplrPrcgElmntTP | R_SettlmtDocSuplrPrcgElmntTP | projection |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA