2LIS_18_I3HDR

Service Orders | #TRAN | Extraction method: F1 | Delta: ABR | Component: Customer Service
Tables used: AFIHQMELVBAPVBAKVBRP ... +188 more
Column Name Description
AUART Order Type
AUFNR FK Order Number
EQUNR FK Equipment Number
SPART Division
TPLNR Functional Location
VKORG Sales Organization
VTWEG Distribution Channel
Column Name Description
Column Name Description
Column Name Description
ERDAT Date on which the record was created
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
Column Name Description Domain name
DLZBRUTTO Order Run-time in Calendar Days (Gross) QSTATWERT
DLZNETTO Order Lead Time/Working Days Acc. to Factory Calendar(Net) QSTATWERT
ZHLAFIH Number of orders INT4
ZHLAFIH_ABGS Number of Closed Orders INT4
ZHLAFIH_GEPL Number of Planned Orders INT4
ZHLAFIH_NDGEF Number of orders not to be run INT4
ZHLAFIH_OFFEN Number of Open Orders INT4
ZHLAFIH_SOF Number of Immediate Orders INT4
ZHLAFIH_TGERL Number of On-time Closed Orders INT4
ZHLAFIH_UNGPL Number of Unscheduled Orders INT4
Master Data Relations | to Other Relations ↓ Join Conditions
Order Number
  • Client
  • Order Number
  • 2LIS_18_I3HDR.MANDT == AUFK.MANDT
  • 2LIS_18_I3HDR.AUFNR == AUFK.AUFNR
Assembly
  • Client
  • Assembly
  • 2LIS_18_I3HDR.MANDT == MARA.MANDT
  • 2LIS_18_I3HDR.BAUTL_HD == MARA.MATNR
Equipment Number
  • Client
  • Equipment Number
  • 2LIS_18_I3HDR.MANDT == EQUI.MANDT
  • 2LIS_18_I3HDR.EQUNR == EQUI.EQUNR
Maintenance activity type
  • Client
  • Maintenance activity type
  • 2LIS_18_I3HDR.MANDT == T353I.MANDT
  • 2LIS_18_I3HDR.ILART == T353I.ILART
Customer Number
  • Client
  • Customer Number
  • 2LIS_18_I3HDR.MANDT == KNA1.MANDT
  • 2LIS_18_I3HDR.KUNUM == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • 2LIS_18_I3HDR.MANDT == T024I.MANDT
  • 2LIS_18_I3HDR.INGRP == T024I.INGRP
  • 2LIS_18_I3HDR.IWERK == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • 2LIS_18_I3HDR.MANDT == T399I.MANDT
  • 2LIS_18_I3HDR.IWERK == T399I.IWERK