C_PurReqnItm

My Purg Doc Items PR tab | view: CPURGDOCITEMSPR | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber Serial number for PReq account assignment segment
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
PurReqnItemTotalAmount null
PurgDocNetAmount Target Amount
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
Quantity Purchase requisition quantity
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
OpenQuantity Open Quantity
Column Name Description
DeliveryDate Delivery Date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
PurReqCreationDate Requisition (request) date
Column Name Description
ObjectType Num1 Show values
Column Name Description Domain name
FormattedPurRequisitionItem null
MaterialDocumentItemText Short Text
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingDocumentItemCategory Item Category in Purchasing Document
PurgDocItemCategoryName Text for Item Category TEXT20
Batch Batch Number CHARG
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
RequirementTracking Requirement Tracking Number
RequisitionerName Name of requisitioner/requester AFNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
FullName Full Name of Person
PurReqnPriceQuantity Price unit
MultipleAcctAssgmtDistrPercent null
PurReqnReleaseStatus Requisition Processing State
PurReqnReleaseStatusDesc Short Text for Fixed Values DDTEXT
Status Processing status of purchase requisition
ProcessingStatusDesc Short Text for Fixed Values DDTEXT
WBSElementExternalID Work Breakdown Structure Element (WBS Element)
CustProjWorkPackageFullName null
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
ServicePerformer Service Performer BU_PARTNER
SalesOrder Sales and Distribution Document Number VBELN
PurchasingDocument Purchase requisition number
SupplyingPlant Supplying (issuing) plant in case of stock transport order
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURREQNITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURREQNITM.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_PURREQNITM.BASEUNIT == T006.MSEHI
  • C_PURREQNITM.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • C_PURREQNITM.COMPANYCODE == T001.BUKRS
  • C_PURREQNITM.MANDT == T001.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_PURREQNITM.COSTCENTER == CSKS.KOSTL
  • C_PURREQNITM.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURREQNITM.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURREQNITM.MANDT == CSKS.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • C_PURREQNITM.EXTDESIREDSUPPLIERFORPURG == LFA1.LIFNR
  • C_PURREQNITM.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • C_PURREQNITM.MANDT == MARA.MANDT
  • C_PURREQNITM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_PURREQNITM.MATERIALGROUP == T023.MATKL
  • C_PURREQNITM.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_PURREQNITM.PLANT == T001W.WERKS
  • C_PURREQNITM.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • ?
  • Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • C_PURREQNITM.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURREQNITM.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURREQNITM.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURREQNITM.MANDT == T161.MANDT
Purchase Requisition Document Type
  • ?
  • Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • C_PURREQNITM.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURREQNITM.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURREQNITM.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURREQNITM.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURREQNITM.PURCHASINGGROUP == T024.EKGRP
  • C_PURREQNITM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURREQNITM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURREQNITM.MANDT == T024E.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURREQNITM.PURGDOCEXTERNALITEMCATEGORY == T163.PSTYP
  • C_PURREQNITM.MANDT == T163.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PURREQNITM.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PURREQNITM.MANDT == TCURC.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • C_PURREQNITM.PLANT == T001L.WERKS
  • C_PURREQNITM.STORAGELOCATION == T001L.LGORT
  • C_PURREQNITM.MANDT == T001L.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • C_PURREQNITM.SUPPLIER == LFA1.LIFNR
  • C_PURREQNITM.MANDT == LFA1.MANDT