What is A_RequestForQuotation in SAP S/4HANA?

A_RequestForQuotation is a composite CDS view in SAP S/4HANA. Request for Quotation It contains 36 fields.

Which tables does A_RequestForQuotation read from?

A_RequestForQuotation reads data from: I_RequestForQuotationEnhanced.

What VDM layer is A_RequestForQuotation?

A_RequestForQuotation is classified as a Composite view that combines data from multiple basic views.

A_RequestForQuotation

DDL: A_REQUESTFORQUOTATION SQL: ARFQHDR Type: view COMPOSITE

36 Fields 1 Data Sources 3 Associations

Request for Quotation

A_RequestForQuotation is a Composite CDS View that provides data about "Request for Quotation" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotationEnhanced) and exposes 36 fields with key field RequestForQuotation. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_RequestForQuotationEnhanced	I_RequestForQuotationEnhanced	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..*]	A_RequestForQuotationItem	_RequestForQuotationItem	`_RequestForQuotationItem.RequestForQuotation = $projection.RequestForQuotation`
[1..*]	A_RequestForQuotationBidder	_RequestForQuotationBidder	`_RequestForQuotationBidder.RequestForQuotation = $projection.RequestForQuotation --Extension`
[0..1]	E_PurchasingDocument	_RequestForQuotationExtension	`_RequestForQuotationExtension.PurchasingDocument = $projection.RequestForQuotation`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	ARFQHDR	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.compositionRoot	true	view
ObjectModel.representativeKey	RequestForQuotation	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
EndUserText.label	Request for Quotation	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (36)

Key	Field	Source Table	Source Field	Description
KEY	RequestForQuotation	I_RequestForQuotationEnhanced	RequestForQuotation	RFQ
	CompanyCode	I_RequestForQuotationEnhanced	CompanyCode	Receiver Company Code
	PurchasingDocumentCategory	I_RequestForQuotationEnhanced	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	I_RequestForQuotationEnhanced	PurchasingDocumentType	RFQ Type
	CreatedByUser	I_RequestForQuotationEnhanced	CreatedByUser	User Name
	CreationDate	I_RequestForQuotationEnhanced	CreationDate	Time Stamp
	LastChangeDateTime	I_RequestForQuotationEnhanced	LastChangeDateTime	Timestamp
	Language	I_RequestForQuotationEnhanced	Language	Report Text Language
	PurchasingOrganization	I_RequestForQuotationEnhanced	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	I_RequestForQuotationEnhanced	PurchasingGroup	Purchasing Group
	DocumentCurrency	I_RequestForQuotationEnhanced	DocumentCurrency	Document Currency
	IncotermsClassification	I_RequestForQuotationEnhanced	IncotermsClassification	Incoterms
	IncotermsTransferLocation	I_RequestForQuotationEnhanced	IncotermsTransferLocation	Incoterms 2
	IncotermsVersion	I_RequestForQuotationEnhanced	IncotermsVersion	Inco. Version
	IncotermsLocation1	I_RequestForQuotationEnhanced	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	I_RequestForQuotationEnhanced	IncotermsLocation2	Inco. Location2
	PaymentTerms	I_RequestForQuotationEnhanced	PaymentTerms	Pyt Terms
	CashDiscount1Days	I_RequestForQuotationEnhanced	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	I_RequestForQuotationEnhanced	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount1Percent	I_RequestForQuotationEnhanced	CashDiscount1Percent	Disc. Percent 1
	CashDiscount2Percent	I_RequestForQuotationEnhanced	CashDiscount2Percent	Disc. Percent 2
	NetPaymentDays	I_RequestForQuotationEnhanced	NetPaymentDays	Net Pmt Terms Period
	RFQPublishingDate	I_RequestForQuotationEnhanced	RFQPublishingDate	Publishing Date
	QuotationLatestSubmissionDate	I_RequestForQuotationEnhanced	QuotationLatestSubmissionDate	Quot. Deadline
	BindingPeriodValidityEndDate	I_RequestForQuotationEnhanced	BindingPeriodValidityEndDate	Binding Period
	TargetAmount
	CorrespncInternalReference	I_RequestForQuotationEnhanced	CorrespncInternalReference	Our Reference
	RFQLifecycleStatus	I_RequestForQuotationEnhanced	RFQLifecycleStatus	Status
	RequestForQuotationName	I_RequestForQuotationEnhanced	RequestForQuotationName	RFQ Description
	QuotationEarliestSubmsnDate	I_RequestForQuotationEnhanced	QuotationEarliestSubmsnDate	Start Date
	LatestRegistrationDate	I_RequestForQuotationEnhanced	LatestRegistrationDate	Apply By
	FollowOnDocumentCategory	I_RequestForQuotationEnhanced	FollowOnDocumentCategory	Follow-On Document Category
	FollowOnDocumentType	I_RequestForQuotationEnhanced	FollowOnDocumentType	Follow-On Document Type
	IsEndOfPurposeBlocked	I_RequestForQuotationEnhanced	IsEndOfPurposeBlocked	Busin. Purp. Cmpltd.
	_RequestForQuotationItem		_RequestForQuotationItem
	_RequestForQuotationBidder		_RequestForQuotationBidder

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 A_RequestForQuotation.
-- 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: ARFQHDR

