ESH_S_CNTRLREQUESTFORQUOTATION

DDL: ESH_S_CNTRLREQUESTFORQUOTATION SQL: ESH_U_CQTN Type: view
22 Fields 1 Data Sources 1 Associations

ESH_S_CNTRLREQUESTFORQUOTATION is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_CNTRLREQUESTFORQUOTATION) and exposes 22 fields with key field CENTRALREQUESTFORQUOTATION. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Central Sourcing
StatusText of the RFQ status. Currently, the following statuses are available: In Preparation Published Canceled 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 central request for quotation. Before you enter any attributes in the search input field, you must select the category Central Requests for Quotations . In the search input field, you can, for example, enter a material number to display all central requests for quotation 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 Measures and attributes section below. A list of central requests for quotation is displayed as a result. For the first central requests for quotation, the display area includes the header, the summary, and details. For all other central requests for quotation, you only see a header and a summary. To display the details of other central requests for quotation, 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 a purchaser want to find particular central requests for quotation directly from the SAP Fiori launchpad without entering the Manage Central RFQs app.

Prerequisites
The following prerequisites must be met: 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
Object types This view relates to the following SAP business object: Central RFQ Main parameters and filters of the CDS view The main parameter is: P_Language used to specify the target language for the data display The main filters are as follows: COMPANYCODE (Company Code) CREATEDBYUSER (Created By) MATERIAL (Material) PURCHASINGGROUP (Purchasing Group) PURCHASINGORGANIZATION (Purchasing Organization) RFQLIFECYCLESTATUSNAME (Status) SUPPLIER (Supplier) Measures and attributes The following table explains the most important attributes in the view. Attribute Description CENTRALREQUESTFORQUOTATION RFQ ID COMPANYCODE Company code ID COMPANYCODENAME Company code text name CORRESPNCINTERNALREFERENCE Our Reference CREATEDBYUSER ID of the user who created an RFQ. CREATIONDATE Date when the RFQ has been created. DOCUMENTCURRENCY Currency ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd. MATERIALGROUP Material Group MATERIALGROUPNAME Product Group Description MATERIALNAME Material name that is used in the RFQ. ORGANIZATIONBPNAME1 Name of the suppliers that were invited to place their bids. PLANT Plant PURCHASINGCENTRALMATERIAL Material ID that is used in the RFQ. PURCHASINGDOCUMENTCATEGORY Purch. Doc. Category PURCHASINGDOCUMENTCATEGORYNAME Short Text for Fixed Values PURCHASINGDOCUMENTITEMTEXT Description of an item in the RFQ PURCHASINGDOCUMENTTYPENAME Name of RFQ type. Currently, there are two RFQ types: Ext. Sourcing Req. Int. Sourcing Req. PURCHASINGDOCUMENTTYPENAME Name of RFQ type. Currently, there are two RFQ types: Ext. Sourcing Req Int. Sourcing Req. PURCHASINGGROUP Purchasing Group PURCHASINGGROUPNAME Purchasing group name PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization PURCHASINGORGANIZATIONNAME Purchasing organization name QUOTATIONLATESTSUBMISSIONDATE Quotation deadline REQUESTFORQUOTATIONNAME RFQ name RFQLIFECYCLESTATUS Status RFQLIFECYCLESTATUSNAME Text of the RFQ status. Currently, the following statuses are available: In Preparation Published Canceled 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_CNTRLREQUESTFORQUOTATION ESH_N_CNTRLREQUESTFORQUOTATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PURCHASINGDOCUMENT _CENTRALREQFORQUOTATIONEXTN ( $projection.CENTRALREQUESTFORQUOTATION = _CENTRALREQFORQUOTATIONEXTN.PURCHASINGDOCUMENT )

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C 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 CentralRequestForQuotation view
UI.headerInfo.typeName Central Request For Quotation view
UI.headerInfo.typeNamePlural Central Request For Quotations view
Consumption.semanticObject CentralRequestForQuotation view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value CENTRALREQUESTFORQUOTATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_CQTN view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CENTRALREQUESTFORQUOTATION CENTRALREQUESTFORQUOTATION
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME COMPANYCODENAME Company Name
CORRESPNCINTERNALREFERENCE CORRESPNCINTERNALREFERENCE Our Reference
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
MATERIALGROUP MATERIALGROUP Product Group
PLANT PLANT Valuation Area
PURCHASINGCENTRALMATERIAL PURCHASINGCENTRALMATERIAL Material
PURCHASINGDOCUMENTCATEGORY PURCHASINGDOCUMENTCATEGORY Doc. Category
PURCHASINGDOCUMENTITEMTEXT PURCHASINGDOCUMENTITEMTEXT Short Text
PURCHASINGDOCUMENTTYPE PURCHASINGDOCUMENTTYPE RFQ Type
PURCHASINGDOCUMENTTYPENAME PURCHASINGDOCUMENTTYPENAME Description
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME PURCHASINGGROUPNAME Purchasing Grp. Name
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME PURCHASINGORGANIZATIONNAME Purch. Org. Name
QUOTATIONLATESTSUBMISSIONDATE QUOTATIONLATESTSUBMISSIONDATE Quot. Deadline
REQUESTFORQUOTATIONNAME REQUESTFORQUOTATIONNAME RFQ Description
RFQLIFECYCLESTATUS RFQLIFECYCLESTATUS Status
USERDESCRIPTION USERDESCRIPTION Full Name

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_CNTRLREQUESTFORQUOTATION.
-- 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_CQTN
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_CNTRLREQUESTFORQUOTATION AS
SELECT
  CENTRALREQUESTFORQUOTATION,
  COMPANYCODE,
  COMPANYCODENAME,
  CORRESPNCINTERNALREFERENCE,
  CREATEDBYUSER,
  CREATIONDATE,
  ISENDOFPURPOSEBLOCKED,
  MATERIALGROUP,
  PLANT,
  PURCHASINGCENTRALMATERIAL,
  PURCHASINGDOCUMENTCATEGORY,
  PURCHASINGDOCUMENTITEMTEXT,
  PURCHASINGDOCUMENTTYPE,
  PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  PURCHASINGORGANIZATIONNAME,
  QUOTATIONLATESTSUBMISSIONDATE,
  REQUESTFORQUOTATIONNAME,
  RFQLIFECYCLESTATUS,
  USERDESCRIPTION
FROM ESH_N_CNTRLREQUESTFORQUOTATION
LEFT OUTER JOIN E_PURCHASINGDOCUMENT AS _CENTRALREQFORQUOTATIONEXTN ON ( CENTRALREQUESTFORQUOTATION = _CENTRALREQFORQUOTATIONEXTN.PURCHASINGDOCUMENT )  -- association [0..1]
;

Learn More