ESH_N_REQUESTFORQUOTATION

DDL: ESH_N_REQUESTFORQUOTATION SQL: ESH_L_RFQ Type: view
28 Fields 1 Data Sources 2 Associations

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

Data Sources (1)

SourceAliasJoin Type
I_REQUESTFORQUOTATION I_REQUESTFORQUOTATION 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 _RFQLIFECYCLESTATUS ( $projection.RFQLifecycleStatus=_RFQLIFECYCLESTATUS.domvalue_l AND _RFQLIFECYCLESTATUS.domname='VDM_RFQ_LFST_CD' AND _RFQLIFECYCLESTATUS.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_RFQ view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY REQUESTFORQUOTATION REQUESTFORQUOTATION RFQ
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
CORRESPNCINTERNALREFERENCE CORRESPNCINTERNALREFERENCE Our Reference
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
MATERIAL _REQUESTFORQUOTATIONITEM MATERIAL Vehicle Model
MATERIALGROUP _REQUESTFORQUOTATIONITEM MATERIALGROUP Product Group
MATERIALGROUPNAME
MATERIALNAME
ORGANIZATIONBPNAME1
PLANT _REQUESTFORQUOTATIONITEM PLANT Valuation Area
PURCHASINGDOCUMENTCATEGORY PURCHASINGDOCUMENTCATEGORY Doc. Category
PURCHASINGDOCUMENTCATEGORYNAME
PURCHASINGDOCUMENTITEMTEXT _REQUESTFORQUOTATIONITEM PURCHASINGDOCUMENTITEMTEXT Short Text
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
QUOTATIONLATESTSUBMISSIONDATE QUOTATIONLATESTSUBMISSIONDATE Quot. Deadline
REQUESTFORQUOTATIONNAME REQUESTFORQUOTATIONNAME RFQ Description
RFQLIFECYCLESTATUS RFQLIFECYCLESTATUS Status
RFQLIFECYCLESTATUSNAME
SUPPLIER _RFQBIDDER SUPPLIER Supplier
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_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_L_RFQ
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_REQUESTFORQUOTATION AS
SELECT
  REQUESTFORQUOTATION,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CORRESPNCINTERNALREFERENCE,
  CREATEDBYUSER,
  CREATIONDATE,
  ISENDOFPURPOSEBLOCKED,
  _REQUESTFORQUOTATIONITEM.MATERIAL AS MATERIAL,
  _REQUESTFORQUOTATIONITEM.MATERIALGROUP AS MATERIALGROUP,
  _REQUESTFORQUOTATIONITEM._MATERIALGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME AS MATERIALGROUPNAME,
  _REQUESTFORQUOTATIONITEM._MATERIAL._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALNAME AS MATERIALNAME,
  _RFQBIDDER._SUPPLIER[1: SUPPLIERLANGUAGE = $parameters. P_Language].ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _REQUESTFORQUOTATIONITEM.PLANT AS PLANT,
  PURCHASINGDOCUMENTCATEGORY,
  _PURCHASINGDOCUMENTCATEGORY[1: ddlanguage = $parameters. P_Language].ddtext AS PURCHASINGDOCUMENTCATEGORYNAME,
  _REQUESTFORQUOTATIONITEM.PURCHASINGDOCUMENTITEMTEXT AS PURCHASINGDOCUMENTITEMTEXT,
  PURCHASINGDOCUMENTTYPE,
  _RFQTYPE._RFQTYPETEXT[1: LANGUAGE = $parameters. P_Language].PURCHASINGDOCUMENTTYPENAME AS PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  _PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  QUOTATIONLATESTSUBMISSIONDATE,
  REQUESTFORQUOTATIONNAME,
  RFQLIFECYCLESTATUS,
  _RFQLIFECYCLESTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS RFQLIFECYCLESTATUSNAME,
  _RFQBIDDER.SUPPLIER AS SUPPLIER,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_REQUESTFORQUOTATION
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 _RFQLIFECYCLESTATUS ON ( RFQLifecycleStatus=_RFQLIFECYCLESTATUS.domvalue_l AND _RFQLIFECYCLESTATUS.domname='VDM_RFQ_LFST_CD' AND _RFQLIFECYCLESTATUS.as4local='A' )  -- association [0..*]
;

Learn More