1. Home
  2. Resources
  3. SAP Tables
  4. HRP1660 - DB Table for Infotype 1660

SAP Table HRP1660

DB Table for Infotype 1660

HRP1660 (DB Table for Infotype 1660) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link HRP1660 to other SAP tables.

HRP1660 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PLVAR Plan Version PLVAR T778P CHAR 2 0
OTYPE Object Type OTYPE T778O CHAR 2 0
OBJID Object ID HROBJID PLOGI NUMC 8 0
SUBTY Subtype SUBTYP CHAR 4 0
ISTAT Planning Status ISTAT_D T778S CHAR 1 0
BEGDA Start Date BEGDATUM DATS 8 0
ENDDA End Date ENDDATUM DATS 8 0
VARYF Variation Field for File PLOG VARYF CHAR 10 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
INFTY Infotype INFOTYP T778T CHAR 4 0
OTJID Concatenation of Object Type and Object ID OTJID CHAR 10 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name USRNAME CHAR 12 0
REASN Reason REASN CHAR 2 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
CMPAR Competitive Area P10_CMPAR T5UPBSCOMPAR CHAR 4 0
CMPLV Competitive Level P10_CMPLV T5UPBSCMPLV CHAR 4 0
STATE Duty Station State or Country P10_STATE T5UPBSDSSTATE CHAR 2 0
COUNTY Duty Station County P10_CONTY T5UPBSDSCOUNTY CHAR 3 0
CITY Duty Station City P10_CITY T5UPBSDSCITY CHAR 4 0
PSOCC Position Occupied P10_PSOCC CHAR 1 0
1 Competitive service
2 Excepted service
3 SES General
4 SES Career Reserved
PSSEN Position Sensitivity P10_PSSEN CHAR 1 0
0 Not Designated
1 Nonsensitive (NS) National Security Risk
2 Noncritical-Sensitive (NCS) National Security Risk
3 Critical-Sensitive (CS) National Security Risk
4 Special-Sensitive (SS) National Security Risk
5 Moderate Risk (MR) Public Trust Position
6 High Risk (HR) Public Trust Position
SECCL Security Clearance P10_SECCL T5UPBSSECCL CHAR 1 0
FINST Financial Statements Required P10_FINST CHAR 1 0
0 None
1 Executive Personnel Financial Disclosure
2 Employment and Financial Interest
DRGTEST Drug Test Designated Position P10_DRGTEST CHAR 1 0
X Yes
NULL No
FUCLS Functional Classification Code P10P_FUCLS T5UPBSPA09 NUMC 2 0
SUSTS Supervisory Status Code P10P_SUSTS T5UPBSPA10 NUMC 1 0
BARUN Bargaining Unit P10P_BARUN T5UPBSPA13 NUMC 4 0
PEROF Personnel Office Identifier P10P_PEROF T5UPBSPA31 NUMC 4 0

HRP1660 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HRP1660 BARUN SYST MANDT T5UPBSPA13 Bargaining Unit (PS) MANDT
HRP1660 BARUN HRP1660 BARUN T5UPBSPA13 Bargaining Unit (PS) BARUN
HRP1660 CITY SYST MANDT T5UPBSDSCITY US Duty Station Cities MANDT
HRP1660 CITY HRP1660 STATE T5UPBSDSCITY US Duty Station Cities STATE
HRP1660 CITY HRP1660 COUNTY T5UPBSDSCITY US Duty Station Cities CONTY
HRP1660 CITY HRP1660 CITY T5UPBSDSCITY US Duty Station Cities CITY
HRP1660 CMPAR HRP1660 CMPAR T5UPBSCOMPAR US Federal Competitive Areas CMPAR
HRP1660 CMPAR SYST MANDT T5UPBSCOMPAR US Federal Competitive Areas MANDT
HRP1660 CMPLV SYST MANDT T5UPBSCMPLV US Federal Competitive Levels MANDT
HRP1660 CMPLV HRP1660 CMPLV T5UPBSCMPLV US Federal Competitive Levels CMPLV
HRP1660 COUNTY HRP1660 STATE T5UPBSDSCOUNTY US Federal Duty Station Counties STATE
HRP1660 COUNTY HRP1660 COUNTY T5UPBSDSCOUNTY US Federal Duty Station Counties CONTY
HRP1660 COUNTY SYST MANDT T5UPBSDSCOUNTY US Federal Duty Station Counties MANDT
HRP1660 FUCLS HRP1660 FUCLS T5UPBSPA09 Functional Classification (PS) FUCLS
HRP1660 FUCLS SYST MANDT T5UPBSPA09 Functional Classification (PS) MANDT
HRP1660 INFTY HRP1660 INFTY T778T Infotypes INFTY
HRP1660 INFTY HRP1660 MANDT T778T Infotypes MANDT
HRP1660 ISTAT HRP1660 MANDT T778S Planning Status MANDT
HRP1660 ISTAT HRP1660 ISTAT T778S Planning Status ISTAT
HRP1660 MANDT HRP1660 MANDT T000 Clients MANDT
HRP1660 OBJID HRP1660 OBJID PLOGI Table Index HRP* OBJID
HRP1660 OBJID HRP1660 MANDT PLOGI Table Index HRP* MANDT
HRP1660 OBJID HRP1660 PLVAR PLOGI Table Index HRP* PLVAR
HRP1660 OBJID HRP1660 OTYPE PLOGI Table Index HRP* OTYPE
HRP1660 OTYPE HRP1660 MANDT T778O Object Types MANDT
HRP1660 OTYPE HRP1660 OTYPE T778O Object Types OTYPE
HRP1660 PEROF SYST MANDT T5UPBSPA31 Personnel Office Identifier MANDT
HRP1660 PEROF HRP1660 PEROF T5UPBSPA31 Personnel Office Identifier PEROF
HRP1660 PLVAR HRP1660 MANDT T778P Plan Versions MANDT
HRP1660 PLVAR HRP1660 PLVAR T778P Plan Versions PLVAR
HRP1660 SECCL SYST MANDT T5UPBSSECCL US Federal Position Security Clearance MANDT
HRP1660 SECCL HRP1660 SECCL T5UPBSSECCL US Federal Position Security Clearance SECCL
HRP1660 STATE SYST MANDT T5UPBSDSSTATE US Federal Duty Station States MANDT
HRP1660 STATE HRP1660 STATE T5UPBSDSSTATE US Federal Duty Station States STATE
HRP1660 SUSTS SYST MANDT T5UPBSPA10 Supervisory Status (PS) MANDT
HRP1660 SUSTS HRP1660 SUSTS T5UPBSPA10 Supervisory Status (PS) SUSTS