ESH_S_REQUESTFORQUOTATION

DDL: ESH_S_REQUESTFORQUOTATION SQL: ESH_U_RFQ Type: view
28 Fields 1 Data Sources 1 Associations

ESH_S_REQUESTFORQUOTATION is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_REQUESTFORQUOTATION) and exposes 28 fields with key field REQUESTFORQUOTATION. It has 1 association to related views.

SAP Help Documentation

CategoryRequest for Quotation
StatusText of the RFQ status. Currently, the following statuses are available: In Preparation Published Cancelled In Approval Rejected Completed
Purpose
This CDS view enables you to use the Enterprise Search in the header bar of the SAP Fiori launchpad to find a particular request for quotation. Before you enter any attributes in the search input field, you should select the category Requests for Quotations . In the search input field, you can, for example, enter a material number to display all RFQs containing this material number. To narrow down your search results, you can also combine several attributes, such as a material number and a purchasing organization. The search takes into account all fields described in the Attributes section below. A list of RFQs is displayed as a result. For the first RFQ, the display area includes the header, the summary, and details. For all other RFQs, you only see a header and a summary. To display the details of other RFQs, you can expand the display area. Note If you cannot find the expected results, try again using *, for example *12345 or *john. This CDS view provides the prerequisites for processing the following business task: I as purchaser want to find particular RFQs directly from the SAP Fiori launchpad without entering the Manage RFQs app.

Prerequisites
You have authorizations to access the relevant RFQs.

Structure
Object types This view is built on the following SAP business objects and uses all relevant attributes: RFQ Main input parameters The main input parameter is: P_Language used to specify the target language for data display. Main CDS filters The main filters are: COMPANYCODE (Company Code) CREATEDBYUSER (Created By) MATERIAL (Material) MATERIALGROUP (Material Group) PURCHASINGDOCUMENTTYPE (Purchasing Document Type) PURCHASINGGROUP (Purchasing Group) PURCHASINGORGANIZATION (Purchasing Organization) RFQLIFECYCLESTATUSNAME (Status) SUPPLIER (Supplier) Attributes The following table explains the most important attributes in the view. Attribute Description COMPANYCODE Company code ID COMPANYCODENAME Company code text name CREATEDBYUSER ID of the user who created an RFQ. CREATIONDATE Date when the RFQ has been created. MATERIAL Material ID that is used in the RFQ. MATERIALGROUP Material group ID that is used in the RFQ. MATERIALGROUPNAME Material group name that is used in the RFQ. MATERIALNAME Material name that is used in the RFQ. ORGANIZATIONBPNAME1 Name of the suppliers that were invited to place their bids. PURCHASINGDOCUMENTITEMTEXT Description of an item in the RFQ PURCHASINGDOCUMENTTYPENAME Name of RFQ type. Currently, there are three RFQ types: Ext. Sourcing Req. Ext. Price Request Int. Sourcing Req. PURCHASINGGROUPNAME Purchasing group name PURCHASINGORGANIZATIONNAME Purchasing organization name QUOTATIONLATESTSUBMISSIONDATE Quotation deadline REQUESTFORQUOTATION RFQ ID REQUESTFORQUOTATIONNAME RFQ name RFQLIFECYCLESTATUSNAME Text of the RFQ status. Currently, the following statuses are available: In Preparation Published Cancelled In Approval Rejected Completed SUPPLIER ID of the suppliers that were invited to place their bids. USERDESCRIPTION Name of the user who created an RFQ

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
ESH_N_REQUESTFORQUOTATION ESH_N_REQUESTFORQUOTATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PURCHASINGDOCUMENT _REQUESTQTNEXTENSION ( $projection.REQUESTFORQUOTATION = _REQUESTQTNEXTENSION.PURCHASINGDOCUMENT )

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name RequestForQuotation view
UI.headerInfo.typeName Request for Quotation view
UI.headerInfo.typeNamePlural Requests for Quotations view
EnterpriseSearch.dclInterpretationMode #RESPECT_CARDINALITY view
Consumption.semanticObject RequestForQuotation view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value REQUESTFORQUOTATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_RFQ view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY REQUESTFORQUOTATION REQUESTFORQUOTATION RFQ
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME COMPANYCODENAME Company Code
CORRESPNCINTERNALREFERENCE CORRESPNCINTERNALREFERENCE Our Reference
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
MATERIAL MATERIAL Vehicle Model
MATERIALGROUP MATERIALGROUP Product Group
MATERIALGROUPNAME MATERIALGROUPNAME Material Group
MATERIALNAME MATERIALNAME Material
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Supplier
PLANT PLANT Valuation Area
PURCHASINGDOCUMENTCATEGORY PURCHASINGDOCUMENTCATEGORY Doc. Category
PURCHASINGDOCUMENTCATEGORYNAME PURCHASINGDOCUMENTCATEGORYNAME Short Description
PURCHASINGDOCUMENTITEMTEXT PURCHASINGDOCUMENTITEMTEXT Item Description
PURCHASINGDOCUMENTTYPE PURCHASINGDOCUMENTTYPE Purchasing Document Type
PURCHASINGDOCUMENTTYPENAME PURCHASINGDOCUMENTTYPENAME Purchasing Document Type
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME PURCHASINGGROUPNAME Purchasing Group
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME PURCHASINGORGANIZATIONNAME Purchasing Organization
QUOTATIONLATESTSUBMISSIONDATE QUOTATIONLATESTSUBMISSIONDATE Quot. Deadline
REQUESTFORQUOTATIONNAME REQUESTFORQUOTATIONNAME RFQ Description
RFQLIFECYCLESTATUS RFQLIFECYCLESTATUS Status
RFQLIFECYCLESTATUSNAME RFQLIFECYCLESTATUSNAME Status
SUPPLIER SUPPLIER Supplier
USERDESCRIPTION USERDESCRIPTION Created By

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 ESH_S_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: ESH_U_RFQ
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_REQUESTFORQUOTATION AS
SELECT
  REQUESTFORQUOTATION,
  COMPANYCODE,
  COMPANYCODENAME,
  CORRESPNCINTERNALREFERENCE,
  CREATEDBYUSER,
  CREATIONDATE,
  ISENDOFPURPOSEBLOCKED,
  MATERIAL,
  MATERIALGROUP,
  MATERIALGROUPNAME,
  MATERIALNAME,
  ORGANIZATIONBPNAME1,
  PLANT,
  PURCHASINGDOCUMENTCATEGORY,
  PURCHASINGDOCUMENTCATEGORYNAME,
  PURCHASINGDOCUMENTITEMTEXT,
  PURCHASINGDOCUMENTTYPE,
  PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  PURCHASINGORGANIZATIONNAME,
  QUOTATIONLATESTSUBMISSIONDATE,
  REQUESTFORQUOTATIONNAME,
  RFQLIFECYCLESTATUS,
  RFQLIFECYCLESTATUSNAME,
  SUPPLIER,
  USERDESCRIPTION
FROM ESH_N_REQUESTFORQUOTATION
LEFT OUTER JOIN E_PURCHASINGDOCUMENT AS _REQUESTQTNEXTENSION ON ( REQUESTFORQUOTATION = _REQUESTQTNEXTENSION.PURCHASINGDOCUMENT )  -- association [0..1]
;

Learn More