SAP ABAP Table PJP_SIFD_SANTEI_GEPPEN (Communication structure for SI FD SANTEI/GEPPEN)

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	PJP_SIFD_SANTEI_GEPPEN	Table Relationship Diagram
Short Description	Communication structure for SI FD SANTEI/GEPPEN

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	.INCLUDE	☐				0	0	Evaluation Result: SANTEI/GEPPEN (Japan)
2	MOCSI	☐	P22J_MOCSI	CHAR6	CHAR	6	0	First month of calculation of SI premium (Japan)
3	SITID	☐	P22J_SITID	SUBTY	CHAR	4	0	Social Insurance Type Indicator
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	GENDR	☐	P22J_SIGEN	P22J_SIGEN	CHAR	1	0	Social insurance gender ID
6	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
7	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
8	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
9	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
10	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
11	SCIMF	☐	P22J_SCIMF	P22J_SCIMF	CHAR	2	0	Social Insurance Modifier	*
12	SIINR	☐	P22J_SIINR	P22J_SIINR	CHAR	15	0	Insurance number
13	SIPNR	☐	P22J_SIPNR	P22J_SIPNR	CHAR	15	0	Pension number
14	SIIID	☐	P22J_SIID2	CHAR1	CHAR	1	0	EE's SI status for reporting
15	EALID	☐	P22J_EALI1	P22J_EALI1	CHAR	1	0	Acquired/Lost	*
16	ALDAT	☐	P22J_ALDAT	DATE	DATS	8	0	SI Last Acquire/Lost Date
17	PREGR	☐	P22J_PREGR	NUMC2	NUMC	2	0	SI Last Grade
18	PRESC	☐	P22J_PRESC	WERT05	CURR	9	2	SI Last Standard Compensation
19	AVGCB	☐	P22J_AVGCB	WERT6	CURR	11	2	Compensation Average Amount (before)
20	SGRUL	☐	P22J_SGRUL	TEXT1	CHAR	1	0	SI Santei/Geppen Rule
21	FCPRE	☐	P22J_FCPRE	WERT6	CURR	11	2	Previous Month of Calculation of premium Fixed Compensation
22	EX1ST	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
23	PB1ST	☐	P22J_PB1ST	P22J_PBDYS	NUMC	2	0	Payment Basis Days 1st Month
24	FC1ST	☐	P22J_FC1ST	WERT6	CURR	11	2	Fixed Compensation 1st Month
25	WC1ST	☐	P22J_WC1ST	WERTV5	CURR	9	2	SI Wage Cut 1st Month
26	CM1ST	☐	P22J_CM1ST	WERT05	CURR	9	2	Compensation Amount (Money) 1st Month
27	CK1ST	☐	P22J_CK1ST	WERT05	CURR	9	2	Compensation amount (benefits in kind) 1st month
28	CA1ST	☐	P22J_CA1ST	WERT6	CURR	11	2	Compensation Amount 1st Month
29	XM1ST	☐	P22J_XM1ST	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 1st Month
30	XK1ST	☐	P22J_XK1ST	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 1st Month
31	XA1ST	☐	P22J_XA1ST	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 1st Month
32	EX2ND	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
33	PB2ND	☐	P22J_PB2ND	P22J_PBDYS	NUMC	2	0	Payment Basis Days 2nd Month
34	FC2ND	☐	P22J_FC2ND	WERT6	CURR	11	2	Fixed Compensation 2nd Month
35	WC2ND	☐	P22J_WC2ND	WERTV5	CURR	9	2	SI Wage Cut 2nd Month
36	CM2ND	☐	P22J_CM2ND	WERT05	CURR	9	2	Compensation Amount (Money) 2nd Month
37	CK2ND	☐	P22J_CK2ND	WERT05	CURR	9	2	Compensation amount (benefits in kind) 2nd month
38	CA2ND	☐	P22J_CA2ND	WERT6	CURR	11	2	Compensation Amount 2nd Month
39	XM2ND	☐	P22J_XM2ND	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 2nd Month
40	XK2ND	☐	P22J_XK2ND	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 2nd Month
41	XA2ND	☐	P22J_XA2ND	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 2nd Month
42	EX3RD	☐	P22J_EXCLD	CHAR1	CHAR	1	0	SI Exclusion ind. from calculation
43	PB3RD	☐	P22J_PB3RD	P22J_PBDYS	NUMC	2	0	Payment Basis Days 3rd Month
44	FC3RD	☐	P22J_FC3RD	WERT6	CURR	11	2	Fixed Compensation 3rd Month
45	WC3RD	☐	P22J_WC3RD	WERTV5	CURR	9	2	SI Wage Cut 3rd Month
46	CM3RD	☐	P22J_CM3RD	WERT05	CURR	9	2	Compensation Amount (Money) 3rd Month
47	CK3RD	☐	P22J_CK3RD	WERT05	CURR	9	2	Compensation amount (Benefits in kind) 3rd month
48	CA3RD	☐	P22J_CA3RD	WERT6	CURR	11	2	Compensation Amount 3rd Month
49	XM3RD	☐	P22J_XM3RD	WERT05	CURR	9	2	Compensation Amount (Money, after Adjustment) 3rd Month
50	XK3RD	☐	P22J_XK3RD	WERT05	CURR	9	2	Compensation Amount (Ben. in Kind, after Adjust.) 3rd Month
51	XA3RD	☐	P22J_XA3RD	WERT6	CURR	11	2	Compensation Amount (after first Adjustment) 3rd Month
52	MOFCC	☐	P22J_MOFCC	CHAR6	CHAR	6	0	Month when fixed compensation changes
53	DFPID	☐	P22J_DFPID	WERTV5	CURR	9	2	Difference Amount after Pay Increase/Decrease
54	RCALP	☐	P22J_RCALP	WERTV5	CURR	9	2	Recalculation Payment
55	AMTCA	☐	P22J_AMTCA	WERT7	CURR	13	2	Total compensation amount
56	AVGCA	☐	P22J_AVGCA	WERT6	CURR	11	2	Compensation Average Amount
57	AVGXM	☐	P22J_AVGXM	WERT05	CURR	9	2	Monthly average compensation
58	AVGXK	☐	P22J_AVGXK	WERT05	CURR	9	2	Monthly average compensation (benefit in kinds)
59	AVGXA	☐	P22J_AVGXA	WERT6	CURR	11	2	Monthly average compensation total
60	FIXGR	☐	P22J_FIXGR	NUMC2	NUMC	2	0	SI Fixed Grade
61	FIXSC	☐	P22J_FIXSC	WERT05	CURR	9	2	SI Fixed Standard Compensation
62	GEPFL	☐	P22J_GEPFL	CHAR1	CHAR	1	0	SI Geppen Fixed
63	CANFL	☐	P22J_CANFL	P22J_CANFL	CHAR	1	0	SI Geppen Candidate Fixed
64	SNTFL	☐	P22J_SNTFL	CHAR1	CHAR	1	0	SI Santei Fixed
65	LSTFL	☐	P22J_LSTFL	CHAR1	CHAR	1	0	SI lost indicator for Ikkatsu-Tekiyou
66	SASTA	☐	P22J_SASTA	P22J_SASTA	CHAR	1	0	SI Hokensya-Santei Status
67	CDATE	☐	P22J_CDATE	DATS	DATS	8	0	SI Hokensya-Santei Last Change Date
68	CTIME	☐	P22J_CTIME	TIME	TIMS	6	0	SI Hokensya-Santei Last Change Time
69	CUSER	☐	P22J_CUSER	CHAR12	CHAR	12	0	SI Hokensya-Santei Last Change User
70	BKTID	☐	P22J_BKTID	TEXT3	CHAR	3	0	Santei/Geppen Form Remark Text ID
71	ENAME	☐	P22J_EMNAM	TEXT40	CHAR	40	0	Name of employee
72	KNAME	☐	P22J_KNAME	TEXT50	CHAR	50	0	Kana Name of Employee
73	PRNFL	☐	PJP_PRNFL	PJP_PRNFL	CHAR	1	0	SI Status (Geppen at the Termination of Parental Leave)
74	FORM_CODE	☐			NUMC	8	0
75	.INCLUDE	☐				0	0	Communication Structure of SI Office Data for SI FD
76	GUNSHIKU_ID	☐			CHAR	8	0
77	SI_OFFICE_ID	☐			CHAR	8	0
78	PRESC_HI	☐	P22J_PRESC	WERT05	CURR	9	2	SI Last Standard Compensation
79	FIXSC_HI	☐	P22J_FIXSC	WERT05	CURR	9	2	SI Fixed Standard Compensation
80	PRESC_EP	☐	P22J_PRESC	WERT05	CURR	9	2	SI Last Standard Compensation
81	FIXSC_EP	☐	P22J_FIXSC	WERT05	CURR	9	2	SI Fixed Standard Compensation
82	SORT_NUMBER	☐			INT4	10	0
83	KAITEI_DATE	☐			DATS	8	0
84	TEKIYOU_DATE	☐			DATS	8	0
85	SANTEI_KISO_MONTH1	☐			CHAR	2	0
86	SANTEI_KISO_MONTH2	☐			CHAR	2	0
87	SANTEI_KISO_MONTH3	☐			CHAR	2	0
88	INC_DEC_ID	☐	PJP_INC_DEC_ID		CHAR	1	0	Indicator (Increase/Decrease in Payment)
89	REMARKS	☐	PJP_REMARKS		STRG	0	0	Remarks Column

History

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