C_PRItemDetailsForGR

PR Items Open for GR | view: CPROPENFORGR | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKET, USR21, FM01, T001W, T001K, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, MMPUR_C_BE_SYREG, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL, FINSC_FISC_DATE

🔑 Keys (1)
💰 Amounts
∑ Quantities (2)
📅 Dates (1)
☰ Categorical
Other (10)
🔗 Relations (11)

Column Name	Description
PurchaseRequisition	Purchase requisition number

Column Name	Description

Column Name	Description
OpenQuantity	null
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty	Purchase Order Quantity

Column Name	Description
CreationDate	Requisition (request) date

Column Name	Description

Column Name	Description	Domain name
PurchaseRequisitionItem	Item number of purchase requisition	BNFPO
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
PurReqnSSPRequestor	Requestor
PurReqnSSPAuthor	Author of Requisition	UNAME
ProcurementHubSourceSystem	Connected System ID
ProcmtHubCompanyCode	Company Code of External System	BUKRS
ProcmtHubPlant	Plant of External System	WERKS
PurchaseOrderItemText	Short Text	TEXT40
Material	Material Number	MATNR
PurchaseOrderItem	Item Number of Purchase Order	EBELP

Master Data Relations	Join Conditions
Plant Client Plant Plant	`C_PRITEMDETAILSFORGR.MANDT == T001W.MANDT` `C_PRITEMDETAILSFORGR.PLANT == T001W.WERKS` `C_PRITEMDETAILSFORGR.PURORDERITEMPLANT == T001W.WERKS`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PRITEMDETAILSFORGR.MANDT == T006.MANDT` `C_PRITEMDETAILSFORGR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Client Purchase Requisition Document Type Purchase Order Type ?	`C_PRITEMDETAILSFORGR.MANDT == T161.MANDT` `C_PRITEMDETAILSFORGR.PURCHASEREQUISITIONTYPE == T161.BSART` `C_PRITEMDETAILSFORGR.PURCHASEORDERTYPE == T161.BSART` `C_PRITEMDETAILSFORGR.[column in domain "BSTYP"] == T161.BSTYP`
Purchase Requisition Document Type Client Purchase Requisition Document Type Purchase Order Type ?	`C_PRITEMDETAILSFORGR.MANDT == T161.MANDT` `C_PRITEMDETAILSFORGR.PURCHASEREQUISITIONTYPE == T161.BSART` `C_PRITEMDETAILSFORGR.PURCHASEORDERTYPE == T161.BSART` `C_PRITEMDETAILSFORGR.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group Purchasing Group	`C_PRITEMDETAILSFORGR.MANDT == T024.MANDT` `C_PRITEMDETAILSFORGR.PURORDPURCHASINGGROUP == T024.EKGRP` `C_PRITEMDETAILSFORGR.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization Purchasing organization	`C_PRITEMDETAILSFORGR.MANDT == T024E.MANDT` `C_PRITEMDETAILSFORGR.PURCHASINGORGANIZATION == T024E.EKORG` `C_PRITEMDETAILSFORGR.PURORDPURCHASINGORGANIZATION == T024E.EKORG`
Plant Client Plant Plant	`C_PRITEMDETAILSFORGR.MANDT == T001W.MANDT` `C_PRITEMDETAILSFORGR.PLANT == T001W.WERKS` `C_PRITEMDETAILSFORGR.PURORDERITEMPLANT == T001W.WERKS`
Purchasing Group Client Purchasing Group Purchasing Group	`C_PRITEMDETAILSFORGR.MANDT == T024.MANDT` `C_PRITEMDETAILSFORGR.PURORDPURCHASINGGROUP == T024.EKGRP` `C_PRITEMDETAILSFORGR.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization Purchasing organization	`C_PRITEMDETAILSFORGR.MANDT == T024E.MANDT` `C_PRITEMDETAILSFORGR.PURCHASINGORGANIZATION == T024E.EKORG` `C_PRITEMDETAILSFORGR.PURORDPURCHASINGORGANIZATION == T024E.EKORG`
Supplier Supplier Client	`C_PRITEMDETAILSFORGR.SUPPLIER == LFA1.LIFNR` `C_PRITEMDETAILSFORGR.MANDT == LFA1.MANDT`