HRP1691

DB Table for Infotype 1691 | #masterdata | Component: France
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
LANGU FK Language Key
FILLER Dummy Function With Length 9
SEQNR Number of Infotype Record With Same Key
Column Name Description
💲 Currency Key (WAERS):
PRICE Proposed amount
💲 Currency Key (WAERS001):
PRICE001 Proposed amount
💲 Currency Key (WAERS002):
PRICE002 Proposed amount
💲 Currency Key (WAERS003):
PRICE003 Proposed amount
💲 Currency Key (WAERS004):
PRICE004 Proposed amount
💲 Currency Key (WAERS005):
PRICE005 Proposed amount
💲 Currency Key (WAERS006):
PRICE006 Proposed amount
💲 Currency Key (WAERS007):
PRICE007 Proposed amount
💲 Currency Key (WAERS008):
PRICE008 Proposed amount
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
AEDTM Changed on
Column Name Description
TRTYP Trainer Object Type Show values
PRDIR Direct entry of price Show values
BUNIT Reference unit Show values
PRDIR001 Direct entry of price Show values
BUNIT001 Reference unit Show values
PRDIR002 Direct entry of price Show values
BUNIT002 Reference unit Show values
PRDIR003 Direct entry of price Show values
BUNIT003 Reference unit Show values
PRDIR004 Direct entry of price Show values
BUNIT004 Reference unit Show values
PRDIR005 Direct entry of price Show values
BUNIT005 Reference unit Show values
PRDIR006 Direct entry of price Show values
BUNIT006 Reference unit Show values
PRDIR007 Direct entry of price Show values
BUNIT007 Reference unit Show values
PRDIR008 Direct entry of price Show values
BUNIT008 Reference unit 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
TROBJ Trainer Object ID HROBJID
PERNR001 Personnel Number PERSNO
PERNR002 Personnel Number PERSNO
Master Data Relations | to Other Relations ↓ Join Conditions
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME001 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME002 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME003 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME004 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME005 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME006 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME007 == T006.MSEHI
Time Unit
  • HRP1691.MANDT == T006.MANDT
  • HRP1691.BZGME008 == T006.MSEHI
Foreign Key: Infotype
  • HRP1691.MANDT == T778T.MANDT
  • HRP1691.INFTY == T778T.INFTY
Foreign Key: Status
  • HRP1691.MANDT == T778S.MANDT
  • HRP1691.ISTAT == T778S.ISTAT
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES001 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES002 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES003 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES004 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES005 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES006 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES007 == T77KB.KOBES
Cost item
  • ?
  • Cost item
  • HRP1691.MANDT == T77KB.MANDT
  • HRP1691.[column in domain "ENDDATUM"] == T77KB.ENDDA
  • HRP1691.KOBES008 == T77KB.KOBES
Language Key HRP1691.LANGU == T002.SPRAS
Foreign Key: Client HRP1691.MANDT == T000.MANDT
HCM Localization HRP1691.MOLGA == T500L.MOLGA
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1691.OTYPE == PLOGI.OTYPE
  • HRP1691.PLVAR == PLOGI.PLVAR
  • HRP1691.MANDT == PLOGI.MANDT
  • HRP1691.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1691.MANDT == T778O.MANDT
  • HRP1691.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1691.MANDT == T778P.MANDT
  • HRP1691.PLVAR == T778P.PLVAR
Reference Number to Table Part
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS001 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS002 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS003 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS004 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS005 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS006 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS007 == TCURC.WAERS
Currency Key
  • HRP1691.MANDT == TCURC.MANDT
  • HRP1691.WAERS008 == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • Personnel Area
  • HRP1691.MANDT == T001P.MANDT
  • HRP1691.BTRTL001 == T001P.BTRTL
  • HRP1691.WERKS001 == T001P.WERKS
Personnel Subarea
  • Personnel Subarea
  • Personnel Area
  • HRP1691.MANDT == T001P.MANDT
  • HRP1691.BTRTL002 == T001P.BTRTL
  • HRP1691.WERKS002 == T001P.WERKS
Personnel Area
  • HRP1691.MANDT == T500P.MANDT
  • HRP1691.WERKS001 == T500P.PERSA
Personnel Area
  • HRP1691.MANDT == T500P.MANDT
  • HRP1691.WERKS002 == T500P.PERSA