A_ProductionOrder

API Production Order | view: APRODNORD | Extraction: Not supported | Component: Enterprise Services

Tables used: AFKO, AFPO, JEST, PRTE, KNA1, AUFK, MARA, MAKT, T024D, PLAF, PROJ, PRPS

🔑 Keys (1)
💰 Amounts
∑ Quantities (3)
📅 Dates (11)
☰ Categorical (2)
Other (38)
🔗 Relations (18)

Column Name	Description
ProductionOrder	Manufacturing Order ID

Column Name	Description

Column Name	Description
📏 Production Unit of Measure (ProductionUnit):
TotalQuantity	Manufacturing Order Planned Total Quantity
MfgOrderConfirmedYieldQty	Confirmed Yield Quantity From Order Confirmation
MfgOrderPlannedScrapQty	Manufacturing Order Planned Scrap Quantity

Column Name	Description
MfgOrderPlannedStartDate	Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime	Manufacturing Order Planned Start Time
MfgOrderPlannedEndDate	Manufacturing Order Planned End Date
MfgOrderPlannedEndTime	Manufacturing Order Planned End Time
MfgOrderScheduledStartDate	Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime	Manufacturing Order Scheduled Start Time
MfgOrderScheduledEndDate	Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime	Manufacturing Order Scheduled End Time
MfgOrderCreationDate	Order Creation Date
MfgOrderCreationTime	Order Creation Time
MfgOrderActualReleaseDate	Manufacturing Order Actual Release Date

Column Name	Description
ManufacturingOrderCategory	Order Category	Show values
InventoryUsabilityCode	Inventory Usability Code	Show values

Column Name	Description	Domain name
OrderInternalBillOfOperations	Order Internal ID	AUFPL
OrderIsCreated	null
OrderIsReleased	null
OrderIsPrinted	null
OrderIsConfirmed	null
OrderIsPartiallyConfirmed	null
OrderIsDelivered	null
OrderIsDeleted	null
OrderIsPreCosted	null
SettlementRuleIsCreated	null
OrderIsPartiallyReleased	null
OrderIsLocked	null
OrderIsTechnicallyCompleted	null
OrderIsClosed	null
OrderIsPartiallyDelivered	null
OrderIsMarkedForDeletion	null
SettlementRuleIsCrtedManually	null
OrderIsScheduled	null
OrderHasGeneratedOperations	null
OrderIsToBeHandledInBatches	null
MaterialAvailyIsNotChecked	null
MaterialName	Material Description	TEXT40
MRPArea	MRP Area	BERID
PlannedOrder	Planned Order	PLNUM
CustomerName	Name of Customer	TEXT80
WBSElement	WBS Element	PS_POSID
WBSDescription	WBS Element Name	TEXT40
PlannedCostsCostingVariant	Costing Variant for Planned Costs	KLVAR
ActualCostsCostingVariant	Costing Variant For Actual Costs	KLVAR
UserID	Object ID for recipient	CHAR70
ProductionVersion	Production Version	VERID
ManufacturingOrderImportance	Order Importance Code	CHAR1
OrderSequenceNumber	Sequence Number Order	CY_SEQNR
GoodsRecipientName	Goods Recipient	WEMPF
MaterialGoodsReceiptDuration	Goods Receipt Processing Duration in Days	DEC3
UnloadingPointName	Unloading Point	TEXT25
StockSegment	Stock Segment	SGT_SRCA
LastChangeDateTime	null

Master Data Relations	Join Conditions
Basic Scheduling Type Basic Scheduling Type Client	`A_PRODUCTIONORDER.BASICSCHEDULINGTYPE == T482.TERMKZ` `A_PRODUCTIONORDER.MANDT == T482.MANDT`
Business Area Business Area Client	`A_PRODUCTIONORDER.BUSINESSAREA == TGSB.GSBER` `A_PRODUCTIONORDER.MANDT == TGSB.MANDT`
Company Code Company Code Client	`A_PRODUCTIONORDER.COMPANYCODE == T001.BUKRS` `A_PRODUCTIONORDER.MANDT == T001.MANDT`
Functional Area Functional Area Client	`A_PRODUCTIONORDER.FUNCTIONALAREA == TFKB.FKBER` `A_PRODUCTIONORDER.MANDT == TFKB.MANDT`
Order Type Order Type Client	`A_PRODUCTIONORDER.MANUFACTURINGORDERTYPE == T003O.AUART` `A_PRODUCTIONORDER.MANDT == T003O.CLIENT`
Material Number for Order Material Number for Order Client	`A_PRODUCTIONORDER.MATERIAL == MARA.MATNR` `A_PRODUCTIONORDER.MANDT == MARA.MANDT`
MRP Controller Group MRP Controller Production Plant Client	`A_PRODUCTIONORDER.MRPCONTROLLER == T024D.DISPO` `A_PRODUCTIONORDER.PRODUCTIONPLANT == T024D.WERKS` `A_PRODUCTIONORDER.MANDT == T024D.MANDT`
Planning Plant for an Order Planning Plant for an Order Client	`A_PRODUCTIONORDER.PLANT == T001W.WERKS` `A_PRODUCTIONORDER.MANDT == T001W.MANDT`
Production Plant Production Plant Client	`A_PRODUCTIONORDER.PRODUCTIONPLANT == T001W.WERKS` `A_PRODUCTIONORDER.MANDT == T001W.MANDT`
Production Supervisor Production Supervisor Production Plant Client	`A_PRODUCTIONORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR` `A_PRODUCTIONORDER.PRODUCTIONPLANT == T024F.WERKS` `A_PRODUCTIONORDER.MANDT == T024F.MANDT`
Production Unit of Measure Production Unit of Measure Client	`A_PRODUCTIONORDER.PRODUCTIONUNIT == T006.MSEHI` `A_PRODUCTIONORDER.MANDT == T006.MANDT`
Profit Center ? ? Profit Center Client	`A_PRODUCTIONORDER.[column in domain "KOKRS"] == CEPC.KOKRS` `A_PRODUCTIONORDER.[column in domain "DATBI"] == CEPC.DATBI` `A_PRODUCTIONORDER.PROFITCENTER == CEPC.PRCTR` `A_PRODUCTIONORDER.MANDT == CEPC.MANDT`
MRP Distribution Key ? MRP Distribution Key Client	`A_PRODUCTIONORDER.[column in domain "WERKS_D"] == T437V.WERKS` `A_PRODUCTIONORDER.QUANTITYDISTRIBUTIONKEY == T437V.VERTL` `A_PRODUCTIONORDER.MANDT == T437V.MANDT`
Storage Location Planning Plant for an Order Storage Location Client	`A_PRODUCTIONORDER.PLANT == T001L.WERKS` `A_PRODUCTIONORDER.STORAGELOCATION == T001L.LGORT` `A_PRODUCTIONORDER.MANDT == T001L.MANDT`