SAP ABAP Table ADS2KIPUPL_H_SPCIPPDR (Hierarchy table structure: ADIP SPEC2000)

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_SPCIPPDR	Table Relationship Diagram
Short Description	Hierarchy table structure: ADIP SPEC2000

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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_PDR	VSPCIPPDR		STRU	0	0
4	.INCLUDE				0	0	Spare parts / End items
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	EIP	ADSPC_EIP	ADSPC_EIP	CHAR	15	0	End Item Part Number
10	EIM	ADSPC_EIM	ADSPC_EIM	CHAR	5	0	End Item Manufacturer Code
11	SPC	ADSPC_SPC	ADSPC_SPC	NUMC	1	0	Spare Part Class Code
12	URR	ADSPC_URR	ADSPC_URR	DEC	9	6	Unscheduled Removal Rate
13	URRTCC	ADSPC_URRTCC	ADSPC_URRTCC	CHAR	1	0	Time Cycle Code for URR
14	TCBSV	ADSPC_TCBSV	ADSPC_TCBSV	NUMC	6	0	Time/Cycles Before Scheduled Shop Visit
15	TCBSVTCC	ADSPC_TCBSVTCC	ADSPC_TCC	CHAR	1	0	Time Cycle Code for TCBSV
16	TCBO	ADSPC_TCBO	ADSPC_TCBSV	NUMC	6	0	Time/Cycles Before Overhaul
17	TCBOTCC	ADSPC_TCBOTCC	ADSPC_TCC	CHAR	1	0	Time Cycle Code for TCBO
18	SCR	ADSPC_SCR	ADSPC_SCR	INT2	5	0	Scrap Rate
19	REC	ADSPC_REC	ADSPC_REC	NUMC	4	0	Recommended Quantity
20	TQA	ADSPC_TQA	ADSPC_TQA	DEC	11	6	Total Quantity per Aircraft/Engine
21	MPC	ADSPC_MPC	ADSPC_MPC	NUMC	2	0	Maintenance Percent
22	SLC	ADSPC_SLC	ADSPC_SLC	CHAR	2	0	Shelf Life Code
23	SLC_UPPER	ADSPC_SLC_UPPER	ADSPC_SLC	CHAR	2	0	Shelf Life Code Upper
24	MST	ADSPC_MST	ADSPC_MST	DEC	9	6	Mean Shop Processing Time
25	OPN	ADSPC_OPN	ADSPC_OPN	CHAR	32	0	Overlength Part Number
26	HAZ	ADSPC_HAZ	ADSPC_HAZ	CHAR	6	0	Hazardous Material Code
27	PIC	ADSPC_PIC	ADSPC_PIC	CHAR	1	0	Pool Item Candidate Indicator
28	ESD	ADSPC_ESD	ADSPC_ESD	CHAR	1	0	Electrostatic Sensitive Device Indicator
29	RMC	ADSPC_RMC	ADSPC_RMC	CHAR	5	0	SPEC2000: Revised Manufacturer Code
30	ICC	ADSCP_ICC	ADSCP_ICC	NUMC	6	0	International Commodity Code
31	OBJ	ADSPCIP_RANGE	ADSPCIP_RANGE	CHAR	20	0	Object for Status Management
32	DELFLG	ADSPC_DELETION_FLAG	CHAR1	CHAR	1	0	Deletion Flag for IP
33	.INCLUDE				0	0
34	.INCLUDE				0	0	Structures for generating change document update programs
35	KZ	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
36	Y_PDR	VSPCIPPDR		STRU	0	0
37	.INCLUDE				0	0	Spare parts / End items
38	CLIENT	SYMANDT	MANDT	CLNT	3	0	Client ID
39	SQNBR	ADSPC_SQNBR	ADSPC_SRNBR	NUMC	5	0	Sequence Number
40	PNR	ADSPC_PNR	CHAR15	CHAR	15	0	Part Number
41	MFR	ADSPC_MFR	CHAR5	CHAR	5	0	Manufacturer Code
42	EIP	ADSPC_EIP	ADSPC_EIP	CHAR	15	0	End Item Part Number
43	EIM	ADSPC_EIM	ADSPC_EIM	CHAR	5	0	End Item Manufacturer Code
44	SPC	ADSPC_SPC	ADSPC_SPC	NUMC	1	0	Spare Part Class Code
45	URR	ADSPC_URR	ADSPC_URR	DEC	9	6	Unscheduled Removal Rate
46	URRTCC	ADSPC_URRTCC	ADSPC_URRTCC	CHAR	1	0	Time Cycle Code for URR
47	TCBSV	ADSPC_TCBSV	ADSPC_TCBSV	NUMC	6	0	Time/Cycles Before Scheduled Shop Visit
48	TCBSVTCC	ADSPC_TCBSVTCC	ADSPC_TCC	CHAR	1	0	Time Cycle Code for TCBSV
49	TCBO	ADSPC_TCBO	ADSPC_TCBSV	NUMC	6	0	Time/Cycles Before Overhaul
50	TCBOTCC	ADSPC_TCBOTCC	ADSPC_TCC	CHAR	1	0	Time Cycle Code for TCBO
51	SCR	ADSPC_SCR	ADSPC_SCR	INT2	5	0	Scrap Rate
52	REC	ADSPC_REC	ADSPC_REC	NUMC	4	0	Recommended Quantity
53	TQA	ADSPC_TQA	ADSPC_TQA	DEC	11	6	Total Quantity per Aircraft/Engine
54	MPC	ADSPC_MPC	ADSPC_MPC	NUMC	2	0	Maintenance Percent
55	SLC	ADSPC_SLC	ADSPC_SLC	CHAR	2	0	Shelf Life Code
56	SLC_UPPER	ADSPC_SLC_UPPER	ADSPC_SLC	CHAR	2	0	Shelf Life Code Upper
57	MST	ADSPC_MST	ADSPC_MST	DEC	9	6	Mean Shop Processing Time
58	OPN	ADSPC_OPN	ADSPC_OPN	CHAR	32	0	Overlength Part Number
59	HAZ	ADSPC_HAZ	ADSPC_HAZ	CHAR	6	0	Hazardous Material Code
60	PIC	ADSPC_PIC	ADSPC_PIC	CHAR	1	0	Pool Item Candidate Indicator
61	ESD	ADSPC_ESD	ADSPC_ESD	CHAR	1	0	Electrostatic Sensitive Device Indicator
62	RMC	ADSPC_RMC	ADSPC_RMC	CHAR	5	0	SPEC2000: Revised Manufacturer Code
63	ICC	ADSCP_ICC	ADSCP_ICC	NUMC	6	0	International Commodity Code
64	OBJ	ADSPCIP_RANGE	ADSPCIP_RANGE	CHAR	20	0	Object for Status Management
65	DELFLG	ADSPC_DELETION_FLAG	CHAR1	CHAR	1	0	Deletion Flag for IP
66	.INCLUDE				0	0
67	.INCLUDE				0	0	Structures for generating change document update programs
68	KZ	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
69	T_X_APN	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
70	T_Y_APN	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
71	T_N_APN	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
72	T_X_MCP	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
73	T_Y_MCP	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
74	T_N_MCP	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
75	T_X_OPT	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
76	T_Y_OPT	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
77	T_N_OPT	ADS2KIPUPL_VSPCIPPARTS		TTYP	0	0
78	T_SUPPLIERS	ADS2KIPUPL_H_T_SPCIPPDS		TTYP	0	0
79	T_LOCATIONS	ADS2KIPUPL_H_T_SPCIPCSN		TTYP	0	0
80	MSC	ADS2KIPUPL_LONGTEXT		STRU	0	0
81	TDOBJECT	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object
82	TDID	TDID	TDID	CHAR	4	0	Text ID
83	LANGUAGE	SPRAS	SPRAS	LANG	1	0	Language Key
84	TDNAME	TDOBNAME	TDOBNAME	CHAR	70	0	Name
85	EXISTS_IN_DB	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
86	MODIFIED	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
87	HEADER	THEAD		STRU	0	0
88	TDOBJECT	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object
89	TDNAME	TDOBNAME	TDOBNAME	CHAR	70	0	Name
90	TDID	TDID	TDID	CHAR	4	0	Text ID
91	TDSPRAS	SPRAS	SPRAS	LANG	1	0	Language Key
92	TDTITLE	TDTITLE	TDTITLE	CHAR	50	0	Title in dialog box
93	TDFORM	TDFORM	TDFORM	CHAR	16	0	Form name
94	TDSTYLE	TDSTYLE	TDSTYLE	CHAR	8	0	Style Name
95	TDVERSION	TDVERSION	TDVERSION	NUMC	5	0	Version
96	TDFUSER	TDFUSER	TDUSER	CHAR	12	0	Created by
97	TDFRELES	TDFRELES	TDRELEASE	CHAR	4	0	Release
98	TDFDATE	TDFDATE	DATUM	DATS	8	0	Date created
99	TDFTIME	TDFTIME	UZEIT	TIMS	6	0	Time Created
100	TDLUSER	TDLUSER	TDUSER	CHAR	12	0	Last changed by
101	TDLRELES	TDLRELES	TDRELEASE	CHAR	4	0	Last Changed in Release
102	TDLDATE	TDLDATE	DATUM	DATS	8	0	Changed On
103	TDLTIME	TDLTIME	UZEIT	TIMS	6	0	Last Changed at
104	TDLINESIZE	TDLINESIZE	TDLINESIZE	NUMC	3	0	Line Width
105	TDTXTLINES	TDTXTLINES	TDVALUE	NUMC	5	0	Number of Text Lines in Line Table
106	TDHYPHENAT	TDHYPHENAT	TDBOOL	CHAR	1	0	Hyphenation Active
107	TDOSPRAS	TDOSPRAS	SPRAS	LANG	1	0	Original language
108	TDTRANSTAT	TDTRANSTAT	TDTRANSTAT	NUMC	1	0	Translation status
109	TDMACODE1	TDMACODE1	TDMACODE	CHAR	16	0	Short Title 1
110	TDMACODE2	TDMACODE2	TDMACODE	CHAR	16	0	Short Title 2
111	TDREFOBJ	TDREFOBJ	TDOBJECT	CHAR	10	0	Object of Referenced Text
112	TDREFNAME	TDREFNAME	TDOBNAME	CHAR	70	0	Name of Referenced Text
113	TDREFID	TDREFID	TDID	CHAR	4	0	ID of Referenced Text
114	TDTEXTTYPE	TDTEXTTYPE	TDTEXTTYPE	CHAR	6	0	SAPscript: Format of Text
115	TDCOMPRESS	TDCOMPRESS	TDCOMPRESS	CHAR	1	0	SAPscript: Text is compressed
116	MANDT	MANDT	MANDT	CLNT	3	0	Client
117	TDOCLASS	TDOCLASS	TDOCLASS	CHAR	4	0	SAPscript: Object Class
118	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system
119	LINES	TLINETAB		TTYP	0	0
120	LTXT	ADS2KIPUPL_LONGTEXT		STRU	0	0
121	TDOBJECT	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object
122	TDID	TDID	TDID	CHAR	4	0	Text ID
123	LANGUAGE	SPRAS	SPRAS	LANG	1	0	Language Key
124	TDNAME	TDOBNAME	TDOBNAME	CHAR	70	0	Name
125	EXISTS_IN_DB	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
126	MODIFIED	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
127	HEADER	THEAD		STRU	0	0
128	TDOBJECT	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object
129	TDNAME	TDOBNAME	TDOBNAME	CHAR	70	0	Name
130	TDID	TDID	TDID	CHAR	4	0	Text ID
131	TDSPRAS	SPRAS	SPRAS	LANG	1	0	Language Key
132	TDTITLE	TDTITLE	TDTITLE	CHAR	50	0	Title in dialog box
133	TDFORM	TDFORM	TDFORM	CHAR	16	0	Form name
134	TDSTYLE	TDSTYLE	TDSTYLE	CHAR	8	0	Style Name
135	TDVERSION	TDVERSION	TDVERSION	NUMC	5	0	Version
136	TDFUSER	TDFUSER	TDUSER	CHAR	12	0	Created by
137	TDFRELES	TDFRELES	TDRELEASE	CHAR	4	0	Release
138	TDFDATE	TDFDATE	DATUM	DATS	8	0	Date created
139	TDFTIME	TDFTIME	UZEIT	TIMS	6	0	Time Created
140	TDLUSER	TDLUSER	TDUSER	CHAR	12	0	Last changed by
141	TDLRELES	TDLRELES	TDRELEASE	CHAR	4	0	Last Changed in Release
142	TDLDATE	TDLDATE	DATUM	DATS	8	0	Changed On
143	TDLTIME	TDLTIME	UZEIT	TIMS	6	0	Last Changed at
144	TDLINESIZE	TDLINESIZE	TDLINESIZE	NUMC	3	0	Line Width
145	TDTXTLINES	TDTXTLINES	TDVALUE	NUMC	5	0	Number of Text Lines in Line Table
146	TDHYPHENAT	TDHYPHENAT	TDBOOL	CHAR	1	0	Hyphenation Active
147	TDOSPRAS	TDOSPRAS	SPRAS	LANG	1	0	Original language
148	TDTRANSTAT	TDTRANSTAT	TDTRANSTAT	NUMC	1	0	Translation status
149	TDMACODE1	TDMACODE1	TDMACODE	CHAR	16	0	Short Title 1
150	TDMACODE2	TDMACODE2	TDMACODE	CHAR	16	0	Short Title 2
151	TDREFOBJ	TDREFOBJ	TDOBJECT	CHAR	10	0	Object of Referenced Text
152	TDREFNAME	TDREFNAME	TDOBNAME	CHAR	70	0	Name of Referenced Text
153	TDREFID	TDREFID	TDID	CHAR	4	0	ID of Referenced Text
154	TDTEXTTYPE	TDTEXTTYPE	TDTEXTTYPE	CHAR	6	0	SAPscript: Format of Text
155	TDCOMPRESS	TDCOMPRESS	TDCOMPRESS	CHAR	1	0	SAPscript: Text is compressed
156	MANDT	MANDT	MANDT	CLNT	3	0	Client
157	TDOCLASS	TDOCLASS	TDOCLASS	CHAR	4	0	SAPscript: Object Class
158	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system
159	LINES	TLINETAB		TTYP	0	0
160	MAX_SRNBR_PARTS	ADSPC_SRNBR	ADSPC_SRNBR	NUMC	5	0	Serial number
161	MAX_SRNBR_CSN	ADSPC_SRNBR	ADSPC_SRNBR	NUMC	5	0	Serial number
162	STATUS_BUSINESS_TRANSACTION	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*