P_EquipmentSearch

Equipment Anchor View for CDS Search Model | view: PEQUISEARCH | Extraction: Not supported | Component: Plant Maintenance
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
Column Name Description
ConstructionMonth Month of construction Show values
AssetSynchronizationRule Change Equipment Master when Changing Asset Show values
HasEquipmentData Equipment data exists 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 Equipment Number EQUNR
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
  • Client
  • Technical Object Authorization Group
  • P_EQUIPMENTSEARCH.MANDT == T370B.MANDT
  • P_EQUIPMENTSEARCH.AUTHORIZATIONGROUP == T370B.BEGRU
Batch Number
  • Batch Number
  • Client
  • Material Number
  • P_EQUIPMENTSEARCH.BATCH == MCH1.CHARG
  • P_EQUIPMENTSEARCH.MANDT == MCH1.MANDT
  • P_EQUIPMENTSEARCH.MATERIAL == MCH1.MATNR
Currency Key
  • Currency Key
  • Client
  • P_EQUIPMENTSEARCH.CURRENCY == TCURC.WAERS
  • P_EQUIPMENTSEARCH.MANDT == TCURC.MANDT
Customer to Whom Serial Number was Delivered
  • Client
  • Customer to Whom Serial Number was Delivered
  • P_EQUIPMENTSEARCH.MANDT == KNA1.MANDT
  • P_EQUIPMENTSEARCH.CUSTOMER == KNA1.KUNNR
Division
  • Client
  • Division
  • P_EQUIPMENTSEARCH.MANDT == TSPA.MANDT
  • P_EQUIPMENTSEARCH.DIVISION == TSPA.SPART
Equipment category
  • Client
  • Equipment category
  • P_EQUIPMENTSEARCH.MANDT == T370T.MANDT
  • P_EQUIPMENTSEARCH.EQUIPMENTCATEGORY == T370T.EQTYP
Unit of weight
  • Unit of weight
  • Client
  • P_EQUIPMENTSEARCH.GROSSWEIGHTUNIT == T006.MSEHI
  • P_EQUIPMENTSEARCH.MANDT == T006.MANDT
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • P_EQUIPMENTSEARCH.MANDT == T005.MANDT
  • P_EQUIPMENTSEARCH.MANUFACTURERCOUNTRY == T005.LAND1
Master warranty number
  • Client
  • Master warranty number
  • P_EQUIPMENTSEARCH.MANDT == BGMK.MANDT
  • P_EQUIPMENTSEARCH.MASTERWARRANTY == BGMK.MGANR
Material Number
  • Client
  • Material Number
  • P_EQUIPMENTSEARCH.MANDT == MARA.MANDT
  • P_EQUIPMENTSEARCH.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • P_EQUIPMENTSEARCH.PLANT == T001W.WERKS
  • P_EQUIPMENTSEARCH.MANDT == T001W.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • P_EQUIPMENTSEARCH.STORAGELOCATION == T001L.LGORT
  • P_EQUIPMENTSEARCH.PLANT == T001L.WERKS
  • P_EQUIPMENTSEARCH.MANDT == T001L.MANDT
Vendor number
  • Vendor number
  • Client
  • P_EQUIPMENTSEARCH.SUPPLIER == LFA1.LIFNR
  • P_EQUIPMENTSEARCH.MANDT == LFA1.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • P_EQUIPMENTSEARCH.TECHNICALOBJECTTYPE == T370K.EQART
  • P_EQUIPMENTSEARCH.MANDT == T370K.MANDT
Foreign Key Check for IUID Type P_EQUIPMENTSEARCH.UNIQUEITEMIDENTIFIERSTRUCTYPE == TIUID_TYPE.IUID_TYPE