I_EquipmentHierarchyNode

Equipment Hierarchy Nodes | view: IEQUIHIERNODE | HIER | Extraction: Full or Incremental | Component: Equipment
Tables used: EQUZ
Column Name Description
HierarchyNode FK Equipment Number
EquipUsagePeriodSequenceNumber Consecutive numbering of EquipUsagePeriods on same day
ValidityEndDate Valid To Date
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Valid To Date
ValidityStartDate Valid-From Date
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Equipment Number
  • Client
  • Equipment Number
  • Equipment Number
  • I_EQUIPMENTHIERARCHYNODE.MANDT == EQUI.MANDT
  • I_EQUIPMENTHIERARCHYNODE.EQUIPMENT == EQUI.EQUNR
  • I_EQUIPMENTHIERARCHYNODE.HIERARCHYNODE == EQUI.EQUNR
Equipment Number
  • Client
  • Equipment Number
  • Equipment Number
  • I_EQUIPMENTHIERARCHYNODE.MANDT == EQUI.MANDT
  • I_EQUIPMENTHIERARCHYNODE.EQUIPMENT == EQUI.EQUNR
  • I_EQUIPMENTHIERARCHYNODE.HIERARCHYNODE == EQUI.EQUNR
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • I_EQUIPMENTHIERARCHYNODE.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
  • I_EQUIPMENTHIERARCHYNODE.MANDT == EQUI.MANDT