SAP ABAP Table PS0795 (Structure for Certificate/License Infotype)
Hierarchy
☛ SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   ⤷ PY-US-PS (Application Component) Öffentlicher Dienst
     ⤷ P10P1 (Package) HR Public Sector USA
Basic Data
Table Category INTTAB    Structure 
Structure PS0795   Table Relationship Diagram
Short Description Structure for Certificate/License Infotype    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 TYPEC P10P_TYPEC CHAR4 CHAR 4   0   Certificate Category T5UPBSTC11
2 CTNUM P10P_CTNUM CHAR10 CHAR 10   0   Certificate Identification  
3 CTBEG P10P_CTBEG DATUM DATS 8   0   Certificate Effective Begin Date  
4 CTEND P10P_CTEND DATUM DATS 8   0   Certificate Effective End Date  
5 CSTAT P10P_CSTAT CHAR1 CHAR 1   0   Certificate and Area Status T5UPBSTC30
6 RENCD P10P_RENCD CHAR4 CHAR 4   0   Renewal Code T5UPBSTC21
7 SBG01 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
8 SEN01 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
9 SCD01 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level) T5UPBSTC16
10 SCL01 P10P_CLASS CHAR4 CHAR 4   0   Classification T5UPBSTC03
11 SDN01 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
12 SST01 P10P_SSTAT CHAR1 CHAR 1   0   Area Status T5UPBSTC30
13 SHQ01 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
14 SBG02 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
15 SEN02 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
16 SCD02 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level) T5UPBSTC16
17 SCL02 P10P_CLASS CHAR4 CHAR 4   0   Classification T5UPBSTC03
18 SDN02 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
19 SST02 P10P_SSTAT CHAR1 CHAR 1   0   Area Status T5UPBSTC30
20 SHQ02 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
21 SBG03 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
22 SEN03 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
23 SCD03 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level) T5UPBSTC16
24 SCL03 P10P_CLASS CHAR4 CHAR 4   0   Classification T5UPBSTC03
25 SDN03 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
26 SST03 P10P_SSTAT CHAR1 CHAR 1   0   Area Status T5UPBSTC30
27 SHQ03 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
28 SBG04 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
29 SEN04 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
30 SCD04 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level) T5UPBSTC16
31 SCL04 P10P_CLASS CHAR4 CHAR 4   0   Classification T5UPBSTC03
32 SDN04 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
33 SST04 P10P_SSTAT CHAR1 CHAR 1   0   Area Status T5UPBSTC30
34 SHQ04 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
35 SBG05 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
36 SEN05 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
37 SCD05 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level) T5UPBSTC16
38 SCL05 P10P_CLASS CHAR4 CHAR 4   0   Classification T5UPBSTC03
39 SDN05 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
40 SST05 P10P_SSTAT CHAR1 CHAR 1   0   Area Status T5UPBSTC30
41 SHQ05 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
42 SBG06 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
43 SEN06 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
44 SCD06 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
45 SCL06 P10P_CLASS CHAR4 CHAR 4   0   Classification  
46 SDN06 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
47 SST06 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
48 SHQ06 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
49 SBG07 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
50 SEN07 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
51 SCD07 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
52 SCL07 P10P_CLASS CHAR4 CHAR 4   0   Classification  
53 SDN07 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
54 SST07 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
55 SHQ07 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
56 SBG08 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
57 SEN08 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
58 SCD08 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
59 SCL08 P10P_CLASS CHAR4 CHAR 4   0   Classification  
60 SDN08 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
61 SST08 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
62 SHQ08 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
63 SBG09 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
64 SEN09 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
65 SCD09 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
66 SCL09 P10P_CLASS CHAR4 CHAR 4   0   Classification  
67 SDN09 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
68 SST09 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
69 SHQ09 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
70 SBG10 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
71 SEN10 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
72 SCD10 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
73 SCL10 P10P_CLASS CHAR4 CHAR 4   0   Classification  
74 SDN10 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
75 SST10 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
76 SHQ10 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
77 SBG11 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
78 SEN11 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
79 SCD11 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
80 SCL11 P10P_CLASS CHAR4 CHAR 4   0   Classification  
81 SDN11 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
82 SST11 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
83 SHQ11 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
84 SBG12 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
85 SEN12 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
86 SCD12 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
87 SCL12 P10P_CLASS CHAR4 CHAR 4   0   Classification  
88 SDN12 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
89 SST12 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
90 SHQ12 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
91 SBG13 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
92 SEN13 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
93 SCD13 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
94 SCL13 P10P_CLASS CHAR4 CHAR 4   0   Classification  
95 SDN13 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
96 SST13 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
97 SHQ13 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
98 SBG14 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
99 SEN14 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
100 SCD14 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
101 SCL14 P10P_CLASS CHAR4 CHAR 4   0   Classification  
102 SDN14 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
103 SST14 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
104 SHQ14 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
105 SBG15 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
106 SEN15 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
107 SCD15 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
108 SCL15 P10P_CLASS CHAR4 CHAR 4   0   Classification  
109 SDN15 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
110 SST15 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
111 SHQ15 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
112 SBG16 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
113 SEN16 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
114 SCD16 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
115 SCL16 P10P_CLASS CHAR4 CHAR 4   0   Classification  
116 SDN16 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
117 SST16 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
118 SHQ16 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
119 SBG17 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
120 SEN17 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
121 SCD17 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
122 SCL17 P10P_CLASS CHAR4 CHAR 4   0   Classification  
123 SDN17 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
124 SST17 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
125 SHQ17 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
126 SBG18 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
127 SEN18 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
128 SCD18 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
129 SCL18 P10P_CLASS CHAR4 CHAR 4   0   Classification  
130 SDN18 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
131 SST18 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
132 SHQ18 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
133 SBG19 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
134 SEN19 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
135 SCD19 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
136 SCL19 P10P_CLASS CHAR4 CHAR 4   0   Classification  
137 SDN19 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
138 SST19 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
139 SHQ19 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
140 SBG20 P10P_SBEGD DATUM DATS 8   0   Area Effective Begin Date  
141 SEN20 P10P_SENDD DATUM DATS 8   0   Area Effective End Date  
142 SCD20 P10P_SCODE CHAR6 CHAR 6   0   Code (Classification, Area and Level)  
143 SCL20 P10P_CLASS CHAR4 CHAR 4   0   Classification  
144 SDN20 P10P_SDNUM CHAR10 CHAR 10   0   Area Document Number  
145 SST20 P10P_SSTAT CHAR1 CHAR 1   0   Area Status  
146 SHQ20 P10P_HQUAL XFELD CHAR 1   0   Highly Qualified  
147 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PS0795 CSTAT T5UPBSTC30 CSTAT REF 1 CN
2 PS0795 RENCD T5UPBSTC21 RENCD REF 1 CN
3 PS0795 SCD01 T5UPBSTC16 SCODE REF 1 CN
4 PS0795 SCD02 T5UPBSTC16 SCODE REF 1 CN
5 PS0795 SCD03 T5UPBSTC16 SCODE REF 1 CN
6 PS0795 SCD04 T5UPBSTC16 SCODE REF 1 CN
7 PS0795 SCD05 T5UPBSTC16 SCODE REF 1 CN
8 PS0795 SCL01 T5UPBSTC03 CLASS REF 1 CN
9 PS0795 SCL02 T5UPBSTC03 CLASS REF 1 CN
10 PS0795 SCL03 T5UPBSTC03 CLASS REF 1 CN
11 PS0795 SCL04 T5UPBSTC03 CLASS REF 1 CN
12 PS0795 SCL05 T5UPBSTC03 CLASS REF 1 CN
13 PS0795 SST01 T5UPBSTC30 CSTAT REF 1 CN
14 PS0795 SST02 T5UPBSTC30 CSTAT REF 1 CN
15 PS0795 SST03 T5UPBSTC30 CSTAT REF 1 CN
16 PS0795 SST04 T5UPBSTC30 CSTAT REF 1 CN
17 PS0795 SST05 T5UPBSTC30 CSTAT REF 1 CN
18 PS0795 TYPEC T5UPBSTC11 TYPEC REF 1 CN
History
Last changed by/on SAP  20050411 
SAP Release Created in 470