ESH_S_SUPPLIERQUOTATION

DDL: ESH_S_SUPPLIERQUOTATION SQL: ESH_U_SPLRQTN Type: view
30 Fields 1 Data Sources 1 Associations

ESH_S_SUPPLIERQUOTATION is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_SUPPLIERQUOTATION) and exposes 30 fields with key field SUPPLIERQUOTATION. It has 1 association to related views.

SAP Help Documentation

CategorySupplier Quotation
StatusSupplier quotation status. Currently, the following statuses are available: In Preparation Submitted Cancelled In Approval Awarded 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 supplier quotation. Before you enter any attributes in the search input field, you should select the category Supplier Quotations . In the search input field, you can, for example, enter a material number to display all supplier quotations 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 supplier quotations is displayed as a result. For the first supplier quotation, the display area includes the header, the summary, and details. For all other supplier quotations, you only see a header and a summary. To display the details of other supplier quotations, 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 supplier quotations directly from the SAP Fiori launchpad without entering the Manage Supplier Quotations app.

Prerequisites
You have authorizations to access the relevant supplier quotations.

Structure
Object types This view is built on the following SAP business object and uses all relevant attributes: Supplier quotation 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) CREATIONDATE (Created On) MATERIAL (Material) MATERIALGROUP (Material Group) PLANT (Plant) PURCHASINGDOCUMENTTYPE (Purchasing Document Type) PURCHASINGGROUP (Purchasing Group) PURCHASINGORGANIZATION (Purchasing Organization) QUOTATIONLATESTSUBMISSIONDATE (Quotation Deadline) QUOTATIONSUBMISSIONDATE (Quotation Submission Date) QTNLIFECYCLESTATUSNAME (Status) SUPPLIER (Supplier) Attributes The following table explains the most important attributes in the view. Attribute Description COMPANYCODE Company code ID COMPANYCODENAME Company code name CREATEDBYUSER ID of the user who created supplier quotation. CREATIONDATE Date when the supplier quotation has been created. MATERIAL Material ID that is used in the supplier quotation. MATERIALGROUP Material group ID that is used in the supplier quotation. MATERIALGROUPNAME Material group name that is used in the supplier quotation. MATERIALNAME Material name that is used in the supplier quotation. ORGANIZATIONBPNAME1 Name of the suppliers that submitted supplier quotation. PLANT Plant to which the supplier quotation is referenced to. PURCHASINGDOCUMENTITEMTEXT Description of an item in the supplier quotation PURCHASINGDOCUMENTTYPENAME Name of the supplier quotation type. Currently, there are three supplier quotation types: Price Quotation Internal Quotation External Quotation PURCHASINGGROUPNAME Purchasing group name PURCHASINGORGANIZATIONNAME Purchasing organization name QUOTATIONLATESTSUBMISSIONDATE Quotation deadline. The latest date till which it is possible to submit supplier quotations. QUOTATIONSUBMISSIONDATE Date when the supplier quotation has been submitted. REQUESTFORQUOTATION ID of the RFQ that is referenced by the supplier quotation QTNLIFECYCLESTATUSNAME Supplier quotation status. Currently, the following statuses are available: In Preparation Submitted Cancelled In Approval Awarded Completed SUPPLIER ID of a supplier that submitted a quotation. SUPPLIERQUOTATION Supplier quotation ID USERDESCRIPTION Name of the user who created an RFQ

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
ESH_N_SUPPLIERQUOTATION ESH_N_SUPPLIERQUOTATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PURCHASINGDOCUMENT _SUPPLIERQTNEXTENSION ( $projection.SUPPLIERQUOTATION = _SUPPLIERQTNEXTENSION.PURCHASINGDOCUMENT )

Annotations (18)

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 SupplierQuotation view
UI.headerInfo.typeName Supplier Quotation view
UI.headerInfo.typeNamePlural Supplier Quotations view
Consumption.semanticObject SupplierQuotation view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value SUPPLIERQUOTATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_SPLRQTN view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SUPPLIERQUOTATION SUPPLIERQUOTATION RFQ
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME COMPANYCODENAME Company Code
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 Name 1
PLANT PLANT Valuation Area
PURCHASINGDOCUMENTCATEGORY PURCHASINGDOCUMENTCATEGORY Doc. Category
PURCHASINGDOCUMENTCATEGORYNAME PURCHASINGDOCUMENTCATEGORYNAME Short Description
PURCHASINGDOCUMENTITEMTEXT PURCHASINGDOCUMENTITEMTEXT Short Text
PURCHASINGDOCUMENTORDERDATE PURCHASINGDOCUMENTORDERDATE PO Date
PURCHASINGDOCUMENTTYPE PURCHASINGDOCUMENTTYPE RFQ Type
PURCHASINGDOCUMENTTYPENAME PURCHASINGDOCUMENTTYPENAME Purchasing Document Type
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME PURCHASINGGROUPNAME Purchasing Group
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME PURCHASINGORGANIZATIONNAME Purchasing Organization
QTNLIFECYCLESTATUS QTNLIFECYCLESTATUS Status
QTNLIFECYCLESTATUSNAME QTNLIFECYCLESTATUSNAME Status
QUOTATIONLATESTSUBMISSIONDATE QUOTATIONLATESTSUBMISSIONDATE Quot. Deadline
QUOTATIONSUBMISSIONDATE QUOTATIONSUBMISSIONDATE Quotation Submission Date
REQUESTFORQUOTATION REQUESTFORQUOTATION RFQ
SUPPLIER SUPPLIER Supplier
SUPPLIERQUOTATIONEXTERNALID SUPPLIERQUOTATIONEXTERNALID Quotation
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_SUPPLIERQUOTATION.
-- 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_SPLRQTN
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_SUPPLIERQUOTATION AS
SELECT
  SUPPLIERQUOTATION,
  COMPANYCODE,
  COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATE,
  ISENDOFPURPOSEBLOCKED,
  MATERIAL,
  MATERIALGROUP,
  MATERIALGROUPNAME,
  MATERIALNAME,
  ORGANIZATIONBPNAME1,
  PLANT,
  PURCHASINGDOCUMENTCATEGORY,
  PURCHASINGDOCUMENTCATEGORYNAME,
  PURCHASINGDOCUMENTITEMTEXT,
  PURCHASINGDOCUMENTORDERDATE,
  PURCHASINGDOCUMENTTYPE,
  PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  PURCHASINGORGANIZATIONNAME,
  QTNLIFECYCLESTATUS,
  QTNLIFECYCLESTATUSNAME,
  QUOTATIONLATESTSUBMISSIONDATE,
  QUOTATIONSUBMISSIONDATE,
  REQUESTFORQUOTATION,
  SUPPLIER,
  SUPPLIERQUOTATIONEXTERNALID,
  USERDESCRIPTION
FROM ESH_N_SUPPLIERQUOTATION
LEFT OUTER JOIN E_PURCHASINGDOCUMENT AS _SUPPLIERQTNEXTENSION ON ( SUPPLIERQUOTATION = _SUPPLIERQTNEXTENSION.PURCHASINGDOCUMENT )  -- association [0..1]
;

Learn More