T7UNPF_HR_STAFF

Staff Member Table | #transactional | Component: Non Profit Organizations
Column Name Description
MANDT FK Client
PERNR FK Personnel Number
SEQNR Number of Infotype Record With Same Key
UNIQUE_ID Org Global Unique ID
OPRHD Unique ID
Column Name Description
Column Name Description
Column Name Description
CRDAT Creation Date
CRTIM Created At
AEDAT Last Changed On
AETIM Time of last change
EXEC_DATE Execution Date
Column Name Description
GENDER Gender Show values
LANGUAGE Language Show values
OPERATION Operation Show values
STATUS Status Show values
Column Name Description Domain name
FIRST_NAME First name. Left justified. CHAR40
MID_NAME Middle Name PAD_VORNM
LAST_NAME Last name. Left justified. CHAR40
BIRTH_DATE Date of birth. DD-MM-YYYY format CHAR10
NATIONALITY Country of nationality PUN_NATIONALITY_CD
BIRTH_COUNTRY Country of Birth PUN_NATIONALITY_CD
MAR_STATUS Marital Status PUN_MARITAL_STAT
STAFF_ORG Organization Code PUN_UNORG_CD
INDEX_NUM Identification Number CHAR30
FORMER_PEN_NUM Former participant Pension Number NUMC6
LASTUPDATED Last Updated time TZNTSTMPS
CRNAM Created By USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Client T7UNPF_HR_STAFF.MANDT == T000.MANDT
Personnel Number
  • Personnel Number
  • Client
  • T7UNPF_HR_STAFF.PERNR == PA0003.PERNR
  • T7UNPF_HR_STAFF.MANDT == PA0003.MANDT