What is C_ServiceQuotationItemDEX in SAP S/4HANA?

C_ServiceQuotationItemDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Srvc Quotation Item It contains 53 fields.

Which tables does C_ServiceQuotationItemDEX read from?

C_ServiceQuotationItemDEX reads data from: I_ServiceDocumentItemEnhcd.

What VDM layer is C_ServiceQuotationItemDEX?

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

C_ServiceQuotationItemDEX

DDL: C_SERVICEQUOTATIONITEMDEX Type: view_entity CONSUMPTION

53 Fields 1 Data Sources 1 Associations

Data Extraction for Srvc Quotation Item

C_ServiceQuotationItemDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Srvc Quotation Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 53 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem. It has 1 association to related views.

SAP Help Documentation

Category	Data Extraction
Data Category	Fact
Status	Life cycle status

Purpose
This CDS view is designed to extract and provide detailed information about service quotation items within a business context. It focuses on transactional data related to service quotations, enabling data extraction and analysis for business purposes. This CDS view provides the data to answer the following business questions: What are the details of service quotation items, including their descriptions, quantities, and associated products? Which organizational units are involved in the service quotation process, such as sales organizations and distribution channels? What are the financial aspects of service quotation items, including gross, net, and tax amounts? Who are the key business partners involved, such as the sold-to and ship-to parties, and responsible employees? What is the status and lifecycle information of service quotation items, including rejection reasons and categories? How are service quotation items linked to reference service contracts and their items? What are the reference object details associated with service quotation items, such as serial numbers, equipments, and functional locations? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRM_CO_SE Authorization Object CRM Order – Bus. Ob. Service Contract CRM_SEO Authorization Object CRM Order – Business Object Service Order CRM_ORD_PR Authorization Object CRM Order – Business Transaction Type CRMS4_SLSO Sales Organizational Units of Service Transactions CRM_ORD_OE Authorization Object CRM Order – Allowed Organ. Units

Structure
Important Fields Important fields in this view include the following: Field Name Description ServiceObjectType Transaction category ServiceDocument Transaction ID ServiceDocumentItem Item number in document ServiceDocumentType Transaction type ServiceDocumentItemDescription Product description ServiceDocumentItemIsRejected Cancellation status SoldToParty Sold-to party ShipToParty Ship-to party RespEmployeeBusinessPartnerId Employee responsible RespyMgmtGlobalTeamID Global team ID SalesOrganizationOrgUnitID Sales Organization ID SalesOfficeOrgUnitID Sales Office SalesGroupOrgUnitID Sales Group SalesOrganization Sales organization DistributionChannel Distribution channel Division Division SalesOffice Sales office SalesGroup Sales group ResponsibleSalesOrganization Organization Unit (Sales) PaymentTerms Terms of payment TransactionCurrency Currency Product Product ServiceDocumentItemQuantity Order quantity ServiceDocItemQuantityUnit Sales unit ServiceDuration Duration ServiceDurationUnit Unit ServiceDocumentItemIsQuotation Quotation status TimeSheetOvertimeCategory Overtime category ServiceDocumentItemStatus Life cycle status ServiceDocItemCategory Item category ServiceDocItemGrossAmount Gross order value ServiceDocumentItemNetAmount Net value ServiceDocumentItemTaxAmount Tax amount ServiceDocItemRejectionReason Cancellation reason code ParentServiceQuotationItem Item number in document ServiceDocumentItemObjectType Object type ReferenceServiceContract Transaction ID ReferenceServiceContractItem Item number in document SerialNumber Serial number Equipment Equipment SrvcQtanItemFunctionalLocation Functional location ProductID Material

Data Extraction
This CDS view is enabled for data extraction in delta mode as well as in full mode.

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItemEnhcd	ServiceQuotationItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_ServiceDocumentItem	_ServiceDocItemExt	`$projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID`

Annotations (12)

Name	Value	Level
EndUserText.label	Data Extraction for Srvc Quotation Item	view
VDM.viewType	#CONSUMPTION	view
Analytics.technicalName	CSRVCQTANITMDEX	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	ServiceDocumentItem	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.sapObjectNodeType.name	ServiceQuotationItem	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (53)

