I_OrderComponent

Order Component | view: IORDERCOMP | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: RESB, AUFK
Column Name Description
Reservation Number of reservation/dependent requirements
ReservationItem Reservation Item
RecordType Reservation Record Type
Column Name Description
💲 Currency Key (Currency):
ExternalProcessingPrice Price
WithdrawnQuantityAmount Value Withdrawn
Column Name Description
📏 Unit of Measure for Variable-Size Components (VariableSizeComponentUnit):
VariableSizeComponentQuantity Variable-Size Item Quantity per PC
📏 Unit of measure for sizes 1 to 3 (VariableSizeDimensionUnit):
VariableSizeDimension1 Size 1
VariableSizeDimension2 Size 2
VariableSizeDimension3 Size 3
📏 Base Unit of Measure (BaseUnit):
RequiredQuantity Requirement Quantity
WithdrawnQuantity Withdrawn Quantity
ConfirmedAvailableQuantity Available Quantity
MaterialCompOriginalQuantity Original Quantity of a Material Component
📏 Unit of entry (EntryUnit):
GoodsMovementEntryQty Quantity in Unit of Entry
Column Name Description
MatlCompRequirementDate Material Component Requirement Date
MatlCompRequirementTime Material Component Requirement Time
LatestRequirementDate Latest Requirement Date
Column Name Description
OrderCategory Order Category 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
MatlCompIsTextItem Item is Text indicator Show values
MaterialPlanningRelevance Code: Relevant for Materials Planning Show values
MatlCompIsConfigurable Indicator: Configurable Item Show values
MaterialComponentIsClassified Indicator: Classification Exists Show values
MaterialCompIsIntraMaterial Indicator: Intra Material Show values
MaterialIsDirectlyProduced Indicator for Direct Production (Collective Order) Show values
MaterialIsDirectlyProcured Direct Procurement Indicator 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
MaterialCompIsAlternativeItem Alternative Item Indicator Show values
AlternativeItemStrategy Alternative Item Strategy Show values
MaterialComponentIsPhantomItem Phantom Item Indicator Show values
MatlCompDiscontinuationType Discontinuation Type Show values
MatlCompIsFollowUpMaterial Indicator: Component is Follow-Up Material Show values
FollowUpMaterialIsNotActive Indicator: Follow-Up Material is Active Show values
QuantityIsFixed Quantity is fixed Show values
IsNetScrap Net Scrap Indicator Show values
Column Name Description Domain name
Sequence Sequence PLNFOLGE
OrderOperation Manufacturing Order Operation VORNR
OrderInternalID Order Internal ID AUFPL
OrderOperationInternalID Internal Identifier of an Operation or Activity CO_APLZL
ReservationItemCreationCode Status of Reservation Item STATR
MatlCompIsMarkedForDeletion Item is Deleted
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
MatlCompFreeDefinedAttribute Sort String CHAR10
BillOfMaterialInternalID Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BOMItem Bill of Material Item KNTNR
BillOfMaterialVersion BOM Version CS_VERSN
BOMItemInternalChangeCount Internal counter CIM_COUNT
InheritedBOMItemNode Inherited node number of BOM item KNTNR
BillOfMaterialItemNumber Bill Of Material Item Number VDM_SPOSN
BOMItemDescription BOM Item Text (Line 1) TEXT40
BOMItemText2 BOM Item Text (Line 2) TEXT40
PurchaseRequisition Purchase Requisition Number BANFN
DeliveryDurationInDays Delivery Duration In Days DEC3
MaterialGoodsReceiptDuration Material Goods Receipt Duration in Days DEC3
NumberOfOperationPriceUnits Material Price Unit Quantity PACK3
SupplyArea Production Supply Area PRVBE
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
RequirementSegment Requirement Segment SGT_SRCA
GLAccount G/L Account Number SAKNR
FunctionalArea Functional Area FKBER
CommitmentItemShortID Commitment Item Short ID FMIS_CI_INTERNALNAME
FundsCenter Funds Center FISTL
AlternativeItemGroup Alternative Item Group CHAR2
AlternativeItemPriority Alternative Item Priority NUM2
UsageProbabilityPercent Usage Probability in % (Alternative Item) DEC3
OrderPathValue Order path AUFWG
OrderLevelValue Order level AUFST
AssemblyOrderPathValue Assembly Order Path AUFWG
AssemblyOrderLevelValue Assembly Order Level AUFST
DiscontinuationGroup Discontinuation Group CHAR2
FollowUpGroup Follow-up Group CHAR2
LeadTimeOffset Lead-Time Offset NLFZT
OperationLeadTimeOffset Lead-Time Offset for Operations NLFZT
ComponentScrapInPercent Component Scrap in Percent DEC3_2
OperationScrapInPercent Operation Scrap DEC3_2
MaterialQtyToBaseQtyNmrtr Numerator for Conversion to Base Units of Measure UMBSZ
MaterialQtyToBaseQtyDnmntr Denominator for conversion to base units of measure UMBSN
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_ORDERCOMPONENT.MANDT == T163K.MANDT
  • I_ORDERCOMPONENT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Higher-Level Assembly Material
  • Higher-Level Assembly Material
  • Client
  • I_ORDERCOMPONENT.ASSEMBLY == MARA.MATNR
  • I_ORDERCOMPONENT.MANDT == MARA.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ORDERCOMPONENT.MANDT == T006.MANDT
  • I_ORDERCOMPONENT.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Material Number
  • Client
  • Plant
  • I_ORDERCOMPONENT.BATCH == MCHA.CHARG
  • I_ORDERCOMPONENT.MATERIAL == MCHA.MATNR
  • I_ORDERCOMPONENT.MANDT == MCHA.MANDT
  • I_ORDERCOMPONENT.PLANT == MCHA.WERKS
