HRP1711

DB Table for Infotype 1711 | #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
PASS_ISSUEDATE UCAS: Passport Issue Date
PASS_EXPIRYDATE UCAS: Passport Expiry Date
DATE_ENTERED_UK Date of Admission to United Kingdom
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
PASSN Passport Number PIQPASSN
PASS_ISSUEPLACE UCAS: Passport Place of Issue CHAR30
Master Data Relations Join Conditions
Infotype
  • HRP1711.MANDT == T778T.MANDT
  • HRP1711.INFTY == T778T.INFTY
Planning Status
  • HRP1711.MANDT == T778S.MANDT
  • HRP1711.ISTAT == T778S.ISTAT
Client HRP1711.MANDT == T000.MANDT
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1711.OTYPE == PLOGI.OTYPE
  • HRP1711.PLVAR == PLOGI.PLVAR
  • HRP1711.MANDT == PLOGI.MANDT
  • HRP1711.OBJID == PLOGI.OBJID
Origin
Object Type
  • HRP1711.MANDT == T778O.MANDT
  • HRP1711.OTYPE == T778O.OTYPE
Plan Version
  • HRP1711.MANDT == T778P.MANDT
  • HRP1711.PLVAR == T778P.PLVAR
Resident County
  • Resident County
  • Resident Country/Region
  • Resident State
  • HRP1711.MANDT == T005E.MANDT
  • HRP1711.RESID_COUNC == T005E.COUNC
  • HRP1711.RESID_COUNTRY == T005E.LAND1
  • HRP1711.RESID_REGIO == T005E.REGIO
Resident Country/Region
  • Resident Country/Region
  • Client
  • HRP1711.RESID_COUNTRY == T005.LAND1
  • HRP1711.MANDT == T005.MANDT
Resident State
  • Resident Country/Region
  • Resident State
  • HRP1711.MANDT == T005S.MANDT
  • HRP1711.RESID_COUNTRY == T005S.LAND1
  • HRP1711.RESID_REGIO == T005S.BLAND
Resident Status
  • Resident Status
  • Client
  • ?
  • HRP1711.RESID_STATUS == T505U.RESIS
  • HRP1711.MANDT == T505U.MANDT
  • HRP1711.[column in domain "MOLGA"] == T505U.MOLGA