SAP ABAP Table PA0747 (HR Master Record for Infotype 0747)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PA-PF-DE (Application Component) Company Pension Scheme Germany
     ⤷ P01A (Package) HR Germany: Retirement Pension Plan

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0747	Table Relationship Diagram
Short Description	HR Master Record for Infotype 0747

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	HR Master Record IT 0747 (Child Data for Request for Bonus)
27	AVFMA	☐	P01C_AVFMA	P01C_AVFMA	CHAR	4	0	Company Pension Scheme Pension Organizations	T5DC3
28	NNAME	☐	P01A_NNAME	TEXT35	CHAR	35	0	Last Name of Child
29	VNAME	☐	P01A_VNAME	TEXT35	CHAR	35	0	Child's First Name
30	GEBDT	☐	P01A_GEBDT	GBDAT	DATS	8	0	Child's Date of Birth
31	ZAHST	☐	P01A_ZAHST	TEXT30	CHAR	30	0	Employment Office/Paying Office of Child Allowance
32	ZAHAZ	☐	P01A_ZAHAZ	TEXT20	CHAR	20	0	Child Allowance Number / File Number
33	NKIZA	☐	P01A_NKIZA	TEXT35	CHAR	35	0	Last Name of Person Entitled to Child Benefit
34	VKIZA	☐	P01A_VKIZA	TEXT35	CHAR	35	0	First Name of Person Entitled to Child Benefit
35	VONMK	☐	P01A_VONMK	P01A_MONAT	NUMC	2	0	From-Month Child Allowance Payment
36	BISMK	☐	P01A_BISMK	P01A_MONAT	NUMC	2	0	To-Month Child Allowance Payment
37	ZUOKN	☐	P01A_ZUOKN	XFELD	CHAR	1	0	Assignment of Child Allowance
38	ZUSDA	☐	P01A_ZUSDA	DATUM	DATS	8	0	Date of Approval and Signature of Wife
39	ANTDA	☐	P01A_ANTDA	DATUM	DATS	8	0	Application Date
40	FRVSW	☐	P01A_VORSW	PC01_TTLIN	CHAR	15	0	Name Prefix	T5D4O
41	FNMZU	☐	P01A_NAMZU	PC01_TTLIN	CHAR	15	0	Name Affixes	T5D4O
42	FSDNR	☐	P01_SIDNR		NUMC	11	0	Tax Identification Number
43	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0747	AVFMA	T5DC3	AVFMA	KEY	1	CN
2	PA0747	FNMZU	T5D4O	TITEL	KEY	1	CN
3	PA0747	FRVSW	T5D4O	TITEL	KEY	1	CN
4	PA0747	PERNR	PA0003	PERNR
5	PA0747	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20091125
SAP Release Created in	470