I_MfgOrderBasicFilter

Manufacturing Order | view: IPPMFGORDBSCFLT | ATTR | Extraction: Not supported | Component: Shop Floor Execution
Tables used: AFKO, AFPO, 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
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
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
ManufacturingOrderHasLongText Long Text Exists Show values
ProdnProcgIsFlexible Flexible Processing Show values
MfgOrderIsToBeDeleted Deletion Flag Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
OrderIsNotCostedAutomatically Indicator: Do not cost automatically Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements 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
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
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
SettlementReservation Settlement Reservation RSNUM
MfgOrderConfirmation Completion confirmation number for the operation CO_RUECK
MfgOrderConfirmationCount Internal counter 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 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
Master Data Relations Join Conditions
Basic Scheduling Type
  • Client
  • Basic Scheduling Type
  • I_MFGORDERBASICFILTER.MANDT == T482.MANDT
  • I_MFGORDERBASICFILTER.BASICSCHEDULINGTYPE == T482.TERMKZ
Batch Number
  • Batch Number
  • ?
  • Client
  • Material Number for Order
  • I_MFGORDERBASICFILTER.BATCH == MCHA.CHARG
  • I_MFGORDERBASICFILTER.[column in domain "WERKS_D"] == MCHA.WERKS
  • I_MFGORDERBASICFILTER.MANDT == MCHA.MANDT
  • I_MFGORDERBASICFILTER.MATERIAL == MCHA.MATNR
BOM Usage
  • BOM Usage
  • Client
  • I_MFGORDERBASICFILTER.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • I_MFGORDERBASICFILTER.MANDT == T416.MANDT
Bill of Operations Material
  • Bill of Operations Material
  • Client
  • I_MFGORDERBASICFILTER.BILLOFOPERATIONSMATERIAL == MARA.MATNR
  • I_MFGORDERBASICFILTER.MANDT == MARA.MANDT
Task List Usage
  • Bill of Operations Usage
  • Client
  • I_MFGORDERBASICFILTER.BILLOFOPERATIONSUSAGE == T411.VERWE
  • I_MFGORDERBASICFILTER.MANDT == T411.MANDT
Business Area
  • Business Area
  • Client
  • I_MFGORDERBASICFILTER.BUSINESSAREA == TGSB.GSBER
  • I_MFGORDERBASICFILTER.MANDT == TGSB.MANDT
Change Number
  • Change Number
  • Client
  • I_MFGORDERBASICFILTER.CHANGENUMBER == AENR.AENNR
  • I_MFGORDERBASICFILTER.MANDT == AENR.MANDT
Company Code
  • Client
  • Company Code
  • I_MFGORDERBASICFILTER.MANDT == T001.MANDT
  • I_MFGORDERBASICFILTER.COMPANYCODE == T001.BUKRS
Application I_MFGORDERBASICFILTER.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Controlling Area
  • Client
  • I_MFGORDERBASICFILTER.CONTROLLINGAREA == TKA01.KOKRS
  • I_MFGORDERBASICFILTER.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • ?
  • Controlling Area
  • Cost Center for Basic Settlement
  • Client
  • I_MFGORDERBASICFILTER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MFGORDERBASICFILTER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERBASICFILTER.COSTCENTER == CSKS.KOSTL
  • I_MFGORDERBASICFILTER.MANDT == CSKS.MANDT
Settlement Cost Element
  • ?
  • Controlling Area
  • Client
  • Settlement Cost Element
  • I_MFGORDERBASICFILTER.[column in domain "DATBI"] == CSKB.DATBI
  • I_MFGORDERBASICFILTER.CONTROLLINGAREA == CSKB.KOKRS
  • I_MFGORDERBASICFILTER.MANDT == CSKB.MANDT
  • I_MFGORDERBASICFILTER.COSTELEMENT == CSKB.KSTAR
Costing Sheet
  • Application
  • ?
  • Client
  • Costing Sheet
  • I_MFGORDERBASICFILTER.CONDITIONAPPLICATION == T683.KAPPL
  • I_MFGORDERBASICFILTER.[column in domain "KVEWE"] == T683.KVEWE
  • I_MFGORDERBASICFILTER.MANDT == T683.MANDT
  • I_MFGORDERBASICFILTER.COSTINGSHEET == T683.KALSM
