SAP ABAP Table PA0476 (HR master record infotype 0476 (Deductions Spain))

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-XX (Application Component) Payroll: General Parts
     ⤷ PGAR (Package) HR Garnishments

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0476	Table Relationship Diagram
Short Description	HR master record infotype 0476 (Deductions Spain)

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	HR master data: Infotype 476: Garnishments: Order
27	.INCLUDE	☐				0	0	Garnishment order - International part
28	IONUM	☐	P_IONUMR		NUMC	4	0	Case Number (Internal) for Garnishment Order
29	JURIS	☐	P_JURISD	P_JURISD	CHAR	4	0	Code for jurisdiction	T53G0
30	GCATE	☐	P_GCATG		CHAR	1	0	Code for Garnishment Category	T53G1
31	DFPRI	☐	P_DFPRO		NUMC	3	0	Priority of Order for Garnishment
32	GFCOD	☐	P_GFCODE	P_GFCODE	CHAR	3	0	Service Charge Rule	*
33	.INCLUDE	☐				0	0	Transfer
34	.INCLUDE	☐				0	0	Transfer
35	PRITY1	☐	P_PRITY	TEXT1	CHAR	1	0	Transfer Priority
36	PRITY2	☐	P_PRITY	TEXT1	CHAR	1	0	Transfer Priority
37	PRITY3	☐	P_PRITY	TEXT1	CHAR	1	0	Transfer Priority
38	UENBN1	☐	P_UEBNO	XFELD	CHAR	1	0	Missing Transfer Indicator
39	UENBN2	☐	P_UEBNO	XFELD	CHAR	1	0	Missing Transfer Indicator
40	UENBN3	☐	P_UEBNO	XFELD	CHAR	1	0	Missing Transfer Indicator
41	SKENN1	☐	P_SKENN	XFELD	CHAR	1	0	Transfer of Main Claim
42	SKENN2	☐	P_SKENN	XFELD	CHAR	1	0	Transfer of Main Claim
43	SKENN3	☐	P_SKENN	XFELD	CHAR	1	0	Transfer of Main Claim
44	KKENN1	☐	P_KKENN	XFELD	CHAR	1	0	Transfer of Costs
45	KKENN2	☐	P_KKENN	XFELD	CHAR	1	0	Transfer of Costs
46	KKENN3	☐	P_KKENN	XFELD	CHAR	1	0	Transfer of Costs
47	SBETR1	☐	P_SBETR	PG_CURR	CURR	8	2	Transfer Amount Main Claim
48	SBETR2	☐	P_SBETR	PG_CURR	CURR	8	2	Transfer Amount Main Claim
49	SBETR3	☐	P_SBETR	PG_CURR	CURR	8	2	Transfer Amount Main Claim
50	KBETR1	☐	P_KBETR	PG_CURR	CURR	8	2	Transfer Amout Costs
51	KBETR2	☐	P_KBETR	PG_CURR	CURR	8	2	Transfer Amout Costs
52	KBETR3	☐	P_KBETR	PG_CURR	CURR	8	2	Transfer Amout Costs
53	SPROZ1	☐	P_SPROZ	DEC4	DEC	4	0	Transfer Percentage Main Claim
54	SPROZ2	☐	P_SPROZ	DEC4	DEC	4	0	Transfer Percentage Main Claim
55	SPROZ3	☐	P_SPROZ	DEC4	DEC	4	0	Transfer Percentage Main Claim
56	KPROZ1	☐	P_KPROZ	DEC4	DEC	4	0	Transfer Percentage Costs
57	KPROZ2	☐	P_KPROZ	DEC4	DEC	4	0	Transfer Percentage Costs
58	KPROZ3	☐	P_KPROZ	DEC4	DEC	4	0	Transfer Percentage Costs
59	.INCLUDE	☐				0	0	Third Pary Remittance
60	CRETY	☐	CRETY	CRETY	CHAR	1	0	HR payee type
61	CRENR	☐	CRENR	CRENR	NUMC	8	0	HR payee number	T51RH
62	LIFNR1	☐	P_LIFNR	LIFNR	CHAR	10	0	Vendor	LFA1
63	LIFNR2	☐	P_LIFNR	LIFNR	CHAR	10	0	Vendor	LFA1
64	LIFNR3	☐	P_LIFNR	LIFNR	CHAR	10	0	Vendor	LFA1
65	AGCOD	☐	P_AGYCD		CHAR	1	0	Code for Garnishment Agency
66	LIFSG1	☐	ACSUB	NUMC5	NUMC	5	0	Vendor subgroup
67	LIFSG2	☐	ACSUB	NUMC5	NUMC	5	0	Vendor subgroup
68	LIFSG3	☐	ACSUB	NUMC5	NUMC	5	0	Vendor subgroup
69	RULNR	☐	P_IOREM	RULNR	NUMC	5	0	Remittance Rule	T51RK
70	IOSCI	☐	P_IOSCI	XFLAG	CHAR	1	0	Single cheque indicator
71	IOPAY	☐	P_IOPAY	XFELD	CHAR	1	0	Make Check Payable to Plaintiff
72	IOANM	☐	P_IOANM	TEXT40	CHAR	40	0	Agency Name
73	IOAST	☐	P_IOAST	TEXT35	CHAR	35	0	Agency Street
74	IOAPC	☐	P_IOAPC	TEXT3	CHAR	3	0	Agency Postal Code
75	IOAPR	☐	P_IOAPR	REGIO	CHAR	3	0	Agency Province	T005S
76	IOACO	☐	P_IOACO	LAND1	CHAR	3	0	Agency Country	T005
77	IOAPH	☐	P_IOAPH	LAND1	CHAR	3	0	Agency Coutry	*
78	IOPLN1	☐	P_IOPLN	TEXT40	CHAR	40	0	Plaintiff 1
79	IOPLN2	☐	P_IOPLN	TEXT40	CHAR	40	0	Plaintiff 1
80	IOPLN3	☐	P_IOPLN	TEXT40	CHAR	40	0	Plaintiff 1
81	.INCLUDE	☐				0	0	Bank Transfer
82	EMFSL1	☐	P_EMFSL	TEXT8	CHAR	8	0	Payee Key
83	EMFSL2	☐	P_EMFSL	TEXT8	CHAR	8	0	Payee Key
84	EMFSL3	☐	P_EMFSL	TEXT8	CHAR	8	0	Payee Key
85	EMFTX1	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
86	EMFTX2	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
87	EMFTX3	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
88	STRAS	☐	P_STRAS	TEXT8	CHAR	8	0	Payee Street
89	BKPLZ1	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
90	BKPLZ2	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
91	BKPLZ3	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
92	BKORT1	☐	ORT01	TEXT25	CHAR	25	0	City
93	BKORT2	☐	ORT01	TEXT25	CHAR	25	0	City
94	BKORT3	☐	ORT01	TEXT25	CHAR	25	0	City
95	BANKS1	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
96	BANKS2	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
97	BANKS3	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
98	BANKL1	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
99	BANKL2	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
100	BANKL3	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
101	BANKN1	☐	BANKN	BANKN	CHAR	18	0	Bank account number
102	BANKN2	☐	BANKN	BANKN	CHAR	18	0	Bank account number
103	BANKN3	☐	BANKN	BANKN	CHAR	18	0	Bank account number
104	ZLSCH1	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
105	ZLSCH2	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
106	ZLSCH3	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
107	ZWECK1	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
108	ZWECK2	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
109	ZWECK3	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
110	.INCLUDE	☐				0	0	Service Charge
111	AGKEM	☐	P_AGKEM	P_AGKEM	CHAR	1	0	Unit Service Charge
112	AGKPZ	☐	P_AGKPZ		DEC	4	0	Percentage Service Charge
113	AGKBT	☐	P_AGKBT		CURR	9	2	Amount for Service Charge
114	AGKHB	☐	P_AGKHB		CURR	9	2	Maximum Amount
115	AGKMB	☐	P_AGKMB		CURR	9	2	Minimum Amount for Service Charge
116	AGKMU	☐	P_AGKMU		CURR	9	2	Minimum Transfer
117	AGUEB	☐	P_AGUEB		CHAR	1	0	Transfer Number
118	AGEIN	☐	P_AGEIN	P_AGEIN	CHAR	1	0	Type of Withholding
119	IOCN1	☐	P_IOCN1	TEXT25	CHAR	25	0	Case Number 1
120	IOCN2	☐	P_IOCN2	TEXT25	CHAR	25	0	Case Number 2
121	IOCTD	☐	P_IOCTD		DATS	8	0	Court Order Date
122	IORCD	☐	P_IORCD		DATS	8	0	Received Date
123	IORHR	☐	P_IORHR		TIMS	6	0	Received Hour
124	IORLD	☐	P_IORLD		DATS	8	0	Release Date
125	IOSTS	☐	P_IOSTS	P_IOSTS	CHAR	1	0	Garnishment Order Status
126	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0476	BANKS1	T005	LAND1
2	PA0476	BANKS2	T005	LAND1
3	PA0476	BANKS3	T005	LAND1
4	PA0476	CRENR	T51RH	CRENR	REF	1	CN
5	PA0476	GCATE	T53G1	GCATE	REF	1	CN
6	PA0476	IOACO	T005	LAND1	REF	1	CN
7	PA0476	IOAPR	T005S	BLAND	REF	1	CN
8	PA0476	JURIS	T53G0	JURIS	REF	1	CN
9	PA0476	LIFNR1	LFA1	LIFNR
10	PA0476	LIFNR2	LFA1	LIFNR
11	PA0476	LIFNR3	LFA1	LIFNR
12	PA0476	MANDT	T000	MANDT	KEY	1	CN
13	PA0476	PERNR	PA0003	PERNR
14	PA0476	PREAS	T530E	PREAS
15	PA0476	RULNR	T51RK	RULNR	REF	1	CN
16	PA0476	WAERS	TCURC	WAERS
17	PA0476	ZLSCH1	T042Z	ZLSCH
18	PA0476	ZLSCH2	T042Z	ZLSCH
19	PA0476	ZLSCH3	T042Z	ZLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in