I_Equipment

Equipment | view: IEQUIPMENT | ATTR | Extraction: Not supported | Component: Equipment
Tables used: EQUI, EQUZ
Column Name Description
Equipment Equipment Number
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Unit of weight (GrossWeightUnit):
GrossWeight Weight of object
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
AcquisitionDate Acquisition date
OperationStartDate Start-up Date of the Technical Object
EquipmentFirstDeliveryDate First delivery date of the equipment
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
Column Name Description
ConstructionMonth Month of construction Show values
AssetSynchronizationRule Change Equipment Master when Changing Asset Show values
HasEquipmentData Equipment data exists Show values
EquipmentHasStockInformation Indicator: Stock Information Available Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
MaintObjectInternalID Object number J_OBJNR
SerialNumber Serial Number GERNR
EquipUsagePeriodSequenceNumber Consecutive numbering of EquipUsagePeriods on same day NUM03
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
UniqueItemIdentifierRespPlant Plant Responsible for UII WERKS
InventoryNumber Inventory number INVNR_ANLA
SizeOrDimensionText Size/dimension GROES
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_EQUIPMENT.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_EQUIPMENT.MANDT == T370B.MANDT
Batch Number
  • Client
  • Batch Number
  • Material Number
  • I_EQUIPMENT.MANDT == MCH1.MANDT
  • I_EQUIPMENT.BATCH == MCH1.CHARG
  • I_EQUIPMENT.MATERIAL == MCH1.MATNR
Currency Key
  • Client
  • Currency Key
  • I_EQUIPMENT.MANDT == TCURC.MANDT
  • I_EQUIPMENT.CURRENCY == TCURC.WAERS
Customer to Whom Serial Number was Delivered
  • Client
  • Customer to Whom Serial Number was Delivered
  • I_EQUIPMENT.MANDT == KNA1.MANDT
  • I_EQUIPMENT.CUSTOMER == KNA1.KUNNR
Division
  • Division
  • Client
  • I_EQUIPMENT.DIVISION == TSPA.SPART
  • I_EQUIPMENT.MANDT == TSPA.MANDT
Equipment category
  • Equipment category
  • Client
  • I_EQUIPMENT.EQUIPMENTCATEGORY == T370T.EQTYP
  • I_EQUIPMENT.MANDT == T370T.MANDT
Unit of weight
  • Unit of weight
  • Client
  • I_EQUIPMENT.GROSSWEIGHTUNIT == T006.MSEHI
  • I_EQUIPMENT.MANDT == T006.MANDT
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • I_EQUIPMENT.MANUFACTURERCOUNTRY == T005.LAND1
  • I_EQUIPMENT.MANDT == T005.MANDT
Master warranty number
  • Master warranty number
  • Client
  • I_EQUIPMENT.MASTERWARRANTY == BGMK.MGANR
  • I_EQUIPMENT.MANDT == BGMK.MANDT
Material Number
  • Client
  • Material Number
  • I_EQUIPMENT.MANDT == MARA.MANDT
  • I_EQUIPMENT.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_EQUIPMENT.MANDT == T001W.MANDT
  • I_EQUIPMENT.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_EQUIPMENT.STORAGELOCATION == T001L.LGORT
  • I_EQUIPMENT.MANDT == T001L.MANDT
  • I_EQUIPMENT.PLANT == T001L.WERKS
Vendor number
  • Client
  • Vendor number
  • I_EQUIPMENT.MANDT == LFA1.MANDT
  • I_EQUIPMENT.SUPPLIER == LFA1.LIFNR
Type of Technical Object
  • Client
  • Type of Technical Object
  • I_EQUIPMENT.MANDT == T370K.MANDT
  • I_EQUIPMENT.TECHNICALOBJECTTYPE == T370K.EQART
Foreign Key Check for IUID Type I_EQUIPMENT.UNIQUEITEMIDENTIFIERSTRUCTYPE == TIUID_TYPE.IUID_TYPE