SAP ABAP Table P22J_RPCSIBJ0_DATA1 (app conversion for RPCSIBJ0)

Hierarchy

☛ SAP_HRCJP (Software Component) Sub component SAP_HRCJP of SAP_HR
   ⤷ PY-JP (Application Component) Japan
     ⤷ PC22 (Package) HR accounting: Japan

Basic Data

Table Category	INTTAB	Structure
Structure	P22J_RPCSIBJ0_DATA1	Table Relationship Diagram
Short Description	app conversion for RPCSIBJ0

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	SITEXT	☐	P22J_SCITX	TEXT24	CHAR	24	0	Indicator for Social Insurance Insured
2	.INCLUDE	☐				0	0	Evaluation Result: SANTEI/GEPPEN (Japan)
3	MOCSI	☐	P22J_MOCSI	CHAR6	CHAR	6	0	First month of calculation of SI premium (Japan)
4	SITID	☐	P22J_SITID	SUBTY	CHAR	4	0	Social Insurance Type Indicator
5	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	GENDR	☐	P22J_SIGEN	P22J_SIGEN	CHAR	1	0	Social insurance gender ID
7	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
8	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
9	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
10	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
11	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
12	SCIMF	☐	P22J_SCIMF	P22J_SCIMF	CHAR	2	0	Social Insurance Modifier	*
13	SIINR	☐	P22J_SIINR	P22J_SIINR	CHAR	15	0	Insurance number
14	SIPNR	☐	P22J_SIPNR	P22J_SIPNR	CHAR	15	0	Pension number
15	SIIID	☐	P22J_SIID2	CHAR1	CHAR	1	0	EE's SI status for reporting
16	EALID	☐	P22J_EALI1	P22J_EALI1	CHAR	1	0	Acquired/Lost	*
17	ALDAT	☐	P22J_ALDAT	DATE	DATS	8	0	SI Last Acquire/Lost Date
18	PREGR	☐	P22J_PREGR	NUMC2	NUMC	2	0	SI Last Grade
19	PRESC	☐	P22J_PRESC	WERT05	CURR	9	2	SI Last Standard Compensation
20	AVGCB	☐	P22J_AVGCB	WERT6	CURR	11	2	Compensation Average Amount (before)
21	SGRUL	☐	P22J_SGRUL	TEXT1	CHAR	1	0	SI Santei/Geppen Rule
22	FCPRE	☐	P22J_FCPRE	WERT6	CURR	11	2	Previous Month of Calculation of premium Fixed Compensation
23	EX1ST	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
24	PB1ST	☐	P22J_PB1ST	P22J_PBDYS	NUMC	2	0	Payment Basis Days 1st Month
25	FC1ST	☐	P22J_FC1ST	WERT6	CURR	11	2	Fixed Compensation 1st Month
26	WC1ST	☐	P22J_WC1ST	WERTV5	CURR	9	2	SI Wage Cut 1st Month
27	CM1ST	☐	P22J_CM1ST	WERT05	CURR	9	2	Compensation Amount (Money) 1st Month
28	CK1ST	☐	P22J_CK1ST	WERT05	CURR	9	2	Compensation amount (benefits in kind) 1st month
29	CA1ST	☐	P22J_CA1ST	WERT6	CURR	11	2	Compensation Amount 1st Month
30	XM1ST	☐	P22J_XM1ST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 1st Month
31	XK1ST	☐	P22J_XK1ST	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 1st Month
32	XA1ST	☐	P22J_XA1ST	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 1st Month
33	EX2ND	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
34	PB2ND	☐	P22J_PB2ND	P22J_PBDYS	NUMC	2	0	Payment Basis Days 2nd Month
35	FC2ND	☐	P22J_FC2ND	WERT6	CURR	11	2	Fixed Compensation 2nd Month
36	WC2ND	☐	P22J_WC2ND	WERTV5	CURR	9	2	SI Wage Cut 2nd Month
37	CM2ND	☐	P22J_CM2ND	WERT05	CURR	9	2	Compensation Amount (Money) 2nd Month
38	CK2ND	☐	P22J_CK2ND	WERT05	CURR	9	2	Compensation amount (benefits in kind) 2nd month
39	CA2ND	☐	P22J_CA2ND	WERT6	CURR	11	2	Compensation Amount 2nd Month
40	XM2ND	☐	P22J_XM2ND	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 2nd Month
41	XK2ND	☐	P22J_XK2ND	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 2nd Month
42	XA2ND	☐	P22J_XA2ND	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 2nd Month
43	EX3RD	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
44	PB3RD	☐	P22J_PB3RD	P22J_PBDYS	NUMC	2	0	Payment Basis Days 3rd Month
45	FC3RD	☐	P22J_FC3RD	WERT6	CURR	11	2	Fixed Compensation 3rd Month
46	WC3RD	☐	P22J_WC3RD	WERTV5	CURR	9	2	SI Wage Cut 3rd Month
47	CM3RD	☐	P22J_CM3RD	WERT05	CURR	9	2	Compensation Amount (Money) 3rd Month
48	CK3RD	☐	P22J_CK3RD	WERT05	CURR	9	2	Compensation amount (Benefits in kind) 3rd month
49	CA3RD	☐	P22J_CA3RD	WERT6	CURR	11	2	Compensation Amount 3rd Month
50	XM3RD	☐	P22J_XM3RD	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 3rd Month
51	XK3RD	☐	P22J_XK3RD	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 3rd Month
52	XA3RD	☐	P22J_XA3RD	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 3rd Month
53	MOFCC	☐	P22J_MOFCC	CHAR6	CHAR	6	0	Month when fixed compensation changes
54	DFPID	☐	P22J_DFPID	WERTV5	CURR	9	2	Difference Amount after Pay Increase/Decrease
55	RCALP	☐	P22J_RCALP	WERTV5	CURR	9	2	Recalculation Payment
56	AMTCA	☐	P22J_AMTCA	WERT7	CURR	13	2	Total compensation amount
57	AVGCA	☐	P22J_AVGCA	WERT6	CURR	11	2	Compensation Average Amount
58	AVGXM	☐	P22J_AVGXM	WERT05	CURR	9	2	Monthly average compensation
59	AVGXK	☐	P22J_AVGXK	WERT05	CURR	9	2	Monthly average compensation (benefit in kinds)
60	AVGXA	☐	P22J_AVGXA	WERT6	CURR	11	2	Monthly average compensation total
61	FIXGR	☐	P22J_FIXGR	NUMC2	NUMC	2	0	SI Fixed Grade
62	FIXSC	☐	P22J_FIXSC	WERT05	CURR	9	2	SI Fixed Standard Compensation
63	GEPFL	☐	P22J_GEPFL	CHAR1	CHAR	1	0	SI Geppen Fixed
64	CANFL	☐	P22J_CANFL	P22J_CANFL	CHAR	1	0	SI Geppen Candidate Fixed
65	SNTFL	☐	P22J_SNTFL	CHAR1	CHAR	1	0	SI Santei Fixed
66	LSTFL	☐	P22J_LSTFL	CHAR1	CHAR	1	0	SI lost indicator for Ikkatsu-Tekiyou
67	SASTA	☐	P22J_SASTA	P22J_SASTA	CHAR	1	0	SI Hokensya-Santei Status
68	CDATE	☐	P22J_CDATE	DATS	DATS	8	0	SI Hokensya-Santei Last Change Date
69	CTIME	☐	P22J_CTIME	TIME	TIMS	6	0	SI Hokensya-Santei Last Change Time
70	CUSER	☐	P22J_CUSER	CHAR12	CHAR	12	0	SI Hokensya-Santei Last Change User
71	BKTID	☐	P22J_BKTID	TEXT3	CHAR	3	0	Santei/Geppen Form Remark Text ID
72	ENAME	☐	P22J_EMNAM	TEXT40	CHAR	40	0	Name of employee
73	KNAME	☐	P22J_KNAME	TEXT50	CHAR	50	0	Kana Name of Employee
74	PRNFL	☐	PJP_PRNFL	PJP_PRNFL	CHAR	1	0	SI Status (Geppen at the Termination of Parental Leave)
75	STEXT	☐	P22J_STEXT	TEXT20	CHAR	20	0	SI Santei Adjustment Status Text
76	.INCLUDE	☐				0	0	Evaluation Result: SANTEI/GEPPEN Annual (Japan)
77	AHSFL	☐	PJP_AHSFL	PJP_AHSFL	CHAR	1	0	Applicability of Hokensha-Santei by Annual Average
78	NAAHS	☐	PJP_NAAHS	PJP_NAAHS	CHAR	1	0	Non-Application of Annual Average Hokensha-Santei
79	EXEP1	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
80	PBEP1	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
81	CMEP1	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
82	CKEP1	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
83	CAEP1	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
84	XMEP1	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
85	XKEP1	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
86	XAEP1	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
87	WCEP1	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
88	KSEP1	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
89	EXEP2	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
90	PBEP2	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
91	CMEP2	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
92	CKEP2	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
93	CAEP2	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
94	XMEP2	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
95	XKEP2	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
96	XAEP2	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
97	WCEP2	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
98	KSEP2	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
99	EXEP3	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
100	PBEP3	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
101	CMEP3	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
102	CKEP3	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
103	CAEP3	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
104	XMEP3	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
105	XKEP3	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
106	XAEP3	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
107	WCEP3	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
108	KSEP3	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
109	EXEP4	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
110	PBEP4	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
111	CMEP4	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
112	CKEP4	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
113	CAEP4	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
114	XMEP4	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
115	XKEP4	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
116	XAEP4	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
117	WCEP4	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
118	KSEP4	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
119	EXEP5	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
120	PBEP5	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
121	CMEP5	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
122	CKEP5	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
123	CAEP5	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
124	XMEP5	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
125	XKEP5	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
126	XAEP5	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
127	WCEP5	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
128	KSEP5	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
129	EXEP6	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
130	PBEP6	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
131	CMEP6	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
132	CKEP6	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
133	CAEP6	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
134	XMEP6	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
135	XKEP6	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
136	XAEP6	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
137	WCEP6	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
138	KSEP6	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
139	EXEP7	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
140	PBEP7	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
141	CMEP7	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
142	CKEP7	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
143	CAEP7	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
144	XMEP7	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
145	XKEP7	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
146	XAEP7	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
147	WCEP7	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
148	KSEP7	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
149	EXEP8	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
150	PBEP8	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
151	CMEP8	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
152	CKEP8	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
153	CAEP8	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
154	XMEP8	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
155	XKEP8	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
156	XAEP8	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
157	WCEP8	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
158	KSEP8	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
159	EXEP9	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
160	PBEP9	☐	PJP_PBPST	P22J_PBDYS	NUMC	2	0	Payment Basis Days in Month (Annual Average)
161	CMEP9	☐	PJP_CMPST	WERT05	CURR	9	2	Compensation Amount (Money) in Month (Annual Average)
162	CKEP9	☐	PJP_CKPST	WERT05	CURR	9	2	Compensation amount (benefits in kind) in Month (Annual)
163	CAEP9	☐	PJP_CAPST	WERT6	CURR	11	2	Compensation Amount in Month (Annual Average)
164	XMEP9	☐	PJP_XMPST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjust.) in Month (Annual)
165	XKEP9	☐	PJP_XKPST	WERT05	CURR	9	2	Comp. Amount(Ben. in Kind, after Adjust.) in Month (Annual)
166	XAEP9	☐	PJP_XAPST	WERT6	CURR	11	2	Compensation Amount (after first Adjust.) in Month (Annual)
167	WCEP9	☐	PJP_WCPST	WERTV5	CURR	9	2	SI Wage Cut in Month (Annual)
168	KSEP9	☐	PJP_KSPST	CHAR1	CHAR	1	0	Kyusyoku Flag in Month (Annual)
169	AMTEA	☐	PJP_AMTEA	WERT7	CURR	13	2	Total Compensation Amount (Exclusion Month Excluded)
170	AVGEA	☐	PJP_AVGEA	WERT6	CURR	11	2	Compensation Average Amount (Exclusion Month Excluded)
171	EXCGR	☐	PJP_EXCGR	NUMC2	NUMC	2	0	SI Fixed Grade (Exclusion Month Excluded)
172	EXCSC	☐	PJP_EXCSC	WERT05	CURR	9	2	SI Fixed Standard Compensation (Exclusion Month Excluded)
173	AMTAA	☐	PJP_AMTAA	WERT7	CURR	13	2	Annual Total Compensation Amount
174	AVGAA	☐	P22J_AVGAA	WERT6	CURR	11	2	Annual Average Compensation
175	YAVGR	☐	PJP_YAVGR	NUMC2	NUMC	2	0	SI Fixed Grade Annual Average
176	YAVSC	☐	PJP_YAVSC	WERT05	CURR	9	2	SI Fixed Standard Compensation Annual Average
177	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

History

Last changed by/on	SAP	20130529
SAP Release Created in