ESH_N_CENTRALSUPPLIERQUOTATION

Anchor view -CENTRALSUPPLIERQUOTATION | view: ESH_L_CNTRLQTN | TRAN | Extraction: Not supported | Component: Central RFQ/Central Quotations
Tables used: EKKOEKPOT001TKA02T001WT024T024ELFA1USR21
Column Name Description
CENTRALSUPPLIERQUOTATION Central 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
ORGANIZATIONBPNAME1 Name 1 NAME
PURCHASINGDOCUMENTITEMTEXT Short Text TEXT40
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
  • Client
  • Company Code
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T001.MANDT
  • ESH_N_CENTRALSUPPLIERQUOTATION.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == MARA.MANDT
  • ESH_N_CENTRALSUPPLIERQUOTATION.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • ESH_N_CENTRALSUPPLIERQUOTATION.MATERIALGROUP == T023.MATKL
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T001W.MANDT
  • ESH_N_CENTRALSUPPLIERQUOTATION.PLANT == T001W.WERKS
Supplier Quotation Document Type
  • Supplier Quotation Document Type
  • Purchasing Document Category
  • Client
  • ESH_N_CENTRALSUPPLIERQUOTATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • ESH_N_CENTRALSUPPLIERQUOTATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T024.MANDT
  • ESH_N_CENTRALSUPPLIERQUOTATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == T024E.MANDT
  • ESH_N_CENTRALSUPPLIERQUOTATION.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • ESH_N_CENTRALSUPPLIERQUOTATION.SUPPLIER == LFA1.LIFNR
  • ESH_N_CENTRALSUPPLIERQUOTATION.MANDT == LFA1.MANDT