HRP1786

DB Table for Infotype 1786 | #masterdata | Component: United Kingdom
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
Column Name Description
REFSTATUS CM: UCAS Referral Status Show values
ENTRY_MONTH UCAS: Entry month Show values
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
ENTRY_YEAR UCAS: Entry year JAHR
Master Data Relations Join Conditions
UCAS: Point of Entry
Foreign Key: Infotype
  • HRP1786.MANDT == T778T.MANDT
  • HRP1786.INFTY == T778T.INFTY
Foreign Key: Status
  • HRP1786.MANDT == T778S.MANDT
  • HRP1786.ISTAT == T778S.ISTAT
Foreign Key: Client HRP1786.MANDT == T000.MANDT
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1786.OTYPE == PLOGI.OTYPE
  • HRP1786.PLVAR == PLOGI.PLVAR
  • HRP1786.MANDT == PLOGI.MANDT
  • HRP1786.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1786.MANDT == T778O.MANDT
  • HRP1786.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1786.MANDT == T778P.MANDT
  • HRP1786.PLVAR == T778P.PLVAR
Reference Number to Table Part