R_MaintBillOfMaterialItemTP

Maintenance BOM Item | view: IMAINTBOMITEMTP | TRAN | Extraction: Not supported | Component: Bills of Material (Plant Maintenance)
Tables used: DRAT, T418, T418T, KLAH, SWOR, EQST, MAST, MAKT, LFA1, TPST, STAS, STPO, STKO, STZU, TCS03, TCS03
Column Name Description
BillOfMaterial null
BillOfMaterialCategory BOM category Show values
BillOfMaterialVariant Alternative BOM
BillOfMaterialVersion BOM Version
TechnicalObject Material Number
Plant Plant
EngineeringChangeDocument FK Change Number
BillOfMaterialVariantUsage FK BOM Usage
BillOfMaterialItemNodeNumber BOM item node number
Column Name Description
💲 Currency Key (Currency):
MaterialComponentPrice Price
Column Name Description
📏 Component Unit of Measure (BillOfMaterialItemUnit):
BillOfMaterialItemQuantity Component Quantity
QuantityVariableSizeItem Variable-Size Item Quantity per Piece (PC)
📏 Unit of measure for sizes 1 to 3 (UnitOfMeasureForSize1To3):
Size1 Size 1
Size2 Size 2
Size3 Size 3
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
BOMItemRecordCreationDate Date Record Created On
BOMItemLastChangeDate Last Changed On
Column Name Description
BillOfMaterialCategory BOM category Show values
IsVersionBillOfMaterial Indicator: Relevant for Versioning Show values
IsSubItem Indicator: sub-items exist Show values
BOMItemHasFixedQuantity Fixed Quantity Show values
IsNetScrap Net Scrap Indicator Show values
IsClassificationRelevant Indicator: classification as selection condition Show values
IsBulkMaterial Indicator: bulk material Show values
IsProductionRelevant Indicator: item relevant to production Show values
BOMItemIsPlantMaintRelevant Indicator: item relevant to plant maintenance Show values
IsEngineeringRelevant Indicator: item relevant to engineering Show values
IsBOMRecursiveAllowed Indicator: recursiveness allowed Show values
BOMIsRecursive Indicator: BOM is recursive Show values
DocumentIsCreatedByCAD CAD Indicator Show values
RequiredComponent Required Component Show values
MultipleSelectionAllowed Multiple Selection Allowed Show values
MaterialIsCoProduct Indicator: co-product Show values
IsConfigurableBOM Selection indicator for configurable BOMs Show values
IsSoftwareComponent Indicator: Software component Show values
IsDeleted Deletion Indicator Show values
IsALE ALE indicator Show values
MaterialComponentIsPhantomItem Phantom item indicator Show values
IsPhantomItem Phantom item indicator Show values
AlternativeItemStrategy Alternative item: strategy Show values
IsPMAssemblyRelevant PM assembly indicator Show values
OrigSalesOrderBOMItmCategory BOM category of original sales order BOM item Show values
Column Name Description Domain name
BillOfMaterialItemUUID Global identification of an item's change status SYSUUID
BillOfMaterialHeaderUUID Global identification of a BOM header change status SYSUUID
BOMItemInternalChangeCount Internal counter CIM_COUNT
ChgToEngineeringChgDocument Change Number To AENNR
InheritedNodeNumberForBOMItem Inherited node number of BOM item KNTNR
InheritedNodeNumberVersionBOM Inherited node number of BOM item KNTNR
BOMItemCreatedByUser User who created record USNAM
BOMItemLastChangedByUser Name of Person Who Changed Object USNAM
BillOfMaterialComponent BOM component MATNR
BillOfMaterialItemNumber null
IsAssembly Indicator: assembly CHAR1
BOMItemSorter Sort String CHAR10
IdentifierBOMItem External identification of an item CHAR8
MaterialPriceUnitQty Price unit PACK3
ComponentScrapInPercent Component Scrap in Percent DEC3_2
OperationScrapInPercent Operation Scrap DEC3_2
BOMItemDescription BOM Item Text (Line 1) TEXT40
BOMItemText2 BOM Item Text (Line 2) TEXT40
ComponentDescription BOM Item Text (Line 1) TEXT40
DocNumber Document number DOKNR
DocumentVersion Document Version DOKVR
DocumentPart Document Part DOKTL
ClassNumber Class number KLASSE
DependencyObjectNumber Number of Object with Assigned Dependencies KNOBJ
ObjectType Object type (BOM item) OBJTY
SpecialProcurementType Special Procurement Type for BOM Item SOBSL
OperationLeadTimeOffset Lead-time offset for operation NLFZT
DeliveryDurationInDays Delivery time in days DEC3
Creditor Account Number of Supplier LIFNR
CostElement Cost element SAKNR
GoodsReceiptDuration Goods receipt processing time in days DEC3
FollowUpGroup Follow-up group CHAR2
DiscontinuationGroup Discontinuation group CHAR2
LeadTimeOffset Lead-time offset NLFZT
BillOfMaterialItemCategoryDesc Item Category Description TEXT30
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
AlternativeItemGroup Alternative item: group CHAR2
AlternativeItemPriority Alternative item: ranking order NUM2
UsageProbabilityPercent Usage Probability in % (Alternative Item) DEC3
OrigSalesOrderBOM null
OrigSalesOrderBOMItmNodeNumber Node number of original sales order BOM item KNTNR
OrigSalesOrderBOMItmNumber Counter for original sales order BOM item CIM_COUNT
Master Data Relations Join Conditions
Item category (bill of material)
  • Item category (bill of material)
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.BILLOFMATERIALITEMCATEGORY == T418.POSTP
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T418.MANDT
BOM Usage
  • BOM Usage
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T416.MANDT
for every costing relevancy none, one or several entries
  • Client
  • Indicator for relevancy to costing
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TCK08.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.BOMITEMISCOSTINGRELEVANT == TCK08.SELKZ
Indicator: item relevant to sales
  • Client
  • Indicator: item relevant to sales
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TVRL.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.BOMITEMISSALESRELEVANT == TVRL.RVREL
Indicator: Spare Part
  • Indicator: Spare Part
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.BOMITEMISSPAREPART == T413.ERSKZ
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T413.MANDT
Class Type
  • Client
  • Class Type
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TCLA.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.CLASSTYPE == TCLA.KLART
Currency Key
  • Currency Key
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.CURRENCY == TCURC.WAERS
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TCURC.MANDT
Distribution key for component consumption
  • ?
  • Distribution key for component consumption
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.[column in domain "WERKS_D"] == T437V.WERKS
  • R_MAINTBILLOFMATERIALITEMTP.DISTRKEYCOMPCONSUMPTION == T437V.VERTL
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T437V.MANDT
Document Type
  • Document Type
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.DOCUMENTTYPE == TDWA.DOKAR
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TDWA.MANDT
Change Number
  • Change Number
  • Change Number
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.HEADERCHANGEDOCUMENT == AENR.AENNR
  • R_MAINTBILLOFMATERIALITEMTP.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == AENR.MANDT
