SAP ABAP Table PA0887 (Personnel master record infotype 0887)

Hierarchy

☛ SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PB04 (Package) HR Master Data: Spain

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0887	Table Relationship Diagram
Short Description	Personnel master record infotype 0887

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	*
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	Garnishments (Spain)
27	GMTYP	☐	PES_GMTYP	SUBTY_591A	CHAR	4	0	Garnishment order type	T591A
28	GMCID	☐	PES_GMCID	CHAR20	CHAR	20	0	Garnishment ID
29	GMSEQ	☐	PES_GMSEQ	NUMC6	NUMC	6	0	Garnishment priority
30	GMBLG	☐	PES_GMBLG	LGART	CHAR	4	0	Garnishment basis wage type	T512Z
31	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
32	GMDEB	☐	PES_GMDEB	P_AMT08	CURR	15	2	Total payable
33	GMSUB	☐	PES_GMSUB	P_AMT08	CURR	15	2	Monthly deductible value
34	GMRTE	☐	PES_GMRTE	PES_PRCNT_2	DEC	5	2	Porcentual deduction of garnishment basis
35	GMRED	☐	PES_GMRED	PES_PRCNT_2	DEC	5	2	Garnishment discount in percentage
36	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
37	GMIPR	☐	PES_GMIPR		CHAR	1	0	Deduction group	T5E92
38	.INCLUDE	☐				0	0	Carrier bank information
39	EMFSL	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	T521C
40	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
41	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
42	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
43	BKPLZ	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
44	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
45	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
46	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
47	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
48	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
49	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
50	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
51	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
52	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
53	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
54	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
55	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
56	INERB	☐	PES_INERB	PES_PRCNT_2	DEC	5	2	Percentage added to non-garnishable wage
57	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0887	BANKS	T005	LAND1	REF	1	CN
2	PA0887	DTAWS	T015W	DTAWS	REF	1	CN
3	PA0887	EMFSL	T521C	EMFSL	REF	1	CN
4	PA0887	GMBLG	T512Z	LGART	REF	1	CN
5	PA0887	GMIPR	T5E92	GMIPR	REF	1	CN
6	PA0887	GMTYP	T591A	SUBTY	REF	1	CN
7	PA0887	PERNR	PA0003	PERNR
8	PA0887	PREAS	T530E	PREAS
9	PA0887	STATE	T005S	BLAND	REF	1	CN
10	PA0887	WAERS	TCURC	WAERS	REF	1	CN
11	PA0887	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

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