I_OrderItem

Order Item | view: IORDERITEM | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFPO
Column Name Description
OrderID FK Order Number
OrderItem Order Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty Planned Total Order Quantity
OrderPlannedScrapQty Planned Scrap Quantity
📏 Production Unit of Measure (ProductionUnit):
ItemQuantity Order Item Planned Total Quantity
MfgOrderItemPlannedScrapQty Order Item Planned Scrap Quantity
MfgOrderItemGoodsReceiptQty Quantity of Goods Received for the Order Item
MfgOrderItemActualDeviationQty Expected Surplus/Deficit For Goods Receipt
MfgOrderItemOpenYieldQty null
Column Name Description
PlannedEndDate Basic finish date
ScheduledBasicEndDate Scheduled finish
PlannedDeliveryDate Delivery Date From Planned Order
ActualDeliveryDate Actual Delivery/Finish Date
TotalCommitmentDate Total Commitment Date
PlndOrderPlannedStartDate Planned Order Planned Start Date
PlannedOrderOpeningDate Opening Date of the Planned Order
Column Name Description
OrderCategory Order Category Show values
IsMarkedForDeletion Deletion Flag Show values
MaterialProcurementCategory Material Procurement Category Show values
MaterialProcurementType Material Procurement Type Show values
MfgOrderItemReplnmtElmntType Kanban Indicator Show values
GoodsReceiptIsExpected Goods Receipt is Allowed and Expected Show values
GoodsReceiptIsNonValuated Goods Receipt is Non-Valuated Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
InventoryUsabilityCode Inventory Usability Code Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ConsumptionPosting Consumption posting Show values
Column Name Description Domain name
OrderIsReleased null
OrderItemIsNotRelevantForMRP Indicator: Order Item is not Relevant for MRP CHAR1
ProductionVersion Production Version VERID
MRPArea MRP Area BERID
QuotaArrangement Quota Arrangement QUNUM
QuotaArrangementItem Quota Arrangement Item NUM03
SettlementReservation Settlement Reservation RSNUM
SettlementReservationItem Settlement Reservation Item RSPOS
CoProductReservation Co-Prodcut Reservation RSNUM
CoProductReservationItem Co-Prodcut Reservation Item RSPOS
NumberOfSerialNumbers Number of Serial Numbers PPH_COUNT_INT4
ProductConfiguration Configuration (internal object number) CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
StockSegment Stock Segment SGT_SRCA
PlannedOrder Planned Order PLNUM
MaterialQtyToBaseQtyNmrtr Numerator for Conversion to Base Units of Measure UMBSZ
MaterialQtyToBaseQtyDnmntr Denominator for conversion to base units of measure UMBSN
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_ORDERITEM.MANDT == T163K.MANDT
  • I_ORDERITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ORDERITEM.MANDT == T006.MANDT
  • I_ORDERITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Production Plant
  • Client
  • Batch Number
  • Material Number for Order
  • I_ORDERITEM.PRODUCTIONPLANT == MCHA.WERKS
  • I_ORDERITEM.MANDT == MCHA.MANDT
  • I_ORDERITEM.BATCH == MCHA.CHARG
  • I_ORDERITEM.MATERIAL == MCHA.MATNR
Bill of Material Explosion Date ID
  • Bill of Material Explosion Date ID
  • Client
  • I_ORDERITEM.BOMEXPLOSIONDATEID == SNUM.SERNR
  • I_ORDERITEM.MANDT == SNUM.MANDT
Business Area
  • Business Area
  • Client
  • I_ORDERITEM.BUSINESSAREA == TGSB.GSBER
  • I_ORDERITEM.MANDT == TGSB.MANDT
Cost Estimate Number for Cost Est. w/o Qty Structure
  • ?
  • Cost Estimate Number for Cost Est. w/o Qty Structure
  • ?
  • ?
  • ?
  • Client
  • ?
  • ?
  • ?
  • I_ORDERITEM.[column in domain "CK_KADKY"] == CKHS.KADKY
  • I_ORDERITEM.COSTESTIMATE == CKHS.KALNR
  • I_ORDERITEM.[column in domain "CK_KKZMA"] == CKHS.KKZMA
  • I_ORDERITEM.[column in domain "CK_OBJ"] == CKHS.BZOBJ
  • I_ORDERITEM.[column in domain "LEDNR"] == CKHS.LEDNR
  • I_ORDERITEM.MANDT == CKHS.MANDT
  • I_ORDERITEM.[column in domain "CK_BWVAR"] == CKHS.BWVAR
  • I_ORDERITEM.[column in domain "CK_KALKA"] == CKHS.KALKA
  • I_ORDERITEM.[column in domain "CK_TVERS"] == CKHS.TVERS
Inventory Special Stock Type
  • Client
  • Inventory Special Stock Type
  • I_ORDERITEM.MANDT == T148.MANDT
  • I_ORDERITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Valuation Category
  • Valuation Category
  • Client
  • I_ORDERITEM.INVENTORYVALUATIONCATEGORY == T149C.BWTTY
  • I_ORDERITEM.MANDT == T149C.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • I_ORDERITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_ORDERITEM.MANDT == T149D.MANDT
Material Number for Order
  • Client
  • Material Number for Order
  • I_ORDERITEM.MANDT == MARA.MANDT
  • I_ORDERITEM.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_ORDERITEM.MANDT == T001W.MANDT
  • I_ORDERITEM.MRPPLANT == T001W.WERKS
Order Number
  • Order Number
  • Client
  • I_ORDERITEM.ORDERID == AUFK.AUFNR
  • I_ORDERITEM.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_ORDERITEM.ORDERTYPE == T003O.AUART
  • I_ORDERITEM.MANDT == T003O.CLIENT
Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Collection
Production Plant
  • Production Plant
  • Client
  • I_ORDERITEM.PRODUCTIONPLANT == T001W.WERKS
  • I_ORDERITEM.MANDT == T001W.MANDT
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_ORDERITEM.PRODUCTIONUNIT == T006.MSEHI
  • I_ORDERITEM.MANDT == T006.MANDT
Season
  • Season
  • Season Year
  • Client
Season Year
  • Season
  • Season Year
  • Client
Fashion Theme
  • Season
  • Season Year
  • Fashion Theme
  • Client
  • Fashion Collection
  • I_ORDERITEM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ORDERITEM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ORDERITEM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ORDERITEM.MANDT == FSH_THEMES.MANDT
  • I_ORDERITEM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
MRP Distribution Key
  • Production Plant
  • Client
  • MRP Distribution Key
  • I_ORDERITEM.PRODUCTIONPLANT == T437V.WERKS
  • I_ORDERITEM.MANDT == T437V.MANDT
  • I_ORDERITEM.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
Serial Number Profile
  • Client
  • Serial Number Profile
  • I_ORDERITEM.MANDT == T377P.MANDT
  • I_ORDERITEM.SERIALNUMBERASSGMTPROFILE == T377P.SERAIL
Storage Location
  • Client
  • Storage Location
  • Planning Plant for an Order
  • I_ORDERITEM.MANDT == T001L.MANDT
  • I_ORDERITEM.STORAGELOCATION == T001L.LGORT
  • I_ORDERITEM.MRPPLANT == T001L.WERKS