SAP table HRP1010 (Infotype 1010 DB table)
SAP table HRP1010 has 10 primary key fields being MANDT,PLVAR,OTYPE,OBJID,SUBTY,ISTAT,BEGDA,ENDDA,VARYF,SEQNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
---|---|---|---|---|---|---|---|
MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
PLVAR | Plan Version | CHAR | 2 | 0 | T778P | PLVAR | |
OTYPE | Object Type | CHAR | 2 | 0 | T778O | OTYPE | |
OBJID | Object ID | NUMC | 8 | 0 | PLOGI | HROBJID | |
SUBTY | Subtype | CHAR | 4 | 0 | * | SUBTYP | |
ISTAT | Planning Status | CHAR | 1 | 0 | T778S | ISTAT_D | |
BEGDA | Start Date | DATS | 8 | 0 | BEGDATUM | ||
ENDDA | End Date | DATS | 8 | 0 | ENDDATUM | ||
VARYF | Variation Field for File PLOG | CHAR | 10 | 0 | VARYF | ||
SEQNR | Number of Infotype Record With Same Key | NUMC | 3 | 0 | SEQNR | ||
INFTY | Infotype | CHAR | 4 | 0 | T778T | INFOTYP | |
OTJID | Concatenation of Object Type and Object ID | CHAR | 10 | 0 | OTJID | ||
AEDTM | Changed on | DATS | 8 | 0 | AEDTM | ||
UNAME | User Name | CHAR | 12 | 0 | USRNAME | ||
REASN | Reason | CHAR | 2 | 0 | REASN | ||
HISTO | Historical Record Flag | CHAR | 1 | 0 | HISTO | ||
ITXNR | Text Module for Infotype | NUMC | 8 | 0 | ITXNR | ||
HILFM | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM001 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM002 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM003 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM004 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM005 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM006 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM007 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM008 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM009 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM010 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM011 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM012 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM013 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM014 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM015 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM016 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM017 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM018 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM019 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM020 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM021 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM022 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM023 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM024 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM025 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM026 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM027 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM028 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM029 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM030 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM031 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM032 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM033 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM034 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM035 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM036 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM037 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM038 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM039 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM040 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM041 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM042 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM043 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM044 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM045 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM046 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM047 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM048 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM049 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM050 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM051 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM052 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM053 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM054 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM055 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM056 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM057 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM058 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM059 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM060 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM061 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM062 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM063 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM064 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM065 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM066 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM067 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM068 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM069 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM070 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM071 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM072 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM073 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM074 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM075 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM076 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM077 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM078 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM079 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM080 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM081 | Resources | CHAR | 3 | 0 | T778W | HILFM | |
HILFM082 | Resources | CHAR | 3 | 0 | T778W | HILFM |
HRP1010 foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 HRP1010 | HILFM | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM001 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM001 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM002 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM002 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM003 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM003 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM004 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM004 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM005 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM005 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM006 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM006 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM007 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM007 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM008 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM008 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM009 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM009 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM010 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM010 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM011 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM011 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM012 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM012 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM013 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM013 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM014 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM014 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM015 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM015 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM016 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM016 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM017 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM017 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM018 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM018 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM019 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM019 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM020 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM020 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM021 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM021 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM022 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM022 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM023 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM023 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM024 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM024 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM025 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM025 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM026 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM026 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM027 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM027 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM028 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM028 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM029 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM029 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM030 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM030 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM031 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM031 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM032 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM032 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM033 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM033 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM034 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM034 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM035 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM035 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM036 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM036 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM037 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM037 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM038 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM038 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM039 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM039 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM040 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM040 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM041 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM041 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM042 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM042 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM043 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM043 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM044 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM044 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM045 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM045 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM046 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM046 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM047 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM047 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM048 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM048 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM049 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM049 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM050 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM050 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM051 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM051 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM052 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM052 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM053 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM053 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM054 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM054 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM055 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM055 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM056 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM056 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM057 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM057 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM058 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM058 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM059 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM059 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM060 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM060 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM061 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM061 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM062 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM062 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM063 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM063 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM064 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM064 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM065 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM065 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM066 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM066 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM067 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM067 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM068 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM068 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM069 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM069 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM070 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM070 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM071 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM071 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM072 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM072 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM073 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM073 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM074 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM074 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM075 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM075 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM076 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM076 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM077 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM077 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM078 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM078 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM079 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM079 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM080 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM080 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | HILFM081 | T778W | Authorities/Resources | MANDT |
1 HRP1010 | HILFM081 | T778W | Authorities/Resources | SUBTY |
0 HRP1010 | HILFM082 | T778W | Authorities/Resources | MANDT |
0 HRP1010 | HILFM082 | T778W | Authorities/Resources | SUBTY |
1 HRP1010 | INFTY | T778T | Infotypes | MANDT |
1 HRP1010 | INFTY | T778T | Infotypes | INFTY |
0 HRP1010 | ISTAT | T778S | Planning Status | MANDT |
1 HRP1010 | MANDT | T000 | Clients | MANDT |
0 HRP1010 | OBJID | PLOGI | Table Index HRP* | MANDT |
0 HRP1010 | OBJID | PLOGI | Table Index HRP* | PLVAR |
0 HRP1010 | OBJID | PLOGI | Table Index HRP* | OTYPE |
0 HRP1010 | OBJID | PLOGI | Table Index HRP* | OBJID |
1 HRP1010 | OTYPE | T778O | Object Types | MANDT |
1 HRP1010 | OTYPE | T778O | Object Types | OTYPE |
0 HRP1010 | PLVAR | T778P | Plan Versions | MANDT |