1. Home
  2. Resources
  3. SAP Tables
  4. SPCIPPDR - Spare parts / End items

SAP Table SPCIPPDR

Spare parts / End items

SPCIPPDR (Spare parts / End items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SPCIPPDR to other SAP tables.

SPCIPPDR table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client ID SYMANDT CLNT 3 0
SQNBR Sequence Number ADSPC_SQNBR NUMC 5 0
PNR Part Number ADSPC_PNR CHAR 15 0
MFR Manufacturer Code ADSPC_MFR CHAR 5 0
EIP End Item Part Number ADSPC_EIP CHAR 15 0
EIM End Item Manufacturer Code ADSPC_EIM CHAR 5 0
SPC Spare Part Class Code ADSPC_SPC NUMC 1 0
0 Reference item
1 Expendable spare
2 Repairable spare, having a supporting CMM
6 Repairable spare, not having a supporting CMM
URR Unscheduled Removal Rate ADSPC_URR DEC 9 6
URRTCC Time Cycle Code for URR ADSPC_URRTCC CHAR 1 0
L Landing cycles
H per 1000 flight hours
C Operating cycles
TCBSV Time/Cycles Before Scheduled Shop Visit ADSPC_TCBSV NUMC 6 0
TCBSVTCC Time Cycle Code for TCBSV ADSPC_TCBSVTCC CHAR 1 0
L Landing cycles
H Flight hours
C Operating cycles
TCBO Time/Cycles Before Overhaul ADSPC_TCBO NUMC 6 0
TCBOTCC Time Cycle Code for TCBO ADSPC_TCBOTCC CHAR 1 0
L Landing cycles
H Flight hours
C Operating cycles
SCR Scrap Rate ADSPC_SCR INT2 5 0
REC Recommended Quantity ADSPC_REC NUMC 4 0
TQA Total Quantity per Aircraft/Engine ADSPC_TQA DEC 11 6
MPC Maintenance Percent ADSPC_MPC NUMC 2 0
SLC Shelf Life Code ADSPC_SLC CHAR 2 0
A 26 months
H 40 months
G 38 months
F 36 months
E 34 months
D 32 months
0 No specified shelf life
B 28 months
K 46 months
6 24 months
5 13-24 months
4 10-12 months
3 7-9 months
2 4-6 months
1 3 months or less
C 30 months
Q 58 months
Y 74 months
X 72 months
W 70 months
V 68 months
U 66 months
T 64 months
I 42 months
R 60 months
J 44 months
P 56 months
O 54 months
N 52 months
M 50 months
L 48 months
Z 76 months
S 62 months
SLC_UPPER Shelf Life Code Upper ADSPC_SLC_UPPER CHAR 2 0
A 26 months
H 40 months
G 38 months
F 36 months
E 34 months
D 32 months
0 No specified shelf life
B 28 months
K 46 months
6 24 months
5 13-24 months
4 10-12 months
3 7-9 months
2 4-6 months
1 3 months or less
C 30 months
Q 58 months
Y 74 months
X 72 months
W 70 months
V 68 months
U 66 months
T 64 months
I 42 months
R 60 months
J 44 months
P 56 months
O 54 months
N 52 months
M 50 months
L 48 months
Z 76 months
S 62 months
MST Mean Shop Processing Time ADSPC_MST DEC 9 6
OPN Overlength Part Number ADSPC_OPN CHAR 32 0
HAZ Hazardous Material Code ADSPC_HAZ CHAR 6 0
PIC Pool Item Candidate Indicator ADSPC_PIC CHAR 1 0
1 Pool Item Candidate
NULL Not a Pool Item Candidate
ESD Electrostatic Sensitive Device Indicator ADSPC_ESD CHAR 1 0
1 Electrostatic sensitive device
NULL Not an electrostatic sensitive device
RMC SPEC2000: Revised Manufacturer Code ADSPC_RMC CHAR 5 0
ICC International Commodity Code ADSCP_ICC NUMC 6 0
OBJ Object for Status Management ADSPCIP_RANGE CHAR 20 0
DELFLG Deletion Flag for IP ADSPC_DELETION_FLAG CHAR 1 0