SAP table HRP1201 (Infotype 1201 DB Table)

SAP table HRP1201 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 T778U 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
SWOTP Object Type CHAR 10 0 TOJTB SWO_OBJTYP
SWMTD Method CHAR 32 0 SWO_METHOD
CLSNAM Object Type CHAR 32 0 SWF_CLSNAM
CLSMET Workflow: Method Name CHAR 32 0 SWF_CLSMET
METHTYPE Object Category CHAR 2 0 SWD_CLSTYP
BO BOR Object Type
CL ABAP Class
EO Business Object Type
BACKGROUND Background Processing CHAR 1 0 HR_BACK_TS
CONFIRMTSK Confirm End of Processing CHAR 1 0 HR_CONF_TS
SYNCHRON Synchronous Object Method CHAR 1 0 HR_SYNC_OM
TTYPE General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
GENERATED Indicator: Entry Generated CHAR 1 0 PD_GEN
ACTOR_FLAG General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
TSKRELSTAT Release Status of Task CHAR 1 0 TSKRELSTAT
Not defined
I Implemented
M Modeled
O Obsolete
R Released
PHONE_ABLE SAPphone: Flag 'Suitable for SAPphone' (4 values'ยด) CHAR 1 0 SP_SPHABLE
Not suitable for SAPphone
A Suitable for SAPphone (incoming and outgoing)
I Suitable for SAPphone (incoming)
O Suitable for SAPphone (outgoing)
TCODE Transaction for starting/executing task on WWW CHAR 20 0 TSTC SWUWEBTA
WEB_ABLE Flag: Task can be executed on Internet CHAR 1 0 SWUWWWFL
FORM_ABLE Indicator: Task Executable with SAPforms Form CHAR 1 0 SWUFRMFLAG

HRP1201 foreign key relationships

Table Field Check Table Check Field
0 HRP1201 INFTY T778T Infotypes MANDT
0 HRP1201 INFTY T778T Infotypes INFTY
1 HRP1201 ISTAT T778S Planning Status MANDT
0 HRP1201 MANDT T000 Clients MANDT
1 HRP1201 OBJID PLOGI Table Index HRP* MANDT
1 HRP1201 OBJID PLOGI Table Index HRP* PLVAR
1 HRP1201 OBJID PLOGI Table Index HRP* OTYPE
1 HRP1201 OBJID PLOGI Table Index HRP* OBJID
0 HRP1201 OTYPE T778O Object Types MANDT
0 HRP1201 OTYPE T778O Object Types OTYPE
1 HRP1201 PLVAR T778P Plan Versions MANDT
0 HRP1201 SUBTY T778U Subtypes MANDT
0 HRP1201 SUBTY T778U Subtypes INFTY
0 HRP1201 SUBTY T778U Subtypes SUBTY
1 HRP1201 SWOTP TOJTB Business object repository: Basic data NAME
0 HRP1201 TCODE TSTC SAP Transaction Codes TCODE