SAP ABAP Table T5JSI (HR Branch Office Information for Social Insurance JP)

Hierarchy

☛ SAP_HRCJP (Software Component) Sub component SAP_HRCJP of SAP_HR
   ⤷ PA-PA-JP (Application Component) Japan
     ⤷ PB22 (Package) HR master data: Japan

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5JSI	Table Relationship Diagram
Short Description	HR Branch Office Information for Social Insurance JP

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SCIMF	☑	P22J_SCIMF	P22J_SCIMF	CHAR	2	0	Social Insurance Modifier
3	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
4	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
6	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
7	ORT01	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
8	ORT02	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
9	STRAS	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
10	JGSNM	☐	P22J_JGSNM	TEXT50	CHAR	50	0	Name of Branch office
11	JGNPS	☐	P22J_JGNPS	TEXT20	CHAR	20	0	Title of Representative person
12	JGNPR	☐	P22J_JGNPR	TEXT40	CHAR	40	0	Name of Representative person
13	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
14	SCICA	☐	P22J_SCICA	TEXT8	CHAR	8	0	Social Insurance Code (Area)
15	SCICC	☐	P22J_SCICC	TEXT8	CHAR	8	0	Social Insurance Code (Name)
16	SCINR	☐	P22J_SCINR	TEXT5	CHAR	5	0	Social Insurance given number
17	SCICN	☐	P22J_SCICN	TEXT6	CHAR	6	0	Social Insurance Code (Number)
18	SCIHI	☐	P22J_SCIHI	TEXT8	CHAR	8	0	Office ID for HI Union
19	SCIPF	☐	P22J_SCIPF	TEXT8	CHAR	8	0	Office ID for Pension Fund
20	SCIPN	☐	P22J_SCIPN	TEXT8	CHAR	8	0	Office number for Pension Fund
21	HIRUL	☐	P22J_HIRUL	P22J_HIRUL	CHAR	1	0	Rule for Health Insurance in Santei/Geppen Process
22	EPRUL	☐	P22J_EPRUL	P22J_EPRUL	CHAR	1	0	Rule for Employee's Pension in Santei/Geppen
23	RULNI	☐	P22J_RULNI	P22J_RULNI	CHAR	1	0	Payment rule for Nursing insurance
24	PTRUL	☐	P22J_PTRUL	P22J_PTRUL	CHAR	1	0	Santei evaluation rule for parttime workers(Japan)
25	IKRUL	☐	P22J_IKRUL	P22J_IKRUL	CHAR	1	0	Basic specifications for IKKATSU TEKIYOU
26	SCICS	☐	P22J_SCICS	TEXT8	CHAR	8	0	Social insurance sign (area)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5JSI	COUNC	T005E	COUNC	KEY	1	CN
2	T5JSI	LAND1	T005	LAND1	KEY	1	CN
3	T5JSI	MANDT	T000	MANDT	KEY	1	CN
4	T5JSI	STATE	T005S	BLAND	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in