What is C_RequestForQuotationDEX in SAP S/4HANA?

C_RequestForQuotationDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Request For Quotation It contains 48 fields.

Which tables does C_RequestForQuotationDEX read from?

C_RequestForQuotationDEX reads data from: I_Requestforquotation_Api01.

What VDM layer is C_RequestForQuotationDEX?

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

C_RequestForQuotationDEX

DDL: C_REQUESTFORQUOTATIONDEX SQL: CMMREQFORQTNDEX Type: view CONSUMPTION

48 Fields 1 Data Sources 13 Associations

Data Extraction for Request For Quotation

C_RequestForQuotationDEX (Consumption)

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

Request For Quotation · Sourcing & Procurement

C_RequestForQuotationDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Request For Quotation" in SAP S/4HANA. It reads from 1 data source (I_Requestforquotation_Api01) and exposes 48 fields with key field RequestForQuotation. It has 13 associations to related views.

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-ANA
Capabilities	Data Source for Data Extraction
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition

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_Requestforquotation_Api01	RequestForQuotation	from

Associations (13)

Cardinality	Target	Alias	Condition
[0..1]	E_PurchasingDocument	_RequestQtnExtension	`$projection.RequestForQuotation = _RequestQtnExtension.PurchasingDocument`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[1..1]	I_PurchasingDocumentCategory	_PurchasingDocumentCategory	`$projection.PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory`
[1..1]	I_PurchasingDocumentType	_PurchasingDocumentType	`$projection.PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType`
[0..1]	I_Language	_Language	`$projection.Language = _Language.Language`
[1..1]	I_PurchasingOrganization	_PurchasingOrganization	`$projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization`
[1..1]	I_PurchasingGroup	_PurchasingGroup	`$projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup`
[1..1]	I_Currency	_Currency	`$projection.DocumentCurrency = _Currency.Currency`
[0..1]	I_IncotermsClassification	_IncotermsClassification	`$projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification`
[0..1]	I_IncotermsVersion	_IncotermsVersion	`$projection.IncotermsVersion = _IncotermsVersion.IncotermsVersion`
[0..1]	I_PaymentTerms	_PaymentTerms	`$projection.PaymentTerms = _PaymentTerms.PaymentTerms`
[0..1]	I_PurchasingDocumentCategory	_FollowOnDocumentCategory	`$projection.FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory`
[0..1]	I_PurchasingDocumentType	_PurgDocFollowOnDocumentType	`$projection.FollowOnDocumentCategory = _PurgDocFollowOnDocumentType.PurchasingDocumentCategory and $projection.PurgDocFollowOnDocumentType = _PurgDocFollowOnDocumentType.PurchasingDocumentType`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CMMREQFORQTNDEX	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.modelingPattern	#ANALYTICAL_FACT	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
EndUserText.label	Data Extraction for Request For Quotation	view
ObjectModel.sapObjectNodeType.name	RequestForQuotation	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	RequestForQuotation	I_Requestforquotation_Api01	RequestForQuotation	Request for Quotation
	CompanyCode	I_Requestforquotation_Api01	CompanyCode	Receiver Company Code
	PurchasingDocumentCategory	I_Requestforquotation_Api01	PurchasingDocumentCategory	Purchasing Document Category
	PurchasingDocumentType	I_Requestforquotation_Api01	PurchasingDocumentType	RFQ Document Type
	CreatedByUser	I_Requestforquotation_Api01	CreatedByUser	User of person who created a purchasing document
	CreationDate	I_Requestforquotation_Api01	CreationDate	Creation Date of Purchasing Document
	LastChangeDateTime	I_Requestforquotation_Api01	LastChangeDateTime	Change Time Stamp
	Language	I_Requestforquotation_Api01	Language	Report Text Language
	PurchasingOrganization	I_Requestforquotation_Api01	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	I_Requestforquotation_Api01	PurchasingGroup	Purchasing Group
	DocumentCurrency	I_Requestforquotation_Api01	DocumentCurrency	Document Currency
	IncotermsClassification	I_Requestforquotation_Api01	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	I_Requestforquotation_Api01	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsVersion	I_Requestforquotation_Api01	IncotermsVersion	Incoterms Version
	IncotermsLocation1	I_Requestforquotation_Api01	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	I_Requestforquotation_Api01	IncotermsLocation2	Incoterms Location 2
	PaymentTerms	I_Requestforquotation_Api01	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	I_Requestforquotation_Api01	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	I_Requestforquotation_Api01	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount1Percent	I_Requestforquotation_Api01	CashDiscount1Percent	Cash discount percentage 1
	CashDiscount2Percent	I_Requestforquotation_Api01	CashDiscount2Percent	Cash discount percentage 2
	NetPaymentDays	I_Requestforquotation_Api01	NetPaymentDays	Net Payment Terms Period
	ValidityStartDate	I_Requestforquotation_Api01	ValidityStartDate	Start of Validity Period
	ValidityEndDate	I_Requestforquotation_Api01	ValidityEndDate	End of Validity Period
	RFQPublishingDate	I_Requestforquotation_Api01	RFQPublishingDate	RFQ Publishing Date
	QuotationLatestSubmissionDate	I_Requestforquotation_Api01	QuotationLatestSubmissionDate	Deadline for Submission of Bid/Quotation
	BindingPeriodValidityEndDate	I_Requestforquotation_Api01	BindingPeriodValidityEndDate	Binding Period for Quotation
	TargetAmount	I_Requestforquotation_Api01	TargetAmount	Target Value for Header Area per Distribution
	RFQLifecycleStatus	I_Requestforquotation_Api01	RFQLifecycleStatus	RFQ Lifecycle Status
	RequestForQuotationName	I_Requestforquotation_Api01	RequestForQuotationName	Short description or the title of the RFQ
	QuotationEarliestSubmsnDate	I_Requestforquotation_Api01	QuotationEarliestSubmsnDate	The date as of which Quotations can be submitted
	LatestRegistrationDate	I_Requestforquotation_Api01	LatestRegistrationDate	Closing Date for Applications
	CorrespncInternalReference	I_Requestforquotation_Api01	CorrespncInternalReference	Our Reference
	FollowOnDocumentCategory	I_Requestforquotation_Api01	FollowOnDocumentCategory	Follow-On Purchasing Document Category
	PurgDocFollowOnDocumentType	I_Requestforquotation_Api01	FollowOnDocumentType	Follow-On Purchasing Document Type
	IsEndOfPurposeBlocked	I_Requestforquotation_Api01	IsEndOfPurposeBlocked	Business Purpose Completed
	_CompanyCode		_CompanyCode
	_PurchasingDocumentCategory		_PurchasingDocumentCategory
	_PurchasingDocumentType		_PurchasingDocumentType
	_Language		_Language
	_PurchasingOrganization		_PurchasingOrganization
	_PurchasingGroup		_PurchasingGroup
	_Currency		_Currency
	_IncotermsClassification		_IncotermsClassification
	_IncotermsVersion		_IncotermsVersion
	_PaymentTerms		_PaymentTerms
	_FollowOnDocumentCategory		_FollowOnDocumentCategory
	_PurgDocFollowOnDocumentType		_PurgDocFollowOnDocumentType

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_RequestForQuotationDEX.
-- 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.
-- SQL view name: CMMREQFORQTNDEX