Key	Field	Source Table	Source Field	Description
KEY	ServiceObjectType	I_ServiceDocumentItemEnhcd	ServiceObjectType	Object Type
KEY	ServiceDocument	I_ServiceDocumentItemEnhcd	ServiceDocument	Transaction ID
KEY	ServiceDocumentItem	I_ServiceDocumentItemEnhcd	ServiceDocumentItem	Service Document
	ServiceDocumentType	I_ServiceDocumentItemEnhcd	ServiceDocumentType	Transaction Type
	ServiceDocumentItemDescription	I_ServiceDocumentItemEnhcd	ServiceDocumentItemDescription
	ServiceDocumentItemIsRejected	I_ServiceDocumentItemEnhcd	ServiceDocumentItemIsRejected
	SoldToParty	I_ServiceDocumentItemEnhcd	SoldToParty	Sold-to Party
	ShipToParty	I_ServiceDocumentItemEnhcd	ShipToParty	Ship-To Party (obsolete)
	RespEmployeeBusinessPartnerId	I_ServiceDocumentItemEnhcd	ResponsibleEmployee	Employee Resp.
	RespyMgmtGlobalTeamID
	SalesOrganizationOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOrganizationOrgUnitID
	SalesOfficeOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOfficeOrgUnitID
	SalesGroupOrgUnitID	I_ServiceDocumentItemEnhcd	SalesGroupOrgUnitID
	ServiceOrganization	I_ServiceDocumentItemEnhcd	ServiceOrganization
	ResponsibleServiceOrganization	I_ServiceDocumentItemEnhcd	ResponsibleServiceOrganization
	SalesOrganization	I_ServiceDocumentItemEnhcd	SalesOrganization	Sales Organization
	DistributionChannel	I_ServiceDocumentItemEnhcd	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_ServiceDocumentItemEnhcd	Division	Internal Division ID
	SalesOffice	I_ServiceDocumentItemEnhcd	SalesOffice	Sales Office
	SalesGroup	I_ServiceDocumentItemEnhcd	SalesGroup	Sales Group
	ResponsibleSalesOrganization	I_ServiceDocumentItemEnhcd	ResponsibleSalesOrganization
	PaymentTerms	I_ServiceDocumentItemEnhcd	PaymentTerms	Pyt Terms
	TransactionCurrency	I_ServiceDocumentItemEnhcd	TransactionCurrency	Transaction Currency
	Product	I_ServiceDocumentItemEnhcd	Product	Product Sold
	ServiceDocumentItemQuantity	I_ServiceDocumentItemEnhcd	ServiceDocumentItemQuantity
	ServiceDocItemQuantityUnit	I_ServiceDocumentItemEnhcd	ServiceDocItemQuantityUnit
	ServiceDuration	I_ServiceDocumentItemEnhcd	ServiceDuration	Work Duration
	ServiceDurationUnit	I_ServiceDocumentItemEnhcd	ServiceDurationUnit	Unit
	ServiceDocumentItemIsQuotation	I_ServiceDocumentItemEnhcd	ServiceDocumentItemIsQuotation
	TimeSheetOvertimeCategory	I_ServiceDocumentItemEnhcd	TimeSheetOvertimeCategory
	ServiceDocumentItemStatus	I_ServiceDocumentItemEnhcd	ServiceDocumentItemStatus
	ServiceDocItemCategory	I_ServiceDocumentItemEnhcd	ServiceDocItemCategory
	ServiceDocItemGrossAmount	I_ServiceDocumentItemEnhcd	ServiceDocItemGrossAmount
	ServiceDocumentItemNetAmount	I_ServiceDocumentItemEnhcd	ServiceDocumentItemNetAmount
	ServiceDocumentItemTaxAmount	I_ServiceDocumentItemEnhcd	ServiceDocumentItemTaxAmount
	ServiceDocItemRejectionReason	I_ServiceDocumentItemEnhcd	ServiceDocItemRejectionReason
	ParentServiceQuotationItem
	ServiceDocumentItemObjectType	I_ServiceDocumentItemEnhcd	ServiceDocumentItemObjectType
	ReferenceServiceContract
	ReferenceServiceContractItem
	SerialNumber	ServiceQtanItemRefObj	SerialNumber	Serial Number
	Equipment	ServiceQtanItemRefObj	Equipment	Equipment check
	SrvcQtanItemFunctionalLocation
	ProductID	ServiceQtanItemRefObj	ProductID	Product ID
	_ServiceObjType	I_ServiceDocumentItemEnhcd	_ServiceObjType
	_ServiceDocumentType	I_ServiceDocumentItemEnhcd	_ServiceDocumentType
	_PaymentTerms	I_ServiceDocumentItemEnhcd	_PaymentTerms
	_TransactionCurrency	I_ServiceDocumentItemEnhcd	_TransactionCurrency
	_SalesUnit	I_ServiceDocumentItemEnhcd	_SalesUnit
	_ServiceDocOvertimeCat	I_ServiceDocumentItemEnhcd	_ServiceDocOvertimeCat
	_ServiceDocItemCategory	I_ServiceDocumentItemEnhcd	_ServiceDocItemCategory
	_SrvcDocItmLifecycleStatus	I_ServiceDocumentItemEnhcd	_SrvcDocItmLifecycleStatus
	_ServiceDocItemRejectionReason	I_ServiceDocumentItemEnhcd	_ServiceDocItemRejectionReason

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_ServiceQuotationItemDEX.
-- 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_ServiceQuotationItemDEX AS
SELECT
  ServiceQuotationItem.ServiceObjectType AS ServiceObjectType,
  ServiceQuotationItem.ServiceDocument AS ServiceDocument,
  ServiceQuotationItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceQuotationItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceQuotationItem.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  ServiceQuotationItem.ServiceDocumentItemIsRejected AS ServiceDocumentItemIsRejected,
  ServiceQuotationItem.SoldToParty AS SoldToParty,
  ServiceQuotationItem.ShipToParty AS ShipToParty,
  ServiceQuotationItem.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceQuotationItem._ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  ServiceQuotationItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceQuotationItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceQuotationItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceQuotationItem.ServiceOrganization AS ServiceOrganization,
  ServiceQuotationItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  ServiceQuotationItem.SalesOrganization AS SalesOrganization,
  ServiceQuotationItem.DistributionChannel AS DistributionChannel,
  ServiceQuotationItem.Division AS Division,
  ServiceQuotationItem.SalesOffice AS SalesOffice,
  ServiceQuotationItem.SalesGroup AS SalesGroup,
  ServiceQuotationItem.ResponsibleSalesOrganization AS ResponsibleSalesOrganization,
  ServiceQuotationItem.PaymentTerms AS PaymentTerms,
  ServiceQuotationItem.TransactionCurrency AS TransactionCurrency,
  ServiceQuotationItem.Product AS Product,
  ServiceQuotationItem.ServiceDocumentItemQuantity AS ServiceDocumentItemQuantity,
  ServiceQuotationItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
  ServiceQuotationItem.ServiceDuration AS ServiceDuration,
  ServiceQuotationItem.ServiceDurationUnit AS ServiceDurationUnit,
  ServiceQuotationItem.ServiceDocumentItemIsQuotation AS ServiceDocumentItemIsQuotation,
  ServiceQuotationItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  ServiceQuotationItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceQuotationItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  ServiceQuotationItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  ServiceQuotationItem.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
  ServiceQuotationItem.ServiceDocumentItemTaxAmount AS ServiceDocumentItemTaxAmount,
  ServiceQuotationItem.ServiceDocItemRejectionReason AS ServiceDocItemRejectionReason,
  ServiceQuotationItem._ParentServiceDocItem_2.ServiceDocumentItem AS ParentServiceQuotationItem,
  ServiceQuotationItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceDocumentItemPrdcssr._ServiceDocItm.ServiceDocument AS ReferenceServiceContract,
  ServiceDocumentItemPrdcssr._ServiceDocItm.ServiceDocumentItem AS ReferenceServiceContractItem,
  ServiceQtanItemRefObj.SerialNumber AS SerialNumber,
  ServiceQtanItemRefObj.Equipment AS Equipment,
  cast( ServiceQtanItemRefObj.FunctionalLocation as functionallocation preserving type ) AS SrvcQtanItemFunctionalLocation,
  ServiceQtanItemRefObj.ProductID AS ProductID,
  ServiceQuotationItem._ServiceObjType AS _ServiceObjType,
  ServiceQuotationItem._ServiceDocumentType AS _ServiceDocumentType,
  ServiceQuotationItem._PaymentTerms AS _PaymentTerms,
  ServiceQuotationItem._TransactionCurrency AS _TransactionCurrency,
  ServiceQuotationItem._SalesUnit AS _SalesUnit,
  ServiceQuotationItem._ServiceDocOvertimeCat AS _ServiceDocOvertimeCat,
  ServiceQuotationItem._ServiceDocItemCategory AS _ServiceDocItemCategory,
  ServiceQuotationItem._SrvcDocItmLifecycleStatus AS _SrvcDocItmLifecycleStatus,
  ServiceQuotationItem._ServiceDocItemRejectionReason AS _ServiceDocItemRejectionReason
FROM I_ServiceDocumentItemEnhcd AS ServiceQuotationItem
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;

Depth:

C_ServiceQuotationItemDEX view_entity

I_ServiceDocumentItemEnhcd view