ESH_S_SUPPLIERQUOTATION

Search view -SUPPLIERQUOTATION | view: ESH_U_SPLRQTN | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: EKKOEKPOT001TKA02MARAT023T023TMAKTT161T161TT024T024ELFA1USR21
Column Name Description
SUPPLIERQUOTATION Supplier Quotation Number
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Creation Date of Purchasing Document
PURCHASINGDOCUMENTORDERDATE Purchasing Document Date
QUOTATIONLATESTSUBMISSIONDATE Deadline for Submission of Bid/Quotation
QUOTATIONSUBMISSIONDATE Quotation Submission Date
Column Name Description
ISENDOFPURPOSEBLOCKED Business Purpose Completed Show values
PURCHASINGDOCUMENTCATEGORY Purchasing Document Category Show values
QTNLIFECYCLESTATUS Supplier Quotation Lifecycle Status Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company
CREATEDBYUSER User of person who created a purchasing document USNAM
MATERIALGROUPNAME Product Group Description
MATERIALNAME Material Description
ORGANIZATIONBPNAME1 Name 1 NAME
PURCHASINGDOCUMENTCATEGORYNAME Short Text for Fixed Values DDTEXT
PURCHASINGDOCUMENTITEMTEXT Short Text TEXT40
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
QTNLIFECYCLESTATUSNAME Short Text for Fixed Values
SUPPLIERQUOTATIONEXTERNALID Quotation Number ANGNR
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • ESH_S_SUPPLIERQUOTATION.MANDT == T001.MANDT
  • ESH_S_SUPPLIERQUOTATION.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • ESH_S_SUPPLIERQUOTATION.MANDT == MARA.MANDT
  • ESH_S_SUPPLIERQUOTATION.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • ESH_S_SUPPLIERQUOTATION.MANDT == T023.MANDT
  • ESH_S_SUPPLIERQUOTATION.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • ESH_S_SUPPLIERQUOTATION.MANDT == T001W.MANDT
  • ESH_S_SUPPLIERQUOTATION.PLANT == T001W.WERKS
Supplier Quotation Document Type
  • Client
  • Supplier Quotation Document Type
  • Purchasing Document Category
  • ESH_S_SUPPLIERQUOTATION.MANDT == T161.MANDT
  • ESH_S_SUPPLIERQUOTATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • ESH_S_SUPPLIERQUOTATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_S_SUPPLIERQUOTATION.MANDT == T024.MANDT
  • ESH_S_SUPPLIERQUOTATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • ESH_S_SUPPLIERQUOTATION.MANDT == T024E.MANDT
  • ESH_S_SUPPLIERQUOTATION.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • ESH_S_SUPPLIERQUOTATION.MANDT == LFA1.MANDT
  • ESH_S_SUPPLIERQUOTATION.SUPPLIER == LFA1.LIFNR