SAP ABAP Table HCMT_BSP_PA_ES_R0887 (Withholdings (Spain))

Hierarchy

☛ EA-HRCES (Software Component) Sub component EA-HRCES of EA-HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PAOC_PAD_UI_ES (Package) User Interface for Personnel Administration - Spain

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_ES_R0887	Table Relationship Diagram
Short Description	Withholdings (Spain)

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	OBJECT_KEY	☐	HCM_OBJECT_KEY		CHAR	100	0	HCM Object Key
2	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
3	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	SPRTX	☐	SPRPSTEXT	SPRPSTEXT	CHAR	40	0	Lock indicator for HR master record (text)
9	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
10	BEGDA	☐	PAD_BEGDA	DATUM	DATS	8	0	Valid-From Date
11	ENDDA	☐	PAD_ENDDA	DATUM	DATS	8	0	Valid To Date
12	.INCLUDE	☐				0	0	Garnishments (Spain)
13	GMTYP	☐	PES_GMTYP	SUBTY_591A	CHAR	4	0	Garnishment order type	*
14	GMCID	☐	PES_GMCID	CHAR20	CHAR	20	0	Garnishment ID
15	GMSEQ	☐	PES_GMSEQ	NUMC6	NUMC	6	0	Garnishment priority
16	GMBLG	☐	PES_GMBLG	LGART	CHAR	4	0	Garnishment basis wage type	T512Z
17	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
18	GMDEB	☐	PES_GMDEB	P_AMT08	CURR	15	2	Total payable
19	GMSUB	☐	PES_GMSUB	P_AMT08	CURR	15	2	Monthly deductible value
20	GMRTE	☐	PES_GMRTE	PES_PRCNT_2	DEC	5	2	Porcentual deduction of garnishment basis
21	GMRED	☐	PES_GMRED	PES_PRCNT_2	DEC	5	2	Garnishment discount in percentage
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
23	GMIPR	☐	PES_GMIPR		CHAR	1	0	Deduction group	T5E92
24	.INCLUDE	☐				0	0	Carrier bank information
25	EMFSL	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	T521C
26	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
27	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
28	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
29	BKPLZ	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
30	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
31	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
32	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
33	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
34	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
35	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
36	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
37	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	*
38	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
39	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
40	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
41	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
42	INERB	☐	PES_INERB	PES_PRCNT_2	DEC	5	2	Percentage added to non-garnishable wage
43	.INCLUDE	☐				0	0
44	GMTYP_FRAME	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
45	GMTYP_TXT	☐	PES_GMTYP_TXT	TEXT34	CHAR	34	0	Garnishment type text
46	GMCID_UI	☐	PES_GMCID	CHAR20	CHAR	20	0	Garnishment ID
47	GMAMD	☐	PES_GMAMD	P_AMT08	CURR	15	2	Total value already deducted
48	WAERSGMAMD	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	GMBAS	☐	PES_GMBAS	P_AMT08	CURR	15	2	Garnishment basis for value calculation
50	WAERSGMBAS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
51	GMCPR	☐	PES_GMCPR	P_AMT08	CURR	15	2	Value previously deducted
52	WAERSGMCPR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
53	WAERSGMSUB	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	WAERSGMDEB	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
55	SBTTX	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
56	GMBLG_TXT	☐	LGTXT	TEXT25	CHAR	25	0	Wage Type Long Text
57	IBAN00	☐	HRPAD_IBAN00	HRPAD_IBAN00	CHAR	42	0	IBAN (International Bank Account Number)
58	.INCLUDE	☐				0	0	Dynpro field, infotype 0887-Payroll results (garnishments)
59	GMTOT	☐	PES_GMTOT	P_AMT08	CURR	15	2	Total amount deducted from the beginning of garnishment
60	WAERSGMTOT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
61	GMNBT	☐	PES_GMNBT	P_AMT08	CURR	15	2	Amount still not transferred
62	WAERSGMNBT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
63	GMNYD	☐	PES_GMNYD	P_AMT08	CURR	15	2	Amount not deducted in period
64	WAERSGMNYD	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
65	INPER_UI	☐	PES_INPER_UI	CHAR7	CHAR	7	0	Payroll in-period
66	IPEND	☐	IPEND	DATUM	DATS	8	0	End of payroll period (IN period)
67	IBAN01	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
68	IBAN02	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
69	IBAN03	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
70	IBAN04	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
71	IBAN05	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
72	IBAN06	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
73	IBAN07	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
74	IBAN08	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
75	IBAN09	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
76	IBAN_VALFR	☐	DATS	DATS	DATS	8	0	Field of type DATS
77	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_ES_R0887	BANKS	T005	LAND1	REF	1	CN
2	HCMT_BSP_PA_ES_R0887	DTAWS	T015W	DTAWS	REF	1	CN
3	HCMT_BSP_PA_ES_R0887	EMFSL	T521C	EMFSL	REF	1	CN
4	HCMT_BSP_PA_ES_R0887	GMBLG	T512Z	LGART	REF	1	CN
5	HCMT_BSP_PA_ES_R0887	GMIPR	T5E92	GMIPR	REF	1	CN
6	HCMT_BSP_PA_ES_R0887	STATE	T005S	BLAND	REF	1	CN
7	HCMT_BSP_PA_ES_R0887	WAERSGMNBT	TCURC	WAERS	REF	1	CN
8	HCMT_BSP_PA_ES_R0887	WAERSGMNYD	TCURC	WAERS	REF	1	CN
9	HCMT_BSP_PA_ES_R0887	WAERSGMTOT	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in