C_PRItemForGoodsReceipt

Purchase Requisition Items Open for GR | view: CPRITEMFORGR | 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
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseOrder FK Purchasing Document Number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OpenQuantity null
Column Name Description
Column Name Description
Column Name Description Domain name
PurchaseOrderItem Item Number of Purchase Order EBELP
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Material Material Number MATNR
PurchaseOrderItemText Short Text TEXT40
SupplierName null
Master Data Relations Join Conditions
Plant
  • Plant
  • Plant
  • Client
  • C_PRITEMFORGOODSRECEIPT.PLANT == T001W.WERKS
  • C_PRITEMFORGOODSRECEIPT.PURORDERITEMPLANT == T001W.WERKS
  • C_PRITEMFORGOODSRECEIPT.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PRITEMFORGOODSRECEIPT.MANDT == T006.MANDT
  • C_PRITEMFORGOODSRECEIPT.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Requisition Document Type
  • Purchase Order Type
  • Client
  • ?
  • C_PRITEMFORGOODSRECEIPT.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PRITEMFORGOODSRECEIPT.PURCHASEORDERTYPE == T161.BSART
  • C_PRITEMFORGOODSRECEIPT.MANDT == T161.MANDT
  • C_PRITEMFORGOODSRECEIPT.[column in domain "BSTYP"] == T161.BSTYP
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchase Order Type
  • Client
  • ?
  • C_PRITEMFORGOODSRECEIPT.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PRITEMFORGOODSRECEIPT.PURCHASEORDERTYPE == T161.BSART
  • C_PRITEMFORGOODSRECEIPT.MANDT == T161.MANDT
  • C_PRITEMFORGOODSRECEIPT.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Purchasing Group
  • Client
  • C_PRITEMFORGOODSRECEIPT.PURCHASINGGROUP == T024.EKGRP
  • C_PRITEMFORGOODSRECEIPT.PURORDPURCHASINGGROUP == T024.EKGRP
  • C_PRITEMFORGOODSRECEIPT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • C_PRITEMFORGOODSRECEIPT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMFORGOODSRECEIPT.PURORDPURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMFORGOODSRECEIPT.MANDT == T024E.MANDT
Plant
  • Plant
  • Plant
  • Client
  • C_PRITEMFORGOODSRECEIPT.PLANT == T001W.WERKS
  • C_PRITEMFORGOODSRECEIPT.PURORDERITEMPLANT == T001W.WERKS
  • C_PRITEMFORGOODSRECEIPT.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Purchasing Group
  • Client
  • C_PRITEMFORGOODSRECEIPT.PURCHASINGGROUP == T024.EKGRP
  • C_PRITEMFORGOODSRECEIPT.PURORDPURCHASINGGROUP == T024.EKGRP
  • C_PRITEMFORGOODSRECEIPT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • C_PRITEMFORGOODSRECEIPT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMFORGOODSRECEIPT.PURORDPURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMFORGOODSRECEIPT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PRITEMFORGOODSRECEIPT.SUPPLIER == LFA1.LIFNR
  • C_PRITEMFORGOODSRECEIPT.MANDT == LFA1.MANDT