I_MfgOrderOperationCompCube

Manufacturing Order Operation Component - Cube | view: IPPMFGORDOPCOMPC | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: SCAL_TT_DATE, RESB, T001, TKA02, MARC, TCS03
Column Name Description
Reservation Number of reservation/dependent requirements
ReservationItem Reservation Item
RecordType Reservation Record Type
Column Name Description
💲 Currency Key (Currency):
WithdrawnQuantityAmount Value Withdrawn
💲 Company Code Currency (CompanyCodeCurrency):
WithdrawnQtyAmountInCoCodeCry Withdrawn Amount in Company Code Currency
FreeDefinedAmount1 User-defined field for values (length 10,3)
Column Name Description
📏 Unit of Measure for Variable-Size Components (VariableSizeComponentUnit):
VariableSizeComponentQuantity Variable-Size Item Quantity per PC
📏 Base Unit of Measure (BaseUnit):
RequiredQuantity Requirement Quantity
WithdrawnQuantity Withdrawn Quantity
OpenQuantity null
DeviationQuantity Deviation Quantity
ConfirmedAvailableQuantity Available Quantity
MaterialCompOriginalQuantity Original Quantity of a Material Component
OriginalDemandQuantity Original Demand Quantity
ExcessConsumptionQuantity Excess Consumption Quantity
📏 Unit of entry (EntryUnit):
GoodsMovementEntryQty Quantity in Unit of Entry
Column Name Description
MatlCompRequirementDate Material Component Requirement Date
MatlCompRequirementTime Material Component Requirement Time
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
ReportingPeriod Reporting Period Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
MaterialComponentIsMissing Missing Part Show values
IsBulkMaterialComponent Indicator: bulk material Show values
MatlCompIsMarkedForBackflush Indicator: Backflush Show values
MaterialCompIsAlternativeItem Alternative Item Indicator Show values
MatlCompIsTextItem Item is Text indicator Show values
MatlCompDiscontinuationType Discontinuation Type Show values
MatlCompIsConfigurable Indicator: Configurable Item Show values
MaterialComponentIsClassified Indicator: Classification Exists Show values
MaterialCompIsIntraMaterial Indicator: Intra Material Show values
OrderIsReleased Checkbox Show values
OrderIsConfirmed Checkbox Show values
OrderIsDeleted Checkbox Show values
OrderIsTechnicallyCompleted Checkbox Show values
OrderIsClosed Checkbox Show values
OrderIsMarkedForDeletion Checkbox Show values
LongTextExists Long Text Exists Show values
RequirementType Requirement Type Show values
BillOfMaterialCategory Bill of Material Category Code Show values
GoodsMovementIsAllowed Goods movement for reservation allowed Show values
DebitCreditCode Debit/Credit Code Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ConsumptionPosting Consumption Posting Show values
MaterialCompIsVariableSized Variable-Sized Item Indicator Show values
MaterialComponentIsPhantomItem Phantom Item Indicator Show values
QuantityIsFixed Quantity is fixed Show values
IsNetScrap Net Scrap Indicator Show values
Column Name Description Domain name
ManufacturingOrderType Manufacturing Order Type AUFART
ManufacturingOrderSequence Sequence PLNFOLGE
ManufacturingOrderOperation Manufacturing Order Operation VORNR
ProductionPlant Production Plant WERKS
OrderInternalBillOfOperations Order Internal ID AUFPL
OrderIntBillOfOperationsItem Internal Identifier of an Operation or Activity CO_APLZL
AssemblyMRPController MRP Controller of Assembly Material DISPO
ProductionSupervisor Production Supervisor FEVOR
RequirementDateWeekDay Week Day NUM1
RequirementDateWeek Calendar Week NUM2
RequirementDateMonth Calendar Month NUM2
RequirementDateYear Calendar Year NUM4
RequirementDateYearMonth Year Month NUM6
ReservationItemCreationCode Status of Reservation Item STATR
MatlCompIsMarkedForDeletion Item is Deleted
UsageProbabilityPercent Usage Probability in % (Alternative Item) DEC3
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
WBSElementInternalID WBS Element PS_S4_PSPNR
ProductConfiguration Configuration (internal object number) CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
SortField Sort String CHAR10
BillOfMaterialInternalID Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialItemNodeNumber Bill of Material Item KNTNR
BillOfMaterialItemNumber Bill Of Material Item Number VDM_SPOSN
BOMItemDescription BOM Item Text (Line 1) TEXT40
PurchaseRequisition Purchase Requisition Number BANFN
DeliveryDurationInDays Delivery Duration In Days DEC3
SupplyArea Production Supply Area PRVBE
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
CompanyCode Company Code BUKRS
GLAccount G/L Account Number SAKNR
FunctionalArea Functional Area FKBER
NumberOfVariableSizeComponents 2 Byte Signed Integer INT2
OrderPathValue Order path AUFWG
OrderLevelValue Order level AUFST
LeadTimeOffset Lead-Time Offset NLFZT
OperationLeadTimeOffset Lead-Time Offset for Operations NLFZT
ComponentScrapInPercent Component Scrap in Percent DEC3_2
OperationScrapInPercent Operation Scrap DEC3_2
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T163K.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T006.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.BASEUNIT == T006.MSEHI
Batch Number
  • Plant
  • Production Plant
  • Client
  • Material Number
  • Batch Number
  • I_MFGORDEROPERATIONCOMPCUBE.PLANT == MCHA.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.PRODUCTIONPLANT == MCHA.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == MCHA.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.MATERIAL == MCHA.MATNR
  • I_MFGORDEROPERATIONCOMPCUBE.BATCH == MCHA.CHARG
