HRP1049

Database Tables for Infotype 1049 | #masterdata | Component: Shift Planning
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
REQMTTYFLAG Mark a requirements record as blank Show values
VARIA Daily Work Schedule Variant Show values
AWTYP Attendance or absence indicator 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
REQMTTY Requirements type for Shift Planning BEDART
ADDWORK ID: Employee can also cover this requirement PROPERTY
TPROG Daily Work Schedule TPROG
AWART Attendance or Absence Type AWART
STNBY Availability Subtype STNBY
ATTTY Attendance type for assigning employee to requirements CHAR4
ATTTYFLAG Inficator that assignment is recorded as absence PROPERTY
Master Data Relations Join Conditions
Foreign Key: Infotype
  • HRP1049.MANDT == T778T.MANDT
  • HRP1049.INFTY == T778T.INFTY
Foreign Key: Status
  • HRP1049.MANDT == T778S.MANDT
  • HRP1049.ISTAT == T778S.ISTAT
Foreign Key: Client HRP1049.MANDT == T000.MANDT
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1049.OTYPE == PLOGI.OTYPE
  • HRP1049.PLVAR == PLOGI.PLVAR
  • HRP1049.MANDT == PLOGI.MANDT
  • HRP1049.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1049.MANDT == T778O.MANDT
  • HRP1049.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1049.MANDT == T778P.MANDT
  • HRP1049.PLVAR == T778P.PLVAR
Reference Number to Table Part