SAP ABAP Table CCHRS_SOCIALINSURANCE (EHS-INT: HR Data - Social Insurance)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CBHR (Package) EH&S: Interface Development HR/EHS

Basic Data

Table Category	INTTAB	Structure
Structure	CCHRS_SOCIALINSURANCE	Table Relationship Diagram
Short Description	EHS-INT: HR Data - Social Insurance

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	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
2	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
3	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
12	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
13	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
14	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
15	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
16	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
17	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
18	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
19	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
22	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
23	KVKZ1	☐	KVKZ1	SVSCH	CHAR	1	0	Indicator for Health Insurance	T5D1Y
24	RVKZ1	☐	RVKZ1	SVSCH	CHAR	1	0	Indicator: Pension Insurance	T5D1Y
25	AVKZ1	☐	AVKZ1	SVSCH	CHAR	1	0	Indicator: Unemployment Insurance	T5D1Y
26	RVNUM	☐	RVNUM	RVNUM	CHAR	12	0	Pension Insurance Number
27	KVSFR	☐	KVSCH	KVSCH	CHAR	8	0	HI Fund Key for Compulsory Health Insurance Fund	T5D11
28	KVGST	☐	KVGST	KVGST	CHAR	6	0	HI Fund Branch Office	T5D1K
29	KVBKL	☐	BTRKL	P011_BTRKL	CHAR	6	0	Contribution Scale	T5D1O
30	KVFBT	☐	KVFBT	SVBTR	CURR	7	2	HI Amount
31	ZUSKA	☐	DZUSKA	KVSCH	CHAR	8	0	Additional Health Insurance Fund	T5D11
32	SONKV	☐	SONKV	P011_SONSV	CHAR	2	0	SI Special Rule HI	T5D1B
33	SONRV	☐	SONRV	P011_SONSV	CHAR	2	0	SI Special Rule PI	T5D1B
34	SONAV	☐	SONAV	P011_SONSV	CHAR	2	0	SI Special Rule SI	T5D1B
35	SELKV	☐	SELKV	XFELD	CHAR	1	0	Indicator Self-Payer HI
36	SELRV	☐	SELRV	XFELD	CHAR	1	0	Self-Payer Pension Insurance
37	KVBFG	☐	KVBFG	P011_KVSVA	CHAR	1	0	Reason for HI exemption	T5D12
38	RVBFG	☐	RVBFG	P011_KVSVA	CHAR	1	0	Reason for PI Exemption	T5D12
39	AVBFG	☐	AVBFG	P011_KVSVA	CHAR	1	0	Reason for UI Exemption	T5D12
40	MAXKV	☐	MAXKV	SVBTR	CURR	7	2	Maximum HI Gross for Pensioners
41	MITNR	☐	MITNR	CHAR15	CHAR	15	0	Membership Number
42	KVBAT	☐	KVBAT	SVBAT	CHAR	1	0	HI Contribution Distribution
43	RVBAT	☐	RVBAT	SVBAT	CHAR	1	0	PI Contribution Distribution
44	AVBAT	☐	AVBAT	SVBAT	CHAR	1	0	UI Contribution Distribution
45	SVA01	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
46	SVA02	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
47	SVA03	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
48	SVA04	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
49	SVA05	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
50	SVA06	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
51	SVA07	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
52	SVA08	☐	SVATT	SVATT	CHAR	2	0	SI Attribute	T5D1D
53	PVKZ1	☐	PVKZ1	SVSCH	CHAR	1	0	Care Insurance Indicator	T5D1Y
54	PVBKL	☐	P011_PVBKL	P011_PVBKL	CHAR	6	0	Care Insurance Contribution Scales for Voluntary Insurees	T5D1Z
55	PVFBT	☐	PVFBT	SVBTR	CURR	7	2	Care Insurance Amount
56	SONPV	☐	SONPV	P011_SONSV	CHAR	2	0	SI Special Rule CI	T5D1B
57	SELPV	☐	SELPV	XFELD	CHAR	1	0	Indicator Self-Payer CI
58	PVBFG	☐	PVBFG	P011_KVSVA	CHAR	1	0	Reason for CI Exemption	T5D12
59	PVBAT	☐	PVBAT	SVBAT	CHAR	1	0	CI Contribution Distribution
60	MAXPV	☐	MAXPV	SVBTR	CURR	7	2	Maxiumum CI Gross for Pensioners
61	AUVOR	☐	P01_AUVOR	P01_AUVOR	CHAR	1	0	Submission of Social Insurance ID Card
62	AUMIT	☐	P01_AUMIT	XFELD	CHAR	1	0	Obligation to Carry Social Insurance ID Card
63	.INCLUDE	☐				0	0	Return Parameter
64	TYPE	☐	BAPI_MTYPE	SYCHAR01	CHAR	1	0	Message type: S Success, E Error, W Warning, I Info, A Abort
65	ID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	T100A
66	NUMBER	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
67	MESSAGE	☐	BAPI_MSG	TEXT220	CHAR	220	0	Message Text
68	LOG_NO	☐	BALOGNR	BALOGNR	CHAR	20	0	Application log: log number	BALHDR
69	LOG_MSG_NO	☐	BALMNR	BALMNR	NUMC	6	0	Application log: Internal message serial number	BALM
70	MESSAGE_V1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
71	MESSAGE_V2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
72	MESSAGE_V3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
73	MESSAGE_V4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
74	PARAMETER	☐	BAPI_PARAM	SWC_ELEM	CHAR	32	0	Parameter Name
75	ROW	☐	BAPI_LINE	INT4	INT4	10	0	Lines in parameter
76	FIELD	☐	BAPI_FLD	FDNAME	CHAR	30	0	Field in parameter	*
77	SYSTEM	☐	BAPILOGSYS	LOGSYS	CHAR	10	0	Logical system from which message originates	*
78	KVGTX	☐	P011_KKTXT	TEXT30	CHAR	30	0	Text for HI Fund
79	TCLAS	☐	TCLAS	TCLAS	CHAR	1	0	Transaction Class for Data Retention
80	.INCLUDE	☐				0	0	EHS-INT: Reserve Structure to Link into Other Structures
81	RESEFLAG1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
82	RESEFLAG2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
83	RESEDOUBLE1	☐	TEXT2	UDCHA2	CHAR	2	0	Text
84	RESEDOUBLE2	☐	TEXT2	UDCHA2	CHAR	2	0	Text
85	RESETEXT1	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
86	RESETEXT2	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
87	RESETEXT3	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCHRS_SOCIALINSURANCE	AVBFG	T5D12	KVSVA	REF	C	CN
2	CCHRS_SOCIALINSURANCE	AVKZ1	T5D1Y	SVSCH
3	CCHRS_SOCIALINSURANCE	ID	T100A	ARBGB
4	CCHRS_SOCIALINSURANCE	INFTY	T582A	INFTY
5	CCHRS_SOCIALINSURANCE	KVBFG	T5D12	KVSVA	REF	C	CN
6	CCHRS_SOCIALINSURANCE	KVBKL	T5D1O	BTRKL
7	CCHRS_SOCIALINSURANCE	KVGST	T5D1K	KVGES
8	CCHRS_SOCIALINSURANCE	KVKZ1	T5D1Y	SVSCH
9	CCHRS_SOCIALINSURANCE	KVSFR	T5D11	KVSCH
10	CCHRS_SOCIALINSURANCE	LOG_MSG_NO	BALM	MSGNUMBER
11	CCHRS_SOCIALINSURANCE	LOG_NO	BALHDR	LOGNUMBER
12	CCHRS_SOCIALINSURANCE	PREAS	T530E	PREAS
13	CCHRS_SOCIALINSURANCE	PVBFG	T5D12	KVSVA	REF	C	CN
14	CCHRS_SOCIALINSURANCE	PVBKL	T5D1Z	BTRKL	REF	C	CN
15	CCHRS_SOCIALINSURANCE	PVKZ1	T5D1Y	SVSCH
16	CCHRS_SOCIALINSURANCE	RVBFG	T5D12	KVSVA	REF	C	CN
17	CCHRS_SOCIALINSURANCE	RVKZ1	T5D1Y	SVSCH
18	CCHRS_SOCIALINSURANCE	SONAV	T5D1B	SONRE	REF
19	CCHRS_SOCIALINSURANCE	SONKV	T5D1B	SONRE	REF
20	CCHRS_SOCIALINSURANCE	SONPV	T5D1B	SONRE	REF
21	CCHRS_SOCIALINSURANCE	SONRV	T5D1B	SONRE	REF
22	CCHRS_SOCIALINSURANCE	SVA01	T5D1D	SVATT
23	CCHRS_SOCIALINSURANCE	SVA02	T5D1D	SVATT
24	CCHRS_SOCIALINSURANCE	SVA03	T5D1D	SVATT
25	CCHRS_SOCIALINSURANCE	SVA04	T5D1D	SVATT
26	CCHRS_SOCIALINSURANCE	SVA05	T5D1D	SVATT
27	CCHRS_SOCIALINSURANCE	SVA06	T5D1D	SVATT
28	CCHRS_SOCIALINSURANCE	SVA07	T5D1D	SVATT
29	CCHRS_SOCIALINSURANCE	SVA08	T5D1D	SVATT
30	CCHRS_SOCIALINSURANCE	ZUSKA	T5D11	KVSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in