SAP ABAP Table T5BS3 (Employee information except reductions ( level 3 ))

Hierarchy

☛ SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   ⤷ PY-BE (Application Component) Belgium
     ⤷ PC12 (Package) HR accounting: Belgium

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5BS3	Table Relationship Diagram
Short Description	Employee information except reductions ( level 3 )

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DECID	☑	P12_DECID	NUM06	NUMC	6	0	SI Declaration identifier
3	STREF	☑	P12_STREF	P12_STREF	NUMC	3	0	Reference pointing to the detailed declaration info
4	RSZCA	☑	RSZCA	RSZCA	CHAR	3	0	Employer class (SI employer category)	*
5	RSZNR	☑	RSZNR	NUM9	NUMC	9	0	SI registration number (employer) (00011)
6	RSZKN	☑	RSZKN	RSZKN	CHAR	3	0	Worker code (SI employee category)	*
7	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
8	STRAV	☐	STRAV	CHAR5	CHAR	5	0	Worker's range number
9	RSZRR	☐	RSZRR	NUM11	NUMC	11	0	INSS - National ID number (00024)
10	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
11	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
12	RSZGL	☐	RSZG0	CHAR5	CHAR	5	0	Country code for place of birth
13	DDREC	☐	DDREC	CHAR1	CHAR	1	0	Correction proposal code
14	NSSOC	☐	NSSOC	CHAR15	CHAR	15	0	Employer number with Social Office
15	RSZLA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
16	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
17	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
18	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
19	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
20	HSNMR	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
21	ORT01	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
22	POSTA	☐	PAD_POSTA	PAD_HSNMR	CHAR	10	0	Identification of an apartment in a building
23	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
24	RSZBL	☐	RSZB0	CHAR5	CHAR	5	0	Sender SI country code
25	DECES	☐	P12_DECES	DATS	DATS	8	0	SI declaration date of death
26	PENS	☐	P12_PENS	DATS	DATS	8	0	SI declaration date of retirement
27	ESCE	☐	P12_ESCE	DATS	DATS	8	0	SI declaration date of entry
28	SORT	☐	P12_SORT	DATS	DATS	8	0	SI declaration date of leaving
29	FRONT	☐	FRONT	CHAR1	CHAR	1	0	Border worker
30	ARTIS	☐	ARTIS	CHAR1	CHAR	1	0	Artist
31	CHOM	☐	CKOM0	CHAR1	CHAR	1	0	Unemployed
32	INTER	☐	INTER	NATION	CHAR	1	0	International address version ID	*
33	TDOMI	☐	TDOMI	CHAR1	CHAR	1	0	Domestic worker
34	DEBST	☐	P12_BEGD3	DATS	DATS	8	0	Begindate in employee category
35	FINST	☐	P12_ENDD3	DATS	DATS	8	0	Enddate in employee category
36	TREMP	☐	TREMP	CHAR1	CHAR	1	0	Employment notion
37	NSTAG	☐	NSTAG	CHAR1	CHAR	1	0	Training employee
38	NOPEP	☐	PC12_NPEPR	CHAR02	CHAR	2	0	Notion first professional experiance
39	BVFAM	☐	BVFAM	BVFAM	CHAR	1	0	Marital status	*
40	RSZNA	☐	RSZNA	RSZNA	CHAR	1	0	Obsolete: SI Nationality	*
41	BVECH	☐	BVECH	BVECH	CHAR	1	0	Partner's profession	*
42	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
43	DTRIM	☐	DTRIM	DATUM	DATS	8	0	File creation date
44	FTRIM	☐	FTRIM	DATUM	DATS	8	0	End of three months period
45	BESTE	☐	BEST0	CHAR1	CHAR	1	0	Frequency of payment
46	BEGPC	☐	BEGPC	BEGPC	CHAR	7	0	Joint Commission (00046)	*
47	BECNR	☐	BECNR	CHAR15	CHAR	15	0	Contract number
48	ARBER	☐	ARBER	DATUM	DATS	8	0	Expiration Date of Work Permit
49	BEANN	☐	BEANN	CHAR2	CHAR	2	0	Contract duration
50	CTTYP	☐	CTTYP	CTTYP	CHAR	2	0	Contract Type	*
51	NSUIT	☐	NSUIT	CHAR3	CHAR	3	0	Activity range number
52	SSGE	☐	SSGE0	CHAR4	CHAR	4	0	Range number HQ
53	STQUA	☐	STQUA	NUMC1	NUMC	1	0	Student capacity
54	STAMT	☐	P12_STAMT	P12_AMOUNT_SI	INT4	10	0	Student salary
55	STDAG	☐	P12_STDAG	P12_DAYS_SI	INT4	10	0	Number of paid days (students)
56	DPD92	☐	P12_DPD92	P12_AMOUNT_SI	INT4	10	0	Double Holiday Pay after 1992
57	COTSP	☐	COTSP	CHAR1	CHAR	1	0	Contribution code
58	MTCOT	☐	P12_MTCOT	P12_AMOUNT_SI	INT4	10	0	Special contribution: amount
59	AMSOL	☐	P12_AMSOL	P12_AMOUNT_SI	INT4	10	0	Solidarity contribution on company car
60	AMELA	☐	P12_AMELA	P12_AMOUNT_SI	INT4	10	0	Contribution extra-legal advantage : amount

History

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