What is I_CentralRequestForQuotation in SAP S/4HANA?

I_CentralRequestForQuotation is a basic CDS view in SAP S/4HANA. Central Request For Quotation Header It contains 55 fields.

Which tables does I_CentralRequestForQuotation read from?

I_CentralRequestForQuotation reads data from: R_CentralRequestForQuotation.

What VDM layer is I_CentralRequestForQuotation?

I_CentralRequestForQuotation is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CentralRequestForQuotation

DDL: I_CENTRALREQUESTFORQUOTATION SQL: ICNTRLRFQHDR Type: view BASIC

55 Fields 1 Data Sources 6 Associations

Central Request For Quotation Header

I_CentralRequestForQuotation (Basic)

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

Sourcing & Procurement

I_CentralRequestForQuotation is a Basic CDS View that provides data about "Central Request For Quotation Header" in SAP S/4HANA. It reads from 1 data source (R_CentralRequestForQuotation) and exposes 55 fields with key field CentralRequestForQuotation. It has 6 associations to related views.

SAP Help Documentation

Category	CDS Views for Central Sourcing
Status	Released

Purpose
This CDS view retrieves header data of a central RFQ. The CDS view includes such data as: Organizational data (company code, purchasing organization, purchasing group, etc.) Administrative data (creation date, created by user, last changed date, etc.) Data for a central RFQ process (publishing date, quotation deadline, etc.) This CDS view provides the prerequisites for answering the following business questions: When was a central RFQ published? When is a central quotation deadline reached? What are the payment terms for a central RFQ?

Prerequisites
If you would like to use this CDS view, be sure that: The business catalog SAP_MM_BC_CRFQ_PROCESS_PC is assigned to your user. You have authorizations to access the relevant central requests for quotation.

Structure
This view relates to the following SAP object types: CentralRequestForQuotationBidder CentralRFQItemDistribution CentralRequestForQuotationItem CentralRFQItemScheduleLine Main parameters and filters of the CDS view The main filters are as follows: CentralRequestForQuotationName PurchasingDocumentType CompanyCode PurchasingOrganization PurchasingGroup DocumentCurrency Measures and attributes Some important measures and attributes are: TargetAmount : target amount of the central RFQ. It helps the users to keep an eye on the budget that they don't want to exceed. RFQPublishingDate : the date when the central RFQ was published. As a starting point of a bidding process it allows you to have transparency about the bidding period. QuotationLatestSubmissionDate : the date until which the suppliers can submit their quotations. RFQLifecycleStatus : the status of the document, for example In Preparation or Published .

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-HUB-RFQ
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view retrieves header data of a central RFQ.</p> <p>The CDS view includes such data as:</p> <ul> <li><p>Organizational data (company code, purchasing organization, purchasing group, etc.)</p></li> <li><p>Administrative data (creation date, created by user, last changed date, etc.)</p></li> <li><p>Data for a central RFQ process (publishing date, quotation deadline, etc.)</p></li> </ul> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>When was a central RFQ published?</p></li> <li><p>When is a central quotation deadline reached?</p></li> <li><p>What are the payment terms for a central RFQ?</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
R_CentralRequestForQuotation	R_CentralRequestForQuotation	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..*]	I_CentralReqForQuotationItem	_CentralReqForQuotationItem	`$projection.CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation`
[1..*]	I_CntrlReqForQuotationBidder	_CntrlReqForQuotationBidder	`$projection.CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation`
[0..1]	I_PurchasingDocumentType	_FollowOnDocumentType	`$projection.PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _FollowOnDocumentType.PurchasingDocumentType`
[0..1]	I_PurchasingDocumentCategory	_FollowOnDocumentCategory	`$projection.PurchasingDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory`
[0..*]	I_CentralSupplierQuotation	_CentralSupplierQuotation	`$projection.CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation --Extension`
[1..1]	E_PurchasingDocument	_CentralReqForQuotationExtn	`_CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation`

Annotations (14)

Name	Value	Level
VDM.viewType	#BASIC	view
EndUserText.label	Central Request For Quotation Header	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	ICNTRLRFQHDR	view
ObjectModel.representativeKey	CentralRequestForQuotation	view
ObjectModel.semanticKey	CentralRequestForQuotation	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (55)

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

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_CentralRequestForQuotation.
-- 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: ICNTRLRFQHDR

CREATE VIEW I_CentralRequestForQuotation AS
SELECT
  CentralRequestForQuotation,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  CreatedByUser,
  CreationDate,
  LastChangeDateTime,
  Language,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  ValidityStartDate,
  ValidityEndDate,
  RFQPublishingDate,
  QuotationLatestSubmissionDate,
  BindingPeriodValidityEndDate,
  TargetAmount,
  RFQLifecycleStatus,
  RequestForQuotationName,
  QuotationEarliestSubmsnDate,
  LatestRegistrationDate,
  CorrespncInternalReference,
  FollowOnDocumentCategory,
  FollowOnDocumentType,
  PurgDocFollowOnDocumentType,
  PurchasingDocumentDeletionCode,
  IsEndOfPurposeBlocked,
  PurContrValidityStartDate,
  PurContrValidityEndDate
FROM R_CentralRequestForQuotation
LEFT OUTER JOIN I_CentralReqForQuotationItem AS _CentralReqForQuotationItem ON CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_CntrlReqForQuotationBidder AS _CntrlReqForQuotationBidder ON CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_PurchasingDocumentType AS _FollowOnDocumentType ON PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _FollowOnDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _FollowOnDocumentCategory ON PurchasingDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_CentralSupplierQuotation AS _CentralSupplierQuotation ON CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _CentralReqForQuotationExtn ON _CentralReqForQuotationExtn.PurchasingDocument = CentralRequestForQuotation  -- association [1..1]
;

Depth:

I_CentralRequestForQuotation view

R_CentralRequestForQuotation view

I_CentralRFQMailParameter view
M_V_CENTRRFQ_OUTPUT_PARAM view