HRP1702

DB Table for Infotype 1702 | #masterdata | Component: Administration
Column Name Description
MANDT FK Client
PLVAR FK Plan Version
OTYPE FK Object Type
OBJID FK Object ID
SUBTY FK Subtype
ISTAT FK Planning Status
BEGDA Start Date
ENDDA End Date
VARYF Variation Field for File PLOG
SEQNR Number of Infotype Record With Same Key
Column Name Description
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
AEDTM Changed on
GBDAT Date of Birth
DEATHDATE Date of Death
DREGDATE Date On Which Death Was Recorded
Column Name Description
Column Name Description Domain name
OTJID Concatenation of Object Type and Object ID CHAR10
UNAME User Name CHAR12
REASN Reason CHAR2
HISTO Historical Record Flag CHAR1
ITXNR Text Module for Infotype NUM08
NACHN Last Name PAD_NACHN
VORNA First Name PAD_VORNM
MIDNM Middle Name PAD_VORNM
INITS Initials TEXT10
BIRTHNAME Name at Birth PAD_NACHN
RUFNM Known As PAD_VORNM
GBORT Birthplace PAD_ORT01
PRDNI Identification Number CHAR20
NACHN_MC Last Name (Field for Search Help) CHAR40
VORNA_MC First Name (Search Help Field) CHAR40
BIRTHNAME_MC Name at Birth (Field for Search Help) CHAR40
MIDNM_MC Middle Name (Field for Search Help) CHAR40
Master Data Relations | to Other Relations ↓ Join Conditions
Form-of-Address Key
  • HRP1702.MANDT == T522G.MANDT
  • HRP1702.ANRED == T522G.ANRED
Region of Birth (State, Province, County)
  • Country/Region of Birth
  • Region of Birth (State, Province, County)
  • HRP1702.MANDT == T005S.MANDT
  • HRP1702.GBLND == T005S.LAND1
  • HRP1702.GBDEP == T005S.BLAND
Country/Region of Birth
  • Country/Region of Birth
  • Client
  • HRP1702.GBLND == T005.LAND1
  • HRP1702.MANDT == T005.MANDT
Nationality (Citizenship) at Birth
  • Nationality (Citizenship) at Birth
  • Client
  • HRP1702.GBNAT == T005.LAND1
  • HRP1702.MANDT == T005.MANDT
Gender key HRP1702.GESCH == TSAD15.GENDER
Infotype
  • HRP1702.MANDT == T778T.MANDT
  • HRP1702.INFTY == T778T.INFTY
Planning Status
  • HRP1702.MANDT == T778S.MANDT
  • HRP1702.ISTAT == T778S.ISTAT
Language of Communication HRP1702.LANGU == T002.SPRAS
Client HRP1702.MANDT == T000.MANDT
Second Nationality (Citizenship)
  • Second Nationality (Citizenship)
  • Client
  • HRP1702.NATI2 == T005.LAND1
  • HRP1702.MANDT == T005.MANDT
Third Nationality (Citizenship)
  • Third Nationality (Citizenship)
  • Client
  • HRP1702.NATI3 == T005.LAND1
  • HRP1702.MANDT == T005.MANDT
Nationality (Citizenship)
  • Nationality (Citizenship)
  • Client
  • HRP1702.NATIO == T005.LAND1
  • HRP1702.MANDT == T005.MANDT
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1702.OTYPE == PLOGI.OTYPE
  • HRP1702.PLVAR == PLOGI.PLVAR
  • HRP1702.MANDT == PLOGI.MANDT
  • HRP1702.OBJID == PLOGI.OBJID
Object Type
  • HRP1702.MANDT == T778O.MANDT
  • HRP1702.OTYPE == T778O.OTYPE
Plan Version
  • HRP1702.MANDT == T778P.MANDT
  • HRP1702.PLVAR == T778P.PLVAR
Other Relations | to Master Data Relations ↑ Join Conditions
Marital Status Key
  • Marital Status Key
  • Language of Communication
  • HRP1702.MANDT == T502T.MANDT
  • HRP1702.FAMST == T502T.FAMST
  • HRP1702.LANGU == T502T.SPRSL
Other Title
  • ?
  • Client
  • Other Title
  • HRP1702.[column in domain "DZSART"] == T535N.ART
  • HRP1702.MANDT == T535N.MANDT
  • HRP1702.NAMZU == T535N.TITEL
Title
  • ?
  • Client
  • Title
  • HRP1702.[column in domain "DZSART"] == T535N.ART
  • HRP1702.MANDT == T535N.MANDT
  • HRP1702.TITEL == T535N.TITEL
Name Prefix
  • ?
  • Client
  • Name Prefix
  • HRP1702.[column in domain "DZSART"] == T535N.ART
  • HRP1702.MANDT == T535N.MANDT
  • HRP1702.VORSW == T535N.TITEL