HRP1719

DB Table for Infotype 1719 | #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
📏 Original Type of Total Credits (TOTEXTCREDTYPE):
TOTEXTATMCRED Total Attempted Credits
TOTEXTGRDCRED Total Graded Credits
TOTEXTERNCRED Total Earned Credits
📏 Converted Credit Type (TOTINTCREDTYPE):
TOTINTATMCRED Total Attempted Credits In Internal Credit Type
TOTINTGRDCRED Total Graded Credits In Internal Credit Type
TOTINTERNCRED Total Earned Credits In Internal Credit Type
Column Name Description
BEGDA Start Date
ENDDA End Date
AEDTM Changed on
REGPERIODFROM Start Date of Registration at External Organization
REGPERIODTO End Date of Registration at External Organization
RETURNDATE Date of Eligibility to Return
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
TRANS_GUID GUID - Unique ID of External Transcript SYSUUID_C
ISSEO Issuing External Organization HROBJID
TRANSEO Transmitting External Organization HROBJID
RANKING Rank
SIZEOFCLASS Class Size
TOTSELFGPA Self-Reported Average
TOTSELFGPANORM Self-Reported Average (Standard Value) PIQSCALE_NORM_VAL
TOTEXTGPA1 External Average 1
TOTEXTGPA1NORM External Average 1 (Standard Value) PIQSCALE_NORM_VAL
TOTEXTGPA2 External Average 2
TOTEXTGPA2NORM External Average 2 (Standard Value) PIQSCALE_NORM_VAL
TOTEXTGPA3 External Average 3
TOTEXTGPA3NORM External Average 3 (Standard Value) PIQSCALE_NORM_VAL
CALCGPAMANFLAG Overwrite Calculated Average Manually
TOTCALCGPA Calculated Average
TOTCALCGPANORM Calculated Average (Standard Value) PIQSCALE_NORM_VAL
TOTCREDMANFLAG Overwrite Converted Credits Manually
Master Data Relations Join Conditions
Foreign Key: Infotype
  • HRP1719.MANDT == T778T.MANDT
  • HRP1719.INFTY == T778T.INFTY
Foreign Key: Status
  • HRP1719.MANDT == T778S.MANDT
  • HRP1719.ISTAT == T778S.ISTAT
Foreign key: Client HRP1719.MANDT == T000.MANDT
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1719.OTYPE == PLOGI.OTYPE
  • HRP1719.PLVAR == PLOGI.PLVAR
  • HRP1719.MANDT == PLOGI.MANDT
  • HRP1719.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1719.MANDT == T778O.MANDT
  • HRP1719.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1719.MANDT == T778P.MANDT
  • HRP1719.PLVAR == T778P.PLVAR
Eligibility to Return
  • Eligibility to Return
  • Client
Reference Number to Table Part
Grading Scale for Calculated Average
Original Type of Total Credits
  • HRP1719.MANDT == T7PIQCP.MANDT
  • HRP1719.TOTEXTCREDTYPE == T7PIQCP.CPUNIT
Grading Scale for External Average 1
Grading Scale for External Average 2
Grading Scale for External Average 3
Converted Credit Type
  • HRP1719.MANDT == T7PIQCP.MANDT
  • HRP1719.TOTINTCREDTYPE == T7PIQCP.CPUNIT
Grading Scale for Self-Reported Average
Transcript Status
  • Transcript Status
  • Client