1. Home
  2. Resources
  3. SAP Tables
  4. P1271 - Infotype 1271: Composite Survey Results

SAP Table P1271

Infotype 1271: Composite Survey Results

P1271 (Infotype 1271: Composite Survey Results) 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 P1271 to other SAP tables.

P1271 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 OBJEKTID NUMC 8 0
INFTY Infotype INFOTYP T778T CHAR 4 0
SUBTY Subtype SUBTYP T778U CHAR 4 0
ISTAT Planning Status ISTAT_D T778S CHAR 1 0
PRIOX Priority PRIOX CHAR 2 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
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
CMPRS Survey Composite Result ECM_CMPRS T71JPR26 CHAR 4 0
STATSTYPE Pay Category ECM_STATSTYPE T71JPR23 CHAR 2 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
FREQU Unit of Time ECM_FREQU NUMC 2 0
01 Monthly
02 Semi-monthly
03 Weekly
04 Bi-weekly
05 Every four weeks
06 Annually
07 Quarterly
08 Half-yearly
AVERAGE Average ECM_AVERAGE CURR 15 2
AVERAGEPCT Average of Salary Expressed as Percentage of Base Salary ECM_AVERAGEPCT DEC 5 2
TARGETPCT Target Bonus Expressed as Percentage of Base Salary ECM_TARGETPCT DEC 5 2
ACTUALPCT Actual Bonus Expressed as Percentage of Base Salary ECM_ACTUALPCT DEC 5 2
PERCENTILE10 10th Percentile (10% of Employees are below value) ECM_PERCENTILE10 CURR 15 2
PERCENTILE25 25th Percentile (25% of Employees are below value) ECM_PERCENTILE25 CURR 15 2
PERCENTILE50 50th Percentile (50% of Employees are below value) ECM_PERCENTILE50 CURR 15 2
PERCENTILE60 60th Percentile (60% of Employees are below value) ECM_PERCENTILE60 CURR 15 2
PERCENTILE75 75th Percentile (75% of Employees are below value) ECM_PERCENTILE75 CURR 15 2
PERCENTILE90 90th Percentile (90% of Employees are below value) ECM_PERCENTILE90 CURR 15 2

P1271 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P1271 CMPRS SYST MANDT T71JPR26 Survey Composite Result MANDT
P1271 CMPRS P1271 CMPRS T71JPR26 Survey Composite Result CMPRS
P1271 CURRENCY SYST MANDT TCURC Currency Codes MANDT
P1271 CURRENCY P1271 CURRENCY TCURC Currency Codes WAERS
P1271 INFTY P1271 MANDT T778T Infotypes MANDT
P1271 INFTY P1271 INFTY T778T Infotypes INFTY
P1271 ISTAT P1271 ISTAT T778S Planning Status ISTAT
P1271 ISTAT P1271 MANDT T778S Planning Status MANDT
P1271 MANDT P1271 MANDT T000 Clients MANDT
P1271 OTYPE P1271 MANDT T778O Object Types MANDT
P1271 OTYPE P1271 OTYPE T778O Object Types OTYPE
P1271 PLVAR P1271 MANDT T778P Plan Versions MANDT
P1271 PLVAR P1271 PLVAR T778P Plan Versions PLVAR
P1271 STATSTYPE SYST MANDT T71JPR23 Pay Category MANDT
P1271 STATSTYPE P1271 STATSTYPE T71JPR23 Pay Category STATSTYPE
P1271 SUBTY P1271 MANDT T778U Subtypes MANDT
P1271 SUBTY P1271 INFTY T778U Subtypes INFTY
P1271 SUBTY P1271 SUBTY T778U Subtypes SUBTY