m_v_pur_req_item

Purchase Requisition Item for OfR | view: CDS_M_PUREQITM | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EBAN
Column Name Description
banfn Purchase Requisition Number
bnfpo Item number of purchase requisition
Column Name Description
💲 Currency Key (waers):
price Price in Purchase Requisition
Column Name Description
📏 Purchase requisition unit of measure (meins):
quantity Purchase requisition quantity
bsmng Quantity ordered against this purchase requisition
OPENQTY null
Column Name Description
lfdat Item delivery date
rel_date Purchase Requisition Release Date
erdat Last Changed On
uzeit Delivery Date Time-Spot
Column Name Description
vrtyp Purchasing Document Category Show values
frgrl Release Not Yet Completely Effected Show values
blckd Purchase Requisition Blocked Show values
zugba Assigned Source of Supply Show values
ebakz Purchase requisition closed Show values
banpr Requisition Processing State Show values
wrtkz Value-Based Commitment Reduction for Service Purchase Reqs Show values
Column Name Description Domain name
peinh Price unit DEC5
ernam Name of Person Responsible for Creating the Object USNAM
afnam Name of requisitioner/requester AFNAM
reswk Supplying (issuing) plant in case of stock transport order WERKS
txz01 Short Text TEXT40
loekz Deletion Indicator in Purchasing Document ELOEK
blckt Reason for Item Block CHAR60K
NAME1 null
SPRAS_L null
WGBEZ null
SPRAS_U null
MSEHT_QU null
NAME1_SP null
NAME1_PL null
NAME2_PL null
ADRNR_PL null
BUKRS null
ANDEC null
MSEHI null
Master Data Relations Join Conditions
Number of delivery address
  • ?
  • ?
  • Client
  • Number of delivery address
  • M_V_PUR_REQ_ITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • M_V_PUR_REQ_ITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • M_V_PUR_REQ_ITEM.MANDT == ADRC.CLIENT
  • M_V_PUR_REQ_ITEM.ADRN2 == ADRC.ADDRNUMBER
Link to Central Address Management
  • ?
  • ?
  • Client
  • Manual address number in purchasing document item
  • M_V_PUR_REQ_ITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • M_V_PUR_REQ_ITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • M_V_PUR_REQ_ITEM.MANDT == ADRC.CLIENT
  • M_V_PUR_REQ_ITEM.ADRNR == ADRC.ADDRNUMBER
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • M_V_PUR_REQ_ITEM.BMEIN == T006.MSEHI
  • M_V_PUR_REQ_ITEM.MANDT == T006.MANDT
Purchase Requisition Document Type
  • ?
  • Client
  • Purchase Requisition Document Type
  • M_V_PUR_REQ_ITEM.[column in domain "BSTYP"] == T161.BSTYP
  • M_V_PUR_REQ_ITEM.MANDT == T161.MANDT
  • M_V_PUR_REQ_ITEM.BSART == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • M_V_PUR_REQ_ITEM.EKGRP == T024.EKGRP
  • M_V_PUR_REQ_ITEM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • M_V_PUR_REQ_ITEM.EKORG == T024E.EKORG
  • M_V_PUR_REQ_ITEM.MANDT == T024E.MANDT
Material number corresponding to manufacturer part number
  • Client
  • Material number corresponding to manufacturer part number
  • M_V_PUR_REQ_ITEM.MANDT == MARA.MANDT
  • M_V_PUR_REQ_ITEM.EMATN == MARA.MATNR
Fixed Vendor
  • Fixed Vendor
  • Client
  • M_V_PUR_REQ_ITEM.FLIEF == LFA1.LIFNR
  • M_V_PUR_REQ_ITEM.MANDT == LFA1.MANDT
Release group
  • Release group
  • Client
  • M_V_PUR_REQ_ITEM.FRGGR == T16FG.FRGGR
  • M_V_PUR_REQ_ITEM.MANDT == T16FG.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • M_V_PUR_REQ_ITEM.INFNR == EINA.INFNR
  • M_V_PUR_REQ_ITEM.MANDT == EINA.MANDT
Customer
  • Client
  • Customer
  • M_V_PUR_REQ_ITEM.MANDT == KNA1.MANDT
  • M_V_PUR_REQ_ITEM.KUNNR == KNA1.KUNNR
Desired Vendor
  • Desired Vendor
  • Client
  • M_V_PUR_REQ_ITEM.LIFNR == LFA1.LIFNR
  • M_V_PUR_REQ_ITEM.MANDT == LFA1.MANDT
Material Group
  • Client
  • Material Group
  • M_V_PUR_REQ_ITEM.MANDT == T023.MANDT
  • M_V_PUR_REQ_ITEM.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • M_V_PUR_REQ_ITEM.MANDT == MARA.MANDT
  • M_V_PUR_REQ_ITEM.MATNR == MARA.MATNR
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • M_V_PUR_REQ_ITEM.MEINS == T006.MSEHI
  • M_V_PUR_REQ_ITEM.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • M_V_PUR_REQ_ITEM.MANDT == T001W.MANDT
  • M_V_PUR_REQ_ITEM.PLANT == T001W.WERKS
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • M_V_PUR_REQ_ITEM.PSTYP == T163.PSTYP
  • M_V_PUR_REQ_ITEM.MANDT == T163.MANDT
Language Key M_V_PUR_REQ_ITEM.SPRAS == T002.SPRAS
Currency Key
  • Client
  • Currency Key
  • M_V_PUR_REQ_ITEM.MANDT == TCURC.MANDT
  • M_V_PUR_REQ_ITEM.WAERS == TCURC.WAERS