ESH_N_PURCHASE_REQ

Anchor view -PURCHASE_REQ | view: ESH_L_PURREQN | Extraction: Not supported | Component: Basic Functions
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 TEXT30
CONTROLLINGAREANAME Controlling Area Name TEXT25
COSTCENTERNAME Cost Center Name TEXT20
ISDELETED Deletion Indicator in Purchasing Document ELOEK
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALNAME Material Description TEXT40
MRPAREA MRP Area BERID
MRPAREATEXT MRP Area Text BERTX
DESIREDSUPPLIERNAME Name 1 NAME
FIXEDSUPPLIERNAME Name 1 NAME
PLANTNAME Plant Name TEXT30
PROFITCENTERNAME Description of Profit Center TEXT20
PROJECTNETWORKDESCRIPTION Description TEXT40
PURCHASEREQUISITIONITEMTEXT Short Text TEXT40
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
PURREQNPRICEQUANTITY Price unit DEC5
USERDESCRIPTION User Description SUIDTECHDESC
WBSDESCRIPTION WBS Element Name TEXT40
WBSELEMENTINTERNALID WBS Element PS_S4_PSPNR
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • ESH_N_PURCHASE_REQ.MANDT == T006.MANDT
  • ESH_N_PURCHASE_REQ.BASEUNIT == T006.MSEHI
Fixed Vendor
  • Fixed Vendor
  • Client
  • ESH_N_PURCHASE_REQ.FIXEDSUPPLIER == LFA1.LIFNR
  • ESH_N_PURCHASE_REQ.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • ESH_N_PURCHASE_REQ.MANDT == MARA.MANDT
  • ESH_N_PURCHASE_REQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • ESH_N_PURCHASE_REQ.MANDT == T023.MANDT
  • ESH_N_PURCHASE_REQ.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • ESH_N_PURCHASE_REQ.MANDT == T001W.MANDT
  • ESH_N_PURCHASE_REQ.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • ?
  • Client
  • Purchase Requisition Document Type
  • ESH_N_PURCHASE_REQ.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_N_PURCHASE_REQ.MANDT == T161.MANDT
  • ESH_N_PURCHASE_REQ.PURCHASEREQUISITIONTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_PURCHASE_REQ.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_PURCHASE_REQ.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_N_PURCHASE_REQ.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_PURCHASE_REQ.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • ESH_N_PURCHASE_REQ.MANDT == TCURC.MANDT
  • ESH_N_PURCHASE_REQ.PURREQNITEMCURRENCY == TCURC.WAERS
Desired Vendor
  • Client
  • Desired Vendor
  • ESH_N_PURCHASE_REQ.MANDT == LFA1.MANDT
  • ESH_N_PURCHASE_REQ.SUPPLIER == LFA1.LIFNR