CREATE VIEW A_RequestForQuotation AS
SELECT
  I_RequestForQuotationEnhanced.RequestForQuotation AS RequestForQuotation,
  I_RequestForQuotationEnhanced.CompanyCode AS CompanyCode,
  I_RequestForQuotationEnhanced.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RequestForQuotationEnhanced.PurchasingDocumentType AS PurchasingDocumentType,
  I_RequestForQuotationEnhanced.CreatedByUser AS CreatedByUser,
  I_RequestForQuotationEnhanced.CreationDate AS CreationDate,
  I_RequestForQuotationEnhanced.LastChangeDateTime AS LastChangeDateTime,
  I_RequestForQuotationEnhanced.Language AS Language,
  I_RequestForQuotationEnhanced.PurchasingOrganization AS PurchasingOrganization,
  I_RequestForQuotationEnhanced.PurchasingGroup AS PurchasingGroup,
  I_RequestForQuotationEnhanced.DocumentCurrency AS DocumentCurrency,
  I_RequestForQuotationEnhanced.IncotermsClassification AS IncotermsClassification,
  I_RequestForQuotationEnhanced.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RequestForQuotationEnhanced.IncotermsVersion AS IncotermsVersion,
  I_RequestForQuotationEnhanced.IncotermsLocation1 AS IncotermsLocation1,
  I_RequestForQuotationEnhanced.IncotermsLocation2 AS IncotermsLocation2,
  I_RequestForQuotationEnhanced.PaymentTerms AS PaymentTerms,
  I_RequestForQuotationEnhanced.CashDiscount1Days AS CashDiscount1Days,
  I_RequestForQuotationEnhanced.CashDiscount2Days AS CashDiscount2Days,
  I_RequestForQuotationEnhanced.CashDiscount1Percent AS CashDiscount1Percent,
  I_RequestForQuotationEnhanced.CashDiscount2Percent AS CashDiscount2Percent,
  I_RequestForQuotationEnhanced.NetPaymentDays AS NetPaymentDays,
  I_RequestForQuotationEnhanced.RFQPublishingDate AS RFQPublishingDate,
  I_RequestForQuotationEnhanced.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_RequestForQuotationEnhanced.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  Semantics.amount.currencyCode: 'DocumentCurrency' I_RequestForQuotationEnhanced.TargetAmount AS TargetAmount,
  I_RequestForQuotationEnhanced.CorrespncInternalReference AS CorrespncInternalReference,
  I_RequestForQuotationEnhanced.RFQLifecycleStatus AS RFQLifecycleStatus,
  I_RequestForQuotationEnhanced.RequestForQuotationName AS RequestForQuotationName,
  I_RequestForQuotationEnhanced.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  I_RequestForQuotationEnhanced.LatestRegistrationDate AS LatestRegistrationDate,
  I_RequestForQuotationEnhanced.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_RequestForQuotationEnhanced.FollowOnDocumentType AS FollowOnDocumentType,
  I_RequestForQuotationEnhanced.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_RequestForQuotationEnhanced
LEFT OUTER JOIN A_RequestForQuotationItem AS _RequestForQuotationItem ON _RequestForQuotationItem.RequestForQuotation = RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN A_RequestForQuotationBidder AS _RequestForQuotationBidder ON _RequestForQuotationBidder.RequestForQuotation = RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocument AS _RequestForQuotationExtension ON _RequestForQuotationExtension.PurchasingDocument = RequestForQuotation  -- association [0..1]
;

Depth:

A_RequestForQuotation view

I_RequestForQuotationEnhanced view