Bill of Material Item Category
  • Client
  • Bill of Material Item Category
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T418.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.BILLOFMATERIALITEMCATEGORY == T418.POSTP
Bill of Material Explosion Date ID
  • Client
  • Bill of Material Explosion Date ID
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == SNUM.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.BOMEXPLOSIONDATEID == SNUM.SERNR
Business Area
  • Client
  • Business Area
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == TGSB.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.BUSINESSAREA == TGSB.GSBER
Change Number
  • Client
  • Change Number
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == AENR.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.CHANGENUMBER == AENR.AENNR
Company Code Currency
  • Client
  • Company Code Currency
  • Currency Key
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == TCURC.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MFGORDEROPERATIONCOMPCUBE.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Company Code Currency
  • Currency Key
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == TCURC.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MFGORDEROPERATIONCOMPCUBE.CURRENCY == TCURC.WAERS
Unit of entry
  • Client
  • Unit of entry
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T006.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.ENTRYUNIT == T006.MSEHI
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.FORMULAKEY == T418F.RFORM
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T418F.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.GOODSMOVEMENTTYPE == T156.BWART
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T156.MANDT
Inventory Special Stock Type
  • Inventory Special Stock Type
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T148.MANDT
Language: The long text was stored in this language I_MFGORDEROPERATIONCOMPCUBE.LONGTEXTLANGUAGECODE == T002.SPRAS
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.MANUFACTURINGORDER == AUFK.AUFNR
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == MARA.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.MATERIAL == MARA.MATNR
Indicator for Relevancy to Costing
  • Indicator for Relevancy to Costing
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.MATERIALCOMPISCOSTRELEVANT == TCK08.SELKZ
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == TCK08.MANDT
Material Group
  • Client
  • Material Group
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T023.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.MATERIALGROUP == T023.MATKL
MRP controller
  • Plant
  • Production Plant
  • Client
  • MRP Controller of Assembly Material
  • MRP Controller
  • I_MFGORDEROPERATIONCOMPCUBE.PLANT == T024D.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.PRODUCTIONPLANT == T024D.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T024D.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.ASSEMBLYMRPCONTROLLER == T024D.DISPO
  • I_MFGORDEROPERATIONCOMPCUBE.MRPCONTROLLER == T024D.DISPO
Unit of Measure for Lead-Time Offset for Operations
  • Client
  • Unit of Measure for Lead-Time Offset for Operations
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T006.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.OPERATIONLEADTIMEOFFSETUNIT == T006.MSEHI
Plant
  • Plant
  • Production Plant
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.PLANT == T001W.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.PRODUCTIONPLANT == T001W.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T024.MANDT
Purchasing Info Record
  • Client
  • Purchasing Info Record
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == EINA.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.PURCHASINGINFORECORD == EINA.INFNR
Storage Bin
  • Storage Type
  • Storage Bin
  • Client
  • Warehouse Number / Warehouse Complex
  • I_MFGORDEROPERATIONCOMPCUBE.STORAGETYPE == LAGP.LGTYP
  • I_MFGORDEROPERATIONCOMPCUBE.STORAGEBIN == LAGP.LGPLA
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == LAGP.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.WAREHOUSE == LAGP.LGNUM
Storage Location
  • Plant
  • Production Plant
  • Client
  • Storage Location
  • I_MFGORDEROPERATIONCOMPCUBE.PLANT == T001L.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.PRODUCTIONPLANT == T001L.WERKS
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T001L.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.STORAGELOCATION == T001L.LGORT
Storage Type
  • Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • I_MFGORDEROPERATIONCOMPCUBE.STORAGETYPE == T301.LGTYP
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T301.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.WAREHOUSE == T301.LGNUM
Unit of Measure for Variable-Size Components
  • Unit of Measure for Variable-Size Components
  • Client
  • I_MFGORDEROPERATIONCOMPCUBE.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T006.MANDT
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • I_MFGORDEROPERATIONCOMPCUBE.MANDT == T300.MANDT
  • I_MFGORDEROPERATIONCOMPCUBE.WAREHOUSE == T300.LGNUM