I_EquipmentData

Equipment Data | view: IEQUIPMENTATTR | ATTR | Extraction: Full only | Component: Equipment
Tables used: JSTO, JEST, EQUI, EQUZ, EAML_D_LFE_DATA, ILOA, PRPS, CRHD
Column Name Description
Equipment FK Equipment Number
ValidityEndDate Valid To Date
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Unit of weight (GrossWeightUnit):
GrossWeight Weight of object
📏 Unit of Measurement for Linear Data (LinearDataUnitOfMeasure):
LinearDataLength null
Column Name Description
ValidityEndDate Valid To Date
OperationStartDate Start-up Date of the Technical Object
CreationDate Date on which the record was created
ValidityStartDate Valid-From Date
ValidityEndTime Equipment usage period time stamp
AcquisitionDate Acquisition date
Column Name Description
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
ConstructionMonth Month of construction Show values
Column Name Description Domain name
EquipUsagePeriodSequenceNumber Consecutive numbering of EquipUsagePeriods on same day NUM03
InventoryNumber Inventory number INVNR_ANLA
AssetRoom Room CHAR8
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
MainWorkCenter Main work center for maintenance tasks ARBPL
WorkCenter Work Center ARBPL
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
EquipmentIsMarkedForDeletion Object is deleted CHAR1
NextEquipUsagePeriodSqncNmbr Number of next EquipUsagePeriod on same day NUM03
TechnicalObjectSortCode Technical identification number TIDNR
ManufacturerPartNmbr Manufacturer part number MAPAR
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
MaintObjectInternalID Object number J_OBJNR
SerialNumber Serial Number GERNR
SizeOrDimensionText Size/dimension GROES
MaintObjectFreeDefinedAttrib Sort Field CHAR30
LinearDataStartPoint Start Point EAML_POINT
LinearDataEndPoint End Point EAML_POINT
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • I_EQUIPMENTDATA.ABCINDICATOR == T370C.ABCKZ
  • I_EQUIPMENTDATA.MANDT == T370C.MANDT
Address Number
  • Address Number
  • ?
  • ?
  • Client
  • I_EQUIPMENTDATA.ADDRESSID == ADRC.ADDRNUMBER
  • I_EQUIPMENTDATA.[column in domain "AD_NATION"] == ADRC.NATION
  • I_EQUIPMENTDATA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_EQUIPMENTDATA.MANDT == ADRC.CLIENT
Location of maintenance object
  • Location of maintenance object
  • Maintenance Plant
  • Client
  • I_EQUIPMENTDATA.ASSETLOCATION == T499S.STAND
  • I_EQUIPMENTDATA.MAINTENANCEPLANT == T499S.WERKS
  • I_EQUIPMENTDATA.MANDT == T499S.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_EQUIPMENTDATA.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_EQUIPMENTDATA.MANDT == T370B.MANDT
Batch Number
  • Batch Number
  • Client
  • Material Number
  • I_EQUIPMENTDATA.BATCH == MCH1.CHARG
  • I_EQUIPMENTDATA.MANDT == MCH1.MANDT
  • I_EQUIPMENTDATA.MATERIAL == MCH1.MATNR
Business Area
  • Business Area
  • Client
  • I_EQUIPMENTDATA.BUSINESSAREA == TGSB.GSBER
  • I_EQUIPMENTDATA.MANDT == TGSB.MANDT
Catalog Profile
  • Client
  • Catalog Profile
  • I_EQUIPMENTDATA.MANDT == T352B.MANDT
  • I_EQUIPMENTDATA.CATALOGPROFILE == T352B.RBNR
Company Code
  • Company Code
  • Client
  • I_EQUIPMENTDATA.COMPANYCODE == T001.BUKRS
  • I_EQUIPMENTDATA.MANDT == T001.MANDT
Construction type material of the object
  • Construction type material of the object
  • Client
  • I_EQUIPMENTDATA.CONSTRUCTIONMATERIAL == MARA.MATNR
  • I_EQUIPMENTDATA.MANDT == MARA.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_EQUIPMENTDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_EQUIPMENTDATA.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • I_EQUIPMENTDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_EQUIPMENTDATA.COSTCENTER == CSKS.KOSTL
  • I_EQUIPMENTDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_EQUIPMENTDATA.MANDT == CSKS.MANDT
Currency Key
  • Currency Key
  • Client
  • I_EQUIPMENTDATA.CURRENCY == TCURC.WAERS
  • I_EQUIPMENTDATA.MANDT == TCURC.MANDT
