HRP1933

DB Table for Infotype 1933 | #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
QUAL_CHECK UCAS: Qualification Check 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
ADDRESS_LINE1 UCAS: Address Line PIQ_GB_UCAS_ADDR_LINE
ADDRESS_LINE2 UCAS: Address Line PIQ_GB_UCAS_ADDR_LINE
ADDRESS_LINE3 UCAS: Address Line PIQ_GB_UCAS_ADDR_LINE
ADDRESS_LINE4 UCAS: Address Line PIQ_GB_UCAS_ADDR_LINE
DFE_NUMBER UCAS: DFE number CHAR7
FAX UCAS: Referee's Fax Number PIQ_GB_UCAS_FAX
FULLTIME_COUNT UCAS: Full time Students Count at School PIQ_GB_UCAS_FULLTIME_COUNT
HIGHR_EDUC_COUNT UCAS: Higher Education Students PIQ_GB_UCAS_HIGHER_EDUC_COUNT
REFEREE_NAME UCAS: Referee Name PIQ_GB_UCAS_REFEREENAME
POSITION_HELD UCAS: Position held by Referee PIQ_GB_UCAS_POSITION_HELD
POSTALCODE UCAS: Referee's Postcode PIQ_GB_UCAS_POSTCODE
ROLL_COUNT UCAS: Total Number of Students at School
SCHOOL_TYPE UCAS: Reference School Type CHAR50
TELEPHONE UCAS: Telephone Number
Master Data Relations Join Conditions
Infotype
  • HRP1933.MANDT == T778T.MANDT
  • HRP1933.INFTY == T778T.INFTY
Planning Status
  • HRP1933.MANDT == T778S.MANDT
  • HRP1933.ISTAT == T778S.ISTAT
Client HRP1933.MANDT == T000.MANDT
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1933.OTYPE == PLOGI.OTYPE
  • HRP1933.PLVAR == PLOGI.PLVAR
  • HRP1933.MANDT == PLOGI.MANDT
  • HRP1933.OBJID == PLOGI.OBJID
Object Type
  • HRP1933.MANDT == T778O.MANDT
  • HRP1933.OTYPE == T778O.OTYPE
Plan Version
  • HRP1933.MANDT == T778P.MANDT
  • HRP1933.PLVAR == T778P.PLVAR