Order Currency
  • Client
  • Order Currency
  • I_MFGORDERBASICFILTER.MANDT == TCURC.MANDT
  • I_MFGORDERBASICFILTER.CURRENCY == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • I_MFGORDERBASICFILTER.FUNCTIONALAREA == TFKB.FKBER
  • I_MFGORDERBASICFILTER.MANDT == TFKB.MANDT
G/L Account for Basic Settlement
  • Client
  • Company Code
  • G/L Account for Basic Settlement
  • I_MFGORDERBASICFILTER.MANDT == SKB1.MANDT
  • I_MFGORDERBASICFILTER.COMPANYCODE == SKB1.BUKRS
  • I_MFGORDERBASICFILTER.GLACCOUNT == SKB1.SAKNR
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_MFGORDERBASICFILTER.LEADINGORDER == AUFK.AUFNR
  • I_MFGORDERBASICFILTER.MANDT == AUFK.MANDT
Manufacturing Order Type
  • Client
  • Manufacturing Order Type
  • I_MFGORDERBASICFILTER.MANDT == T003O.CLIENT
  • I_MFGORDERBASICFILTER.MANUFACTURINGORDERTYPE == T003O.AUART
Material Number for Order
  • Client
  • Material Number for Order
  • I_MFGORDERBASICFILTER.MANDT == MARA.MANDT
  • I_MFGORDERBASICFILTER.MATERIAL == MARA.MATNR
MRP Controller Group
  • MRP Controller
  • Client
  • Production Plant
  • I_MFGORDERBASICFILTER.MRPCONTROLLER == T024D.DISPO
  • I_MFGORDERBASICFILTER.MANDT == T024D.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONPLANT == T024D.WERKS
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDERBASICFILTER.MANDT == T001W.MANDT
  • I_MFGORDERBASICFILTER.MRPPLANT == T001W.WERKS
Production Plant
  • Client
  • Production Plant
  • I_MFGORDERBASICFILTER.MANDT == T001W.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONPLANT == T001W.WERKS
Production Scheduling Profile
  • Client
  • Production Plant
  • Production Scheduling Profile
  • I_MFGORDERBASICFILTER.MANDT == TCO43.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONPLANT == TCO43.WERKS
  • I_MFGORDERBASICFILTER.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
Production Supervisor
  • Production Supervisor
  • Client
  • Production Plant
  • I_MFGORDERBASICFILTER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGORDERBASICFILTER.MANDT == T024F.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONPLANT == T024F.WERKS
Production Unit of Measure
  • Client
  • Production Unit of Measure
  • I_MFGORDERBASICFILTER.MANDT == T006.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONUNIT == T006.MSEHI
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • I_MFGORDERBASICFILTER.[column in domain "DATBI"] == CEPC.DATBI
  • I_MFGORDERBASICFILTER.CONTROLLINGAREA == CEPC.KOKRS
  • I_MFGORDERBASICFILTER.MANDT == CEPC.MANDT
  • I_MFGORDERBASICFILTER.PROFITCENTER == CEPC.PRCTR
Reference Order Number
  • Client
  • Reference Order Number
  • I_MFGORDERBASICFILTER.MANDT == AUFK.MANDT
  • I_MFGORDERBASICFILTER.REFERENCEORDER == AUFK.AUFNR
Responsible Cost Center
  • ?
  • Controlling Area
  • Responsible Cost Center
  • Client
  • I_MFGORDERBASICFILTER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MFGORDERBASICFILTER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERBASICFILTER.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MFGORDERBASICFILTER.MANDT == CSKS.MANDT
Serial Number Profile
  • Client
  • Serial Number Profile
  • I_MFGORDERBASICFILTER.MANDT == T377P.MANDT
  • I_MFGORDERBASICFILTER.SERIALNUMBERASSGMTPROFILE == T377P.SERAIL
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • I_MFGORDERBASICFILTER.STORAGELOCATION == T001L.LGORT
  • I_MFGORDERBASICFILTER.MANDT == T001L.MANDT
  • I_MFGORDERBASICFILTER.MRPPLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Client
  • Production Plant
  • Responsible Planner Group or Department
  • I_MFGORDERBASICFILTER.MANDT == T024A.MANDT
  • I_MFGORDERBASICFILTER.PRODUCTIONPLANT == T024A.WERKS
  • I_MFGORDERBASICFILTER.RESPONSIBLEPLANNERGROUP == T024A.FEVOR