SAP Table T5F1C
SI contributions:rates and wage types
T5F1C (SI contributions:rates and wage types) 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 T5F1C to other SAP tables.
T5F1C table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| ORGAN | SI contribution funds | ORGA1 | T5F1A | CHAR | 4 | 0 | ||||||
| COTIS | Tax and social insurance payroll costs | COTIS | T5F1B | CHAR | 4 | 0 | ||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||
| ASSCO | Assessment Basis | ASSC1 | T5F1G | NUMC | 3 | 0 | ||||||
| FBTAN | Fixed amount for employee | FBTAN | CURR | 6 | 2 | |||||||
| PRANA | Rate of employee contributions level A (%) | PRANA | DEC | 5 | 3 | |||||||
| PRANB | Rate of employee contributions level B (%) | PRANB | DEC | 5 | 3 | |||||||
| PRANC | Rate of employee contributions level C (%) | PRANC | DEC | 5 | 3 | |||||||
| FBTAG | Employer part fixed amount | FBTAG | CURR | 6 | 2 | |||||||
| PRAGA | Rate of employer contributions level A (%) | PRAGA | DEC | 5 | 3 | |||||||
| PRAGB | Rate of employer contributions level B (%) | PRAGB | DEC | 5 | 3 | |||||||
| PRAGC | Rate of employer contributions level C (%) | PRAGC | DEC | 5 | 3 | |||||||
| LAGSA | Wage Type for Employer - Level A | LAGSA | T512W | CHAR | 4 | 0 | ||||||
| LAGSB | Wage Type for Employer - Level B | LAGSB | T512W | CHAR | 4 | 0 | ||||||
| LAGSC | Wage Type for Employer - Level C | LAGSC | T512W | CHAR | 4 | 0 | ||||||
| LAGBT | Wage Type for Fixed Amount | LAGBT | T512W | CHAR | 4 | 0 | ||||||
| LANSA | Wage Type for Employee - Level A | LANSA | T512W | CHAR | 4 | 0 | ||||||
| LANSB | Wage Type for Employee - Level B | LANSB | T512W | CHAR | 4 | 0 | ||||||
| LANSC | Wage Type for Employee - Level C | LANSC | T512W | CHAR | 4 | 0 | ||||||
| LANBT | Wage Type for Fixed Amount | LANBT | T512W | CHAR | 4 | 0 | ||||||
| CTMOD | Contribution type | P06_CTMOD | T5F1C2 | CHAR | 2 | 0 | ||||||
| COND | Condition type | P06_COND | T5F1C5 | CHAR | 4 | 0 | ||||||
| CRULE | Rule type | P06_RULE | T5F1C8 | CHAR | 4 | 0 | ||||||
| SPECI | Outside contribution module | P06_CALCUL_PARTIC_COTIS | CHAR | 1 | 0 |
Possible values
|
||||||
| CINAC | Contributions calculation indicator for unemployed employees | P06_CALCUL_IF_INACTIVE | CHAR | 1 | 0 |
Possible values
|
||||||
| ASMOD | Contribution attributes for pension/insurance contract | P06_ASMOD | T5F1O | CHAR | 2 | 0 | ||||||
| THGRP | Grouping indicator for contributions with a common platform | P06_THGRP | CHAR | 2 | 0 | |||||||
T5F1C foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5F1C | ASMOD | T5F1C | MANDT | T5F1O | Contribution attribute modifiers | MANDT |
| T5F1C | ASMOD | T5F1C | ASMOD | T5F1O | Contribution attribute modifiers | ASMOD |
| T5F1C | ASSCO | T5F1C | MANDT | T5F1G | Contributions assessment thresholds | MANDT |
| T5F1C | ASSCO | T5F1C | ASSCO | T5F1G | Contributions assessment thresholds | ASSCO |
| T5F1C | ASSCO | * | T5F1G | Contributions assessment thresholds | ENDDA | |
| T5F1C | COND | T5F1C | COND | T5F1C5 | Contributions conditions | COND |
| T5F1C | COND | T5F1C | MANDT | T5F1C5 | Contributions conditions | MANDT |
| T5F1C | COTIS | T5F1C | MANDT | T5F1B | SI contributions | MANDT |
| T5F1C | COTIS | T5F1C | COTIS | T5F1B | SI contributions | COTIS |
| T5F1C | CRULE | T5F1C | MANDT | T5F1C8 | Contributions rules | MANDT |
| T5F1C | CRULE | T5F1C | CRULE | T5F1C8 | Contributions rules | CRULE |
| T5F1C | CTMOD | T5F1C | MANDT | T5F1C2 | Contributions types | MANDT |
| T5F1C | CTMOD | T5F1C | CTMOD | T5F1C2 | Contributions types | CTMOD |
| T5F1C | LAGBT | T5F1C | LAGBT | T512W | Wage Type Valuation | LGART |
| T5F1C | LAGBT | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LAGBT | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LAGBT | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LAGSA | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LAGSA | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LAGSA | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LAGSA | T5F1C | LAGSA | T512W | Wage Type Valuation | LGART |
| T5F1C | LAGSB | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LAGSB | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LAGSB | T5F1C | LAGSB | T512W | Wage Type Valuation | LGART |
| T5F1C | LAGSB | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LAGSC | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LAGSC | T5F1C | LAGSC | T512W | Wage Type Valuation | LGART |
| T5F1C | LAGSC | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LAGSC | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LANBT | T5F1C | LANBT | T512W | Wage Type Valuation | LGART |
| T5F1C | LANBT | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LANBT | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LANBT | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LANSA | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LANSA | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LANSA | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LANSA | T5F1C | LANSA | T512W | Wage Type Valuation | LGART |
| T5F1C | LANSB | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | LANSB | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LANSB | T5F1C | LANSB | T512W | Wage Type Valuation | LGART |
| T5F1C | LANSB | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LANSC | '06' | T512W | Wage Type Valuation | MOLGA | |
| T5F1C | LANSC | T5F1C | LANSC | T512W | Wage Type Valuation | LGART |
| T5F1C | LANSC | * | T512W | Wage Type Valuation | ENDDA | |
| T5F1C | LANSC | T5F1C | MANDT | T512W | Wage Type Valuation | MANDT |
| T5F1C | MANDT | T5F1C | MANDT | T000 | Clients | MANDT |
| T5F1C | ORGAN | T5F1C | MANDT | T5F1A | SI organizations (France) | MANDT |
| T5F1C | ORGAN | T5F1C | ORGAN | T5F1A | SI organizations (France) | ORGAN |