Bill of Material Explosion Date ID
  • Client
  • Bill of Material Explosion Date ID
  • I_ORDERCOMPONENT.MANDT == SNUM.MANDT
  • I_ORDERCOMPONENT.BOMEXPLOSIONDATEID == SNUM.SERNR
Bill of Material Item Category
  • Client
  • Bill of Material Item Category
  • I_ORDERCOMPONENT.MANDT == T418.MANDT
  • I_ORDERCOMPONENT.BOMITEMCATEGORY == T418.POSTP
Business Area
  • Business Area
  • Client
  • I_ORDERCOMPONENT.BUSINESSAREA == TGSB.GSBER
  • I_ORDERCOMPONENT.MANDT == TGSB.MANDT
Change Number
  • Client
  • Change Number
  • I_ORDERCOMPONENT.MANDT == AENR.MANDT
  • I_ORDERCOMPONENT.CHANGENUMBER == AENR.AENNR
Company Code
  • Company Code
  • Client
  • I_ORDERCOMPONENT.COMPANYCODE == T001.BUKRS
  • I_ORDERCOMPONENT.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_ORDERCOMPONENT.MANDT == TKA01.MANDT
  • I_ORDERCOMPONENT.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • I_ORDERCOMPONENT.MANDT == TCURC.MANDT
  • I_ORDERCOMPONENT.CURRENCY == TCURC.WAERS
Unit of entry
  • Unit of entry
  • Client
  • I_ORDERCOMPONENT.ENTRYUNIT == T006.MSEHI
  • I_ORDERCOMPONENT.MANDT == T006.MANDT
Follow-Up / Original Material
  • Client
  • Follow-Up / Original Material
  • I_ORDERCOMPONENT.MANDT == MARA.MANDT
  • I_ORDERCOMPONENT.FOLLOWUPMATERIAL == MARA.MATNR
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • I_ORDERCOMPONENT.FORMULAKEY == T418F.RFORM
  • I_ORDERCOMPONENT.MANDT == T418F.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_ORDERCOMPONENT.GOODSMOVEMENTTYPE == T156.BWART
  • I_ORDERCOMPONENT.MANDT == T156.MANDT
Inventory Special Stock Type
  • Inventory Special Stock Type
  • Client
  • I_ORDERCOMPONENT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_ORDERCOMPONENT.MANDT == T148.MANDT
