ESH_N_SUPPLIERQUOTATION

Anchor view -SUPPLIERQUOTATION | view: ESH_L_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 TEXT25
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
QTNLIFECYCLESTATUSNAME Short Text for Fixed Values DDTEXT
SUPPLIERQUOTATIONEXTERNALID Quotation Number ANGNR
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_N_SUPPLIERQUOTATION.COMPANYCODE == T001.BUKRS
  • ESH_N_SUPPLIERQUOTATION.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_SUPPLIERQUOTATION.MATERIAL == MARA.MATNR
  • ESH_N_SUPPLIERQUOTATION.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ESH_N_SUPPLIERQUOTATION.MATERIALGROUP == T023.MATKL
  • ESH_N_SUPPLIERQUOTATION.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • ESH_N_SUPPLIERQUOTATION.PLANT == T001W.WERKS
  • ESH_N_SUPPLIERQUOTATION.MANDT == T001W.MANDT
Supplier Quotation Document Type
  • Supplier Quotation Document Type
  • Purchasing Document Category
  • Client
  • ESH_N_SUPPLIERQUOTATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • ESH_N_SUPPLIERQUOTATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • ESH_N_SUPPLIERQUOTATION.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_SUPPLIERQUOTATION.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_SUPPLIERQUOTATION.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • ESH_N_SUPPLIERQUOTATION.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_SUPPLIERQUOTATION.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_N_SUPPLIERQUOTATION.SUPPLIER == LFA1.LIFNR
  • ESH_N_SUPPLIERQUOTATION.MANDT == LFA1.MANDT