SAP ABAP Table QCAPFODE (Screen Fields for ESS Capital Formation)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE (Application Component) Germany
     ⤷ PC01 (Package) HR Payroll: Germany

Basic Data

Table Category	INTTAB	Structure
Structure	QCAPFODE	Table Relationship Diagram
Short Description	Screen Fields for ESS Capital Formation

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	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
2	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
3	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
4	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
5	STEXT	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
6	ATEXT	☐	ANLTX	TEXT20	CHAR	20	0	Asset type text
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	RADIO	☐	SELEC	XFELD	CHAR	1	0	Indicator for list screen
10	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
11	DDATE	☐	ENDDA	DATUM	DATS	8	0	End Date
12	.INCLUDE	☐				0	0	HR Master Record: Infotype 0010 (Capital Formation)
13	LFDNR	☐	VMBNR	SUBTY_591A	CHAR	4	0	Current Contract for Capital Formation	T591A
14	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	*
15	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
16	BETRG	☐	VBTRG	WERT5	CURR	9	2	Amount for Capital Formation
17	SONRE	☐	SONRE	VWLSO	CHAR	2	0	Special Rule for Capital Formation	T5D3K
18	ZDATE	☐	DZDATE	DATUM	DATS	8	0	First payment date
19	ZFPER	☐	DZFPER	PABRP	NUMC	2	0	First payment period
20	ZANZL	☐	DZANZL	DEC3	DEC	3	0	Number for determining further payment dates
21	ZEINZ	☐	DZEINZ	RPMSH	CHAR	3	0	Time unit for determining next payment	T538A
22	ANZHL	☐	VBANZ	NUM2	NUMC	2	0	Number of Employer Shares
23	EMFSL	☐	EMFSL	EMFSL	CHAR	8	0	Payee key for bank transfers
24	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
25	BKPLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
26	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
27	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
28	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
29	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
30	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
31	UWKEN	☐	UWKEN	CHAR1	CHAR	1	0	Transfer Indicator
32	PRITY	☐	PRIZA	P013_PRITY	CHAR	1	0	Payment Priority
33	VBAFM	☐	VBAFM	VBAFM	CHAR	1	0	Type of investment/asset for capital formation	T5D3G
34	VBAGA	☐	VBAG1	VWLSO	CHAR	2	0	Employer's Contribution to Capital Formation	*
35	VBABS	☐	VBABS	CHAR1	CHAR	1	0	Investment confirmation
36	STBKN	☐	STBKN	CHAR1	CHAR	1	0	Indicator: Tax Confirmation
37	WZKZ1	☐	WZKZ1	WZKZ1	CHAR	1	0	Processing Type of Capital Formation Record
38	WZKZ2	☐	WZKZZ	CHAR1	CHAR	1	0	Indicator: Continued Payment w/o Payment Amount
39	WAERS	☐	PB01_VLWAE	WAERS	CUKY	5	0	Currency of Capital Formation Savings Deposit	T500W
40	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
41	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
42	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QCAPFODE	BANKS	T005	LAND1	REF	1	CN
2	QCAPFODE	LFDNR	T591A	SUBTY	REF	C	CN
3	QCAPFODE	SONRE	T5D3K	VWLSO	REF	C	CN
4	QCAPFODE	VBAFM	T5D3G	ANLAG	REF	C	CN
5	QCAPFODE	WAERS	T500W	WAERS	REF	1	CN
6	QCAPFODE	ZEINZ	T538A	ZEINH
7	QCAPFODE	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46B