SAP ABAP Table P06CR_BRC_ALV (To print Contribution Summary Sheets)
Hierarchy
☛
SAP_HRCFR (Software Component) Sub component SAP_HRCFR of SAP_HR
⤷ PY-FR (Application Component) France
⤷ PC06 (Package) HR Payroll: France
⤷ PY-FR (Application Component) France
⤷ PC06 (Package) HR Payroll: France
Basic Data
Table Category | INTTAB | Structure |
Structure | P06CR_BRC_ALV | Table Relationship Diagram |
Short Description | To print Contribution Summary Sheets |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | SIREN | SIREN | CHAR9 | CHAR | 9 | 0 | SIREN number | ||
3 | NUMIC | NUMIC | CHAR5 | CHAR | 5 | 0 | NIC | ||
4 | FPPER | FAPER | CHAR6 | CHAR | 6 | 0 | For-period for payroll | ||
5 | FP_BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
6 | FP_ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
7 | INPER | IPERI | CHAR6 | CHAR | 6 | 0 | In-period for payroll | ||
8 | IN_BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | IN_ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
10 | CNTR1 | CNTR1 | RAW1 | RAW | 1 | 0 | SI split | ||
11 | CATEG | P06_CATCC | P06_CATCC | CHAR | 3 | 0 | Insur. org. category | ||
12 | SCREEN_CATEG | P06_CATCC | P06_CATCC | CHAR | 3 | 0 | Insur. org. category | ||
13 | CORGA | P06_CORGA | P06_CORGA | CHAR | 2 | 0 | Agency code | * | |
14 | C1_CORGA | P06_CORGA1 | CHAR | 1 | 0 | First character of agency code BRC | |||
15 | C2_CORGA | P06_CORGA2 | CHAR | 1 | 0 | Second character of agency code BRC | |||
16 | PERTY | P06_PERTY | P06_PERTY | CHAR | 5 | 0 | Employee type | * | |
17 | C1_PERTY | P06_PERTY1 | CHAR | 1 | 0 | First character of Employee type BRC | |||
18 | C2_PERTY | P06_PERTY2 | CHAR | 1 | 0 | Second character of Employee type BRC | |||
19 | C3_PERTY | P06_PERTY3 | CHAR | 1 | 0 | Third character of Employee type BRC | |||
20 | C4_PERTY | P06_PERTY4 | CHAR | 1 | 0 | Fourth character of Employee type BRC | |||
21 | C5_PERTY | P06_PERTY5 | CHAR | 1 | 0 | Fifth character of Employee type BRC | |||
22 | AT_RATE | P06_PERER | DEC2_3 | DEC | 5 | 3 | Rate of the employer's contribution (%) | ||
23 | NATDEC | P06_NATDEC | P06_NATDEC | NUMC | 1 | 0 | BRC: type of declaration | ||
24 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
25 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
26 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | * | |
27 | PERMO | PERMO | PERMO | NUMC | 2 | 0 | Period Parameters | * | |
28 | DATMO | DATMO | DATMO | NUMC | 2 | 0 | Date modifier | * | |
29 | PERNR | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
30 | EXOEFF | P06_EXOEFF | XFELD | CHAR | 1 | 0 | Count indicator for contribution-exempt headcount | ||
31 | EXONEG | P06_EXONEG | XFELD | CHAR | 1 | 0 | Negative contribution amount indicator for BRC | ||
32 | DIFBASE | P06_DIFBASE | XFELD | CHAR | 1 | 0 | Contribution indicator on different basis | ||
33 | REGNO | REGNO | P06_REGNO | CHAR | 4 | 0 | SI contrib. model | * | |
34 | CTMOD | P06_CTMOD | P06_CTMOD | CHAR | 2 | 0 | Contribution type | * | |
35 | RTMOD | P06_RTMOD | P06_RTMOD | CHAR | 4 | 0 | Contribution rate modifier | * | |
36 | ORGAN | ORGA1 | P06_ORGA1 | CHAR | 4 | 0 | SI contribution funds | * | |
37 | COTIS | COTIS | P06_COTIS | CHAR | 4 | 0 | Tax and social insurance payroll costs | * | |
38 | PAYDT | PAYDT | DATUM | DATS | 8 | 0 | Pay date for awards | ||
39 | DTCHC | P06_DTCHC | DATS | DATS | 8 | 0 | DUCS: Contribution conditions change date | ||
40 | OPS | P06_OPS | P06_OPS | CHAR | 9 | 0 | Social Protection Agency | * | |
41 | COTTY | P06_COTTY | P06_COTTY | CHAR | 2 | 0 | DUCS Contribution Type | ||
42 | CONTY | P06_CONTY | P06_CONTY | CHAR | 3 | 0 | DUCS Condition Type | ||
43 | CPMOD | P06_CPMOD | P06_CPMOD | CHAR | 4 | 0 | DUCS Declared unit modifier by Corga/Perty | ||
44 | COTGR | P06_COTGR | P06_COTGR | CHAR | 3 | 0 | Contributor group | ||
45 | PCS_GCO | P06_PCS | P06_PCS | CHAR | 4 | 0 | Socio-professional category INSEE code | * | |
46 | PERTY_LABEL | P06_TPCTX | CHAR20 | CHAR | 20 | 0 | Employee group short text | ||
47 | S_DTUPD | SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
48 | S_TIMUPD | SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
49 | S_PAID_HEADC | P06_PAID_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | Last BRC: paid headcount over a period | ||
50 | S_EXEMPT_HEADC | P06_EXPT_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | Last BRC: contr.-exempt headcount during period | ||
51 | S_ENDOP_MEN | P06_ENDOP_MEN | P06_HEADCOUNTS | NUMC | 7 | 0 | Last BRC: male headcount at end of period | ||
52 | S_ENDOP_WOMEN | P06_ENDOP_WOMEN | P06_HEADCOUNTS | NUMC | 7 | 0 | Last BRC: female headcount at end of period | ||
53 | S_ENDOP_HEADC | P06_ENDOP_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | Last BRC: total headcount at end of period | ||
54 | S_WAERS | P06_BRC_WAERS | WAERS | CUKY | 5 | 0 | Last BRC : currency key | * | |
55 | S_CONT_BASIS | P06_TYPCOT | P06_TYPCOT | CHAR | 1 | 0 | Contribution type: max.amount fixed, not fixed or "accident" | ||
56 | S_PAID_SALARY | P06_PAID_SALARY | BTRA_BETRG | CURR | 15 | 2 | Last BRC: contributions base | ||
57 | S_NORMAL_RATE | P06_NORMAL_RATE | DEC2_3 | DEC | 5 | 3 | Last BRC: standard contribution rate ( non AT ) | ||
58 | S_NORMAL_CONT | P06_NORMAL_CONT | BTRA_BETRG | CURR | 15 | 2 | Last BRC: standard contribution rate (non AT) | ||
59 | S_SPECIAL_RATE | P06_SPECIAL_RATE | DEC2_3 | DEC | 5 | 3 | Last BRC: special contribution rate ( AT ) | ||
60 | S_SPECIAL_CONT | P06_SPEC_CONT | BTRA_BETRG | CURR | 15 | 2 | Last BRC: special rate contributions ( ToDo ) | ||
61 | S_TOTAL_RATE | P06_TOTAL_RATE | DEC2_3 | DEC | 5 | 3 | Last BRC : total rate of contributions | ||
62 | S_TOTAL_CONT | P06_TOTAL_CONT | BTRA_BETRG | CURR | 15 | 2 | Last BRC : total contributions | ||
63 | S_DELTA_CONT | P06_DELTA_CONT | BTRA_BETRG | CURR | 15 | 2 | Final BRC: Recalculation Final Delta | ||
64 | C_PAID_HEADC | P06_NEW_PAID_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | New BRC: paid headcount over a period | ||
65 | C_EXEMPT_HEADC | P06_NEW_EXPT_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | New BRC: exempt headcount during period | ||
66 | C_ENDOP_MEN | P06_NEW_ENDOP_MEN | P06_HEADCOUNTS | NUMC | 7 | 0 | New BRC: male headcount at end of period | ||
67 | C_ENDOP_WOMEN | P06_NEW_ENDOP_WOMEN | P06_HEADCOUNTS | NUMC | 7 | 0 | New BRC: female headcount at end of period | ||
68 | C_ENDOP_HEADC | P06_NEW_ENDOP_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | New BRC: total headcount at end of period | ||
69 | C_WAERS | P06_NEW_BRC_WAERS | WAERS | CUKY | 5 | 0 | New BRC: currency key | * | |
70 | C_CONT_BASIS | P06_TYPCOT | P06_TYPCOT | CHAR | 1 | 0 | Contribution type: max.amount fixed, not fixed or "accident" | ||
71 | C_PAID_SALARY | P06_NEW_PAID_SALARY | BTRA_BETRG | CURR | 15 | 2 | New BRC: paid salary over period | ||
72 | C_NORMAL_RATE | P06_NEW_NORMAL_RATE | DEC3_3 | DEC | 6 | 3 | New BRC: special contribution rate (non AT) | ||
73 | C_NORMAL_CONT | P06_NEW_NORMAL_CONT | BTRA_BETRG | CURR | 15 | 2 | New BRC: standard rate contributions ( non AT ) | ||
74 | C_SPECIAL_RATE | P06_NEW_SPECIAL_RATE | DEC3_3 | DEC | 6 | 3 | Nzw BRC: special contribution rate ( AT ) | ||
75 | C_SPECIAL_CONT | P06_NEW_SPEC_CONT | BTRA_BETRG | CURR | 15 | 2 | New BRC: special contribution rate (AT) | ||
76 | C_TOTAL_RATE | P06_NEW_TOTAL_RATE | DEC3_3 | DEC | 6 | 3 | New BRC : total rate of contributions | ||
77 | C_TOTAL_CONT | P06_NEW_TOTAL_CONT | BTRA_BETRG | CURR | 15 | 2 | New BRC: total contributions | ||
78 | C_BASE_COMPARE | P06_NEW_PAID_SALARY | BTRA_BETRG | CURR | 15 | 2 | New BRC: paid salary over period | ||
79 | C_RECALC_CONT | P06_NEW_RECALC_CONT | BTRA_BETRG | CURR | 15 | 2 | New BRC: recalculation of contributions | ||
80 | C_DELTA_CONT | P06_NEW_DELTA_CONT | BTRA_BETRG | CURR | 15 | 2 | New BRC: recalculated Delta contributions | ||
81 | C_BRUT | P06_BRUT | PRBETRG | CURR | 15 | 2 | Contributions: Gross | ||
82 | C_TOT_LINES | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
83 | D_PAID_HEADC | P06_DIF_PAID_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | BRC: paid headcount difference during period | ||
84 | D_EXEMPT_HEADC | P06_DIF_EXPT_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | BRC: tax-exempt headcount difference during period | ||
85 | D_ENDOP_HEADC | P06_DIF_ENDOP_HEADC | P06_HEADCOUNTS | NUMC | 7 | 0 | BRC: headcount difference at end of period | ||
86 | D_PAID_SALARY | P06_DIF_PAID_SALARY | BTRA_BETRG | CURR | 15 | 2 | BRC: paid salary difference during period | ||
87 | D_NORMAL_RATE | P06_DIF_NORMAL_RATE | DEC3_3 | DEC | 6 | 3 | BRC: standard rate contributions difference (not To Do) | ||
88 | D_NORMAL_CONT | P06_DIF_NORMAL_CONT | BTRA_BETRG | CURR | 15 | 2 | BRC: standard rate contributions difference ( not ToDo ) | ||
89 | D_SPECIAL_RATE | P06_DIF_SPECIAL_RATE | DEC3_3 | DEC | 6 | 3 | BRC: special contribution rate difference ( ToDo ) | ||
90 | D_SPECIAL_CONT | P06_DIF_SPEC_CONT | BTRA_BETRG | CURR | 15 | 2 | BRC: special contribution rate difference ( AT ) | ||
91 | D_TOTAL_RATE | P06_DIF_TOTAL_RATE | DEC3_3 | DEC | 6 | 3 | BRC: total contribution rate difference | ||
92 | D_TOTAL_CONT | P06_DIF_TOTAL_CONT | BTRA_BETRG | CURR | 15 | 2 | BRC: total contributions difference | ||
93 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |