C_PurReqnItemMntr

Monitor Purchase Requisition Items | view: CPRITEMMNTR | Extraction: Not supported | Component: Purchase Requisitions

Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, CMD_PRDTYPE, CMD_PRDTYPE_T, T163I, T163K, BUT000, T001, TKA02, FM01, MARA, T023, T023T, MAKT, T024D, T001W, T161U, T161, T161T, T024, EINA, T024E, T163, T163Y, T16FT, T001L, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (5)
∑ Quantities (3)
📅 Dates (6)
☰ Categorical (6)
Other (65)
🔗 Relations (17)

Column Name	Description
PurchaseRequisition	Purchase requisition number
PurchaseRequisitionItem	Item number of purchase requisition

Column Name	Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice	Price in Purchase Requisition
💲 Display Currency (DisplayCurrency):
PurReqnTotalAmountInDspCrcy	null
PurchaseReqnInApprovalAmount	null
PurReqnWithoutFllwOnDocAmount	null
NetValueAmount	null

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity	Purchase requisition quantity
OrderedQuantity	Quantity ordered against this purchase requisition
OpenQuantity	null

Column Name	Description
DeliveryDate	Delivery Date
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
PurReqCreationDate	Requisition (request) date
PerformancePeriodStartDate	Start Date for Period of Performance
PerformancePeriodEndDate	End Date for Period of Performance
LastChangedDate	Last Changed On

Column Name	Description
PurchasingDocumentSubtype	Control indicator for purchasing document type	Show values
IsPurReqnBlocked	Purchase Requisition Blocked	Show values
IsPurReqnCmplt	Purchase Requisition not yet Complete	Show values
PurchasingDocumentCategory	Purchasing Document Category	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
SourceOfSupplyIsAssigned	Assigned Source of Supply	Show values

