m_v_m2s_pr_itm

ME2STAR: CDS View for Purchase Requisition | view: CDS_M_M2S_PR_ITM | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EBAN, EBKN, EBAN, ADRP, LFA1, MAKT, T001W, T023T, T024, T024E, USR21
Column Name Description
banfn Purchase Requisition Number
bnfpo Item number of purchase requisition
Column Name Description
💲 Currency Key (waers):
preis Price in Purchase Requisition
Column Name Description
📏 Purchase requisition unit of measure (meins):
menge Purchase requisition quantity
bsmng Quantity ordered against this purchase requisition
Column Name Description
badat Requisition (request) date
erdat Last Changed On
lfdat Item delivery date
frgdt Purchase Requisition Release Date
Column Name Description
bstyp Purchasing Document Category Show values
statu Processing status of purchase requisition Show values
banpr Requisition Processing State Show values
ebakz Purchase requisition closed Show values
Column Name Description Domain name
loekz Deletion Indicator in Purchasing Document ELOEK
txz01 Short Text TEXT40
afnam Name of requisitioner/requester AFNAM
bednr Requirement Tracking Number CHAR10
reswk Supplying (issuing) plant in case of stock transport order WERKS
vbeln Sales and Distribution Document Number VBELN
frgst Release strategy in the purchase requisition FRGST
peinh Price unit DEC5
ernam Name of Person Responsible for Creating the Object USNAM
berid MRP Area BERID
name1 Name 1 NAME
sortl Sort field CHAR10
eknam Description of purchasing group TEXT18
ekotx Description of purchasing organization TEXT20
name1_p Name TEXT30
name_text Full Name of Person TEXT80
maktx null
wgbez null
batxt null
statustext null
cntb null
status null
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • M_V_M2S_PR_ITM.AUFNR == AUFK.AUFNR
  • M_V_M2S_PR_ITM.MANDT == AUFK.MANDT
Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • M_V_M2S_PR_ITM.MANDT == T161.MANDT
  • M_V_M2S_PR_ITM.BSTYP == T161.BSTYP
  • M_V_M2S_PR_ITM.BSART == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • M_V_M2S_PR_ITM.EKGRP == T024.EKGRP
  • M_V_M2S_PR_ITM.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • M_V_M2S_PR_ITM.MANDT == T024E.MANDT
  • M_V_M2S_PR_ITM.EKORG == T024E.EKORG
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • M_V_M2S_PR_ITM.EMATN == MARA.MATNR
  • M_V_M2S_PR_ITM.MANDT == MARA.MANDT
Fixed Vendor
  • Client
  • Fixed Vendor
  • M_V_M2S_PR_ITM.MANDT == LFA1.MANDT
  • M_V_M2S_PR_ITM.FLIEF == LFA1.LIFNR
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • M_V_M2S_PR_ITM.INFNR == EINA.INFNR
  • M_V_M2S_PR_ITM.MANDT == EINA.MANDT
Account Assignment Category
  • Account Assignment Category
  • Client
  • M_V_M2S_PR_ITM.KNTTP == T163K.KNTTP
  • M_V_M2S_PR_ITM.MANDT == T163K.MANDT
Cost Center
  • ?
  • Client
  • Last Changed On
  • Cost Center
  • M_V_M2S_PR_ITM.[column in domain "KOKRS"] == CSKS.KOKRS
  • M_V_M2S_PR_ITM.MANDT == CSKS.MANDT
  • M_V_M2S_PR_ITM.ERDAT == CSKS.DATBI
  • M_V_M2S_PR_ITM.KOSTL == CSKS.KOSTL
Storage location
  • Client
  • Storage location
  • Plant
  • M_V_M2S_PR_ITM.MANDT == T001L.MANDT
  • M_V_M2S_PR_ITM.LGORT == T001L.LGORT
  • M_V_M2S_PR_ITM.WERKS == T001L.WERKS
Desired Vendor
  • Desired Vendor
  • Client
  • M_V_M2S_PR_ITM.LIFNR == LFA1.LIFNR
  • M_V_M2S_PR_ITM.MANDT == LFA1.MANDT
Material Group
  • Material Group
  • Client
  • M_V_M2S_PR_ITM.MATKL == T023.MATKL
  • M_V_M2S_PR_ITM.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • M_V_M2S_PR_ITM.MANDT == MARA.MANDT
  • M_V_M2S_PR_ITM.MATNR == MARA.MATNR
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • M_V_M2S_PR_ITM.MANDT == T006.MANDT
  • M_V_M2S_PR_ITM.MEINS == T006.MSEHI
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • M_V_M2S_PR_ITM.PSTYP == T163.PSTYP
  • M_V_M2S_PR_ITM.MANDT == T163.MANDT
Language Key
  • Language Key
  • Language Key
  • M_V_M2S_PR_ITM.SPRAS_T023T == T002.SPRAS
  • M_V_M2S_PR_ITM.SPRAS == T002.SPRAS
Language key
  • Language Key
  • Language Key
  • M_V_M2S_PR_ITM.SPRAS_T023T == T002.SPRAS
  • M_V_M2S_PR_ITM.SPRAS == T002.SPRAS
Currency Key
  • Client
  • Currency Key
  • M_V_M2S_PR_ITM.MANDT == TCURC.MANDT
  • M_V_M2S_PR_ITM.WAERS == TCURC.WAERS
Plant
  • Client
  • Plant
  • M_V_M2S_PR_ITM.MANDT == T001W.MANDT
  • M_V_M2S_PR_ITM.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • ?
  • Client
  • Category of delivery date
  • M_V_M2S_PR_ITM.[column in domain "SPRAS"] == TPRG.SPRAS
  • M_V_M2S_PR_ITM.MANDT == TPRG.MANDT
  • M_V_M2S_PR_ITM.LPEIN == TPRG.PRGBZ