SAP ABAP Table T5FN4DS004 (S30)

Hierarchy

☛ SAP_HRCFR (Software Component) Sub component SAP_HRCFR of SAP_HR
   ⤷ PY-FR (Application Component) France
     ⤷ PC06 (Package) HR Payroll: France

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5FN4DS004	Table Relationship Diagram
Short Description	S30

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	T000
2	.INCLUDE	☑				0	0	Declaration key
3	TYPE	☑	P06_N4DSAT_TYPE		RAW	1	0	N4DS result type (internal)	T5FN4DS000
4	RUNID	☑	P06_N4DSAT_RUNID	P06_N4DSAT_RUNID	RAW	4	0	Result ID (execution ID)	T5FN4DS000
5	DECLNR	☑	P06_N4DSAT_DECLNR		RAW	2	0	Declaration number (order number)
6	PERNR	☑	P_PERNR	PERNR	NUMC	8	0	Personnel Number
7	SANMS	☐	NUMSS	NUMSS	CHAR	13	0	Social insurance number
8	SANOM	☐	P06_NOMPAT	CHAR80	CHAR	80	0	Last name
9	SAPNM	☐	P06_SAL_PRENOM	CHAR40	CHAR	40	0	First name
10	SANUS	☐	P06_NOMUSA	CHAR80	CHAR	80	0	Customary name, married name...
11	SAPRE	☐	P06_PRENOMUSA	CHAR40	CHAR	40	0	Customary first name
12	SASUR	☐	P06_SURNOM	CHAR80	CHAR	80	0	Nickname
13	SACIV	☐	P06_CIVILITE	CHAR2	CHAR	2	0	Form of address code
14	SADAT	☐	P06_DATENAISS	DATE	DATS	8	0	Birth date
15	SACOM	☐	P06_SACOM	CHAR30	CHAR	30	0	Municipality or place of birth
16	SADPT	☐	P06_DPTNAISS	CHAR2	CHAR	2	0	Birth department code
17	SAPAY	☐	P06_SAL_PAYSNAISS2	CHAR38	CHAR	38	0	Country of birth
18	SANAT	☐	P06_PAYSNATIO2	CHAR38	CHAR	38	0	Country of nationality
19	SAMAT	☐	P06_MATRICULE30_ENT	CHAR30	CHAR	30	0	Personnel number of employee in company

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5FN4DS004	MANDT	T000	MANDT
2	T5FN4DS004	RUNID	T5FN4DS000	RUNID	KEY	1	CN
3	T5FN4DS004	TYPE	T5FN4DS000	TYPE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in