I_MfgOrderDuration

Manufacturing Order Duration | view: IMFGORDERDURN | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO, AFPO, JEST, AUFK
Column Name Description
ManufacturingOrder Manufacturing Order ID
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty Manufacturing Order Planned Total Quantity
MfgOrderPlannedScrapQty Manufacturing Order Planned Scrap Quantity
MfgOrderPlannedYieldQty Planned Yield Quantity
MfgOrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
ExpectedDeviationQuantity Expected Yield Deviation
ActualDeliveredQuantity Quantity of Goods Received for the Order Item
Column Name Description
MfgOrderCreationDate Order Creation Date
MfgOrderCreationTime Order Creation Time
LastChangeDate Change Date for Order Master
LastChangeTime Changed At
BOOExplosionDate Date for Routing Explosion
BOOValidityStartDate Valid-From Date
BOMExplosionDate Date of BOM Explosion/Routing Transfer
BOMValidityStartDate Valid-From Date
MfgOrderPlannedStartDate Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime Manufacturing Order Planned Start Time
MfgOrderPlannedEndDate Manufacturing Order Planned End Date
MfgOrderPlannedEndTime Manufacturing Order Planned End Time
MfgOrderPlannedReleaseDate Manufacturing Order Planned Release Date
MfgOrderScheduledStartDate Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime Manufacturing Order Scheduled Start Time
MfgOrderScheduledEndDate Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime Manufacturing Order Scheduled End Time
MfgOrderScheduledReleaseDate Manufacturing Order Scheduled Release Date
MfgOrderActualStartDate Manufacturing Order Actual Start Date
MfgOrderActualStartTime Manufacturing Order Actual Start Time
MfgOrderActualEndDate Manufacturing Order Actual End Date
MfgOrderActualReleaseDate Manufacturing Order Actual Release Date
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime Manufacturing Order Confirmed End Time
MfgOrderTotalCommitmentDate Total Commitment Date
Column Name Description
ManufacturingOrderCategory Order Category Show values
ManufacturingOrderHasLongText Long Text Exists Show values
MfgOrderIsToBeDeleted Deletion Flag Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
ProdnProcgIsFlexible Flexible Processing Show values
InventoryUsabilityCode Inventory Usability Code Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements Show values
MfgOrderSplitStatus Status of an Order in a Split Hierarchy Show values
BillOfMaterialCategory Bill of Material Category Code Show values
ControllingObjectClass Controlling Object Class Show values
Column Name Description Domain name
ManufacturingOrderText Manufacturing Order Text TEXT40
LongTextLanguageCode Long Text Language SPRAS
ManufacturingOrderImportance Order Importance Code CHAR1
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
OrderIsShopFloorOrder null
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
StockSegment Stock Segment SGT_SRCA
OrderInternalBillOfOperations Order Internal ID AUFPL
MfgOrderSuperiorMfgOrder Number of Superior Order AUFNR
MRPArea MRP Area BERID
ProductionVersion Production Version VERID
PlannedOrder Planned Order PLNUM
Reservation Number of reservation/dependent requirements RSNUM
MfgOrderConfirmation Completion confirmation number for the operation CO_RUECK
NumberOfMfgOrderConfirmations Number Of Confirmations CIM_COUNT
CapacityRequirement ID of the Capacity Requirements Record BEDID
InspectionLot Inspection Lot Number QPLOS
ForecastSchedulingType Forecast Scheduling Type TERART
ProductConfiguration Product Configuration CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
CapacityActiveVersion Version of Available Capacity KAPVERSION
OrderSequenceNumber Sequence Number Order CY_SEQNR
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperations Bill of Operations ID PLNNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterial Bill of Material STNUM
BillOfMaterialInternalID Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
ProductCostCollector Cost Collector for Production Process AUFNR
ActualCostsCostingVariant Costing Variant For Actual Costs KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
CurrentStartDelayInSeconds null
CurrentEndDelayInSeconds null
ConfirmedStartDelayInSeconds null
ConfirmedEndDelayInSeconds null
Master Data Relations Join Conditions
Basic Scheduling Type
  • Client
  • Basic Scheduling Type
  • I_MFGORDERDURATION.MANDT == T482.MANDT
  • I_MFGORDERDURATION.BASICSCHEDULINGTYPE == T482.TERMKZ