CREATE VIEW C_RequestForQuotationDEX AS
SELECT
  RequestForQuotation.RequestForQuotation AS RequestForQuotation,
  RequestForQuotation.CompanyCode AS CompanyCode,
  RequestForQuotation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  RequestForQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  RequestForQuotation.CreatedByUser AS CreatedByUser,
  RequestForQuotation.CreationDate AS CreationDate,
  RequestForQuotation.LastChangeDateTime AS LastChangeDateTime,
  RequestForQuotation.Language AS Language,
  RequestForQuotation.PurchasingOrganization AS PurchasingOrganization,
  RequestForQuotation.PurchasingGroup AS PurchasingGroup,
  RequestForQuotation.DocumentCurrency AS DocumentCurrency,
  RequestForQuotation.IncotermsClassification AS IncotermsClassification,
  RequestForQuotation.IncotermsTransferLocation AS IncotermsTransferLocation,
  RequestForQuotation.IncotermsVersion AS IncotermsVersion,
  RequestForQuotation.IncotermsLocation1 AS IncotermsLocation1,
  RequestForQuotation.IncotermsLocation2 AS IncotermsLocation2,
  RequestForQuotation.PaymentTerms AS PaymentTerms,
  RequestForQuotation.CashDiscount1Days AS CashDiscount1Days,
  RequestForQuotation.CashDiscount2Days AS CashDiscount2Days,
  RequestForQuotation.CashDiscount1Percent AS CashDiscount1Percent,
  RequestForQuotation.CashDiscount2Percent AS CashDiscount2Percent,
  RequestForQuotation.NetPaymentDays AS NetPaymentDays,
  RequestForQuotation.ValidityStartDate AS ValidityStartDate,
  RequestForQuotation.ValidityEndDate AS ValidityEndDate,
  RequestForQuotation.RFQPublishingDate AS RFQPublishingDate,
  RequestForQuotation.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  RequestForQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  RequestForQuotation.TargetAmount AS TargetAmount,
  RequestForQuotation.RFQLifecycleStatus AS RFQLifecycleStatus,
  RequestForQuotation.RequestForQuotationName AS RequestForQuotationName,
  RequestForQuotation.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  RequestForQuotation.LatestRegistrationDate AS LatestRegistrationDate,
  RequestForQuotation.CorrespncInternalReference AS CorrespncInternalReference,
  RequestForQuotation.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  RequestForQuotation.FollowOnDocumentType AS PurgDocFollowOnDocumentType,
  RequestForQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_Requestforquotation_Api01 AS RequestForQuotation
LEFT OUTER JOIN E_PurchasingDocument AS _RequestQtnExtension ON RequestForQuotation = _RequestQtnExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _FollowOnDocumentCategory ON FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurgDocFollowOnDocumentType ON FollowOnDocumentCategory = _PurgDocFollowOnDocumentType.PurchasingDocumentCategory AND PurgDocFollowOnDocumentType = _PurgDocFollowOnDocumentType.PurchasingDocumentType  -- association [0..1]
;

Depth:

C_RequestForQuotationDEX view

I_Requestforquotation_Api01 view