SAP ABAP Table ADS2KIPUPL_H_SPCIPPDS (Hierarchy table structure:SPL)
Hierarchy
ECC-DIMP (Software Component) DIMP
   IS-AD-SPC (Application Component) Specification 2000
     ADS2KIPUPL_DL (Package) SPEC2000 Initial Provisioning Upload: DB Layer
Basic Data
Table Category INTTAB    Structure 
Structure ADS2KIPUPL_H_SPCIPPDS   Table Relationship Diagram
Short Description Hierarchy table structure:SPL    
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 API_UPDATEFLAG ADSPC_CHG ADSPC_CHG CHAR 1   0   Change Code  
2 UPDATEFLAG ADSPC_CHG ADSPC_CHG CHAR 1   0   Change Code  
3 X_PDS VSPCIPPDS   STRU 0   0    
4 .INCLUDE       0   0   SPEC2000: Procurement Data Segment  
5 CLIENT SYMANDT MANDT CLNT 3   0   Client ID  
6 SQNBR ADSPC_SQNBR ADSPC_SRNBR NUMC 5   0   Sequence Number  
7 PNR ADSPC_PNR CHAR15 CHAR 15   0   Part Number  
8 MFR ADSPC_MFR CHAR5 CHAR 5   0   Manufacturer Code  
9 SPL ADSPC_SPL CHAR5 CHAR 5   0   Supplier Code  
10 KWD ADSPC_KWD CHAR8 CHAR 8   0   Keyword Name  
11 UNT ADSPC_UNT CHAR2 CHAR 2   0   Unit of Measure Code  
12 UNCQNT ADSPC_UNCQNT ADSPC_QTO NUMC 5   0   Unit of measure clarification - Quantity  
13 UNCUNT ADSPC_UNCUNT ADSPC_UNT CHAR 2   0   Unit of measure clarification - Unit of Measure  
14 UNP ADSPC_UNP CHAR13 CHAR 13   0   Unit Price Amount  
15 ICR ADSPC_ICR CHAR3 CHAR 3   0   International Currency Code  
16 PTC ADSPC_PTC ADSPC_PTC CHAR 1   0   SPEC 2000: Price Type Code  
17 PRCC ADSPC_PRCC ADSPC_PRCC CHAR 1   0   Price Condition Code  
18 SPQ ADSPC_SPQ CHAR3 CHAR 3   0   Standard Package Quantity  
19 DIS ADSPC_DIS CHAR2 CHAR 2   0   Discount Percent  
20 PDP ADSPC_PDP CHAR5 CHAR 5   0   Procurement Discount Percent  
21 LTM ADSPC_LTM CHAR3 CHAR 3   0   Lead Time  
22 PRP ADSPC_PRP ADSPC_PRP CHAR 1   0   Proprietary Code  
23 SIRPNR ADSPC_SIRPNR ADSPC_OPN CHAR 32   0   Selected Item - Part Number  
24 SIRMFR ADSPC_SIRMFR ADSPC_MFR CHAR 5   0   Selected Item - Manufacturer Code  
25 CSDDNR ADSPC_CSDDNR ADSPC_OPN CHAR 32   0   Control Specification/Drawing - Number  
26 CSDMFR ADSPC_CSDMFR ADSPC_MFR CHAR 5   0   Control Specification/Drawing - Manufacturer Code  
27 CPNPNR ADSPC_CPNPNR ADSPC_OPN CHAR 32   0   Category I Container - Part Number  
28 CPNMFR ADSPC_CPNMFR ADSPC_MFR CHAR 5   0   Category I Container - Manufacturer Code  
29 PSPPNR ADSPC_PSPPNR ADSPC_OPN CHAR 32   0   Preferred Spare Part Number  
30 PSPMFR ADSPC_PSPMFR ADSPC_MFR CHAR 5   0   Preferred Spare Part - Manufacturer Code  
31 MSQ ADSPC_MSQ CHAR5 CHAR 5   0   Minimum Sales Quantity  
32 EXP ADSPC_EXP ADSPC_EXP CHAR 6   0   Expiration Date  
33 EFFDATE ADSPC_EFFDATE ADSPC_EFFDATE NUMC 5   0   Effective Date  
34 OBJ ADSPCIP_RANGE ADSPCIP_RANGE CHAR 20   0   Object for Status Management  
35 DELFLG ADSPC_DELETION_FLAG CHAR1 CHAR 1   0   Deletion Flag for IP  
36 .INCLUDE       0   0    
37 .INCLUDE       0   0   Structures for generating change document update programs  
38 KZ CDCHNGIND CDCHNGIND CHAR 1   0   Change type (U, I, E, D)  
39 Y_PDS VSPCIPPDS   STRU 0   0    
40 .INCLUDE       0   0   SPEC2000: Procurement Data Segment  
41 CLIENT SYMANDT MANDT CLNT 3   0   Client ID  
42 SQNBR ADSPC_SQNBR ADSPC_SRNBR NUMC 5   0   Sequence Number  
43 PNR ADSPC_PNR CHAR15 CHAR 15   0   Part Number  
44 MFR ADSPC_MFR CHAR5 CHAR 5   0   Manufacturer Code  
45 SPL ADSPC_SPL CHAR5 CHAR 5   0   Supplier Code  
46 KWD ADSPC_KWD CHAR8 CHAR 8   0   Keyword Name  
47 UNT ADSPC_UNT CHAR2 CHAR 2   0   Unit of Measure Code  
48 UNCQNT ADSPC_UNCQNT ADSPC_QTO NUMC 5   0   Unit of measure clarification - Quantity  
49 UNCUNT ADSPC_UNCUNT ADSPC_UNT CHAR 2   0   Unit of measure clarification - Unit of Measure  
50 UNP ADSPC_UNP CHAR13 CHAR 13   0   Unit Price Amount  
51 ICR ADSPC_ICR CHAR3 CHAR 3   0   International Currency Code  
52 PTC ADSPC_PTC ADSPC_PTC CHAR 1   0   SPEC 2000: Price Type Code  
53 PRCC ADSPC_PRCC ADSPC_PRCC CHAR 1   0   Price Condition Code  
54 SPQ ADSPC_SPQ CHAR3 CHAR 3   0   Standard Package Quantity  
55 DIS ADSPC_DIS CHAR2 CHAR 2   0   Discount Percent  
56 PDP ADSPC_PDP CHAR5 CHAR 5   0   Procurement Discount Percent  
57 LTM ADSPC_LTM CHAR3 CHAR 3   0   Lead Time  
58 PRP ADSPC_PRP ADSPC_PRP CHAR 1   0   Proprietary Code  
59 SIRPNR ADSPC_SIRPNR ADSPC_OPN CHAR 32   0   Selected Item - Part Number  
60 SIRMFR ADSPC_SIRMFR ADSPC_MFR CHAR 5   0   Selected Item - Manufacturer Code  
61 CSDDNR ADSPC_CSDDNR ADSPC_OPN CHAR 32   0   Control Specification/Drawing - Number  
62 CSDMFR ADSPC_CSDMFR ADSPC_MFR CHAR 5   0   Control Specification/Drawing - Manufacturer Code  
63 CPNPNR ADSPC_CPNPNR ADSPC_OPN CHAR 32   0   Category I Container - Part Number  
64 CPNMFR ADSPC_CPNMFR ADSPC_MFR CHAR 5   0   Category I Container - Manufacturer Code  
65 PSPPNR ADSPC_PSPPNR ADSPC_OPN CHAR 32   0   Preferred Spare Part Number  
66 PSPMFR ADSPC_PSPMFR ADSPC_MFR CHAR 5   0   Preferred Spare Part - Manufacturer Code  
67 MSQ ADSPC_MSQ CHAR5 CHAR 5   0   Minimum Sales Quantity  
68 EXP ADSPC_EXP ADSPC_EXP CHAR 6   0   Expiration Date  
69 EFFDATE ADSPC_EFFDATE ADSPC_EFFDATE NUMC 5   0   Effective Date  
70 OBJ ADSPCIP_RANGE ADSPCIP_RANGE CHAR 20   0   Object for Status Management  
71 DELFLG ADSPC_DELETION_FLAG CHAR1 CHAR 1   0   Deletion Flag for IP  
72 .INCLUDE       0   0    
73 .INCLUDE       0   0   Structures for generating change document update programs  
74 KZ CDCHNGIND CDCHNGIND CHAR 1   0   Change type (U, I, E, D)  
75 T_X_PQA ADS2KIPUPL_VSPCIPPQA   TTYP 0   0    
76 T_Y_PQA ADS2KIPUPL_VSPCIPPQA   TTYP 0   0    
77 T_N_PQA ADS2KIPUPL_VSPCIPPQA   TTYP 0   0    
78 T_X_OCH ADS2KIPUPL_VSPCIPOCH   TTYP 0   0    
79 T_Y_OCH ADS2KIPUPL_VSPCIPOCH   TTYP 0   0    
80 T_N_OCH ADS2KIPUPL_VSPCIPOCH   TTYP 0   0    
81 T_X_OSC ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
82 T_Y_OSC ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
83 T_N_OSC ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
84 T_X_DST ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
85 T_Y_DST ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
86 T_N_DST ADS2KIPUPL_VSPCIPOSDS   TTYP 0   0    
87 ADT ADS2KIPUPL_LONGTEXT   STRU 0   0    
88 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
89 TDID TDID TDID CHAR 4   0   Text ID  
90 LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
91 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
92 EXISTS_IN_DB CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
93 MODIFIED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
94 HEADER THEAD   STRU 0   0    
95 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
96 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
97 TDID TDID TDID CHAR 4   0   Text ID  
98 TDSPRAS SPRAS SPRAS LANG 1   0   Language Key  
99 TDTITLE TDTITLE TDTITLE CHAR 50   0   Title in dialog box  
100 TDFORM TDFORM TDFORM CHAR 16   0   Form name  
101 TDSTYLE TDSTYLE TDSTYLE CHAR 8   0   Style Name  
102 TDVERSION TDVERSION TDVERSION NUMC 5   0   Version  
103 TDFUSER TDFUSER TDUSER CHAR 12   0   Created by  
104 TDFRELES TDFRELES TDRELEASE CHAR 4   0   Release  
105 TDFDATE TDFDATE DATUM DATS 8   0   Date created  
106 TDFTIME TDFTIME UZEIT TIMS 6   0   Time Created  
107 TDLUSER TDLUSER TDUSER CHAR 12   0   Last changed by  
108 TDLRELES TDLRELES TDRELEASE CHAR 4   0   Last Changed in Release  
109 TDLDATE TDLDATE DATUM DATS 8   0   Changed On  
110 TDLTIME TDLTIME UZEIT TIMS 6   0   Last Changed at  
111 TDLINESIZE TDLINESIZE TDLINESIZE NUMC 3   0   Line Width  
112 TDTXTLINES TDTXTLINES TDVALUE NUMC 5   0   Number of Text Lines in Line Table  
113 TDHYPHENAT TDHYPHENAT TDBOOL CHAR 1   0   Hyphenation Active  
114 TDOSPRAS TDOSPRAS SPRAS LANG 1   0   Original language  
115 TDTRANSTAT TDTRANSTAT TDTRANSTAT NUMC 1   0   Translation status  
116 TDMACODE1 TDMACODE1 TDMACODE CHAR 16   0   Short Title 1  
117 TDMACODE2 TDMACODE2 TDMACODE CHAR 16   0   Short Title 2  
118 TDREFOBJ TDREFOBJ TDOBJECT CHAR 10   0   Object of Referenced Text  
119 TDREFNAME TDREFNAME TDOBNAME CHAR 70   0   Name of Referenced Text  
120 TDREFID TDREFID TDID CHAR 4   0   ID of Referenced Text  
121 TDTEXTTYPE TDTEXTTYPE TDTEXTTYPE CHAR 6   0   SAPscript: Format of Text  
122 TDCOMPRESS TDCOMPRESS TDCOMPRESS CHAR 1   0   SAPscript: Text is compressed  
123 MANDT MANDT MANDT CLNT 3   0   Client  
124 TDOCLASS TDOCLASS TDOCLASS CHAR 4   0   SAPscript: Object Class  
125 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system  
126 LINES TLINETAB   TTYP 0   0    
127 LFM ADS2KIPUPL_LONGTEXT   STRU 0   0    
128 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
129 TDID TDID TDID CHAR 4   0   Text ID  
130 LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
131 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
132 EXISTS_IN_DB CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
133 MODIFIED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
134 HEADER THEAD   STRU 0   0    
135 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
136 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
137 TDID TDID TDID CHAR 4   0   Text ID  
138 TDSPRAS SPRAS SPRAS LANG 1   0   Language Key  
139 TDTITLE TDTITLE TDTITLE CHAR 50   0   Title in dialog box  
140 TDFORM TDFORM TDFORM CHAR 16   0   Form name  
141 TDSTYLE TDSTYLE TDSTYLE CHAR 8   0   Style Name  
142 TDVERSION TDVERSION TDVERSION NUMC 5   0   Version  
143 TDFUSER TDFUSER TDUSER CHAR 12   0   Created by  
144 TDFRELES TDFRELES TDRELEASE CHAR 4   0   Release  
145 TDFDATE TDFDATE DATUM DATS 8   0   Date created  
146 TDFTIME TDFTIME UZEIT TIMS 6   0   Time Created  
147 TDLUSER TDLUSER TDUSER CHAR 12   0   Last changed by  
148 TDLRELES TDLRELES TDRELEASE CHAR 4   0   Last Changed in Release  
149 TDLDATE TDLDATE DATUM DATS 8   0   Changed On  
150 TDLTIME TDLTIME UZEIT TIMS 6   0   Last Changed at  
151 TDLINESIZE TDLINESIZE TDLINESIZE NUMC 3   0   Line Width  
152 TDTXTLINES TDTXTLINES TDVALUE NUMC 5   0   Number of Text Lines in Line Table  
153 TDHYPHENAT TDHYPHENAT TDBOOL CHAR 1   0   Hyphenation Active  
154 TDOSPRAS TDOSPRAS SPRAS LANG 1   0   Original language  
155 TDTRANSTAT TDTRANSTAT TDTRANSTAT NUMC 1   0   Translation status  
156 TDMACODE1 TDMACODE1 TDMACODE CHAR 16   0   Short Title 1  
157 TDMACODE2 TDMACODE2 TDMACODE CHAR 16   0   Short Title 2  
158 TDREFOBJ TDREFOBJ TDOBJECT CHAR 10   0   Object of Referenced Text  
159 TDREFNAME TDREFNAME TDOBNAME CHAR 70   0   Name of Referenced Text  
160 TDREFID TDREFID TDID CHAR 4   0   ID of Referenced Text  
161 TDTEXTTYPE TDTEXTTYPE TDTEXTTYPE CHAR 6   0   SAPscript: Format of Text  
162 TDCOMPRESS TDCOMPRESS TDCOMPRESS CHAR 1   0   SAPscript: Text is compressed  
163 MANDT MANDT MANDT CLNT 3   0   Client  
164 TDOCLASS TDOCLASS TDOCLASS CHAR 4   0   SAPscript: Object Class  
165 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system  
166 LINES TLINETAB   TTYP 0   0    
167 MSC ADS2KIPUPL_LONGTEXT   STRU 0   0    
168 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
169 TDID TDID TDID CHAR 4   0   Text ID  
170 LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
171 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
172 EXISTS_IN_DB CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
173 MODIFIED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
174 HEADER THEAD   STRU 0   0    
175 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
176 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
177 TDID TDID TDID CHAR 4   0   Text ID  
178 TDSPRAS SPRAS SPRAS LANG 1   0   Language Key  
179 TDTITLE TDTITLE TDTITLE CHAR 50   0   Title in dialog box  
180 TDFORM TDFORM TDFORM CHAR 16   0   Form name  
181 TDSTYLE TDSTYLE TDSTYLE CHAR 8   0   Style Name  
182 TDVERSION TDVERSION TDVERSION NUMC 5   0   Version  
183 TDFUSER TDFUSER TDUSER CHAR 12   0   Created by  
184 TDFRELES TDFRELES TDRELEASE CHAR 4   0   Release  
185 TDFDATE TDFDATE DATUM DATS 8   0   Date created  
186 TDFTIME TDFTIME UZEIT TIMS 6   0   Time Created  
187 TDLUSER TDLUSER TDUSER CHAR 12   0   Last changed by  
188 TDLRELES TDLRELES TDRELEASE CHAR 4   0   Last Changed in Release  
189 TDLDATE TDLDATE DATUM DATS 8   0   Changed On  
190 TDLTIME TDLTIME UZEIT TIMS 6   0   Last Changed at  
191 TDLINESIZE TDLINESIZE TDLINESIZE NUMC 3   0   Line Width  
192 TDTXTLINES TDTXTLINES TDVALUE NUMC 5   0   Number of Text Lines in Line Table  
193 TDHYPHENAT TDHYPHENAT TDBOOL CHAR 1   0   Hyphenation Active  
194 TDOSPRAS TDOSPRAS SPRAS LANG 1   0   Original language  
195 TDTRANSTAT TDTRANSTAT TDTRANSTAT NUMC 1   0   Translation status  
196 TDMACODE1 TDMACODE1 TDMACODE CHAR 16   0   Short Title 1  
197 TDMACODE2 TDMACODE2 TDMACODE CHAR 16   0   Short Title 2  
198 TDREFOBJ TDREFOBJ TDOBJECT CHAR 10   0   Object of Referenced Text  
199 TDREFNAME TDREFNAME TDOBNAME CHAR 70   0   Name of Referenced Text  
200 TDREFID TDREFID TDID CHAR 4   0   ID of Referenced Text  
201 TDTEXTTYPE TDTEXTTYPE TDTEXTTYPE CHAR 6   0   SAPscript: Format of Text  
202 TDCOMPRESS TDCOMPRESS TDCOMPRESS CHAR 1   0   SAPscript: Text is compressed  
203 MANDT MANDT MANDT CLNT 3   0   Client  
204 TDOCLASS TDOCLASS TDOCLASS CHAR 4   0   SAPscript: Object Class  
205 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system  
206 LINES TLINETAB   TTYP 0   0    
207 LTXT ADS2KIPUPL_LONGTEXT   STRU 0   0    
208 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
209 TDID TDID TDID CHAR 4   0   Text ID  
210 LANGUAGE SPRAS SPRAS LANG 1   0   Language Key  
211 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
212 EXISTS_IN_DB CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
213 MODIFIED CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
214 HEADER THEAD   STRU 0   0    
215 TDOBJECT TDOBJECT TDOBJECT CHAR 10   0   Texts: application object  
216 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
217 TDID TDID TDID CHAR 4   0   Text ID  
218 TDSPRAS SPRAS SPRAS LANG 1   0   Language Key  
219 TDTITLE TDTITLE TDTITLE CHAR 50   0   Title in dialog box  
220 TDFORM TDFORM TDFORM CHAR 16   0   Form name  
221 TDSTYLE TDSTYLE TDSTYLE CHAR 8   0   Style Name  
222 TDVERSION TDVERSION TDVERSION NUMC 5   0   Version  
223 TDFUSER TDFUSER TDUSER CHAR 12   0   Created by  
224 TDFRELES TDFRELES TDRELEASE CHAR 4   0   Release  
225 TDFDATE TDFDATE DATUM DATS 8   0   Date created  
226 TDFTIME TDFTIME UZEIT TIMS 6   0   Time Created  
227 TDLUSER TDLUSER TDUSER CHAR 12   0   Last changed by  
228 TDLRELES TDLRELES TDRELEASE CHAR 4   0   Last Changed in Release  
229 TDLDATE TDLDATE DATUM DATS 8   0   Changed On  
230 TDLTIME TDLTIME UZEIT TIMS 6   0   Last Changed at  
231 TDLINESIZE TDLINESIZE TDLINESIZE NUMC 3   0   Line Width  
232 TDTXTLINES TDTXTLINES TDVALUE NUMC 5   0   Number of Text Lines in Line Table  
233 TDHYPHENAT TDHYPHENAT TDBOOL CHAR 1   0   Hyphenation Active  
234 TDOSPRAS TDOSPRAS SPRAS LANG 1   0   Original language  
235 TDTRANSTAT TDTRANSTAT TDTRANSTAT NUMC 1   0   Translation status  
236 TDMACODE1 TDMACODE1 TDMACODE CHAR 16   0   Short Title 1  
237 TDMACODE2 TDMACODE2 TDMACODE CHAR 16   0   Short Title 2  
238 TDREFOBJ TDREFOBJ TDOBJECT CHAR 10   0   Object of Referenced Text  
239 TDREFNAME TDREFNAME TDOBNAME CHAR 70   0   Name of Referenced Text  
240 TDREFID TDREFID TDID CHAR 4   0   ID of Referenced Text  
241 TDTEXTTYPE TDTEXTTYPE TDTEXTTYPE CHAR 6   0   SAPscript: Format of Text  
242 TDCOMPRESS TDCOMPRESS TDCOMPRESS CHAR 1   0   SAPscript: Text is compressed  
243 MANDT MANDT MANDT CLNT 3   0   Client  
244 TDOCLASS TDOCLASS TDOCLASS CHAR 4   0   SAPscript: Object Class  
245 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system  
246 LINES TLINETAB   TTYP 0   0    
247 MAX_SRNBR_OSDS ADSPC_SRNBR ADSPC_SRNBR NUMC 5   0   Serial number  
248 MAX_SRNBR_PQA ADSPC_SRNBR ADSPC_SRNBR NUMC 5   0   Serial number  
249 MAX_SRNBR_OCH ADSPC_SRNBR ADSPC_SRNBR NUMC 5   0   Serial number  
250 STATUS_BUSINESS_TRANSACTION J_VORGANG J_VORGANG CHAR 4   0   Business Transaction *
History
Last changed by/on SAP  20130529 
SAP Release Created in 470