SAP ABAP Table Q0887 (Dynpro field, infotype 0887 (Garnishments))

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	INTTAB	Structure
Structure	Q0887	Table Relationship Diagram
Short Description	Dynpro field, infotype 0887 (Garnishments)

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	GMTYP	☐	PES_GMTYP	SUBTY_591A	CHAR	4	0	Garnishment order type	*
2	GMTYP_FRAME	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
3	GMTYP_TXT	☐	PES_GMTYP_TXT	TEXT34	CHAR	34	0	Garnishment type text
4	GMCID_UI	☐	PES_GMCID	CHAR20	CHAR	20	0	Garnishment ID
5	.INCLUDE	☐				0	0	Carrier bank information
6	EMFSL	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	T521C
7	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
8	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
9	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
10	BKPLZ	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
11	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
12	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
13	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
14	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
15	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
16	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
17	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
18	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	*
19	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
20	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
21	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
23	GMAMD	☐	PES_GMAMD	P_AMT08	CURR	15	2	Total value already deducted
24	WAERSGMAMD	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
25	GMBAS	☐	PES_GMBAS	P_AMT08	CURR	15	2	Garnishment basis for value calculation
26	WAERSGMBAS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
27	GMCPR	☐	PES_GMCPR	P_AMT08	CURR	15	2	Value previously deducted
28	WAERSGMCPR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
29	GMSUB	☐	PES_GMSUB	P_AMT08	CURR	15	2	Monthly deductible value
30	WAERSGMSUB	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
31	WAERSGMDEB	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
32	SBTTX	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
33	GMBLG_TXT	☐	LGTXT	TEXT25	CHAR	25	0	Wage Type Long Text
34	IBAN00	☐	HRPAD_IBAN00	HRPAD_IBAN00	CHAR	42	0	IBAN (International Bank Account Number)
35	.INCLUDE	☐				0	0	Dynpro field, infotype 0887-Payroll results (garnishments)
36	GMTOT	☐	PES_GMTOT	P_AMT08	CURR	15	2	Total amount deducted from the beginning of garnishment
37	WAERSGMTOT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	GMNBT	☐	PES_GMNBT	P_AMT08	CURR	15	2	Amount still not transferred
39	WAERSGMNBT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	GMNYD	☐	PES_GMNYD	P_AMT08	CURR	15	2	Amount not deducted in period
41	WAERSGMNYD	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	INPER_UI	☐	PES_INPER_UI	CHAR7	CHAR	7	0	Payroll in-period
43	IPEND	☐	IPEND	DATUM	DATS	8	0	End of payroll period (IN period)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	Q0887	BANKS	T005	LAND1	REF	1	CN
2	Q0887	DTAWS	T015W	DTAWS	REF	1	CN
3	Q0887	EMFSL	T521C	EMFSL	REF	1	CN
4	Q0887	STATE	T005S	BLAND	REF	1	CN

History

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