0CS_ORDER_ATTR

Service order | #ATTR | Extraction method: V | Delta: AIE | Component: Customer Service Master Data
Tables used: ILOA, AFIH, AUFK, PMSDO, CRHD → show details
Column Name Description
AUFNR FK Service Order
AUART FK Order Type
EQUNR FK Equipment Number
BAUTL FK Assembly
IWERK FK Maintenance Planning Plant
INGRP FK Planner Group for Customer Service and Plant Maintenance
ARBPL Work Center
WERKS FK Plant
KUNUM FK Customer Number
REVNR FK Revision for Plant Maintenance and Customer Service
ILART FK Maintenance activity type
TPLNR FK Functional Location
ABCKZ FK ABC Indicator for Technical Object
SWERK FK Maintenance Plant
STORT FK Location of maintenance object
MSGRP Room
BEBER FK Plant Section
GSBER FK Business Area
KOKRS FK Controlling Area
KOSTL FK Cost Center
BUKRS FK Company Code
ANLNR FK Main Asset Number
ANLUN FK Asset Subnumber
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
VKGRP FK Sales group
VKBUR FK Sales office
OBJNR FK Object number
ERDAT Created On
AEDAT Change Date for Order Master
QMNUM FK Notification Number
Column Name Description
Column Name Description
Column Name Description
ERDAT Created On
AEDAT Change Date for Order Master
Column Name Description
Column Name Description Domain name
BWSTSYS0 System Status J_STONR
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • 0CS_ORDER_ATTR.MANDT == T370C.MANDT
  • 0CS_ORDER_ATTR.ABCKZ == T370C.ABCKZ
Asset Subnumber
  • Main Asset Number
  • Company Code
  • Asset Subnumber
  • Client
  • 0CS_ORDER_ATTR.ANLNR == ANLA.ANLN1
  • 0CS_ORDER_ATTR.BUKRS == ANLA.BUKRS
  • 0CS_ORDER_ATTR.ANLUN == ANLA.ANLN2
  • 0CS_ORDER_ATTR.MANDT == ANLA.MANDT
Order Type
  • Order Type
  • Client
  • 0CS_ORDER_ATTR.AUART == T003O.AUART
  • 0CS_ORDER_ATTR.MANDT == T003O.CLIENT
Service Order
  • Client
  • Service Order
  • 0CS_ORDER_ATTR.MANDT == AUFK.MANDT
  • 0CS_ORDER_ATTR.AUFNR == AUFK.AUFNR
Assembly
  • Client
  • Assembly
  • 0CS_ORDER_ATTR.MANDT == MARA.MANDT
  • 0CS_ORDER_ATTR.BAUTL == MARA.MATNR
Plant Section
  • Maintenance Plant
  • Client
  • Plant Section
  • 0CS_ORDER_ATTR.SWERK == T357.WERKS
  • 0CS_ORDER_ATTR.MANDT == T357.MANDT
  • 0CS_ORDER_ATTR.BEBER == T357.BEBER
Company Code
  • Company Code
  • Client
  • 0CS_ORDER_ATTR.BUKRS == T001.BUKRS
  • 0CS_ORDER_ATTR.MANDT == T001.MANDT
Equipment Number
  • Client
  • Equipment Number
  • 0CS_ORDER_ATTR.MANDT == EQUI.MANDT
  • 0CS_ORDER_ATTR.EQUNR == EQUI.EQUNR
Business Area
  • Business Area
  • Client
  • 0CS_ORDER_ATTR.GSBER == TGSB.GSBER
  • 0CS_ORDER_ATTR.MANDT == TGSB.MANDT
Maintenance activity type
  • Maintenance activity type
  • Client
  • 0CS_ORDER_ATTR.ILART == T353I.ILART
  • 0CS_ORDER_ATTR.MANDT == T353I.MANDT
Controlling Area
  • Controlling Area
  • Client
  • 0CS_ORDER_ATTR.KOKRS == TKA01.KOKRS
  • 0CS_ORDER_ATTR.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • Client
  • 0CS_ORDER_ATTR.KOKRS == CSKS.KOKRS
  • 0CS_ORDER_ATTR.KOSTL == CSKS.KOSTL
  • 0CS_ORDER_ATTR.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • 0CS_ORDER_ATTR.KUNUM == KNA1.KUNNR
  • 0CS_ORDER_ATTR.MANDT == KNA1.MANDT
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • 0CS_ORDER_ATTR.REVNR == T352R.REVNR
  • 0CS_ORDER_ATTR.IWERK == T352R.IWERK
  • 0CS_ORDER_ATTR.MANDT == T352R.MANDT
Division
  • Division
  • Client
  • 0CS_ORDER_ATTR.SPART == TSPA.SPART
  • 0CS_ORDER_ATTR.MANDT == TSPA.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • 0CS_ORDER_ATTR.SWERK == T499S.WERKS
  • 0CS_ORDER_ATTR.MANDT == T499S.MANDT
  • 0CS_ORDER_ATTR.STORT == T499S.STAND
Maintenance Plant
  • Maintenance Plant
  • Client
  • 0CS_ORDER_ATTR.SWERK == T001W.WERKS
  • 0CS_ORDER_ATTR.MANDT == T001W.MANDT
Functional Location
  • Functional Location
  • Client
  • 0CS_ORDER_ATTR.TPLNR == IFLOT.TPLNR
  • 0CS_ORDER_ATTR.MANDT == IFLOT.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • 0CS_ORDER_ATTR.VKBUR == TVBVK.VKBUR
  • 0CS_ORDER_ATTR.VKGRP == TVBVK.VKGRP
  • 0CS_ORDER_ATTR.MANDT == TVBVK.MANDT
Sales Organization
  • Sales Organization
  • Client
  • 0CS_ORDER_ATTR.VKORG == TVKO.VKORG
  • 0CS_ORDER_ATTR.MANDT == TVKO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • 0CS_ORDER_ATTR.MANDT == TVTW.MANDT
  • 0CS_ORDER_ATTR.VTWEG == TVTW.VTWEG
Plant
  • Plant
  • Client
  • 0CS_ORDER_ATTR.WERKS == T001W.WERKS
  • 0CS_ORDER_ATTR.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • 0CS_ORDER_ATTR.INGRP == T024I.INGRP
  • 0CS_ORDER_ATTR.IWERK == T024I.IWERK
  • 0CS_ORDER_ATTR.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • 0CS_ORDER_ATTR.MANDT == T399I.MANDT
  • 0CS_ORDER_ATTR.IWERK == T399I.IWERK
Sales office
  • Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • 0CS_ORDER_ATTR.VKBUR == TVKBZ.VKBUR
  • 0CS_ORDER_ATTR.SPART == TVKBZ.SPART
  • 0CS_ORDER_ATTR.VTWEG == TVKBZ.VTWEG
  • 0CS_ORDER_ATTR.MANDT == TVKBZ.MANDT
  • 0CS_ORDER_ATTR.VKORG == TVKBZ.VKORG