R_PurReqnItmHierNodeRltn

Purchase Requisition Item Hierarchy data | view: RPURREQNHIERRLN | TRAN | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, KNA1, FM01, T001W, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical (5)
Other (6)
🔗 Relations (14)

Column Name	Description
PurchaseRequisitionItem	Item number of purchase requisition
PurchaseRequisition	Purchase requisition number

Column Name	Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice	Price in Purchase Requisition

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
OrderedQuantity	Quantity ordered against this purchase requisition

Column Name	Description
DeliveryDate	Item delivery date
CreationDate	Requisition (request) date
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date

Column Name	Description
PurReqnReleaseStatus	Requisition Processing State	Show values
IsClosed	Purchase requisition closed	Show values
PurchaseRequisitionIsFixed	Purchase requisition is fixed	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values

Column Name	Description	Domain name
PurchasingParentItem	Parent Item No	BNFPO
PurgConfigurableItemNumber	Hierarchy Number	EXLIN
PurgExternalSortNumber	External Sort Number	EXSNR
PurchaseRequisitionItemText	Short Text	TEXT40
PurchaseRequisitionStatus	Release State	FRGZU
PurReqnPriceQuantity	Price unit	DEC5

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`R_PURREQNITMHIERNODERLTN.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `R_PURREQNITMHIERNODERLTN.MANDT == T163K.MANDT`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`R_PURREQNITMHIERNODERLTN.MANDT == T006.MANDT` `R_PURREQNITMHIERNODERLTN.BASEUNIT == T006.MSEHI`
Material Number Client Material Number	`R_PURREQNITMHIERNODERLTN.MANDT == MARA.MANDT` `R_PURREQNITMHIERNODERLTN.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`R_PURREQNITMHIERNODERLTN.MANDT == T023.MANDT` `R_PURREQNITMHIERNODERLTN.MATERIALGROUP == T023.MATKL`
MRP Controller Client Plant MRP Controller	`R_PURREQNITMHIERNODERLTN.MANDT == T024D.MANDT` `R_PURREQNITMHIERNODERLTN.PLANT == T024D.WERKS` `R_PURREQNITMHIERNODERLTN.MRPCONTROLLER == T024D.DISPO`
Plant Client Plant	`R_PURREQNITMHIERNODERLTN.MANDT == T001W.MANDT` `R_PURREQNITMHIERNODERLTN.PLANT == T001W.WERKS`
Purchase Requisition Document Type Purchase Requisition Document Type ? Client	`R_PURREQNITMHIERNODERLTN.PURCHASEREQUISITIONTYPE == T161.BSART` `R_PURREQNITMHIERNODERLTN.[column in domain "BSTYP"] == T161.BSTYP` `R_PURREQNITMHIERNODERLTN.MANDT == T161.MANDT`
Purchasing Group Client Purchasing Group	`R_PURREQNITMHIERNODERLTN.MANDT == T024.MANDT` `R_PURREQNITMHIERNODERLTN.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`R_PURREQNITMHIERNODERLTN.MANDT == T024E.MANDT` `R_PURREQNITMHIERNODERLTN.PURCHASINGORGANIZATION == T024E.EKORG`
Currency Key Client Currency Key	`R_PURREQNITMHIERNODERLTN.MANDT == TCURC.MANDT` `R_PURREQNITMHIERNODERLTN.PURREQNITEMCURRENCY == TCURC.WAERS`
Storage location Client Plant Storage location	`R_PURREQNITMHIERNODERLTN.MANDT == T001L.MANDT` `R_PURREQNITMHIERNODERLTN.PLANT == T001L.WERKS` `R_PURREQNITMHIERNODERLTN.STORAGELOCATION == T001L.LGORT`
Desired Vendor Client Desired Vendor	`R_PURREQNITMHIERNODERLTN.MANDT == LFA1.MANDT` `R_PURREQNITMHIERNODERLTN.SUPPLIER == LFA1.LIFNR`