SAP ABAP Table T5FN4DS008 (S40G1010)
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 T5FN4DS008   Table Relationship Diagram
Short Description S40G1010    
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 SPAPP P06_SOAPP P06_SOAPP CHAR 2   0    
10 SPJUR P06_SOJUR CHAR3 CHAR 3   0   Legal status code  
11 SPSER P06_SOSER CHAR2 CHAR 2   0   Service category code  
12 SPEMP P06_CODE_STATUT_EMP CHAR10 CHAR 10   0   Original statutory employment code  
13 SPECH P06_ECHELON CHAR2 CHAR 2   0   DADS-U: Level  
14 SPCAT P06_CAT_STATUT P06_COD_CAT_STAT CHAR 2   0   Statutory category code  
15 SPDEC P06_SPDEC DATS DATS 8   0   Date of effect of level or scale  
16 SPDAC P06_SPDAC DATS DATS 8   0   Date of decision on statutory employment code allocation  
17 SPIBR P06_ESIBR CHAR4 CHAR 4   0   Gross index  
18 SPIMJ P06_INDMJ DEC4 DEC 4   0   Indice majoré  
19 SPPIS P06_SPPIS DEC4 DEC 4   0   Number of supplementary index points  
20 SPIBO P06_INDICE_BRUT_ORIGINE CHAR2 CHAR 2   0   DADS-U: Original gross index  
21 SPORO P06_CODE_ORGAN_ORIGIN CHAR2 CHAR 2   0   DADS-U: Original agency code  
22 SPNIS P06_SPNIS DEC2 DEC 2   0   Nature code of allowance of special constraints and risk  
23 SPPSU P06_SPPSU DEC8 DEC 8   0   Number of points of special constraints and risk allowance  
24 SPPBO P06_SPPBO DEC4_2 DEC 6   2   Monthly number of points - new index payment  
25 SPTPA P06_SPTPA DEC3 DEC 3   0   Activity extension type code  
26 SPPCS P06_SPPCS CHAR5 CHAR 5   0   Socio-professional category and profession code (PCS)  
27 SPCPS P06_SPCPS CHAR4 CHAR 4   0   PCS supplement  
28 SPNCO P06_CONTRAT CHAR2 CHAR 2   0   DADS-U: Work contract code  
29 SPPOS P06_SPPOS CHAR3 CHAR 3   0   Statutory position code  
30 SPDPN P06_SPDPN CHAR5 CHAR 5   0   Detailed code of normal activity position  
31 SPDMP P06_SPDMD CHAR5 CHAR 5   0   Detailed code of the supply position  
32 SPDEL P06_SPDEL CHAR5 CHAR 5   0   Detailed code of the delegation position  
33 SPDHC P06_SPDHC CHAR5 CHAR 5   0   Detailed code of seconded position  
34 SPDCP P06_SPDCP CHAR5 CHAR 5   0   Detailed code of parental leave position  
35 SPDIS P06_SPDIS CHAR5 CHAR 5   0   Detailed code of availability position  
36 SPCST P06_SPCST CHAR5 CHAR 5   0   Detailed code of the unpaid leave position  
37 SPDSO P06_SPDSO CHAR5 CHAR 5   0   Detailed code special availability position - officers  
38 SPANM P06_SPANM CHAR5 CHAR 5   0   Detailed code of soldier inactivity position  
39 SPHCP P06_SPHCP CHAR5 CHAR 5   0   Detailed code of seconded position (prefects, sub-prefects)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 T5FN4DS008 MANDT T000 MANDT    
2 T5FN4DS008 RUNID T5FN4DS000 RUNID KEY 1 CN
3 T5FN4DS008 TYPE T5FN4DS000 TYPE KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in