HRBENUS_D_PERSON

Affordable Care Act - Person Information | #transactional | Component: Benefit Integration
Column Name Description
MANDT FK Client
APPL FK Subapplication
RUNID FK Numeric ID Key for ACA Database Record
ALERP FK Tax company
PERNR Personnel Number
SUBTY Type of Family Record
OBJPS Object Identification
Column Name Description
Column Name Description
Column Name Description
GENDA Generation Date
GENTM Generation Time
GBDAT Date of Birth
Column Name Description
STATS Status of Database Record Show values
RESTY Result Type Show values
Column Name Description Domain name
CNAME Complete Name TEXT80
STRAS Street and House Number PAD_STRAS
LOCAT 2nd address line PAD_LOCAT
ORT01 City PAD_ORT01
PSTLZ Postal Code PSTLZ
PERID Personnel ID Number CHAR20
FIRST_NAME First Name PAD_VORNM
MIDDLE_NAME Middle Name PAD_VORNM
LAST_NAME Last Name PAD_NACHN
SUFFIX_NAME Other Title TITEL
Master Data Relations Join Conditions
txcmp
  • Tax company
  • Client
  • HRBENUS_D_PERSON.ALERP == T5UTL.TXCMP
  • HRBENUS_D_PERSON.MANDT == T5UTL.MANDT
Subapplication
  • Subapplication
  • Client
  • ?
  • HRBENUS_D_PERSON.APPL == T596A.APPL
  • HRBENUS_D_PERSON.MANDT == T596A.MANDT
  • HRBENUS_D_PERSON.[column in domain "MOLGA"] == T596A.MOLGA
Country/Region Key
  • Country/Region Key
  • Client
  • HRBENUS_D_PERSON.LAND1 == T005.LAND1
  • HRBENUS_D_PERSON.MANDT == T005.MANDT
Mandt HRBENUS_D_PERSON.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • HRBENUS_D_PERSON.MANDT == T005S.MANDT
  • HRBENUS_D_PERSON.LAND1 == T005S.LAND1
  • HRBENUS_D_PERSON.STATE == T005S.BLAND