SAP ABAP Table P08P1CLS (CLASS CPX INTERFACE Snapshot Table)
Hierarchy
☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P1 (Package) HR Public Sector Great Britain
Basic Data
Table Category TRANSP    Transparent table 
Transparent table P08P1CLS   Table Relationship Diagram
Short Description CLASS CPX INTERFACE Snapshot Table    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 PERNR PERSNO PERSNO NUMC 8   0   Personnel number *
3 SDATE P08_CNT01 DATUM DATS 8   0   CLASS CPX INTERFACE Control File Snapshot Date  
4 RUNNO P08_CNT02 NUM10 NUMC 10   0   CLASS CPX INTERFACE Control File Run Number  
5 .INCLUDE       0   0   CLASS CPX INTERFACE File Key Fields  
6 RECTP P08_CLS01 P08_CLS01 CHAR 1   0   CLASS CPX INTERFACE Record Type (Starter,Amendment,Leaver)  
7 NINUM P08_CLS02 CHAR9 CHAR 9   0   CLASS CPX INTERFACE National Insurance Number  
8 FILL1 P08_CLS03 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Filler 3 Characters  
9 KEY2 P08_CLS04 CHAR12 CHAR 12   0   CLASS CPX INTERFACE Second Key  
10 .INCLUDE       0   0   CLASS CPX INTERFACE File Non Key Fields  
11 SNAME P08_CLS05 CHAR25 CHAR 25   0   CLASS CPX INTERFACE Surname  
12 FNAME P08_CLS06 CHAR25 CHAR 25   0   CLASS CPX INTERFACE Forenames  
13 SCHEM P08_CLS07 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Id  
14 STATU P08_CLS08 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Status  
15 SEX P08_CLS09 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Sex  
16 CLASS P08_CLS10 P08_CLS10 CHAR 2   0   CLASS CPX INTERFACE Class  
17 DOB P08_CLS11 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Of Birth  
18 DJEMP P08_CLS12 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Joined Employer  
19 DJFUN P08_CLS13 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Joined Fund  
20 LSDAT P08_CLS14 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Location Start Date  
21 LOCAT P08_CLS15 CHAR5 CHAR 5   0   CLASS CPX INTERFACE Location  
22 FILL2 P08_CLS16 CHAR5 CHAR 5   0   CLASS CPX INTERFACE Filler 5 Characters  
23 DSPEN P08_CLS17 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Commenced Pensionable Service  
24 DOSER P08_CLS18 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Contracted Out Of SERPS  
25 FILL3 P08_CLS19 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Filler 8 digits.  
26 TITLE P08_CLS20 CHAR4 CHAR 4   0   CLASS CPX INTERFACE Title  
27 FILL4 P08_CLS21 CHAR14 CHAR 14   0   CLASS CPX INTERFACE Filler 14 Characters  
28 NILET P08_CLS22 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NI Table Letter  
29 REDNI P08_CLS23 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Reduced NI Indicator  
30 PTIND P08_CLS24 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Part-time Indicator  
31 CRATE P08_CLS25 CHAR6 CHAR 6   0   CLASS CPX INTERFACE Contribution Rate  
32 DLEFT P08_CLS26 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date Left Active Service  
33 LEFTR P08_CLS27 CHAR4 CHAR 4   0   CLASS CPX INTERFACE Reason For Leaving  
34 FILLC P08_CLS03 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Filler 3 Characters  
35 KEY3 P08_CLS28 CHAR12 CHAR 12   0   CLASS CPX INTERFACE Third Key  
36 KEY4 P08_CLS29 CHAR12 CHAR 12   0   CLASS CPX INTERFACE Fourth Key  
37 SPDT1 P08_CLS30 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Spare Date 1  
38 SPDT2 P08_CLS31 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Spare Date 2  
39 SPDT3 P08_CLS32 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Spare Date 3  
40 SPIND P08_CLS33 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Spare Indicator  
41 PTPER P08_CLS34 CHAR9 CHAR 9   0   CLASS CPX INTERFACE Part-time Percentage  
42 NOTUS P08_CLS35 CHAR2 CHAR 2   0   CLASS CPX INTERFACE NOT FOR USE  
43 LADD1 P08_CLS36 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Leavers Address Line 1  
44 LADD2 P08_CLS37 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Leavers Address Line 2  
45 LADD3 P08_CLS38 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Leavers Address Line 3  
46 LADD4 P08_CLS39 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Leavers Address Line 4  
47 LADD5 P08_CLS40 CHAR20 CHAR 20   0   CLASS CPX INTERFACE Leavers Address Line 5  
48 LPTCD P08_CLS41 CHAR10 CHAR 10   0   CLASS CPX INTERFACE Leavers Post Code  
49 SPNAM P08_CLS42 CHAR25 CHAR 25   0   CLASS CPX INTERFACE NOK Spouse's Name  
50 SPV P08_CLS43 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NOK Spouse "V"  
51 SPKID P08_CLS44 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NOK Number Of Children  
52 SPMDT P08_CLS45 CHAR8 CHAR 8   0   CLASS CPX INTERFACE NOK Spouse Date Of Marriage  
53 SPV2 P08_CLS46 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NOK Spouse V  
54 SPID1 P08_CLS47 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NOK Spouse Indicator 1  
55 SPID2 P08_CLS48 CHAR1 CHAR 1   0   CLASS CPX INTERFACE NOK Spouse Indicator 2  
56 SPGEN P08_CLS49 CHAR9 CHAR 9   0   CLASS CPX INTERFACE NOK Spouse General  
57 CADD1 P08_CLS50 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Correspondence Address Line 1  
58 CADD2 P08_CLS51 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Correspondence Address Line 2  
59 CADD3 P08_CLS52 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Correspondence Address Line 3  
60 CADD4 P08_CLS53 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Correspondence Address Line 4  
61 CADD5 P08_CLS54 CHAR30 CHAR 30   0   CLASS CPX INTERFACE Correspondence Address Line 5  
62 CPTCD P08_CLS55 CHAR10 CHAR 10   0   CLASS CPX INTERFACE Correspondence Post Code  
63 FILL5 P08_CLS56 CHAR13 CHAR 13   0   CLASS CPX INTERFACE Filler 13 Characters  
64 S1SDT P08_CLS57 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service 1 Start Date  
65 S1EDT P08_CLS58 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service 1 End Date  
66 S1ADJ P08_CLS59 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Service 1 Adjustment  
67 S1ID1 P08_CLS60 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service 1 Indicator 1  
68 S1ID2 P08_CLS61 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service 1 Indicator 2  
69 FILL6 P08_CLS62 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Filler 1 Character  
70 S1SI1 P08_CLS63 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 1  
71 S1SI2 P08_CLS64 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 2  
72 S1SI3 P08_CLS65 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 3  
73 FILL7 P08_CLS66 CHAR15 CHAR 15   0   CLASS CPX INTERFACE Filler 15 Characters  
74 S2SDT P08_CLS67 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service 2 Start Date  
75 S2EDT P08_CLS68 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service 2 End Date  
76 S2ADJ P08_CLS69 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Service 2 Adjustment  
77 S2ID1 P08_CLS70 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service 2 Indicator 1  
78 S2ID2 P08_CLS71 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service 2 Indicator 2  
79 FILL8 P08_CLS72 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Filler 1 Character  
80 S2SI1 P08_CLS73 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 1  
81 S2SI2 P08_CLS74 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 2  
82 S2SI3 P08_CLS75 CHAR3 CHAR 3   0   CLASS CPX INTERFACE Scheme Indicator 3  
83 FILL9 P08_CLS76 CHAR15 CHAR 15   0   CLASS CPX INTERFACE Filler 15 Characters  
84 SBSDT P08_CLS77 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service Break Start Date  
85 SBEDT P08_CLS78 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Service Break End Date  
86 SBHR1 P08_CLS79 CHAR5 CHAR 5   0   CLASS CPX INTERFACE Service Break Hours 1  
87 SBHR2 P08_CLS80 CHAR5 CHAR 5   0   CLASS CPX INTERFACE Service Break Hours 2  
88 SBID1 P08_CLS81 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service Break Indicator 1  
89 SBID2 P08_CLS82 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service Break Indicator 2  
90 SBID3 P08_CLS83 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Service Break Indicator 3  
91 FILLA P08_CLS84 CHAR1 CHAR 1   0   CLASS CPX INTERFACE Filler 1 Character  
92 SBGEN P08_CLS85 CHAR18 CHAR 18   0   CLASS CPX INTERFACE Service Break General  
93 DMEMC P08_CLS86 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 1 (Members Contributions)  
94 AMEMC P08_CLS87 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 1 (Members Contributions)  
95 DSTRC P08_CLS88 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 2 (Strike Break Contributions)  
96 ASTRC P08_CLS89 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 2 (Strike Break Contributions)  
97 DNICC P08_CLS90 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 3 (NI Earnings)  
98 ANICC P08_CLS91 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 3 (NI Earnings)  
99 DACTC P08_CLS92 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 4 (Actual Remuneration)  
100 AACTC P08_CLS93 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 4 (Actual Remuneration)  
101 DPENC P08_CLS94 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 5 (Pensionable Remuneration)  
102 APENC P08_CLS95 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 5 (Pensionable Remuneration)  
103 DSIX P08_CLS96 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date 6  
104 ASIX P08_CLS97 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 6  
105 S2DAT P08_CLS98 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date (Set 2)  
106 S2AM1 P08_CLS99 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 1 (Set 2)  
107 S2AM2 P08_CLSA0 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 2 (Set 2)  
108 S2TYP P08_CLSA1 CHAR4 CHAR 4   0   CLASS CPX INTERFACE Type (Set 2)  
109 S3DAT P08_CLSA2 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date (Set 3)  
110 S3AM1 P08_CLSA3 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 1 (Set 3)  
111 S3AM2 P08_CLSA4 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 2 (Set 3)  
112 S3TYP P08_CLSA5 CHAR4 CHAR 4   0   CLASS CPX INTERFACE Type (Set 3)  
113 S4DAT P08_CLSA6 CHAR8 CHAR 8   0   CLASS CPX INTERFACE Date (Set 4)  
114 S4AM1 P08_CLSA7 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 1 (Set 4)  
115 S4AM2 P08_CLSA8 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 2 (Set 4)  
116 S4AM3 P08_CLSA9 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 3 (Set 4)  
117 S4AM4 P08_CLSB0 CHAR11 CHAR 11   0   CLASS CPX INTERFACE Amount 4 (Set 4)  
118 S4TYP P08_CLSB1 CHAR4 CHAR 4   0   CLASS CPX INTERFACE Type (Set 4)  
119 FILLB P08_CLSB2 CHAR10 CHAR 10   0   CLASS CPX INTERFACE Filler 10 Characters  
History
Last changed by/on SAP  20020520 
SAP Release Created in