Customer to Whom Serial Number was Delivered
  • Customer to Whom Serial Number was Delivered
  • Client
  • I_EQUIPMENTDATA.CUSTOMER == KNA1.KUNNR
  • I_EQUIPMENTDATA.MANDT == KNA1.MANDT
Division
  • Division
  • Client
  • I_EQUIPMENTDATA.DIVISION == TSPA.SPART
  • I_EQUIPMENTDATA.MANDT == TSPA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_EQUIPMENTDATA.EQUIPMENT == EQUI.EQUNR
  • I_EQUIPMENTDATA.MANDT == EQUI.MANDT
Equipment category
  • Equipment category
  • Client
  • I_EQUIPMENTDATA.EQUIPMENTCATEGORY == T370T.EQTYP
  • I_EQUIPMENTDATA.MANDT == T370T.MANDT
Asset Subnumber
  • Company Code
  • Asset Subnumber
  • Main Asset Number
  • Client
  • I_EQUIPMENTDATA.COMPANYCODE == ANLA.BUKRS
  • I_EQUIPMENTDATA.FIXEDASSET == ANLA.ANLN2
  • I_EQUIPMENTDATA.MASTERFIXEDASSET == ANLA.ANLN1
  • I_EQUIPMENTDATA.MANDT == ANLA.MANDT
Functional Location
  • Functional Location
  • Client
  • I_EQUIPMENTDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_EQUIPMENTDATA.MANDT == IFLOT.MANDT
Unit of weight
  • Unit of weight
  • Client
  • I_EQUIPMENTDATA.GROSSWEIGHTUNIT == T006.MSEHI
  • I_EQUIPMENTDATA.MANDT == T006.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • I_EQUIPMENTDATA.MAINTENANCEPLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_EQUIPMENTDATA.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_EQUIPMENTDATA.MANDT == ILOA.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • I_EQUIPMENTDATA.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_EQUIPMENTDATA.WORKCENTERTYPECODE == CRID.OBJTY
  • I_EQUIPMENTDATA.MANDT == CRID.MANDT
Plant associated with main work center
  • Plant
  • Plant associated with main work center
  • Client
  • I_EQUIPMENTDATA.WORKCENTERPLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MAINWORKCENTERPLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MANDT == T001W.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • I_EQUIPMENTDATA.MANUFACTURERCOUNTRY == T005.LAND1
  • I_EQUIPMENTDATA.MANDT == T005.MANDT
Material Number
  • Client
  • Material Number
  • I_EQUIPMENTDATA.MANDT == MARA.MANDT
  • I_EQUIPMENTDATA.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • I_EQUIPMENTDATA.PLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MANDT == T001W.MANDT
Plant Section
  • Plant Section
  • Maintenance Plant
  • Client
  • I_EQUIPMENTDATA.PLANTSECTION == T357.BEBER
  • I_EQUIPMENTDATA.MAINTENANCEPLANT == T357.WERKS
  • I_EQUIPMENTDATA.MANDT == T357.MANDT
Settlement order
  • Settlement order
  • Client
  • I_EQUIPMENTDATA.SETTLEMENTORDER == AUFK.AUFNR
  • I_EQUIPMENTDATA.MANDT == AUFK.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • I_EQUIPMENTDATA.STORAGELOCATION == T001L.LGORT
  • I_EQUIPMENTDATA.PLANT == T001L.WERKS
  • I_EQUIPMENTDATA.MANDT == T001L.MANDT
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • I_EQUIPMENTDATA.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
  • I_EQUIPMENTDATA.MANDT == EQUI.MANDT
Vendor number
  • Vendor number
  • Client
  • I_EQUIPMENTDATA.SUPPLIER == LFA1.LIFNR
  • I_EQUIPMENTDATA.MANDT == LFA1.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_EQUIPMENTDATA.TECHNICALOBJECTTYPE == T370K.EQART
  • I_EQUIPMENTDATA.MANDT == T370K.MANDT
Object ID of PP work center
  • Object ID of PP work center
  • ?
  • Client
  • I_EQUIPMENTDATA.WORKCENTERINTERNALID == CRID.OBJID
  • I_EQUIPMENTDATA.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_EQUIPMENTDATA.MANDT == CRID.MANDT
Plant
  • Plant
  • Plant associated with main work center
  • Client
  • I_EQUIPMENTDATA.WORKCENTERPLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MAINWORKCENTERPLANT == T001W.WERKS
  • I_EQUIPMENTDATA.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • I_EQUIPMENTDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_EQUIPMENTDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_EQUIPMENTDATA.MANDT == T024I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Client
  • I_EQUIPMENTDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_EQUIPMENTDATA.MANDT == T399I.MANDT