HRP1520

DB Table for Infotype 1520 | #masterdata | Component: Budget Management
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
💲 Currency Key (CURCY):
BUDIN Input Amount
BUDIN2 Total input amount
💲 Currency Key (TCURCY):
TOTAL Total allocation amount
💲 Currency Key (ADD_CURCY):
ADD_TOTAL Budget Change
ADD_TOTAL_ROLL Budget Change
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
AEDTM Changed on
Column Name Description
ADD_ROLL "Summarize Your Own Changes" Flag Show values
CHANGES_BY_UPDATES General Flag 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
AMNT Number PMAMNT
DYAVG Number of Hours per Day STDAZ
WKAVG Number of Hours per Week STDAZ
MOAVG Number of hours per month STDAZ
YRAVG Number of Hours per Year JRSTD
AKTE Record Number TEXT15
KOMM Reason TEXT40
AMNT2 Number PMAMNT
TAVG Total working hours (daily) DEC11
ADD_AMNT Budget Change ADD_AMNT
ADD_AMNT_ROLL Budget Change ADD_AMNT
BDNUM Number of Budgeted Awards ECM_STKNO
Master Data Relations Join Conditions
Budget Unit
  • Budget Unit
  • ?
  • Client
  • HRP1520.BUGRU == T7PM4.BUGRU
  • HRP1520.[column in domain "BUTGR"] == T7PM4.BUTGR
  • HRP1520.MANDT == T7PM4.MANDT
Currency Key
  • HRP1520.MANDT == TCURC.MANDT
  • HRP1520.CURCY == TCURC.WAERS
Time base
  • HRP1520.MANDT == T7PMI.MANDT
  • HRP1520.FREQU == T7PMI.FREQUENCY
Infotype
  • HRP1520.MANDT == T778T.MANDT
  • HRP1520.INFTY == T778T.INFTY
Planning Status
  • HRP1520.MANDT == T778S.MANDT
  • HRP1520.ISTAT == T778S.ISTAT
Client HRP1520.MANDT == T000.MANDT
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1520.OTYPE == PLOGI.OTYPE
  • HRP1520.PLVAR == PLOGI.PLVAR
  • HRP1520.MANDT == PLOGI.MANDT
  • HRP1520.OBJID == PLOGI.OBJID
Object Type
  • HRP1520.MANDT == T778O.MANDT
  • HRP1520.OTYPE == T778O.OTYPE
Plan Version
  • HRP1520.MANDT == T778P.MANDT
  • HRP1520.PLVAR == T778P.PLVAR
Stock Unit
  • Stock Unit
  • Client
Subtype
  • Subtype
  • Client
  • Infotype
  • HRP1520.SUBTY == T778U.SUBTY
  • HRP1520.MANDT == T778U.MANDT
  • HRP1520.INFTY == T778U.INFTY
Currency Key
  • HRP1520.MANDT == TCURC.MANDT
  • HRP1520.TCURCY == TCURC.WAERS