SAP ABAP Table HBRRS2_07 (SIAL: record type 2 (V. 2007))

Hierarchy

☛ SAP_HRCBR (Software Component) Sub component SAP_HRCBR of SAP_HR
   ⤷ PY-BR (Application Component) Brazil
     ⤷ PC37 (Package) HR settlement: Brazil

Basic Data

Table Category	INTTAB	Structure
Structure	HBRRS2_07	Table Relationship Diagram
Short Description	SIAL: record type 2 (V. 2007)

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	SEQUE	☐	PBR_SEQUR	NUMC6	NUMC	6	0	SIAL: file record sequence number
2	CGCEI	☐	PBR_CGCER	NUMC14	NUMC	14	0	Sial: CNPJ or SRS number
3	PREFI	☐	PBR_PREFI	CHAR2	CHAR	2	0	SIAL: prefix of file's first establishment
4	TIPOR	☐	PBR_TIPOR	CHAR1	CHAR	1	0	Sial: record type
5	CDPIS	☐	PBR_CDPIS	CHAR11	CHAR	11	0	Sial: SIP/PSHFP code
6	NOMEE	☐	PBR_NOMEE	CHAR30	CHAR	30	0	SIAL: employee name
7	DNASC	☐	PBR_DNASC	CHAR8	CHAR	8	0	SIAL: employee's birth date
8	NACDD	☐	PBR_NACDD	CHAR2	CHAR	2	0	SIAL: employee nationality
9	ACHEG	☐	PBR_ACHEG	CHAR4	CHAR	4	0	Sial: year of arrival at country
10	GRAUI	☐	PBR_GRAUI02	NUMC02	NUMC	2	0	SIAL: education level
11	NOCPF	☐	PBR_NOCPF	CHAR11	CHAR	11	0	SIAL: employee SPR
12	NCTPS	☐	PBR_NCTPS08	NUMC8	NUMC	8	0	SIAL: worker's card number
13	SCTPS	☐	PBR_SCTPS	CHAR5	CHAR	5	0	SIAL: worker's card series
14	DTADM	☐	PBR_DTADM	CHAR8	CHAR	8	0	SIAL: hiring or transfer date
15	TPADM	☐	PBR_TPADM	CHAR1	CHAR	1	0	SIAL: admission type
16	SALCT	☐	PBR_SALCT	NUM9	NUMC	9	0	SIAL: contract wage
17	SALTP	☐	PBR_SALTP	CHAR1	CHAR	1	0	SIAL: type of contract wage
18	HRSEM	☐	PBR_HRSEM	NUMC2	NUMC	2	0	SIAL: weekly hours
19	NOCBO	☐	PBR_CBO6	NUMC6	NUMC	6	0	Brazilian Job Occupation Code
20	VINEM	☐	PBR_VINEM	CHAR2	CHAR	2	0	SIAL: employment relationship
21	DESLG	☐	PBR_DESLG	CHAR2	CHAR	2	0	SIAL: dismissal code
22	DESDT	☐	PBR_DESDT	CHAR4	CHAR	4	0	SIAL: date of dismissal
23	REM01	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
24	REM02	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
25	REM03	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
26	REM04	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
27	REM05	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
28	REM06	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
29	REM07	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
30	REM08	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
31	REM09	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
32	REM10	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
33	REM11	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
34	REM12	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
35	RE113	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
36	ME113	☐	PBR_MES13	CHAR2	CHAR	2	0	SIAL: Christmas allowance payment month
37	RE213	☐	PBR_REMUN	NUM9	NUMC	9	0	SIAL: monthly remuneration
38	ME213	☐	PBR_MES13	CHAR2	CHAR	2	0	SIAL: Christmas allowance payment month
39	ERACE	☐	PBR_ERACE	CHAR01	CHAR	1	0	Sial: race/complexion indicator
40	DEFFI	☐	PBR_DEFFI	CHAR01	CHAR	1	0	Greu: challenge indicator
41	ALVRA	☐	PBR_ALVRA	XFLAG	CHAR	1	0	Permit indicator (Permission)
42	AVIPR	☐	PBR_AVIPR	NUM9	NUMC	9	0	"Notice period" severance pay
43	GENDR	☐	PBR_GENDR	CHAR1	CHAR	1	0	Gender
44	LIC1	☐	PBR_ARAIS	PBR_ARAIS	NUMC	2	0	Absence code for SIAL
45	ILIC1	☐	PBR_INILI	NUM4	NUMC	4	0	SIAL: start date of leave
46	FLIC1	☐	PBR_FIMLI	NUM4	NUMC	4	0	SIAL: end date of leave
47	LIC2	☐	PBR_ARAIS	PBR_ARAIS	NUMC	2	0	Absence code for SIAL
48	ILIC2	☐	PBR_INILI	NUM4	NUMC	4	0	SIAL: start date of leave
49	FLIC2	☐	PBR_FIMLI	NUM4	NUMC	4	0	SIAL: end date of leave
50	LIC3	☐	PBR_ARAIS	PBR_ARAIS	NUMC	2	0	Absence code for SIAL
51	ILIC3	☐	PBR_INILI	NUM4	NUMC	4	0	SIAL: start date of leave
52	FLIC3	☐	PBR_FIMLI	NUM4	NUMC	4	0	SIAL: end date of leave
53	DIALI	☐	PBR_DIALI	NUM3	NUMC	3	0	SIAL: total days on leave
54	RESCFER	☐	PBR_VACTERM	NUMC8	NUMC	8	0	Vacation amount received upon termination
55	EXTRAHOURS	☐	PBR_EXTRAHOURS	NUMC8	NUMC	8	0	Total amount of overtime balance
56	NCOMPHOURS	☐	PBR_NCOMPHOURS	NUMC2	NUMC	2	0	Quantity of time bank competences (months)
57	DISSIDIO	☐	PBR_DISSIDIO	NUMC8	NUMC	8	0	Salary premium (collective dissension)
58	NCOMPDISS	☐	PBR_NCOMPDISS	NUMC2	NUMC	2	0	Quantity of dissension competences (months)
59	BONUS	☐	PBR_BONUS	NUMC8	NUMC	8	0	Total amount from gratuities
60	COMPBONUS	☐	PBR_NCOMPBONUS	NUMC2	NUMC	2	0	Quantity of bonus competences (months)
61	FGTSFINE	☐	PBR_FGTSFINE	NUMC8	NUMC	8	0	Termination penalty
62	CNPJUNASC1ST	☐	PBR_CNPJPATASC	NUMC14	NUMC	14	0	CNPJ of union which benefits from association contribution
63	CONTUNASC1ST	☐	PBR_CONTPATASC	NUMC8	NUMC	8	0	Total amount of union association
64	CNPJUNASC2ND	☐	PBR_CNPJPATASC	NUMC14	NUMC	14	0	CNPJ of union which benefits from association contribution
65	CONTUNASC2ND	☐	PBR_CONTPATASC	NUMC8	NUMC	8	0	Total amount of union association
66	CNPJUNSIND	☐	PBR_CNPJPATSIND	NUMC14	NUMC	14	0	CNPJ of union which benefits from union contribution
67	CONTUNSIND	☐	PBR_CONTPATSIND	NUMC8	NUMC	8	0	Total amount of union
68	CNPJUNAST	☐	PBR_CNPJPATAST	NUMC14	NUMC	14	0	CNPJ of union which benefits from assistance contribution
69	CONTUNAST	☐	PBR_CONTPATAST	NUMC8	NUMC	8	0	Total amount of union assistance
70	CNPJUNCONF	☐	PBR_CNPJPATCONF	NUMC14	NUMC	14	0	CNPJ of union which benefits from confederate contribution
71	CONTUNCONF	☐	PBR_CONTPATCONF	NUMC8	NUMC	8	0	Total amount of union confederate
72	CDMUN	☐	PBR_CDMUN	CHAR7	CHAR	7	0	Sial: municipality code
73	OVTHOURSJAN	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
74	OVTHOURSFEB	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
75	OVTHOURSMAR	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
76	OVTHOURSAPR	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
77	OVTHOURSMAY	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
78	OVTHOURSJUN	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
79	OVTHOURSJUL	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
80	OVTHOURSAUG	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
81	OVTHOURSSEP	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
82	OVTHOURSOCT	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
83	OVTHOURSNOV	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
84	OVTHOURSDEC	☐	PBR_OVTHOURSM	NUMC3	NUMC	3	0	Overtime month
85	INDICSIND	☐	PBR_INDICSIND	NUMC1	NUMC	1	0	Indicator - union worker
86	USEMP	☐	PBR_USEMP12	CHAR12	CHAR	12	0	SIAL: company exclusive use
87	CRLF	☐	PBR_CRLF	HEX002	RAW	2	0	CRLF

History

Last changed by/on	SAP	20130529
SAP Release Created in	470