C_PurReqItemByPurOrder

Purchase Requisition Item | view: CPREQITMBYPURORD | TRAN | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
PurchaseOrder FK Purchasing Document Number
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
PurReqnItemTotalAmount Purchase Requisition Item Total Amount
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
PurchaseRequisitionItemText Short Text TEXT40
PurReqnPriceQuantity Price unit DEC5
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_PURREQITEMBYPURORDER.MANDT == T006.MANDT
  • C_PURREQITEMBYPURORDER.BASEUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • C_PURREQITEMBYPURORDER.MANDT == MARA.MANDT
  • C_PURREQITEMBYPURORDER.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURREQITEMBYPURORDER.MANDT == T023.MANDT
  • C_PURREQITEMBYPURORDER.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURREQITEMBYPURORDER.MANDT == T001W.MANDT
  • C_PURREQITEMBYPURORDER.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • C_PURREQITEMBYPURORDER.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURREQITEMBYPURORDER.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURREQITEMBYPURORDER.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURREQITEMBYPURORDER.MANDT == T024.MANDT
  • C_PURREQITEMBYPURORDER.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURREQITEMBYPURORDER.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURREQITEMBYPURORDER.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PURREQITEMBYPURORDER.MANDT == TCURC.MANDT
  • C_PURREQITEMBYPURORDER.PURREQNITEMCURRENCY == TCURC.WAERS