Explosion type
  • Client
  • Explosion type
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T414.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.EXPLOSIONTYPE == T414.DISPO
Formula Key for Variable-Size Items
  • Client
  • Formula Key for Variable-Size Items
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T418F.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.FORMULAKEY == T418F.RFORM
Change Number
  • Change Number
  • Change Number
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.HEADERCHANGEDOCUMENT == AENR.AENNR
  • R_MAINTBILLOFMATERIALITEMTP.ENGINEERINGCHANGEDOCUMENT == AENR.AENNR
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == AENR.MANDT
Material Provision Indicator
  • Material Provision Indicator
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.ISMATERIALPROVISION == T417.BEIKZ
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T417.MANDT
Long Text Language, for Creation of a Change Document R_MAINTBILLOFMATERIALITEMTP.LONGTEXTLANGUAGE == T002.SPRAS
Material Group
  • Material Group
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.MATERIALGROUP == T023.MATKL
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T023.MANDT
Unit for lead-time offset for operation
  • Client
  • Unit for lead-time offset for operation
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T006.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.OPSLEADTIMEOFFSETUNIT == T006.MSEHI
Issue Location for Production Order
  • ?
  • Issue Location for Production Order
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.[column in domain "WERKS_D"] == T001L.WERKS
  • R_MAINTBILLOFMATERIALITEMTP.PRODORDERISSUELOCATION == T001L.LGORT
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T001L.MANDT
Production Supply Area
  • ?
  • Production Supply Area
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.[column in domain "WERKS_D"] == PVBE.WERKS
  • R_MAINTBILLOFMATERIALITEMTP.PRODUCTIONSUPPLYAREA == PVBE.PRVBE
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == PVBE.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.PURCHASINGGROUP == T024.EKGRP
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.PURCHASINGORGANIZATION == T024E.EKORG
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T024E.MANDT
Reference point for BOM transfer
  • Client
  • Reference point for BOM transfer
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == TCNRFP.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.REFERENCEPOINT == TCNRFP.RFPNT
Resulting item category
  • Resulting item category
  • Client
  • R_MAINTBILLOFMATERIALITEMTP.RESULTINGITEMCATEGORY == T418.POSTP
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T418.MANDT
Unit of measure for sizes 1 to 3
  • Client
  • Unit of measure for sizes 1 to 3
  • R_MAINTBILLOFMATERIALITEMTP.MANDT == T006.MANDT
  • R_MAINTBILLOFMATERIALITEMTP.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI