SAP ABAP Table PUNPAY_DALL (Internal payroll structure for Dependency Allowance)

Hierarchy

☛ SAP_HRCUN (Software Component) Sub component SAP_HRCUN of SAP_HR
   ⤷ PY-NPO (Application Component) Non Profit Organizations
     ⤷ PCUN (Package) Payroll Non Profit Organizations

Basic Data

Table Category	INTTAB	Structure
Structure	PUNPAY_DALL	Table Relationship Diagram
Short Description	Internal payroll structure for Dependency Allowance

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	.INCLUDE	☐				0	0	HR Master Record: Infotype 0021 (Family)
2	.INCLUDE	☐				0	0	Headers for Infotype Records
3	.INCLUDE	☐				0	0	Keys for HR Master Data
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
6	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
7	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
8	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
12	.INCLUDE	☐				0	0	HR Master Record: Control Field
13	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
16	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
17	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
18	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
19	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
20	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
21	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
27	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
28	.INCLUDE	☐				0	0	HR Master Record: Infotype 0021 (Family)
29	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
30	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
31	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
32	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
33	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
34	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
35	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
36	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
37	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
38	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
39	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
40	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
41	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
42	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
43	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
44	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
45	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
46	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
47	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
48	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
49	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
50	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
51	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
52	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
53	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
54	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
55	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
56	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
57	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
58	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
59	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
60	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
61	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
62	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
63	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
64	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
65	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
66	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
67	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
68	.INCLUDE	☐				0	0
69	BETR1	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
70	WAER1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
71	LGRT1	☐	LGART	LGART	CHAR	4	0	Wage Type	*
72	BETR2	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
73	WAER2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
74	LGRT2	☐	LGART	LGART	CHAR	4	0	Wage Type	*
75	BETR3	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
76	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
77	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	*
78	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
79	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
80	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
81	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
82	IRDOA	☐	PUN_IRDOA	DATE	DATS	8	0	In receipt date of allowance

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PUNPAY_DALL	FANA2	T005	LAND1
2	PUNPAY_DALL	FANA3	T005	LAND1
3	PUNPAY_DALL	FANAT	T005	LAND1
4	PUNPAY_DALL	FASAR	T517T	SLART
5	PUNPAY_DALL	FGBLD	T005	LAND1
6	PUNPAY_DALL	FGDEP	T005S	BLAND
7	PUNPAY_DALL	FNMZU	T535N	TITEL
8	PUNPAY_DALL	FVRS2	T535N	TITEL
9	PUNPAY_DALL	FVRSW	T535N	TITEL
10	PUNPAY_DALL	INFTY	T582A	INFTY
11	PUNPAY_DALL	KDART	T577	AUSPR
12	PUNPAY_DALL	KDBSL	T577	AUSPR
13	PUNPAY_DALL	KDGBR	T577	AUSPR
14	PUNPAY_DALL	KDSVH	T577	AUSPR
15	PUNPAY_DALL	KDUTB	T577	AUSPR
16	PUNPAY_DALL	KDVBE	T577	AUSPR
17	PUNPAY_DALL	KDZUG	T577	AUSPR
18	PUNPAY_DALL	KDZUL	T577	AUSPR
19	PUNPAY_DALL	PREAS	T530E	PREAS
20	PUNPAY_DALL	TITEL	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in	200