What is C_SalesQuotationItemQry in SAP S/4HANA?

C_SalesQuotationItemQry is a consumption CDS view in SAP S/4HANA. Sales Quotation Item - Query It contains 126 fields.

Which tables does C_SalesQuotationItemQry read from?

C_SalesQuotationItemQry reads data from: I_SalesQuotationItemCube_2.

What VDM layer is C_SalesQuotationItemQry?

C_SalesQuotationItemQry is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SalesQuotationItemQry

DDL: C_SALESQUOTATIONITEMQRY Type: view CONSUMPTION

126 Fields 1 Data Sources

Sales Quotation Item - Query

C_SalesQuotationItemQry (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

C_SalesQuotationItemQry is a Consumption CDS View that provides data about "Sales Quotation Item - Query" in SAP S/4HANA. It reads from 1 data source (I_SalesQuotationItemCube_2) and exposes 126 fields with key fields SalesQuotation, SalesQuotationItem.

SAP Help Documentation

Category	Sales Quotation
Data Category	Query
Status	Released
Corresponding DataSource	2CCSDSLSQTANITMQRY

Purpose
This CDS view provides prerequisites for analyzing sales quotations on a variety of dimensions. It answers the following business questions: What are the net amounts of my sales quotations on a month-to-month basis? What is the item quantity of my sales quotations? Have my quotations been converted to orders? To what extent? What are the current situations of my quotations? Are they expiring, expired, or rejected?

Prerequisites
This query is built on top of the cube view Sales Quotation Item - Cube ( I_SalesQuotationItemCube_2 ). You can use this query to create sales reports. Users who want to run these reports must have the relevant authorizations as required for using the cube view (see Sales Quotation Item - Cube ).

Structure
Object types This view is built on the business object of sales quotation. Main input parameters P_ExchangeRateType used to specify the exchange rate type for currency conversion. The default value is M (average rate). P_DisplayCurrency used to specify the target currency for currency conversion 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 SalesQuotationConversionRate Quotation conversion rate The percentage of the net value of order items that have been converted from a quotation item, based on the total net value of quotation items. SalesQuotationQuantity Quantity of sales quotation items SlsQuotationOpenNetAmtInDC Net value of open quotation items in display currency Quotation items that are not fully referenced or rejected. NmbrOfOpenSlsQuotationItems Number of open quotation items SlsQuotationExpiredNetAmtInDC Net value of expired quotations in display currency Quotations of which the validity ends today or has ended before today. NmbrOfExpiredSlsQuotationItems Number of items in expired quotations SlsQuotationExpiringNetAmtInDC Net value of expiring quotations in display currency Quotations of which the validity ends in seven days or less from today. NmbrOfExprgSlsQuotationItems Number of items in expiring quotations SlsQtanRejectedNetAmountInDC Net value of rejected quotation items NmbrOfRejectedSlsQtanItems Number of rejected quotation items Note For currency conversion, the exchange rate is determined by the specified exchange rate type and the creation date of the sales quotation item. Some important attributes are: Sales quotation ( SalesQuotation ) Sales quotation item ( SalesQuotationItem ) Quotation valid-from date ( BindingPeriodValidityStartDate ) Quotation valid-to date ( BindingPeriodValidityEndDate ) Sales organization ( SalesOrganization ) Product ( Product ) Sold-to party ( SoldToParty )

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sales
Application Component	SD-ANA
Capabilities	Analytical Query
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides prerequisites for analyzing sales quotations on a variety of dimensions. It answers the following business questions:</p> <ul> <li><p>What are the net amounts of my sales quotations on a month-to-month basis?</p></li> <li><p>What is the item quantity of my sales quotations?</p></li> <li><p>Have my quotations been converted to orders? To what extent?</p></li> <li><p>What are the current situations of my quotations? Are they expiring, expired, or rejected?</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_SalesQuotationItemCube_2	I_SalesQuotationItemCube_2	from

Parameters (2)

Name	Type	Default
P_ExchangeRateType	kurst
P_DisplayCurrency	vdm_v_display_currency

Annotations (14)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Sales Quotation Item - Query	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AbapCatalog.sqlViewName	CSDSLSQTANITMQRY	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
Analytics.query	true	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
OData.publish	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (126)

Key	Field	Source Field	Description
KEY	SalesQuotation	SalesQuotation	Sales Quotation
KEY	SalesQuotationItem	SalesQuotationItem	Sales Quotation Item
	SalesQuotationType	SalesQuotationType	Sales Document Type
	SalesQuotationItemType	SalesQuotationItemType	Item Type
	SalesQuotationItemCategory	SalesQuotationItemCategory	Sales Document Item Category
	CreatedByUser	CreatedByUser	Name of Person Responsible for Creating the Object
	CreationDate	CreationDate	Record Created On
	CreationTime	CreationTime	Time at Which Record Was Created
	LastChangeDate	LastChangeDate	Last Changed On
	CreationDateYear	CreationDateYear	Year of Creation
	CreationDateYearQuarter	CreationDateYearQuarter	Year/Quarter of Creation
	CreationDateYearMonth	CreationDateYearMonth	Year/Month of Creation
	SalesQuotationDate	SalesQuotationDate	Document Date (Date Received/Sent)
	SalesQuotationDateYear	SalesQuotationDateYear	Year of Quotation
	SalesQuotationDateYearQuarter	SalesQuotationDateYearQuarter	Quarter of Quotation
	SalesQuotationDateYearMonth	SalesQuotationDateYearMonth	Month of Quotation
	BindingPeriodValidityStartDate	BindingPeriodValidityStartDate	Quotation/Inquiry is Valid From
	BindingPeriodValidityEndDate	BindingPeriodValidityEndDate	Date Until Which Bid/Quotation is Binding (Valid-To Date)
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	OrganizationDivision	OrganizationDivision	Organization Division
	SalesOffice	SalesOffice	Sales Office
	SalesGroup	SalesGroup	Sales Group
	PartnerCompany	PartnerCompany	Company ID of Trading Partner
	SoldToParty	SoldToParty	Sold-to Party
	CustomerGroup	CustomerGroup	Customer Group
	AdditionalCustomerGroup1	AdditionalCustomerGroup1	Customer Group 1
	AdditionalCustomerGroup2	AdditionalCustomerGroup2	Customer Group 2
	AdditionalCustomerGroup3	AdditionalCustomerGroup3	Customer Group 3
	AdditionalCustomerGroup4	AdditionalCustomerGroup4	Customer Group 4
	AdditionalCustomerGroup5	AdditionalCustomerGroup5	Customer Group 5
	SDDocumentReason	SDDocumentReason	Order Reason (Reason for the Business Transaction)
	CustomerPurchaseOrderType	CustomerPurchaseOrderType	Customer Purchase Order Type
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Purchase Order Number
	CustomerPurchaseOrderDate	CustomerPurchaseOrderDate	Customer Reference Date
	SalesQuotationItemText	SalesQuotationItemText	Short text for sales order item
	SalesDocumentRjcnReason	SalesDocumentRjcnReason	Reason for Rejection of Sales Documents
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	RequestedDeliveryDate	RequestedDeliveryDate	Requested Delivery Date
	ShippingCondition	ShippingCondition	Shipping Conditions
	CompleteDeliveryIsDefined	CompleteDeliveryIsDefined	Complete Delivery Defined for Each Sales Order
	DeliveryBlockReason	DeliveryBlockReason	Delivery Block (Document Header)
	ShippingPoint	ShippingPoint	Shipping Point / Receiving Point
	DeliveryPriority	DeliveryPriority	Delivery Priority
	ShippingType	ShippingType	Shipping Type
	Route	Route	Vehicle route
	Product	Product	Product Number
	OriginallyRequestedMaterial	OriginallyRequestedMaterial	Material Entered
	MaterialByCustomer	MaterialByCustomer	Material Number Used by Customer
	ProductGroup	ProductGroup	Product Sold Group
	AdditionalMaterialGroup1	AdditionalMaterialGroup1	Material Group 1
	AdditionalMaterialGroup2	AdditionalMaterialGroup2	Material Group 2
	AdditionalMaterialGroup3	AdditionalMaterialGroup3	Material Group 3
	AdditionalMaterialGroup4	AdditionalMaterialGroup4	Material Group 4
	AdditionalMaterialGroup5	AdditionalMaterialGroup5	Material Group 5
	Division	Division	Internal Division ID
	Plant	Plant	Plant (Own or External)
	StorageLocation	StorageLocation	Storage Location
	MainItemPricingRefProduct	MainItemPricingRefProduct	Pricing Reference Product of Main Item
	HigherLevelItem	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	BillOfMaterial	BillOfMaterial	Bill of Material
	PropagatePrftbltySgmt2BOM	PropagatePrftbltySgmt2BOM	Propagate Profitability Segment to BOM (Sales Kit) Sub-Items
	CostDeterminationIsRequired	CostDeterminationIsRequired	Determine cost
	PricingDate	PricingDate	Date for Pricing and Exchange Rate
	SalesDistrict	SalesDistrict	Sales District
	IncotermsVersion	IncotermsVersion	Incoterms Version
	IncotermsClassification	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	IncotermsLocation2	Incoterms Location 2
	CustomerPaymentTerms	CustomerPaymentTerms	Terms of Payment Key
	PaymentMethod	PaymentMethod	Payment Method
	BillingCompanyCode	BillingCompanyCode	Company Code to Be Billed
	BillingDocumentDate	BillingDocumentDate	Billing Date
	FiscalYear	FiscalYear	G/L Fiscal Year
	FiscalPeriod	FiscalPeriod	Posting Period
	BusinessArea	BusinessArea	Business Area
	ProfitCenter	ProfitCenter	Profit Center
	CustomerAccountAssignmentGroup	CustomerAccountAssignmentGroup	Account Assignment Group for Customer
	ReferenceSDDocumentCategory	ReferenceSDDocumentCategory	Reference Document Category
	ReferenceSDDocument	ReferenceSDDocument	Document Number of Reference Document
	ReferenceSDDocumentItem	ReferenceSDDocumentItem	Item number of the reference item
	DisplayCurrency	DisplayCurrency	Display Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	BaseUnit	BaseUnit	Base Unit of Measure
	SalesQuotationNetAmtInDspCrcy	SalesQuotationNetAmtInDspCrcy	Net Amount of Sales Quotation Items in Display Currency
	CnvrtdSalesQtanNetAmtInDspCrcy	CnvrtdSalesQtanNetAmtInDspCrcy	Converted Sales Quoation Net Amount in Display Currency
	SalesQuotationConversionRate		Sales Quotation Conversion Rate
	SalesQuotationQuantity	SalesQuotationQuantity	Quantity of Sales Quotation Items
	NmbrOfOpenSlsQuotationItems	NmbrOfOpenSlsQuotationItems	Number of Open Sales Quotation Items
	SlsQuotationOpenNetAmtInDC	SlsQuotationOpenNetAmtInDC	Net Value of Open Sales Quotations in Display Currency
	NmbrOfExpiredSlsQuotationItems	NmbrOfExpiredSlsQuotationItems	Number of Items in Expired Sales Quotations
	SlsQuotationExpiredNetAmtInDC	SlsQuotationExpiredNetAmtInDC	Net Value of Expired Sales Quotations in Display Currency
	NmbrOfExprgSlsQuotationItems	NmbrOfExprgSlsQuotationItems	Number of Items in Expiring Sales Quotations
	SlsQuotationExpiringNetAmtInDC	SlsQuotationExpiringNetAmtInDC	Net Value of Expiring Sales Quotations in Display Currency
	NmbrOfRejectedSlsQtanItems	NmbrOfRejectedSlsQtanItems	Number of Rejected Sales Quotation Items
	SlsQtanRejectedNetAmountInDC	SlsQtanRejectedNetAmountInDC	Net Value of Rejected Quotation Items in Display Currency
	OverallSDProcessStatus	OverallSDProcessStatus	Overall Processing Status (Header/All Items)
	OverallSDDocumentRejectionSts	OverallSDDocumentRejectionSts	Rejection Status (All Items)
	TotalBlockStatus	TotalBlockStatus	Overall Block Status (Header)
	OverallDelivConfStatus	OverallDelivConfStatus	Delivery Confirmation Status (All Items)
	OverallTotalDeliveryStatus	OverallTotalDeliveryStatus	Overall Delivery Status (All Items)
	OverallDeliveryStatus	OverallDeliveryStatus	Delivery Status (All Items)
	OverallDeliveryBlockStatus	OverallDeliveryBlockStatus	Overall Delivery Block Status (All Items)
	OverallOrdReltdBillgStatus	OverallOrdReltdBillgStatus	Order-Related Billing Status (All Items)
	OverallBillingBlockStatus	OverallBillingBlockStatus	Billing Block Status (All Items)
	OverallTotalSDDocRefStatus	OverallTotalSDDocRefStatus	Overall Reference Status (All Items)
	OverallSDDocReferenceStatus	OverallSDDocReferenceStatus	Reference Status (All Items)
	HdrGeneralIncompletionStatus	HdrGeneralIncompletionStatus	Incompletion Status (Header)
	HeaderDelivIncompletionStatus	HeaderDelivIncompletionStatus	Delivery Incompletion Status (Header)
	HeaderBillgIncompletionStatus	HeaderBillgIncompletionStatus	Billing Incompletion Status (Header)
	OvrlItmGeneralIncompletionSts	OvrlItmGeneralIncompletionSts	Incompletion Status (All Items)
	OvrlItmBillingIncompletionSts	OvrlItmBillingIncompletionSts	Billing Incompletion Status (All Items)
	OvrlItmDelivIncompletionSts	OvrlItmDelivIncompletionSts	Delivery Incompletion Status (All Items)
	SDProcessStatus	SDProcessStatus	Overall Processing Status (Item)
	DeliveryConfirmationStatus	DeliveryConfirmationStatus	Delivery Confirmation Status (Item)
	TotalDeliveryStatus	TotalDeliveryStatus	Overall Delivery Status (Item)
	DeliveryStatus	DeliveryStatus	Delivery Status (Item)
	DeliveryBlockStatus	DeliveryBlockStatus	Delivery Block Status (Item)
	OrderRelatedBillingStatus	OrderRelatedBillingStatus	Order-Related Billing Status (Item)
	BillingBlockStatus	BillingBlockStatus	Billing Block Status (Item)
	ItemGeneralIncompletionStatus	ItemGeneralIncompletionStatus	Incompletion Status (Item)
	ItemBillingIncompletionStatus	ItemBillingIncompletionStatus	Billing Incompletion Status (Item)
	ItemDeliveryIncompletionStatus	ItemDeliveryIncompletionStatus	Delivery Incompletion Status (Item)
	SDDocumentRejectionStatus	SDDocumentRejectionStatus	Rejection Status (Item)
	TotalSDDocReferenceStatus	TotalSDDocReferenceStatus	Overall Reference Status (Item)

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_SalesQuotationItemQry.
-- 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_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_SalesQuotationItemQry AS
SELECT
  SalesQuotation,
  SalesQuotationItem,
  SalesQuotationType,
  SalesQuotationItemType,
  SalesQuotationItemCategory,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  CreationDateYear,
  CreationDateYearQuarter,
  CreationDateYearMonth,
  SalesQuotationDate,
  SalesQuotationDateYear,
  SalesQuotationDateYearQuarter,
  SalesQuotationDateYearMonth,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  PartnerCompany,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentReason,
  CustomerPurchaseOrderType,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  SalesQuotationItemText,
  SalesDocumentRjcnReason,
  ShipToParty,
  RequestedDeliveryDate,
  ShippingCondition,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  ShippingPoint,
  DeliveryPriority,
  ShippingType,
  Route,
  Product,
  OriginallyRequestedMaterial,
  MaterialByCustomer,
  ProductGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Division,
  Plant,
  StorageLocation,
  MainItemPricingRefProduct,
  HigherLevelItem,
  BillOfMaterial,
  PropagatePrftbltySgmt2BOM,
  CostDeterminationIsRequired,
  PricingDate,
  SalesDistrict,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPaymentTerms,
  PaymentMethod,
  BillingCompanyCode,
  BillingDocumentDate,
  FiscalYear,
  FiscalPeriod,
  BusinessArea,
  ProfitCenter,
  CustomerAccountAssignmentGroup,
  ReferenceSDDocumentCategory,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  DisplayCurrency,
  TransactionCurrency,
  BaseUnit,
  SalesQuotationNetAmtInDspCrcy,
  CnvrtdSalesQtanNetAmtInDspCrcy,
  cast (1 as sd_quotation_conversion_rate) AS SalesQuotationConversionRate,
  SalesQuotationQuantity,
  NmbrOfOpenSlsQuotationItems,
  SlsQuotationOpenNetAmtInDC,
  NmbrOfExpiredSlsQuotationItems,
  SlsQuotationExpiredNetAmtInDC,
  NmbrOfExprgSlsQuotationItems,
  SlsQuotationExpiringNetAmtInDC,
  NmbrOfRejectedSlsQtanItems,
  SlsQtanRejectedNetAmountInDC,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallDelivConfStatus,
  OverallTotalDeliveryStatus,
  OverallDeliveryStatus,
  OverallDeliveryBlockStatus,
  OverallOrdReltdBillgStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  HdrGeneralIncompletionStatus,
  HeaderDelivIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  OvrlItmDelivIncompletionSts,
  SDProcessStatus,
  DeliveryConfirmationStatus,
  TotalDeliveryStatus,
  DeliveryStatus,
  DeliveryBlockStatus,
  OrderRelatedBillingStatus,
  BillingBlockStatus,
  ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  SDDocumentRejectionStatus,
  TotalSDDocReferenceStatus
FROM I_SalesQuotationItemCube_2
;

Depth:

C_SalesQuotationItemQry view

I_SalesQuotationItemCube_2 view