SAP ABAP Table PJP_RPCLIAJ1_ALV (ALV Structure for RPCLIAJ1)

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_RPCLIAJ1_ALV	Table Relationship Diagram
Short Description	ALV Structure for RPCLIAJ1

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	LBICC	☐	P22J_LBICC	TEXT14	CHAR	14	0	Labour Insurance Code
2	LBINO	☐	P22J_LBINO	TEXT11	CHAR	11	0	Number of Branch office for LI
3	JGSNM	☐	P22J_JGSNM	TEXT50	CHAR	50	0	Name of Branch office
4	LBIMF	☐	P22J_LBIMF	P22J_LBIMF	CHAR	2	0	Labour Insurance Modifier	T5JL1
5	SIPID	☐	P22J_LIPI1	P22J_LIPI1	CHAR	2	0	Labour Insurance Premium Rate	*
6	EPEPR_EI	☐	PJP_EPEPR_EI	DEC3_3	DEC	6	3	Employment Insurance Premium Rate for Employee
7	PRATE_EI	☐	PJP_PRATE_EI	DEC3_3	DEC	6	3	Employment Insurance Premium Rate for Branch Office
8	EPEPR_WI	☐	PJP_EPEPR_WI	DEC3_3	DEC	6	3	Worker's Insurance Premium Rate for Employee
9	PRATE_WI	☐	PJP_PRATE_WI	DEC3_3	DEC	6	3	Worker's Insurance Premium Rate for Branch Office
10	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
11	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	LAND1TX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
13	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
14	STATETX	☐	BEZEI20	TEXT20	CHAR	20	0	Description
15	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
16	COUNCTX	☐	BEZEI20	TEXT20	CHAR	20	0	Description
17	ORT01	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
18	ORT02	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
19	STRAS	☐	P22J_ADRLJ	TEXT30	CHAR	30	0	Line of Address in Kanji
20	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
21	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
22	WERKSTX	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
23	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
24	BTRTLTX	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
25	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
26	PERSGTX	☐	PGTXT	TEXT20	CHAR	20	0	Name of Employee Group
27	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
28	PERSKTX	☐	PKTXT	TEXT20	CHAR	20	0	Name of Employee Subgroup
29	EX_WERKS	☐	PJPSK_EX_WERKS	PERSA	CHAR	4	0	External Personnel Area	*
30	EX_WERKSTX	☐	PJPSK_EX_WERKSTX	TEXT30	CHAR	30	0	External Personnel Area - Text
31	EX_BTRTL	☐	PJPSK_EX_BTRTL	BTRTL	CHAR	4	0	External Personnel Subarea	*
32	EX_BTRTLTX	☐	PJPSK_EX_BTRTLTX	TEXT15	CHAR	15	0	External Personnel Subarea - Text
33	ORGEH	☐	PBAS_ORGEH	TEXT40	CHAR	40	0	Organizational Unit External
34	POSIT	☐	PBAS_POSIT	TEXT40	CHAR	40	0	External position/work center key
35	CONTTY	☐	PJPSK_CONTTY	PJPSK_CONTTY	CHAR	4	0	Shukko Contract Type	*
36	CONTTYTX	☐	PJPSK_CONTTY_T	PJPSK_TEXT40	CHAR	40	0	Shukko Contract Type Text
37	PARTNER	☐	PJPSK_PARTNER	PJPSK_PARTNER	CHAR	10	0	Shukko Partner	*
38	PARTNERTX	☐	PJPSK_PARTNER_T	PJPSK_TEXT40	CHAR	40	0	Shukko Partner Text
39	EI_INSURED	☐	PJPSK_EI_INSURED	XFELD	CHAR	1	0	Employement Insurance Insured Status in External Assignment
40	WI_INSURED	☐	PJPSK_WI_INSURED	XFELD	CHAR	1	0	Worker's Insurance Insured Status in External Assignment
41	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
42	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
43	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
44	SIIID_EI	☐	PJP_SIIID_EI	P22J_SIII1	CHAR	1	0	Entitlement Status of Employment Insurance	*
45	SIIID_EITX	☐	PJP_SIIID_EITX	TEXT24	CHAR	24	0	Entitlement Status of Employment Insurance Text (Infotype)
46	SIIID_WI	☐	PJP_SIIID_WI	P22J_SIII1	CHAR	1	0	Entitlement Status of Worker's Insurance	*
47	SIIID_WITX	☐	PJP_SIIID_WITX	TEXT24	CHAR	24	0	Entitlement Status of Worker Insurance Text (Infotype)
48	SIIID_EI_FPEND	☐	PJP_SIIID_EI_FPEND	P22J_SIII1	CHAR	1	0	Entitlement Status of Employment Insurance (FPEND)	*
49	SIIID_EITX_FPEND	☐	PJP_SIIID_EITX_FPEND	TEXT24	CHAR	24	0	Entitlement Status of Employment Insurance Text (Payroll RT)
50	SIIID_WI_FPEND	☐	PJP_SIIID_WI_FPEND	P22J_SIII1	CHAR	1	0	Entitlement Status of Worker's Insurance	*
51	SIIID_WITX_FPEND	☐	PJP_SIIID_WITX_FPEND	TEXT24	CHAR	24	0	Entitlement Status of Worker Insurance Text (Payroll RT)
52	FPPER	☐	FAPER	CHAR6	CHAR	6	0	For-period for payroll
53	FPBEG	☐	FPBEG	DATUM	DATS	8	0	Start date of payroll period (FOR period)
54	FPEND	☐	FPEND	DATUM	DATS	8	0	End of payroll period (for-period)
55	PAYDT	☐	PAY_DATE	DATUM	DATS	8	0	Pay date for payroll result
56	OCRSN	☐	PAY_OCRSN	PAY_OCRSN	CHAR	4	0	Reason for Off-Cycle Payroll	T52OCR
57	OCRTX	☐	PAY_OCRTX	TEXT40	CHAR	40	0	Reason for Off-Cycle Payroll: Text
58	OCCAT	☐	PAY_OCCAT	PAY_OCCAT	CHAR	2	0	Category for off-cycle reason	T52OCC
59	OCCTX	☐	PAY_OCCTX	TEXT40	CHAR	40	0	Category for off-cycle reason - text
60	PAYTY	☐	PAYTY	PAYTY	CHAR	1	0	Payroll type
61	PAYTYTX	☐	PJP_PAYTYTX	DDTEXT	CHAR	60	0	Payroll Type Text
62	PAYID	☐	PAYID	CHAR1	CHAR	1	0	Payroll Identifier
63	BETRG107	☐	PJP_BETRG107	PRBETRG	CURR	15	2	Payroll Amount: WT /107 -Wage Amount (Labour Insurance)
64	BETRG1E7	☐	PJP_BETRG1E7	PRBETRG	CURR	15	2	Payroll Amount: WT /1E7 -Wage Amount (Employment Insurance)
65	BETRG1W7	☐	PJP_BETRG1W7	PRBETRG	CURR	15	2	Payroll Amount: WT /1W7 -Wage Amount (Worker's Insurance)
66	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
67	REC_COUNT	☐	PJP_ALV_REC_COUNT		INT4	10	0	Dummy Field to Count Number of Records inALV
68	REC_COUNT_EI	☐	PJP_ALV_REC_COUNT_EI		INT4	10	0	Dummy Field to Count Number of Records inALV
69	REC_COUNT_WI	☐	PJP_ALV_REC_COUNT_WI		INT4	10	0	Dummy Field to Count Number of Records inALV
70	BETRG1EE	☐	PJP_BETRG1EE	PRBETRG	CURR	15	2	Payroll Amount: WT /1EE -Exemption Amount (EI)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PJP_RPCLIAJ1_ALV	BTRTL	T001P	BTRTL
2	PJP_RPCLIAJ1_ALV	COUNC	T005E	COUNC
3	PJP_RPCLIAJ1_ALV	LAND1	T005	LAND1
4	PJP_RPCLIAJ1_ALV	LBIMF	T5JL1	LBIMF
5	PJP_RPCLIAJ1_ALV	OCCAT	T52OCC	OCCAT
6	PJP_RPCLIAJ1_ALV	OCRSN	T52OCR	OCRSN
7	PJP_RPCLIAJ1_ALV	PERSG	T501	PERSG
8	PJP_RPCLIAJ1_ALV	PERSK	T503K	PERSK
9	PJP_RPCLIAJ1_ALV	STATE	T005S	BLAND
10	PJP_RPCLIAJ1_ALV	WAERS	TCURC	WAERS
11	PJP_RPCLIAJ1_ALV	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20131127
SAP Release Created in	700