ESH_S_REQUESTFORQUOTATION

Search view -REQUESTFORQUOTATION | view: ESH_U_RFQ | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: EKKOEKPOT001TKA02MARAT023T023TMAKTTPAREKPAT161T161TT024T024ELFA1USR21
Column Name Description
REQUESTFORQUOTATION Request for Quotation
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Creation Date of Purchasing Document
QUOTATIONLATESTSUBMISSIONDATE Deadline for Submission of Bid/Quotation
Column Name Description
ISENDOFPURPOSEBLOCKED Business Purpose Completed Show values
PURCHASINGDOCUMENTCATEGORY Purchasing Document Category Show values
RFQLIFECYCLESTATUS RFQ Lifecycle Status Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company
CORRESPNCINTERNALREFERENCE Our Reference TEXT12
CREATEDBYUSER User of person who created a purchasing document USNAM
MATERIALGROUPNAME Product Group Description
MATERIALNAME Material Description
ORGANIZATIONBPNAME1 Name 1
PURCHASINGDOCUMENTCATEGORYNAME Short Text for Fixed Values DDTEXT
PURCHASINGDOCUMENTITEMTEXT Short Text
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
REQUESTFORQUOTATIONNAME Short description or the title of the RFQ TEXT40
RFQLIFECYCLESTATUSNAME Short Text for Fixed Values
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • ESH_S_REQUESTFORQUOTATION.MANDT == T001.MANDT
  • ESH_S_REQUESTFORQUOTATION.COMPANYCODE == T001.BUKRS
Material Number
  • Material Number
  • Client
  • ESH_S_REQUESTFORQUOTATION.MATERIAL == MARA.MATNR
  • ESH_S_REQUESTFORQUOTATION.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • ESH_S_REQUESTFORQUOTATION.MANDT == T023.MANDT
  • ESH_S_REQUESTFORQUOTATION.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • ESH_S_REQUESTFORQUOTATION.PLANT == T001W.WERKS
  • ESH_S_REQUESTFORQUOTATION.MANDT == T001W.MANDT
RFQ Document Type
  • Purchasing Document Category
  • Client
  • RFQ Document Type
  • ESH_S_REQUESTFORQUOTATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • ESH_S_REQUESTFORQUOTATION.MANDT == T161.MANDT
  • ESH_S_REQUESTFORQUOTATION.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_S_REQUESTFORQUOTATION.MANDT == T024.MANDT
  • ESH_S_REQUESTFORQUOTATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • ESH_S_REQUESTFORQUOTATION.MANDT == T024E.MANDT
  • ESH_S_REQUESTFORQUOTATION.PURCHASINGORGANIZATION == T024E.EKORG
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • ESH_S_REQUESTFORQUOTATION.SUPPLIER == LFA1.LIFNR
  • ESH_S_REQUESTFORQUOTATION.MANDT == LFA1.MANDT