HRP1037

Infotype 1037 DB Table | #masterdata | Component: Training and Event Management
Column Name Description
MANDT FK Client
PLVAR FK Plan Version
OTYPE FK Object Type
OBJID FK Object ID
SUBTY 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
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
Master Data Relations Join Conditions
Infotype
  • HRP1037.MANDT == T778T.MANDT
  • HRP1037.INFTY == T778T.INFTY
Planning Status
  • HRP1037.MANDT == T778S.MANDT
  • HRP1037.ISTAT == T778S.ISTAT
Controlling area for activity type
  • HRP1037.MANDT == TKA01.MANDT
  • HRP1037.KOKRS == TKA01.KOKRS
Account assignment group for material
  • HRP1037.MANDT == TVKM.MANDT
  • HRP1037.KTGRM == TVKM.KTGRM
Foreign key: activity type
  • Controlling Area
  • Activity Type for Business Events
  • ?
  • HRP1037.MANDT == CSLA.MANDT
  • HRP1037.KOKRS == CSLA.KOKRS
  • HRP1037.LSTAR == CSLA.LSTAR
  • HRP1037.[column in domain "DATBI"] == CSLA.DATBI
Client HRP1037.MANDT == T000.MANDT
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1037.OTYPE == PLOGI.OTYPE
  • HRP1037.PLVAR == PLOGI.PLVAR
  • HRP1037.MANDT == PLOGI.MANDT
  • HRP1037.OBJID == PLOGI.OBJID
Object Type
  • HRP1037.MANDT == T778O.MANDT
  • HRP1037.OTYPE == T778O.OTYPE
Plan Version
  • HRP1037.MANDT == T778P.MANDT
  • HRP1037.PLVAR == T778P.PLVAR
Activity type for instructor function
  • Controlling Area
  • Activity type for instructor function
  • ?
  • HRP1037.MANDT == CSLA.MANDT
  • HRP1037.KOKRS == CSLA.KOKRS
  • HRP1037.RLART == CSLA.LSTAR
  • HRP1037.[column in domain "DATBI"] == CSLA.DATBI
Division
  • HRP1037.MANDT == TSPA.MANDT
  • HRP1037.SPART == TSPA.SPART
Sales Organization
  • HRP1037.MANDT == TVKO.MANDT
  • HRP1037.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • HRP1037.VTWEG == TVTW.VTWEG
  • HRP1037.MANDT == TVTW.MANDT