Material Provision Indicator
  • Client
  • Material Provision Indicator
  • Material Provision Type
  • I_ORDERCOMPONENT.MANDT == T417.MANDT
  • I_ORDERCOMPONENT.ISMATERIALPROVISION == T417.BEIKZ
  • I_ORDERCOMPONENT.MATERIALPROVISIONTYPE == T417.BEIKZ
Language: The long text was stored in this language I_ORDERCOMPONENT.LONGTEXTLANGUAGECODE == T002.SPRAS
Material Number
  • Material Number
  • Client
  • I_ORDERCOMPONENT.MATERIAL == MARA.MATNR
  • I_ORDERCOMPONENT.MANDT == MARA.MANDT
Indicator for Relevancy to Costing
  • Indicator for Relevancy to Costing
  • Client
  • I_ORDERCOMPONENT.MATERIALCOMPISCOSTRELEVANT == TCK08.SELKZ
  • I_ORDERCOMPONENT.MANDT == TCK08.MANDT
Indicator: Spare Part
  • Indicator: Spare Part
  • Client
  • I_ORDERCOMPONENT.MATERIALCOMPONENTISSPAREPART == T413.ERSKZ
  • I_ORDERCOMPONENT.MANDT == T413.MANDT
Material Group
  • Material Group
  • Client
  • I_ORDERCOMPONENT.MATERIALGROUP == T023.MATKL
  • I_ORDERCOMPONENT.MANDT == T023.MANDT
Material Provision Type
  • Client
  • Material Provision Indicator
  • Material Provision Type
  • I_ORDERCOMPONENT.MANDT == T417.MANDT
  • I_ORDERCOMPONENT.ISMATERIALPROVISION == T417.BEIKZ
  • I_ORDERCOMPONENT.MATERIALPROVISIONTYPE == T417.BEIKZ
Unit of Measure for Lead-Time Offset for Operations
  • Client
  • Unit of Measure for Lead-Time Offset for Operations
  • I_ORDERCOMPONENT.MANDT == T006.MANDT
  • I_ORDERCOMPONENT.OPERATIONLEADTIMEOFFSETUNIT == T006.MSEHI
Order Number
  • Client
  • Order Number
  • I_ORDERCOMPONENT.MANDT == AUFK.MANDT
  • I_ORDERCOMPONENT.ORDERID == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • I_ORDERCOMPONENT.ORDERTYPE == T003O.AUART
  • I_ORDERCOMPONENT.MANDT == T003O.CLIENT
Plant
  • Client
  • Plant
  • I_ORDERCOMPONENT.MANDT == T001W.MANDT
  • I_ORDERCOMPONENT.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • I_ORDERCOMPONENT.PURCHASINGGROUP == T024.EKGRP
  • I_ORDERCOMPONENT.MANDT == T024.MANDT
Purchasing Info Record
  • Purchasing Info Record
  • Client
  • I_ORDERCOMPONENT.PURCHASINGINFORECORD == EINA.INFNR
  • I_ORDERCOMPONENT.MANDT == EINA.MANDT
Sequence Category I_ORDERCOMPONENT.SEQUENCECATEGORY == TCA07.FLGAT
Storage Location
  • Storage Location
  • Client
  • Plant
  • I_ORDERCOMPONENT.STORAGELOCATION == T001L.LGORT
  • I_ORDERCOMPONENT.MANDT == T001L.MANDT
  • I_ORDERCOMPONENT.PLANT == T001L.WERKS
Unit of Measure for Variable-Size Components
  • Client
  • Unit of Measure for Variable-Size Components
  • I_ORDERCOMPONENT.MANDT == T006.MANDT
  • I_ORDERCOMPONENT.VARIABLESIZECOMPONENTUNIT == T006.MSEHI
Unit of measure for sizes 1 to 3
  • Unit of measure for sizes 1 to 3
  • Client
  • I_ORDERCOMPONENT.VARIABLESIZEDIMENSIONUNIT == T006.MSEHI
  • I_ORDERCOMPONENT.MANDT == T006.MANDT