SAP ABAP Table PA0067 (HR master data infotype 0067 - Canadian garnishment: debt)

Hierarchy

☛ SAP_HRCCA (Software Component) Sub component SAP_HRCCA of SAP_HR
   ⤷ PY-CA (Application Component) Canada
     ⤷ PB7G (Package) HR Garnishment Canada

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0067	Table Relationship Diagram
Short Description	HR master data infotype 0067 - Canadian garnishment: debt

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	Garnishment debt
27	.INCLUDE	☐				0	0	Garnishment debt - International Part
28	IONUM	☐	P_IONUM	P_IONUM	NUMC	4	0	Internal order number
29	DBCOD	☐	P_DBCOD	P_DBCOD	CHAR	2	0	Debt code	*
30	CRCOD	☐	P_CRCOD	P_CRCOD	CHAR	3	0	Code for calculation rule	*
31	IDOTG	☐	PCA_IDOTG	XFLAG	CHAR	1	0	One-time garnishment
32	IDBAL	☐	PCA_IDBAL	PCA_BALCUR	CURR	9	2	Initial balance
33	IDOPA	☐	PCA_IDOPA	PCA_OPACUR	CURR	9	2	Amount of ongoing payment
34	IDOPU	☐	PCA_IDOPU	PCA_IDOPU	CHAR	1	0	Unit of ongoing payment
35	IDDEP	☐	PCA_IDDEP	PCA_NXEXD	NUMC	2	0	Number of dependants
36	IDNIE	☐	PCA_IDNIE	XFELD	CHAR	1	0	Is result of exemption calculation the exempt amount?
37	IDNIN	☐	PCA_IDNIN	XFELD	CHAR	1	0	Is result of exemption calculation the non-exempt amount?
38	IDNLP	☐	PCA_IDNLP	PCA_PERCNT	DEC	5	2	Percentage for overwriting garnishment rule limit
39	IDNUP	☐	PCA_IDNUP	PCA_NXUNP	CHAR	1	0	Unit of percentage limit for overwriting garnishment rule
40	IDNLF	☐	PCA_IDNLF	PCA_NXFCUR	CURR	9	2	Flat amount value for overwriting garnishment rule limit
41	IDNLD	☐	PCA_IDNLD	PCA_NXDCUR	CURR	9	2	Amount per dependant for overwriting rule limit
42	IDNUA	☐	PCA_IDNUA	PCA_NXUNA	CHAR	1	0	Unit of amount value for overwriting rule limit
43	IDNRL	☐	PCA_IDNRL	PCA_NXREL	CHAR	1	0	Relation between percentage and flat amount limits
44	IDSA1	☐	PCA_IDSA1	PCA_CUR9_2	CURR	9	2	Amount field 1 of special rule
45	IDSA2	☐	PCA_IDSA2	PCA_CUR9_2	CURR	9	2	Amount field 2 of special rule
46	IDSP1	☐	PCA_IDSP1	PCA_PERCNT	DEC	5	2	Percentage field 1 of special rule
47	IDSP2	☐	PCA_IDSP2	PCA_PERCNT	DEC	5	2	Percentage field 2 of special rule
48	ZEINH	☐	PFREQ	PFREQ	NUMC	2	0	Payroll time units
49	IDPA1	☐	PCA_IDSAM	PCA_OPACUR	CURR	9	2	Amount field in payment schedule
50	IDPA2	☐	PCA_IDSAM	PCA_OPACUR	CURR	9	2	Amount field in payment schedule
51	IDPA3	☐	PCA_IDSAM	PCA_OPACUR	CURR	9	2	Amount field in payment schedule
52	IDPA4	☐	PCA_IDSAM	PCA_OPACUR	CURR	9	2	Amount field in payment schedule
53	IDPA5	☐	PCA_IDSAM	PCA_OPACUR	CURR	9	2	Amount field in payment schedule
54	IDBTY	☐	PCA_IDBTY	PCA_IDBTY	CHAR	1	0	Type of initial balance
55	IDUDE	☐	PCA_IDUDE	XFELD	CHAR	1	0	Use dependants from infotype 21 for non-exempt model
56	IDORR	☐	PCA_IDORR	XFELD	CHAR	1	0	Override previous limits from higher priority debts
57	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0067	MANDT	T000	MANDT	KEY	1	CN
2	PA0067	PERNR	PA0003	PERNR	KEY	1	CN
3	PA0067	PREAS	T530E	PREAS	KEY	1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in