C_PRItemDetails

PR Items for GR | view: CPRITEMDETAILS | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKET, FM01, T001W, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchase Order
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
OrderQuantity Purchase Order Quantity
RoughGoodsReceiptQty null
OpenQuantity null
Column Name Description
CreationDate Requisition (request) date
Column Name Description
PurReqnIsValdInCntrlReqnProcg Is PR relevant for Central PR Processing Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ItemNetAmount null
PurReqnSSPRequestor Requestor
PurReqnSSPAuthor Author of Requisition UNAME
ProcurementHubSourceSystem Connected System ID
ExtCompanyCodeForPurg Company Code of External System BUKRS
ExtPlantForPurg Plant of External System WERKS
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
Material Material Number MATNR
PurchasingDocumentItemText Short Text TEXT40
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PRITEMDETAILS.ORDERQUANTITYUNIT == T006.MSEHI
  • C_PRITEMDETAILS.MANDT == T006.MANDT
Plant
  • Plant
  • Plant
  • Client
  • C_PRITEMDETAILS.PLANT == T001W.WERKS
  • C_PRITEMDETAILS.PURORDERITEMPLANT == T001W.WERKS
  • C_PRITEMDETAILS.MANDT == T001W.MANDT
Purchase Order Type
  • Purchase Order Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • C_PRITEMDETAILS.PURCHASEORDERTYPE == T161.BSART
  • C_PRITEMDETAILS.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PRITEMDETAILS.[column in domain "BSTYP"] == T161.BSTYP
  • C_PRITEMDETAILS.MANDT == T161.MANDT
Purchase Requisition Document Type
  • Purchase Order Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • C_PRITEMDETAILS.PURCHASEORDERTYPE == T161.BSART
  • C_PRITEMDETAILS.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PRITEMDETAILS.[column in domain "BSTYP"] == T161.BSTYP
  • C_PRITEMDETAILS.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Purchasing Group
  • Client
  • C_PRITEMDETAILS.PURCHASINGGROUP == T024.EKGRP
  • C_PRITEMDETAILS.PURORDPURCHASINGGROUP == T024.EKGRP
  • C_PRITEMDETAILS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • C_PRITEMDETAILS.PURORDPURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMDETAILS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMDETAILS.MANDT == T024E.MANDT
Plant
  • Plant
  • Plant
  • Client
  • C_PRITEMDETAILS.PLANT == T001W.WERKS
  • C_PRITEMDETAILS.PURORDERITEMPLANT == T001W.WERKS
  • C_PRITEMDETAILS.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Purchasing Group
  • Client
  • C_PRITEMDETAILS.PURCHASINGGROUP == T024.EKGRP
  • C_PRITEMDETAILS.PURORDPURCHASINGGROUP == T024.EKGRP
  • C_PRITEMDETAILS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • C_PRITEMDETAILS.PURORDPURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMDETAILS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PRITEMDETAILS.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PRITEMDETAILS.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PRITEMDETAILS.MANDT == TCURC.MANDT
Supplier
  • Supplier
  • Client
  • C_PRITEMDETAILS.SUPPLIER == LFA1.LIFNR
  • C_PRITEMDETAILS.MANDT == LFA1.MANDT