I_SlsQtanConversionRateCube
Sales Quotation Conversion Rate - Cube
I_SlsQtanConversionRateCube (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Sales
I_SlsQtanConversionRateCube is a Composite CDS View (Cube) that provides data about "Sales Quotation Conversion Rate - Cube" in SAP S/4HANA. It reads from 1 data source (I_SlsQtanCnvrsnRateAnalytics) and exposes 35 fields with key fields SalesQuotation, SalesQuotationItem. It has 1 association to related views.
SAP Help Documentation
| Category | Sales Quotation |
|---|---|
| Data Category | Cube |
| Status | Released |
Purpose
This CDS view provides quotation conversion rates by various dimensions such as sales organization, customer, product, and sales office, among others. It provides the prerequisites for answering the following business questions: What is the proportion of quotations that have been converted into sales orders? What is the net value of converted quotations? What is the net value of a given quotation? Is a given quotation still within its validity period? By how much does actual quotation conversion rate deviate from the predicted rate? Note Only sales quotation items that meet the following condition are considered in this CDS view. Reference is relevant for quotation item completion. When this condition is met, the system takes into account the preset reference-related completion rule (for example, item completed upon first reference) when evaluating whether a sales quotation item is completed. You can find the completion rule in Customizing settings for item category. If no completion rule has been specified, reference is not relevant for quotation item completion.
Prerequisites
Users who want to run reports using this CDS view must have read access to: Sales document type Sales organization Distribution channel Division
Structure
Object types This view is built on the following object type: Sales Quotation Main CDS parameters and filters The main CDS parameters are: P_Date : used to specify the date on which your report is generated. P_ExchangeRateType : used to specify the exchange rate type for currency conversion. P_DisplayCurrency : used to specify the target currency for currency conversion. No filters are provided. Measures and attributes The following table explains the most important measures in the view. Measure Description SalesQuotationNetAmtInDspCrcy Net value of sales quotations in display currency CnvrtdSalesQtanNetAmtInDspCrcy Net value of sales quotation items that have been converted to sales orders in display currency SlsQtanPeriodElapsedPercent Percentage of elapsed time over quotation validity period SlsQtanPeriodDueDays Number of days before the quotation expires PrdtvSlsQtanCnvrsnRate Predicted quotation conversion rate PrdtvSlsQtanCnvrsnAmtInDspCrcy Predicted order value in display currency The net value predicted to be converted from quotations to sales orders Note The prediction is based on an active version of the default model in the predefined predictive scenario for quotation conversion rate ( SLSQTANPREDICTION ). For more information about how to make predictions, see Quotation Conversion Rates - Valid/Not Completed . For currency conversion, the exchange rate is determined by the exchange rate type and the creation date of the sales quotation item. Some important attributes are: Sales quotation Sales quotation item Sales organization Sold-to party Product
This CDS view provides quotation conversion rates by various dimensions such as sales organization, customer, product, and sales office, among others. It provides the prerequisites for answering the following business questions: What is the proportion of quotations that have been converted into sales orders? What is the net value of converted quotations? What is the net value of a given quotation? Is a given quotation still within its validity period? By how much does actual quotation conversion rate deviate from the predicted rate? Note Only sales quotation items that meet the following condition are considered in this CDS view. Reference is relevant for quotation item completion. When this condition is met, the system takes into account the preset reference-related completion rule (for example, item completed upon first reference) when evaluating whether a sales quotation item is completed. You can find the completion rule in Customizing settings for item category. If no completion rule has been specified, reference is not relevant for quotation item completion.
Prerequisites
Users who want to run reports using this CDS view must have read access to: Sales document type Sales organization Distribution channel Division
Structure
Object types This view is built on the following object type: Sales Quotation Main CDS parameters and filters The main CDS parameters are: P_Date : used to specify the date on which your report is generated. P_ExchangeRateType : used to specify the exchange rate type for currency conversion. P_DisplayCurrency : used to specify the target currency for currency conversion. No filters are provided. Measures and attributes The following table explains the most important measures in the view. Measure Description SalesQuotationNetAmtInDspCrcy Net value of sales quotations in display currency CnvrtdSalesQtanNetAmtInDspCrcy Net value of sales quotation items that have been converted to sales orders in display currency SlsQtanPeriodElapsedPercent Percentage of elapsed time over quotation validity period SlsQtanPeriodDueDays Number of days before the quotation expires PrdtvSlsQtanCnvrsnRate Predicted quotation conversion rate PrdtvSlsQtanCnvrsnAmtInDspCrcy Predicted order value in display currency The net value predicted to be converted from quotations to sales orders Note The prediction is based on an active version of the default model in the predefined predictive scenario for quotation conversion rate ( SLSQTANPREDICTION ). For more information about how to make predictions, see Quotation Conversion Rates - Valid/Not Completed . For currency conversion, the exchange rate is determined by the exchange rate type and the creation date of the sales quotation item. Some important attributes are: Sales quotation Sales quotation item Sales organization Sold-to party Product
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Sales |
| Application Component | SD-ANA |
| Capabilities | Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities |
| Package | Sales for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view provides quotation conversion rates by various dimensions such as sales organization, customer, product, and sales office, among others. It provides the prerequisites for answering the following business questions:</p> <p> </p> <ul> <li><p>What is the proportion of quotations that have been converted into sales orders?</p></li> <li><p>What is the net value of converted quotations?</p></li> <li><p>What is the net value of a given quotation?</p></li> <li><p>Is a given quotation still within its validity period?</p></li> <li><p>By how much does actual quotation conversion rate deviate from the predicted rate?</p></li> </ul> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SlsQtanCnvrsnRateAnalytics | I_SlsQtanCnvrsnRateAnalytics | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_Date | sydate | |
| P_ExchangeRateType | kurst | |
| P_DisplayCurrency | vdm_v_display_currency |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_SalesDocumentItemBasic | _Extension | $projection.SalesQuotation = _Extension.SalesDocument and $projection.SalesQuotationItem = _Extension.SalesDocumentItem |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Quotation Conversion Rate - Cube | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | ISDSLSQTANCRC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Analytics.dataCategory | #CUBE | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (35)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesQuotation | SalesQuotation | Sales Quotation | |
| KEY | SalesQuotationItem | SalesQuotationItem | Sales Quotation Item | |
| SalesQuotationType | SalesQuotationType | Sales Document Type | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| _SalesOrganization | _SalesOrganization | |||
| DistributionChannel | DistributionChannel | Distribution Channel | ||
| _DistributionChannel | _DistributionChannel | |||
| OrganizationDivision | OrganizationDivision | Org. Division | ||
| _OrganizationDivision | _OrganizationDivision | |||
| SalesOffice | SalesOffice | Sales Office | ||
| _SalesOffice | _SalesOffice | |||
| SalesGroup | SalesGroup | Sales Group | ||
| _SalesGroup | _SalesGroup | |||
| PartnerCompany | _SoldToParty | TradingPartner | Company ID of Trading Partner | |
| _GlobalCompany | _SoldToParty | _GlobalCompany | ||
| SoldToParty | SoldToParty | Sold-to Party | ||
| _SoldToParty | _SoldToParty | |||
| ResponsibleEmployee | ResponsibleEmployee | Employee Responsible | ||
| _ResponsibleEmployee | _ResponsibleEmployee | |||
| SalesEmployee | SalesEmployee | Sales Employee | ||
| _SalesEmployee | _SalesEmployee | |||
| CreationDate | CreationDate | Record Created On | ||
| BindingPeriodValidityStartDate | BindingPeriodValidityStartDate | Quotation/Inquiry is Valid From | ||
| BindingPeriodValidityEndDate | BindingPeriodValidityEndDate | Date Until Which Bid/Quotation is Binding (Valid-To Date) | ||
| Material | Material | Material Number | ||
| Product | Product | Product Number | ||
| _Product | _Product | |||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| _TransactionCurrency | _TransactionCurrency | |||
| DisplayCurrency | Display Currency | |||
| SalesQuotationNetAmount | SalesQuotationNetAmount | Net Value of the Document Item in Document Currency | ||
| CnvrtdSalesQuotationNetAmount | CnvrtdSalesQuotationNetAmount | Converted Sales Quotation Net Amount | ||
| SlsQtanPeriodElapsedPercent | SlsQtanPeriodElapsedPercent | Sales Quotation Period Elapsed Percent | ||
| PrdtvSlsQtanCnvrsnRate | PrdtvSlsQtanCnvrsnRate | Predicted Sales Quotation Conversion Rate | ||
| PrdtvSlsQtanCnvrsnAmount | PrdtvSlsQtanCnvrsnAmount | Predicted Order Value in Transaction Currency |
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_SlsQtanConversionRateCube.
-- 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.
-- Parameters: P_Date : sydate, P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency
CREATE VIEW I_SlsQtanConversionRateCube AS
SELECT
SalesQuotation,
SalesQuotationItem,
SalesQuotationType,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SalesOffice,
SalesGroup,
_SoldToParty.TradingPartner AS PartnerCompany,
_SoldToParty._GlobalCompany AS _GlobalCompany,
SoldToParty,
ResponsibleEmployee,
SalesEmployee,
CreationDate,
BindingPeriodValidityStartDate,
BindingPeriodValidityEndDate,
Material,
Product,
TransactionCurrency,
cast( :P_DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
SalesQuotationNetAmount,
CnvrtdSalesQuotationNetAmount,
SlsQtanPeriodElapsedPercent,
PrdtvSlsQtanCnvrsnRate,
PrdtvSlsQtanCnvrsnAmount
FROM I_SlsQtanCnvrsnRateAnalytics
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesQuotation = _Extension.SalesDocument AND SalesQuotationItem = _Extension.SalesDocumentItem -- association [0..1]
;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