T5K0P

Personnel Area/Sub Area (Canada) | #other | Component: Canada
Column Name Description
MANDT FK Client
WERKS FK Personnel Area
BTRTL FK Personnel Subarea
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ORREG Region CHAR3
ORDIS District CHAR3
EINUM Employer identification CHAR11
STCAN STATS Canada number CHAR9
DANDB Dunn & Bradstreet Number CHAR9
WCCLS Workers' compensation class CHAR4
WCRGR Workers' compensation contribution group CHAR4
WCERA Workers' compensation account number CHAR9
WCERF Workers' compensation company number CHAR10
MOBEN Benefits Modifier NUM2
MORET Plan Modifier NUM2
SICNO SIC_code - Standard industry sector code for EECRS only CHAR5
Master Data Relations | to Other Relations ↓ Join Conditions
NAICS codes for Canada
  • ?
  • NAICS codes for Canada
  • Client
  • T5K0P.[column in domain "MOLGA"] == T5KNC.MOLGA
  • T5K0P.KNAICS == T5KNC.NAICS
  • T5K0P.MANDT == T5KNC.MANDT
Client T5K0P.MANDT == T000.MANDT
NAICS codes -> T5UNC
  • NAICS code
  • Client
  • ?
  • T5K0P.NAICS == T5UNC.NAICS
  • T5K0P.MANDT == T5UNC.MANDT
  • T5K0P.[column in domain "MOLGA"] == T5UNC.MOLGA
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel subarea
  • Personnel Subarea
  • Personnel Area
  • T5K0P.MANDT == T001P.MANDT
  • T5K0P.BTRTL == T001P.BTRTL
  • T5K0P.WERKS == T001P.WERKS
Industry sector
  • ?
  • Client
  • Industry sector
  • T5K0P.[column in domain "SPRAS"] == T5K0Q.SPRSL
  • T5K0P.MANDT == T5K0Q.MANDT
  • T5K0P.INDSC == T5K0Q.INDSC
Tax plant section
  • T5K0P.MANDT == T5KTL.MANDT
  • T5K0P.TXCMP == T5KTL.TXCMP
Personnel area
  • Personnel Subarea
  • Personnel Area
  • T5K0P.MANDT == T001P.MANDT
  • T5K0P.BTRTL == T001P.BTRTL
  • T5K0P.WERKS == T001P.WERKS