Column Name	Description	Domain name
FormattedPurRequisitionItem	Formatted Purchase Requisition Item
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingGroupName	Purchasing Group Name	TEXT18
MaterialGroupName	Product Group Description
PurchasingDocumentTypeName	Short Description of Purchasing Document Type
PlantName	Plant Name	TEXT30
PreferredSupplierName	Name of Supplier
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PurgDocItemCategoryName	Item Category Text	TEXT20
AcctAssignmentCategoryName	Account Assignment Category Description
MaterialName	Material Description
DurationToNextStatusInDays	null
SchedDelivDteNextStsInDaysTxt	null
IsOverdue	null
OverdueCategoryName	null
ActiveRFQItem	null
PurReqnPriceQuantity	Price unit
RequirementTracking	Requirement Tracking Number
PurchaseRequisitionItemText	Short Text
SupplierName	Name of Supplier
PurReqnReleaseStatus	Requisition Processing State
PurReqnReleaseStatusDesc	Short Text for Fixed Values
ProcessingStatus	Processing status of purchase requisition
DomainValue	Short Text for Fixed Values
PurchasingReleaseIndicatorDesc	Description of release indicator
PurchaseRequisitionStatus	Release State	FRGZU
StorageLocationName	Storage Location Name	TEXT16
PurchasingInfoRecordDesc	Short Text for Purchasing Info Record
PurReqnRequestor	Requestor
RequisitionerName	Name of requisitioner/requester
MRPControllerName	MRP Controller Name	TEXT18
Batch	Batch Number	CHARG
PurReqnOrigin	Creation indicator (purchase requisition/schedule lines)
PurReqnOriginDesc	Short Text for Fixed Values
ReleaseStrategy	Release strategy in the purchase requisition
PurchasingReleaseStrategyDesc	Description of release strategy
IsClosed	Purchase requisition closed
IsDeleted	Deletion Indicator in Purchasing Document	ELOEK
CreatedByUser	User Description
CompanyCodeName	Name of Company Code or Company	TEXT25
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Purchasing Category Name
PurgCatUUID	Purchasing Category UUID	/BOBF/CONF_KEY
PrimaryCostObjectCategory	Consumption posting
PurchasingIsBlockedForSupplier	null
PurchasingDocumentStatus	null
PurchasingDocumentStatusName	null
ProductType	Product Type Group	CHAR2
ProductTypeName	Product Type Group Description	TEXT40
SupplierMaterialNumber	Material Number Used by Supplier
MaterialRevisionLevel	Revision Level
ServicePerformer	Service Performer	BU_PARTNER
ServicePerformerName	null
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days
PurchaseRequisitionIsFixed	Purchase requisition is fixed
MaterialGoodsReceiptDuration	Goods receipt processing time in days
GoodsReceiptIsExpected	Goods Receipt Indicator
InvoiceIsExpected	Invoice receipt indicator
GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
SourceDocument	null
PurchasingSourceType	null
PurchasingSourceTypeDesc	Short Text for Fixed Values
SupplyingPlant	Supplying (issuing) plant in case of stock transport order
SupplyingPlantName	Plant Name
StockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`C_PURREQNITEMMNTR.MANDT == T163K.MANDT` `C_PURREQNITEMMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`C_PURREQNITEMMNTR.MANDT == T006.MANDT` `C_PURREQNITEMMNTR.BASEUNIT == T006.MSEHI`
Company code Company Code Client	`C_PURREQNITEMMNTR.COMPANYCODE == T001.BUKRS` `C_PURREQNITEMMNTR.MANDT == T001.MANDT`
Fixed Vendor Fixed Vendor Client	`C_PURREQNITEMMNTR.FIXEDSUPPLIER == LFA1.LIFNR` `C_PURREQNITEMMNTR.MANDT == LFA1.MANDT`
Material Number Client Material Number	`C_PURREQNITEMMNTR.MANDT == MARA.MANDT` `C_PURREQNITEMMNTR.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_PURREQNITEMMNTR.MATERIALGROUP == T023.MATKL` `C_PURREQNITEMMNTR.MANDT == T023.MANDT`
MRP Controller Client MRP Controller Plant	`C_PURREQNITEMMNTR.MANDT == T024D.MANDT` `C_PURREQNITEMMNTR.MRPCONTROLLER == T024D.DISPO` `C_PURREQNITEMMNTR.PLANT == T024D.WERKS`
Plant Client Plant	`C_PURREQNITEMMNTR.MANDT == T001W.MANDT` `C_PURREQNITEMMNTR.PLANT == T001W.WERKS`
Purchase Requisition Document Type Purchasing Document Category Client Purchase Requisition Document Type	`C_PURREQNITEMMNTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `C_PURREQNITEMMNTR.MANDT == T161.MANDT` `C_PURREQNITEMMNTR.PURCHASEREQUISITIONTYPE == T161.BSART`
Item category in purchasing document Item category in purchasing document Client	`C_PURREQNITEMMNTR.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP` `C_PURREQNITEMMNTR.MANDT == T163.MANDT`
Purchasing Group Client Purchasing Group	`C_PURREQNITEMMNTR.MANDT == T024.MANDT` `C_PURREQNITEMMNTR.PURCHASINGGROUP == T024.EKGRP`
Number of purchasing info record Number of purchasing info record Client	`C_PURREQNITEMMNTR.PURCHASINGINFORECORD == EINA.INFNR` `C_PURREQNITEMMNTR.MANDT == EINA.MANDT`
Purchasing Organization Purchasing Organization Client	`C_PURREQNITEMMNTR.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURREQNITEMMNTR.MANDT == T024E.MANDT`
Currency Key Client Currency Key	`C_PURREQNITEMMNTR.MANDT == TCURC.MANDT` `C_PURREQNITEMMNTR.PURREQNITEMCURRENCY == TCURC.WAERS`
Release Indicator Release Indicator Client	`C_PURREQNITEMMNTR.RELEASECODE == T161S.FRGKZ` `C_PURREQNITEMMNTR.MANDT == T161S.MANDT`
Storage location Storage location Client Plant	`C_PURREQNITEMMNTR.STORAGELOCATION == T001L.LGORT` `C_PURREQNITEMMNTR.MANDT == T001L.MANDT` `C_PURREQNITEMMNTR.PLANT == T001L.WERKS`
Desired Vendor Client Desired Vendor	`C_PURREQNITEMMNTR.MANDT == LFA1.MANDT` `C_PURREQNITEMMNTR.SUPPLIER == LFA1.LIFNR`