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