C_PurchaseOrderItemMoni

Monitor Purchase Order Items | view: CPURORDITEMMONI | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKET, EKES, MMPUR_ANA_EKET, MMPO_SUPDLVPRED, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, T163K, T163I, BUT000, T001, TKA02, TCURT, MARA, T023, T023T, MAKT, T001W, CMD_PRDTYPE, CMD_PRDTYPE_T, T163B, T161T, T024, T024E, MMPUR_ANA_CONF, T163Y, T001L, LFA1, T006A, USR21, T161M

🔑 Keys (2)
💰 Amounts (8)
∑ Quantities (6)
📅 Dates (7)
☰ Categorical (3)
Other (55)
🔗 Relations (20)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order

Column Name	Description
💲 null (DisplayCurrency):
NetPriceAmount	null
NetAmount	Net Amount (in Reporting Currency 1)
ExpectedOverallLimitAmount	null
OverallLimitAmount	null
GoodsReceiptAmountInCoCodeCrcy	null
StillToBeDeliveredValue	null
InvoiceReceiptAmount	null
StillToInvoiceValue	null

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOpenQty	Open Quantity
OrderQuantity	Purchase Order Quantity
GoodsReceiptQty	Delivered Quantity
StillToBeDeliveredQuantity	null
InvoiceReceiptQty	null
StillToInvoiceQuantity	null

Column Name	Description
PurchaseOrderDate	Purchase Order Date
CreationDate	Creation Date of Purchasing Document
ScheduleLineDeliveryDate	Item delivery date
PerformancePeriodStartDate	Start Date for Period of Performance
PerformancePeriodEndDate	End Date for Period of Performance
PredictedDelivDte	null
SuplrNextDeliveryPredictionDte	Predicted On

Column Name	Description
PurgDocMigrtnIsCmpltdForAnlyts	Indicator for Data Migration of Schedule Line	Show values
PredictedDelDaysRltnPOPostDate	Prediction of Delivery Date for PO Items	Show values
InfoRecordIsToBeUpdated	Info Record Update	Show values

Column Name	Description	Domain name
FormattedPurchaseOrderItem	null
PurchaseOrderTypeName	Short Description of Purchasing Document Type
SupplierName	Name of Supplier
SupplyingPlantName	Plant Name
PurchasingOrganizationName	Purchasing Organization Name
CompanyCodeName	Name of Company Code or Company
PurchasingGroupName	Purchasing Group Name
CurrencyName	Description	TEXT40
PurchasingDocumentStatusName	Purchasing Document Status Name
CreatedByUser	User of person who created a purchasing document	USNAM
CreatedByUserFullName	User Description
PurchaseContractItem	null
NumberOfPurchaseOrderItems	null
PurchaseOrderItemText	Short Text
MaterialGroupName	Product Group Description
MaterialName	Material Description
ProductType	Product Type Group	CHAR2
ProductTypeName	Product Type Group Description
PurgDocExternalItemCategory	Item Category in Purchasing Document
PurOrdItemCategoryName	Text for Item Category
AcctAssignmentCategoryName	Account Assignment Category Description
PlantName	Plant Name	TEXT30
ServicePerformer	Service Performer	BU_PARTNER
ServicePerformerName	null
PurchasingCategory	Purchasing Category ID
PurgCatName	Name of Purchasing Category
IsReturnsItem	Returns Item
DeliveryDateCriticality	null
DeliveryStatus	null
DeliveryStatusDescription	null
NetPriceQuantity	Price Unit	DEC5
UnitOfMeasureLongName	Unit of Measurement Text (Maximum 30 Characters)	TEXT30
GoodsReceiptIsExpected	Goods Receipt Indicator
GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
IsCompletelyDelivered	"Delivery Completed" Indicator
IsFinallyInvoiced	Final Invoice Indicator
InvoiceIsExpected	Invoice receipt indicator
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
IsCompleted	Checkbox
StorageLocationName	Storage Location Name
RequirementTracking	Requirement Tracking Number
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem	null
PlannedDeliveryDuration	null
RequestForQuotation	Identifier for Request for Quotation
RequestForQuotationItem	null
PredictedDaysOfDelivDeviation	Predicted Delivery Delay in Days
PurchaseOrderScheduleLine	Schedule Line Number	ETENR
DeliveryInfoText2	null
PurchasingIsBlocked	Centrally imposed purchasing block
PurchaseOrderStatus	null
PurchaseOrderOutputStatusName	Purchasing Document Status Name
PurchaseOrderItemStatus	null
PurchaseOrderItemStatusName	Purchasing Document Status Name	DDTEXT
StockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_PURCHASEORDERITEMMONI.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_PURCHASEORDERITEMMONI.MANDT == T163K.MANDT`
Company Code Company Code Client	`C_PURCHASEORDERITEMMONI.COMPANYCODE == T001.BUKRS` `C_PURCHASEORDERITEMMONI.MANDT == T001.MANDT`
Currency Key Currency Key Client	`C_PURCHASEORDERITEMMONI.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURCHASEORDERITEMMONI.MANDT == TCURC.MANDT`
Material Number Material Number Client	`C_PURCHASEORDERITEMMONI.MATERIAL == MARA.MATNR` `C_PURCHASEORDERITEMMONI.MANDT == MARA.MANDT`
Material Group Client Material Group	`C_PURCHASEORDERITEMMONI.MANDT == T023.MANDT` `C_PURCHASEORDERITEMMONI.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURCHASEORDERITEMMONI.ORDERPRICEUNIT == T006.MSEHI` `C_PURCHASEORDERITEMMONI.MANDT == T006.MANDT`
Plant Plant Client	`C_PURCHASEORDERITEMMONI.PLANT == T001W.WERKS` `C_PURCHASEORDERITEMMONI.MANDT == T001W.MANDT`
Item category in purchasing document Item category in purchasing document Client	`C_PURCHASEORDERITEMMONI.PURCHASEORDERITEMCATEGORY == T163.PSTYP` `C_PURCHASEORDERITEMMONI.MANDT == T163.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURCHASEORDERITEMMONI.MANDT == T006.MANDT` `C_PURCHASEORDERITEMMONI.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type ? Purchase Order Type Client	`C_PURCHASEORDERITEMMONI.[column in domain "BSTYP"] == T161.BSTYP` `C_PURCHASEORDERITEMMONI.PURCHASEORDERTYPE == T161.BSART` `C_PURCHASEORDERITEMMONI.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_PURCHASEORDERITEMMONI.PURCHASINGGROUP == T024.EKGRP` `C_PURCHASEORDERITEMMONI.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_PURCHASEORDERITEMMONI.PURCHASINGINFORECORD == EINA.INFNR` `C_PURCHASEORDERITEMMONI.MANDT == EINA.MANDT`
Purchasing organization Purchasing organization Client	`C_PURCHASEORDERITEMMONI.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURCHASEORDERITEMMONI.MANDT == T024E.MANDT`
Storage Location Plant Storage Location Client	`C_PURCHASEORDERITEMMONI.PLANT == T001L.WERKS` `C_PURCHASEORDERITEMMONI.STORAGELOCATION == T001L.LGORT` `C_PURCHASEORDERITEMMONI.MANDT == T001L.MANDT`
Supplier Supplier Client	`C_PURCHASEORDERITEMMONI.SUPPLIER == LFA1.LIFNR` `C_PURCHASEORDERITEMMONI.MANDT == LFA1.MANDT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`C_PURCHASEORDERITEMMONI.MANDT == T001W.MANDT` `C_PURCHASEORDERITEMMONI.SUPPLYINGPLANT == T001W.WERKS`