A_ProductionOrderItem

API Production Order Items | view: APRODORDITEM | TRAN | Extraction: Not supported | Component: Enterprise Services
Tables used: AFKOAFPO
Column Name Description
ManufacturingOrder FK Manufacturing Order ID
ManufacturingOrderItem Manufacturing Order Item ID
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderItemPlannedTotalQty 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
Column Name Description
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
MfgOrderItemPlndDeliveryDate Delivery Date From Planned Order
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
InventoryUsabilityCode Inventory Usability Code Show values
Column Name Description Domain name
MRPArea MRP Area BERID
GoodsRecipientName Goods Recipient WEMPF
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
UnloadingPointName Unloading Point TEXT25
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Production Plant
  • Client
  • Material Number for Order
  • A_PRODUCTIONORDERITEM.BATCH == MCHA.CHARG
  • A_PRODUCTIONORDERITEM.PRODUCTIONPLANT == MCHA.WERKS
  • A_PRODUCTIONORDERITEM.MANDT == MCHA.MANDT
  • A_PRODUCTIONORDERITEM.MATERIAL == MCHA.MATNR
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • A_PRODUCTIONORDERITEM.MANUFACTURINGORDER == AUFK.AUFNR
  • A_PRODUCTIONORDERITEM.MANDT == AUFK.MANDT
Manufacturing Order Type
  • Manufacturing Order Type
  • Client
  • A_PRODUCTIONORDERITEM.MANUFACTURINGORDERTYPE == T003O.AUART
  • A_PRODUCTIONORDERITEM.MANDT == T003O.CLIENT
Material Number for Order
  • Client
  • Material Number for Order
  • A_PRODUCTIONORDERITEM.MANDT == MARA.MANDT
  • A_PRODUCTIONORDERITEM.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Planning Plant for an Order
  • Client
  • A_PRODUCTIONORDERITEM.MRPPLANT == T001W.WERKS
  • A_PRODUCTIONORDERITEM.MANDT == T001W.MANDT
Production Plant
  • Production Plant
  • Client
  • A_PRODUCTIONORDERITEM.PRODUCTIONPLANT == T001W.WERKS
  • A_PRODUCTIONORDERITEM.MANDT == T001W.MANDT
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • A_PRODUCTIONORDERITEM.PRODUCTIONUNIT == T006.MSEHI
  • A_PRODUCTIONORDERITEM.MANDT == T006.MANDT
MRP Distribution Key
  • Production Plant
  • Client
  • MRP Distribution Key
  • A_PRODUCTIONORDERITEM.PRODUCTIONPLANT == T437V.WERKS
  • A_PRODUCTIONORDERITEM.MANDT == T437V.MANDT
  • A_PRODUCTIONORDERITEM.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
Storage Location
  • Storage Location
  • Planning Plant for an Order
  • Client
  • A_PRODUCTIONORDERITEM.STORAGELOCATION == T001L.LGORT
  • A_PRODUCTIONORDERITEM.MRPPLANT == T001L.WERKS
  • A_PRODUCTIONORDERITEM.MANDT == T001L.MANDT