SAP ABAP Table SPCIPPARTS (Other parts that can be used)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD-SPC-PR (Application Component) Provisioning
     ⤷ AD_SPC_PH3_IP (Package) SPEC 2000 Initial Provisioning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SPCIPPARTS	Table Relationship Diagram
Short Description	Other parts that can be used

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	CLIENT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	SPCIPPDR
2	SQNBR	☑	ADSPC_SQNBR	ADSPC_SRNBR	NUMC	5	0	Sequence Number	SPCIPPDR
3	PNR	☑	ADSPC_PNR	CHAR15	CHAR	15	0	Part Number	SPCIPPDR
4	MFR	☑	ADSPC_MFR	CHAR5	CHAR	5	0	Manufacturer Code	SPCIPPDR
5	EIP	☑	ADSPC_EIP	ADSPC_EIP	CHAR	15	0	End Item Part Number	SPCIPPDR
6	EIM	☑	ADSPC_EIM	ADSPC_EIM	CHAR	5	0	End Item Manufacturer Code	SPCIPPDR
7	SRNBR	☑	ADSPC_SRNBR	ADSPC_SRNBR	NUMC	5	0	Serial number
8	PARTTP	☐	ADSPC_PARTTP	ADSPC_PARTTP	CHAR	1	0	Part type
9	PARTPNR	☐	ADSPC_PARTPNR	ADSPC_OPN	CHAR	32	0	Other Parts - Part Number
10	PARTMFR	☐	ADSPC_PARTMFR	ADSPC_MFR	CHAR	5	0	Other Parts - Manufacturer Code
11	OBJ	☐	ADSPCIP_RANGE	ADSPCIP_RANGE	CHAR	20	0	Object for Status Management
12	DELFLG	☐	ADSPC_DELETION_FLAG	CHAR1	CHAR	1	0	Deletion Flag for IP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPCIPPARTS	CLIENT	SPCIPPDR	CLIENT		1	N
2	SPCIPPARTS	EIM	SPCIPPDR	EIM		1	N
3	SPCIPPARTS	EIP	SPCIPPDR	EIP		1	N
4	SPCIPPARTS	MFR	SPCIPPDR	MFR		1	N
5	SPCIPPARTS	PNR	SPCIPPDR	PNR		1	N
6	SPCIPPARTS	SQNBR	SPCIPPDR	SQNBR		1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2