ESH_S_PURCHASE_REQ

Search view -PURCHASE_REQ | view: ESH_U_PURREQN | Extraction: Not supported | Component: Basic Functions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, EBAN, PRTE, EBKN, TGSBT, TKA01, CSKS, CSKT, FM01, AUFK, MARA, T023, T023T, MAKT, MDLV, T001W, CEPC, CEPCT, PROJ, PROJ, CNLDST_SHORTTX, T024, T024E, T000, LFA1, USR21, T001K, PRPS, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PURCHASEREQUISITION Purchase requisition number
PURCHASEREQUISITIONITEM Item number of purchase requisition
Column Name Description
💲 Currency Key (PURREQNITEMCURRENCY):
PURCHASEREQUISITIONPRICE Price in Purchase Requisition
Column Name Description
📏 Purchase requisition unit of measure (BASEUNIT):
REQUESTEDQUANTITY Purchase requisition quantity
Column Name Description
COSTCENTERVALIDTODATE Valid To Date
DELIVERYDATE Item delivery date
LASTCHANGEDDATE Last Changed On
PRFTCTRVALIDTODATE Valid To Date
Column Name Description
Column Name Description Domain name
BUSINESSAREANAME Business Area Description
CONTROLLINGAREANAME Controlling Area Name
COSTCENTERNAME Cost Center Name TEXT20
ISDELETED Deletion Indicator in Purchasing Document ELOEK
MATERIALGROUPNAME Product Group Description
MATERIALNAME Material Description
MRPAREA MRP Area BERID
MRPAREATEXT MRP Area Text
DESIREDSUPPLIERNAME Name 1 NAME
FIXEDSUPPLIERNAME Name 1 NAME
PLANTNAME Plant Name
PROFITCENTERNAME Description of Profit Center
PROJECTNETWORKDESCRIPTION Description
PURCHASEREQUISITIONITEMTEXT Short Text TEXT40
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
PURREQNPRICEQUANTITY Price unit
USERDESCRIPTION User Description
WBSDESCRIPTION WBS Element Name
WBSELEMENTINTERNALID WBS Element PS_S4_PSPNR
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • ESH_S_PURCHASE_REQ.MANDT == T006.MANDT
  • ESH_S_PURCHASE_REQ.BASEUNIT == T006.MSEHI
Fixed Vendor
  • Fixed Vendor
  • Client
  • ESH_S_PURCHASE_REQ.FIXEDSUPPLIER == LFA1.LIFNR
  • ESH_S_PURCHASE_REQ.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • ESH_S_PURCHASE_REQ.MANDT == MARA.MANDT
  • ESH_S_PURCHASE_REQ.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • ESH_S_PURCHASE_REQ.MATERIALGROUP == T023.MATKL
  • ESH_S_PURCHASE_REQ.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • ESH_S_PURCHASE_REQ.MANDT == T001W.MANDT
  • ESH_S_PURCHASE_REQ.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • ESH_S_PURCHASE_REQ.PURCHASEREQUISITIONTYPE == T161.BSART
  • ESH_S_PURCHASE_REQ.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_S_PURCHASE_REQ.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_S_PURCHASE_REQ.PURCHASINGGROUP == T024.EKGRP
  • ESH_S_PURCHASE_REQ.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_S_PURCHASE_REQ.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_S_PURCHASE_REQ.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • ESH_S_PURCHASE_REQ.MANDT == TCURC.MANDT
  • ESH_S_PURCHASE_REQ.PURREQNITEMCURRENCY == TCURC.WAERS
Desired Vendor
  • Client
  • Desired Vendor
  • ESH_S_PURCHASE_REQ.MANDT == LFA1.MANDT
  • ESH_S_PURCHASE_REQ.SUPPLIER == LFA1.LIFNR