ESH_N_SUPPLIERQUOTATION

DDL: ESH_N_SUPPLIERQUOTATION SQL: ESH_L_SPLRQTN Type: view
30 Fields 1 Data Sources 2 Associations

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

Data Sources (1)

SourceAliasJoin Type
I_SUPPLIERQUOTATION I_SUPPLIERQUOTATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..*] dd07t _PURCHASINGDOCUMENTCATEGORY $projection.PurchasingDocumentCategory=_PURCHASINGDOCUMENTCATEGORY.domvalue_l and _PURCHASINGDOCUMENTCATEGORY.domname='EBSTYP' and _PURCHASINGDOCUMENTCATEGORY.as4local='A'
[0..*] dd07t _QTNLIFECYCLESTATUS ( $projection.QTNLifecycleStatus=_QTNLIFECYCLESTATUS.domvalue_l AND _QTNLIFECYCLESTATUS.domname='VDM_QTN_LFST_CD' AND _QTNLIFECYCLESTATUS.as4local='A' )

Annotations (7)

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
AbapCatalog.sqlViewName ESH_L_SPLRQTN view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SUPPLIERQUOTATION SUPPLIERQUOTATION RFQ
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
MATERIAL _SUPPLIERQUOTATIONITEM MATERIAL Vehicle Model
MATERIALGROUP _SUPPLIERQUOTATIONITEM MATERIALGROUP Product Group
MATERIALGROUPNAME
MATERIALNAME
ORGANIZATIONBPNAME1 _SUPPLIER ORGANIZATIONBPNAME1 Name 1
PLANT _SUPPLIERQUOTATIONITEM PLANT Valuation Area
PURCHASINGDOCUMENTCATEGORY PURCHASINGDOCUMENTCATEGORY Doc. Category
PURCHASINGDOCUMENTCATEGORYNAME
PURCHASINGDOCUMENTITEMTEXT _SUPPLIERQUOTATIONITEM PURCHASINGDOCUMENTITEMTEXT Short Text
PURCHASINGDOCUMENTORDERDATE PURCHASINGDOCUMENTORDERDATE PO Date
PURCHASINGDOCUMENTTYPE PURCHASINGDOCUMENTTYPE RFQ Type
PURCHASINGDOCUMENTTYPENAME
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME _PURCHASINGGROUP PURCHASINGGROUPNAME Purchasing Grp. Name
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME _PURCHASINGORGANIZATION PURCHASINGORGANIZATIONNAME Purch. Org. Name
QTNLIFECYCLESTATUS QTNLIFECYCLESTATUS Status
QTNLIFECYCLESTATUSNAME
QUOTATIONLATESTSUBMISSIONDATE QUOTATIONLATESTSUBMISSIONDATE Quot. Deadline
QUOTATIONSUBMISSIONDATE QUOTATIONSUBMISSIONDATE Quotation Date
REQUESTFORQUOTATION REQUESTFORQUOTATION RFQ
SUPPLIER SUPPLIER Supplier
SUPPLIERQUOTATIONEXTERNALID SUPPLIERQUOTATIONEXTERNALID Quotation
USERDESCRIPTION _CREATEDBYUSER 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_N_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_L_SPLRQTN
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SUPPLIERQUOTATION AS
SELECT
  SUPPLIERQUOTATION,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATE,
  ISENDOFPURPOSEBLOCKED,
  _SUPPLIERQUOTATIONITEM.MATERIAL AS MATERIAL,
  _SUPPLIERQUOTATIONITEM.MATERIALGROUP AS MATERIALGROUP,
  _SUPPLIERQUOTATIONITEM._MATERIALGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME AS MATERIALGROUPNAME,
  _SUPPLIERQUOTATIONITEM._MATERIAL._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALNAME AS MATERIALNAME,
  _SUPPLIER.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _SUPPLIERQUOTATIONITEM.PLANT AS PLANT,
  PURCHASINGDOCUMENTCATEGORY,
  _PURCHASINGDOCUMENTCATEGORY[1: ddlanguage = $parameters. P_Language].ddtext AS PURCHASINGDOCUMENTCATEGORYNAME,
  _SUPPLIERQUOTATIONITEM.PURCHASINGDOCUMENTITEMTEXT AS PURCHASINGDOCUMENTITEMTEXT,
  PURCHASINGDOCUMENTORDERDATE,
  PURCHASINGDOCUMENTTYPE,
  _PURCHASINGDOCUMENTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].PURCHASINGDOCUMENTTYPENAME AS PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  _PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  QTNLIFECYCLESTATUS,
  _QTNLIFECYCLESTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS QTNLIFECYCLESTATUSNAME,
  QUOTATIONLATESTSUBMISSIONDATE,
  QUOTATIONSUBMISSIONDATE,
  REQUESTFORQUOTATION,
  SUPPLIER,
  SUPPLIERQUOTATIONEXTERNALID,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_SUPPLIERQUOTATION
LEFT OUTER JOIN dd07t AS _PURCHASINGDOCUMENTCATEGORY ON PurchasingDocumentCategory=_PURCHASINGDOCUMENTCATEGORY.domvalue_l AND _PURCHASINGDOCUMENTCATEGORY.domname='EBSTYP' AND _PURCHASINGDOCUMENTCATEGORY.as4local='A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS _QTNLIFECYCLESTATUS ON ( QTNLifecycleStatus=_QTNLIFECYCLESTATUS.domvalue_l AND _QTNLIFECYCLESTATUS.domname='VDM_QTN_LFST_CD' AND _QTNLIFECYCLESTATUS.as4local='A' )  -- association [0..*]
;

Learn More