Batch Number
  • Batch Number
  • ?
  • Client
  • Material Number for Order
  • I_MFGORDERDURATION.BATCH == MCHA.CHARG
  • I_MFGORDERDURATION.[column in domain "WERKS_D"] == MCHA.WERKS
  • I_MFGORDERDURATION.MANDT == MCHA.MANDT
  • I_MFGORDERDURATION.MATERIAL == MCHA.MATNR
BOM Usage
  • Client
  • BOM Usage
  • I_MFGORDERDURATION.MANDT == T416.MANDT
  • I_MFGORDERDURATION.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Bill of Operations Material
  • Bill of Operations Material
  • Client
  • I_MFGORDERDURATION.BILLOFOPERATIONSMATERIAL == MARA.MATNR
  • I_MFGORDERDURATION.MANDT == MARA.MANDT
Task List Usage
  • Bill of Operations Usage
  • Client
  • I_MFGORDERDURATION.BILLOFOPERATIONSUSAGE == T411.VERWE
  • I_MFGORDERDURATION.MANDT == T411.MANDT
Business Area
  • Business Area
  • Client
  • I_MFGORDERDURATION.BUSINESSAREA == TGSB.GSBER
  • I_MFGORDERDURATION.MANDT == TGSB.MANDT
Change Number
  • Change Number
  • Client
  • I_MFGORDERDURATION.CHANGENUMBER == AENR.AENNR
  • I_MFGORDERDURATION.MANDT == AENR.MANDT
Company Code
  • Company Code
  • Client
  • I_MFGORDERDURATION.COMPANYCODE == T001.BUKRS
  • I_MFGORDERDURATION.MANDT == T001.MANDT
Application I_MFGORDERDURATION.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Controlling Area
  • Client
  • I_MFGORDERDURATION.CONTROLLINGAREA == TKA01.KOKRS
  • I_MFGORDERDURATION.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • Controlling Area
  • Cost Center for Basic Settlement
  • Client
  • ?
  • I_MFGORDERDURATION.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERDURATION.COSTCENTER == CSKS.KOSTL
  • I_MFGORDERDURATION.MANDT == CSKS.MANDT
  • I_MFGORDERDURATION.[column in domain "DATBI"] == CSKS.DATBI
Settlement Cost Element
  • Controlling Area
  • Settlement Cost Element
  • Client
  • ?
  • I_MFGORDERDURATION.CONTROLLINGAREA == CSKB.KOKRS
  • I_MFGORDERDURATION.COSTELEMENT == CSKB.KSTAR
  • I_MFGORDERDURATION.MANDT == CSKB.MANDT
  • I_MFGORDERDURATION.[column in domain "DATBI"] == CSKB.DATBI
Costing Sheet
  • Application
  • ?
  • Costing Sheet
  • Client
  • I_MFGORDERDURATION.CONDITIONAPPLICATION == T683.KAPPL
  • I_MFGORDERDURATION.[column in domain "KVEWE"] == T683.KVEWE
  • I_MFGORDERDURATION.COSTINGSHEET == T683.KALSM
  • I_MFGORDERDURATION.MANDT == T683.MANDT
Order Currency
  • Order Currency
  • Client
  • I_MFGORDERDURATION.CURRENCY == TCURC.WAERS
  • I_MFGORDERDURATION.MANDT == TCURC.MANDT
Functional Area
  • Functional Area
  • Client
  • I_MFGORDERDURATION.FUNCTIONALAREA == TFKB.FKBER
  • I_MFGORDERDURATION.MANDT == TFKB.MANDT
G/L Account for Basic Settlement
  • Company Code
  • Client
  • G/L Account for Basic Settlement
  • I_MFGORDERDURATION.COMPANYCODE == SKB1.BUKRS
  • I_MFGORDERDURATION.MANDT == SKB1.MANDT
  • I_MFGORDERDURATION.GLACCOUNT == SKB1.SAKNR
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_MFGORDERDURATION.LEADINGORDER == AUFK.AUFNR
  • I_MFGORDERDURATION.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MFGORDERDURATION.MANUFACTURINGORDERTYPE == T003O.AUART
  • I_MFGORDERDURATION.MANDT == T003O.CLIENT
