HRBENUS_D_REPORT

Affordable Care Act - Reporting ALE 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
ADRTY FK Address Type
Column Name Description
Column Name Description
Column Name Description
Column Name Description
STATS Status of Database Record Show values
RESTY Result Type Show values
Column Name Description Domain name
ALENM Description TEXT40
CNAME Complete Name TEXT80
CPHON Addresses: telephone no. TEXT30
STRAS Street and House Number PAD_STRAS
LOCAT 2nd address line PAD_LOCAT
ORT01 City PAD_ORT01
PSTLZ Postal Code PSTLZ
EINUM Employer Identification number EIDNO
FRMCT Counter HRPAYUS_COUNT
Master Data Relations Join Conditions
Address Type
  • Address Type
  • Client
  • ?
  • HRBENUS_D_REPORT.ADRTY == T536D.ANART
  • HRBENUS_D_REPORT.MANDT == T536D.MANDT
  • HRBENUS_D_REPORT.[column in domain "MOLGA"] == T536D.MOLGA
txcmp
  • Tax company
  • Client
  • HRBENUS_D_REPORT.ALERP == T5UTL.TXCMP
  • HRBENUS_D_REPORT.MANDT == T5UTL.MANDT
Subapplication
  • Subapplication
  • Client
  • ?
  • HRBENUS_D_REPORT.APPL == T596A.APPL
  • HRBENUS_D_REPORT.MANDT == T596A.MANDT
  • HRBENUS_D_REPORT.[column in domain "MOLGA"] == T596A.MOLGA
Country/Region Key
  • Country/Region Key
  • Client
  • HRBENUS_D_REPORT.LAND1 == T005.LAND1
  • HRBENUS_D_REPORT.MANDT == T005.MANDT
Mandt HRBENUS_D_REPORT.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • HRBENUS_D_REPORT.MANDT == T005S.MANDT
  • HRBENUS_D_REPORT.LAND1 == T005S.LAND1
  • HRBENUS_D_REPORT.STATE == T005S.BLAND