SAP ABAP Table T5FN4DS007 (S40G1005)

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	T5FN4DS007	Table Relationship Diagram
Short Description	S40G1005

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	.INCLUDE	☑				0	0	N4DS Pernr declaration key
7	PERNR	☑	P_PERNR	PERNR	NUMC	8	0	Personnel Number
8	SEQNR	☑	P06_N4DSAT_SEQNR		RAW	1	0	N4DS Pernr sequential number (activityperiod)
9	SSPCS	☐	P06_PCS	P06_PCS	CHAR	4	0	Socio-professional category INSEE code	*
10	SSCPC	☐	P06_CCPCS	P06_CCPCS	CHAR	6	0	PCS supplement
11	SSMSA	☐	P06_ACTIVITE_MSA	CHAR4	CHAR	4	0	MSA activity code
12	SSCNC	☐	P06_CONTRAT	CHAR2	CHAR	2	0	DADS-U: Work contract code
13	SSCDC	☐	P06_DR_CONTR	P06_DROITC	CHAR	2	0	Work contract law indicator
14	SSCIC	☐	P06_CD_INTITULE_CONTRAT	P06_CD_INTITULE_CONTRAT	CHAR	2	0	Employment contract title code
15	SSRCT	☐	P06_CREF_CONTRAT	CHAR20	CHAR	20	0	Employment contract reference
16	SSDIF	☐	P06_DATE_INITALE	DATUM	DATS	8	0	Initial date of temporary work relationship (CDD) end
17	SSCMA	☐	P06_MODAL_ACTIVITE	P06_KZTIM	CHAR	2	0	Activity's modality code	*
18	SSCSC	☐	P06_STATCATEG	CHAR2	CHAR	2	0	DADS-U: Employee category status code
19	SSCSA	☐	P06_STATCATEG_AGIRC	CHAR2	CHAR	2	0	DADS-U: Employee AGIRC-ARRCO group status indicator
20	SSCSM	☐	P06_STATUT_MSA	CHAR2	CHAR	2	0	MSA category-specific status code
21	SSCCC	☐	P06_CONVCOLL	CHAR4	CHAR	4	0	DADS-U: Collective agreement code
22	SSCCO	☐	P06_CLAS_CONV	CHAR100	CHAR	100	0	DADS-U: Conventional assignment to wage lev.
23	SSECT	☐	P06_PRUDH_COD_FIN	CHAR2	CHAR	2	0	DADS-U: Contract status on the last Friday of the year

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in