What is I_SupplierQuotation_Api01 in SAP S/4HANA?

I_SupplierQuotation_Api01 is a basic CDS view in SAP S/4HANA. Supplier Quotation It contains 37 fields.

Which tables does I_SupplierQuotation_Api01 read from?

I_SupplierQuotation_Api01 reads data from: I_SupplierQuotation.

What VDM layer is I_SupplierQuotation_Api01?

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

I_SupplierQuotation_Api01

DDL: I_SUPPLIERQUOTATION_API01 SQL: IMMQTNAPI01 Type: view BASIC

37 Fields 1 Data Sources 1 Associations

Supplier Quotation

I_SupplierQuotation_Api01 (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_SupplierQuotation_Api01 is a Basic CDS View that provides data about "Supplier Quotation" in SAP S/4HANA. It reads from 1 data source (I_SupplierQuotation) and exposes 37 fields with key field SupplierQuotation. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Sourcing
Status	Released

Purpose
This CDS view retrieves header data of a supplier quotation. The CDS view retrieves 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 the RFQ process (submission date, status, etc.) This CDS view provides the prerequisites for answering the following business questions: When was the quotation submitted? What is the status of the quotation? What is the currency of the quotation?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: Purchasing organization Purchasing group Purchasing document type These restriction types are edited in the Maintain Business Roles app.

Structure
SupplierQuotation This view relates to the following SAP object types: RequestForQuotation SupplierQuotation Main parameters and filters of the CDS view The main filters are as follows: SupplierQuotation : allows you to filter by number of the supplier quotation. PurchasingDocumentType : allows you to filter by the document type of the supplier quotation. CompanyCode : allows you to filter by company code. PurchasingOrganization : allows you to filter by purchasing organization. PurchasingGroup : allows you to filter by purchasing group. DocumentCurrency : allows you to filter by document currency. Measures and attributes An important attribute is QuotationSubmissionDate (the date when the supplier quotation was submitted).

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-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

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_SupplierQuotation	I_SupplierQuotation	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_PurchasingDocument	_SupplierQuotationExtension	`$projection.SupplierQuotation = _SupplierQuotationExtension.PurchasingDocument`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IMMQTNAPI01	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
EndUserText.label	Supplier Quotation	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (37)

Key	Field	Source Table	Source Field	Description
KEY	SupplierQuotation	I_SupplierQuotation	SupplierQuotation	Supplier Quotation Number
	CompanyCode	I_SupplierQuotation	CompanyCode	Receiver Company Code
	PurchasingDocumentCategory	I_SupplierQuotation	PurchasingDocumentCategory	Purchasing Document Category
	PurchasingDocumentType	I_SupplierQuotation	PurchasingDocumentType	Supplier Quotation Document Type
	Supplier	I_SupplierQuotation	Supplier	Supplier
	CreatedByUser	I_SupplierQuotation	CreatedByUser	User of person who created a purchasing document
	CreationDate	I_SupplierQuotation	CreationDate	Creation Date of Purchasing Document
	LastChangeDateTime	I_SupplierQuotation	LastChangeDateTime	Change Time Stamp
	Language	I_SupplierQuotation	Language	Report Text Language
	DocumentCurrency	I_SupplierQuotation	DocumentCurrency	Document Currency
	IncotermsClassification	I_SupplierQuotation	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	I_SupplierQuotation	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsVersion	I_SupplierQuotation	IncotermsVersion	Incoterms Version
	IncotermsLocation1	I_SupplierQuotation	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	I_SupplierQuotation	IncotermsLocation2	Incoterms Location 2
	PaymentTerms	I_SupplierQuotation	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	I_SupplierQuotation	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	I_SupplierQuotation	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount1Percent	I_SupplierQuotation	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	I_SupplierQuotation	CashDiscount2Percent	Cash Discount Percentage 2
	NetPaymentDays	I_SupplierQuotation	NetPaymentDays	Net Payment Terms Period
	PricingProcedure	I_SupplierQuotation	PricingProcedure	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
	PurchasingDocumentCondition	I_SupplierQuotation	PurchasingDocumentCondition	Number of the Document Condition
	PurchasingOrganization	I_SupplierQuotation	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	I_SupplierQuotation	PurchasingGroup	Purchasing Group
	PurchasingDocumentOrderDate	I_SupplierQuotation	PurchasingDocumentOrderDate	Purchasing Document Date
	RequestForQuotation	I_SupplierQuotation	RequestForQuotation	Request for Quotation
	SupplierQuotationExternalID	I_SupplierQuotation	SupplierQuotationExternalID	Quotation Number
	QuotationSubmissionDate	I_SupplierQuotation	QuotationSubmissionDate	Quotation Submission Date
	QuotationLatestSubmissionDate	I_SupplierQuotation	QuotationLatestSubmissionDate	Deadline for Submission of Bid/Quotation
	BindingPeriodValidityEndDate	I_SupplierQuotation	BindingPeriodValidityEndDate	Binding Period for Quotation
	ExchangeRate	I_SupplierQuotation	ExchangeRate	Exchange rate
	ExchangeRateIsFixed	I_SupplierQuotation	ExchangeRateIsFixed	Indicator for Fixed Exchange Rate
	QTNLifecycleStatus	I_SupplierQuotation	QtnLifecycleStatus	Supplier Quotation Lifecycle Status
	FollowOnDocumentCategory	I_SupplierQuotation	FollowOnDocumentCategory	Follow-On Purchasing Document Category
	FollowOnDocumentType	I_SupplierQuotation	FollowOnDocumentType	Follow-On Purchasing Document Type
	IsEndOfPurposeBlocked	I_SupplierQuotation	IsEndOfPurposeBlocked	Business Purpose Completed

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_SupplierQuotation_Api01.
-- 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: IMMQTNAPI01

CREATE VIEW I_SupplierQuotation_Api01 AS
SELECT
  I_SupplierQuotation.SupplierQuotation AS SupplierQuotation,
  I_SupplierQuotation.CompanyCode AS CompanyCode,
  I_SupplierQuotation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SupplierQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  I_SupplierQuotation.Supplier AS Supplier,
  I_SupplierQuotation.CreatedByUser AS CreatedByUser,
  I_SupplierQuotation.CreationDate AS CreationDate,
  I_SupplierQuotation.LastChangeDateTime AS LastChangeDateTime,
  I_SupplierQuotation.Language AS Language,
  I_SupplierQuotation.DocumentCurrency AS DocumentCurrency,
  I_SupplierQuotation.IncotermsClassification AS IncotermsClassification,
  I_SupplierQuotation.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SupplierQuotation.IncotermsVersion AS IncotermsVersion,
  I_SupplierQuotation.IncotermsLocation1 AS IncotermsLocation1,
  I_SupplierQuotation.IncotermsLocation2 AS IncotermsLocation2,
  I_SupplierQuotation.PaymentTerms AS PaymentTerms,
  I_SupplierQuotation.CashDiscount1Days AS CashDiscount1Days,
  I_SupplierQuotation.CashDiscount2Days AS CashDiscount2Days,
  I_SupplierQuotation.CashDiscount1Percent AS CashDiscount1Percent,
  I_SupplierQuotation.CashDiscount2Percent AS CashDiscount2Percent,
  I_SupplierQuotation.NetPaymentDays AS NetPaymentDays,
  I_SupplierQuotation.PricingProcedure AS PricingProcedure,
  I_SupplierQuotation.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  I_SupplierQuotation.PurchasingOrganization AS PurchasingOrganization,
  I_SupplierQuotation.PurchasingGroup AS PurchasingGroup,
  I_SupplierQuotation.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_SupplierQuotation.RequestForQuotation AS RequestForQuotation,
  I_SupplierQuotation.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  I_SupplierQuotation.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_SupplierQuotation.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_SupplierQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_SupplierQuotation.ExchangeRate AS ExchangeRate,
  I_SupplierQuotation.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  I_SupplierQuotation.QtnLifecycleStatus AS QTNLifecycleStatus,
  I_SupplierQuotation.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_SupplierQuotation.FollowOnDocumentType AS FollowOnDocumentType,
  I_SupplierQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_SupplierQuotation
LEFT OUTER JOIN E_PurchasingDocument AS _SupplierQuotationExtension ON SupplierQuotation = _SupplierQuotationExtension.PurchasingDocument  -- association [1..1]
;

Depth:

I_SupplierQuotation_Api01 view

I_SupplierQuotation view

C_SupplierQuotationDEX view