Material Number for Order
  • Client
  • Material Number for Order
  • I_MFGORDERDURATION.MANDT == MARA.MANDT
  • I_MFGORDERDURATION.MATERIAL == MARA.MATNR
MRP Controller Group
  • MRP Controller
  • Production Plant
  • Client
  • I_MFGORDERDURATION.MRPCONTROLLER == T024D.DISPO
  • I_MFGORDERDURATION.PRODUCTIONPLANT == T024D.WERKS
  • I_MFGORDERDURATION.MANDT == T024D.MANDT
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDERDURATION.MANDT == T001W.MANDT
  • I_MFGORDERDURATION.MRPPLANT == T001W.WERKS
Fashion Collection
  • Season
  • Fashion Collection
  • Season Year
  • Client
Production Plant
  • Production Plant
  • Client
  • I_MFGORDERDURATION.PRODUCTIONPLANT == T001W.WERKS
  • I_MFGORDERDURATION.MANDT == T001W.MANDT
Production Scheduling Profile
  • Production Plant
  • Client
  • Production Scheduling Profile
  • I_MFGORDERDURATION.PRODUCTIONPLANT == TCO43.WERKS
  • I_MFGORDERDURATION.MANDT == TCO43.MANDT
  • I_MFGORDERDURATION.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
Production Supervisor
  • Production Plant
  • Client
  • Production Supervisor
  • I_MFGORDERDURATION.PRODUCTIONPLANT == T024F.WERKS
  • I_MFGORDERDURATION.MANDT == T024F.MANDT
  • I_MFGORDERDURATION.PRODUCTIONSUPERVISOR == T024F.FEVOR
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_MFGORDERDURATION.PRODUCTIONUNIT == T006.MSEHI
  • I_MFGORDERDURATION.MANDT == T006.MANDT
Season
  • Season
  • Season Year
  • Client
  • I_MFGORDERDURATION.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_MFGORDERDURATION.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_MFGORDERDURATION.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_MFGORDERDURATION.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_MFGORDERDURATION.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_MFGORDERDURATION.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Fashion Collection
  • Season Year
  • Client
  • Fashion Theme
  • I_MFGORDERDURATION.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_MFGORDERDURATION.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_MFGORDERDURATION.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_MFGORDERDURATION.MANDT == FSH_THEMES.MANDT
  • I_MFGORDERDURATION.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • I_MFGORDERDURATION.CONTROLLINGAREA == CEPC.KOKRS
  • I_MFGORDERDURATION.MANDT == CEPC.MANDT
  • I_MFGORDERDURATION.[column in domain "DATBI"] == CEPC.DATBI
  • I_MFGORDERDURATION.PROFITCENTER == CEPC.PRCTR
MRP Distribution Key
  • ?
  • MRP Distribution Key
  • Client
  • I_MFGORDERDURATION.[column in domain "WERKS_D"] == T437V.WERKS
  • I_MFGORDERDURATION.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
  • I_MFGORDERDURATION.MANDT == T437V.MANDT
Reference Order Number
  • Client
  • Reference Order Number
  • I_MFGORDERDURATION.MANDT == AUFK.MANDT
  • I_MFGORDERDURATION.REFERENCEORDER == AUFK.AUFNR
Responsible Cost Center
  • Responsible Cost Center
  • Controlling Area
  • Client
  • ?
  • I_MFGORDERDURATION.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MFGORDERDURATION.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERDURATION.MANDT == CSKS.MANDT
  • I_MFGORDERDURATION.[column in domain "DATBI"] == CSKS.DATBI
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • I_MFGORDERDURATION.STORAGELOCATION == T001L.LGORT
  • I_MFGORDERDURATION.MANDT == T001L.MANDT
  • I_MFGORDERDURATION.MRPPLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Production Plant
  • Client
  • Responsible Planner Group or Department
  • I_MFGORDERDURATION.PRODUCTIONPLANT == T024A.WERKS
  • I_MFGORDERDURATION.MANDT == T024A.MANDT
  • I_MFGORDERDURATION.RESPONSIBLEPLANNERGROUP == T024A.FEVOR