ESH_N_REQUESTFORQUOTATION

Anchor view -REQUESTFORQUOTATION | view: ESH_L_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 TEXT25
CORRESPNCINTERNALREFERENCE Our Reference TEXT12
CREATEDBYUSER User of person who created a purchasing document USNAM
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALNAME Material Description TEXT40
ORGANIZATIONBPNAME1 Name 1 NAME
PURCHASINGDOCUMENTCATEGORYNAME Short Text for Fixed Values DDTEXT
PURCHASINGDOCUMENTITEMTEXT Short Text TEXT40
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
REQUESTFORQUOTATIONNAME Short description or the title of the RFQ TEXT40
RFQLIFECYCLESTATUSNAME Short Text for Fixed Values DDTEXT
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_N_REQUESTFORQUOTATION.COMPANYCODE == T001.BUKRS
  • ESH_N_REQUESTFORQUOTATION.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_REQUESTFORQUOTATION.MATERIAL == MARA.MATNR
  • ESH_N_REQUESTFORQUOTATION.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ESH_N_REQUESTFORQUOTATION.MATERIALGROUP == T023.MATKL
  • ESH_N_REQUESTFORQUOTATION.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • ESH_N_REQUESTFORQUOTATION.MANDT == T001W.MANDT
  • ESH_N_REQUESTFORQUOTATION.PLANT == T001W.WERKS
RFQ Document Type
  • RFQ Document Type
  • Purchasing Document Category
  • Client
  • ESH_N_REQUESTFORQUOTATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • ESH_N_REQUESTFORQUOTATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • ESH_N_REQUESTFORQUOTATION.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_REQUESTFORQUOTATION.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_REQUESTFORQUOTATION.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • ESH_N_REQUESTFORQUOTATION.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_REQUESTFORQUOTATION.MANDT == T024E.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • ESH_N_REQUESTFORQUOTATION.SUPPLIER == LFA1.LIFNR
  • ESH_N_REQUESTFORQUOTATION.MANDT == LFA1.MANDT