SAP Table PA0064
Infotype 0064 : Social Insurance - France
PA0064 (Infotype 0064 : Social Insurance - France) 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 PA0064 to other SAP tables.
PA0064 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| PERNR | Personnel number | PERSNO | PA0003 | NUMC | 8 | 0 | ||||||||
| SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||
| PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||||
| NUMSS | Social insurance number | NUMSS | CHAR | 13 | 0 | |||||||||
| CLESS | Verification key for the SI number | CLESS | NUMC | 2 | 0 | |||||||||
| TPART | Part-time activity code | TPART_D | CHAR | 1 | 0 |
Possible values
|
||||||||
| REGNO | Expense template for other plans | P06_REGNO | T5F1I | CHAR | 4 | 0 | ||||||||
| ORG01 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT01 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG02 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT02 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG03 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT03 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG04 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT04 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG05 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT05 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG06 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT06 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG07 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT07 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG08 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT08 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG09 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT09 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| ORG10 | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||||
| COT10 | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||||
| REGSS | Expense template for social insurance plan | P06_REGSS0 | T5F1I | CHAR | 4 | 0 | ||||||||
| REGAC | Expense template for unemployment insurance plan | P06_REGAC | T5F1I | CHAR | 4 | 0 | ||||||||
| REGRT | Expense template for supplementary retirement pension plan | P06_REGRT | T5F1I | CHAR | 4 | 0 | ||||||||
PA0064 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PA0064 | COT01 | PA0064 | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT01 | PA0064 | COT01 | T5F1B | SI contributions | COTIS |
| PA0064 | COT02 | PA0064 | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT02 | PA0064 | COT02 | T5F1B | SI contributions | COTIS |
| PA0064 | COT03 | PA0064 | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT03 | PA0064 | COT03 | T5F1B | SI contributions | COTIS |
| PA0064 | COT04 | PA0064 | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT04 | PA0064 | COT04 | T5F1B | SI contributions | COTIS |
| PA0064 | COT05 | PA0064 | COT05 | T5F1B | SI contributions | COTIS |
| PA0064 | COT05 | PA0064 | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT06 | SYST | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT06 | PA0064 | COT06 | T5F1B | SI contributions | COTIS |
| PA0064 | COT07 | SYST | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT07 | PA0064 | COT07 | T5F1B | SI contributions | COTIS |
| PA0064 | COT08 | SYST | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT08 | PA0064 | COT08 | T5F1B | SI contributions | COTIS |
| PA0064 | COT09 | SYST | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT09 | PA0064 | COT09 | T5F1B | SI contributions | COTIS |
| PA0064 | COT10 | SYST | MANDT | T5F1B | SI contributions | MANDT |
| PA0064 | COT10 | PA0064 | COT10 | T5F1B | SI contributions | COTIS |
| PA0064 | MANDT | PA0064 | MANDT | T000 | Clients | MANDT |
| PA0064 | ORG01 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG01 | PA0064 | ORG01 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG02 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG02 | PA0064 | ORG02 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG03 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG03 | PA0064 | ORG03 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG04 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG04 | PA0064 | ORG04 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG05 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG05 | PA0064 | ORG05 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG06 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG06 | PA0064 | ORG06 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG07 | PA0064 | ORG07 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG07 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG08 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG08 | PA0064 | ORG08 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG09 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG09 | PA0064 | ORG09 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | ORG10 | SYST | MANDT | T5F1A | SI organizations (France) | MANDT |
| PA0064 | ORG10 | PA0064 | ORG10 | T5F1A | SI organizations (France) | ORGAN |
| PA0064 | PERNR | PA0064 | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| PA0064 | PERNR | PA0064 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| PA0064 | PREAS | PA0064 | MANDT | T530E | Reasons for Changes | MANDT |
| PA0064 | PREAS | '0064' | T530E | Reasons for Changes | INFTY | |
| PA0064 | PREAS | PA0064 | PREAS | T530E | Reasons for Changes | PREAS |
| PA0064 | REGAC | SYST | MANDT | T5F1I | Fund model | MANDT |
| PA0064 | REGAC | PA0064 | REGAC | T5F1I | Fund model | REGNO |
| PA0064 | REGNO | SYST | MANDT | T5F1I | Fund model | MANDT |
| PA0064 | REGNO | PA0064 | REGNO | T5F1I | Fund model | REGNO |
| PA0064 | REGRT | PA0064 | REGRT | T5F1I | Fund model | REGNO |
| PA0064 | REGRT | SYST | MANDT | T5F1I | Fund model | MANDT |
| PA0064 | REGSS | SYST | MANDT | T5F1I | Fund model | MANDT |
| PA0064 | REGSS | PA0064 | REGSS | T5F1I | Fund model | REGNO |
