SAP ABAP Table SPCIPPDS (SPEC2000: Procurement Data Segment)

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	SPCIPPDS	Table Relationship Diagram
Short Description	SPEC2000: Procurement Data Segment

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	SPL	☑	ADSPC_SPL	CHAR5	CHAR	5	0	Supplier Code
6	KWD	☐	ADSPC_KWD	CHAR8	CHAR	8	0	Keyword Name
7	UNT	☐	ADSPC_UNT	CHAR2	CHAR	2	0	Unit of Measure Code
8	UNCQNT	☐	ADSPC_UNCQNT	ADSPC_QTO	NUMC	5	0	Unit of measure clarification - Quantity
9	UNCUNT	☐	ADSPC_UNCUNT	ADSPC_UNT	CHAR	2	0	Unit of measure clarification - Unit of Measure
10	UNP	☐	ADSPC_UNP	CHAR13	CHAR	13	0	Unit Price Amount
11	ICR	☐	ADSPC_ICR	CHAR3	CHAR	3	0	International Currency Code
12	PTC	☐	ADSPC_PTC	ADSPC_PTC	CHAR	1	0	SPEC 2000: Price Type Code
13	PRCC	☐	ADSPC_PRCC	ADSPC_PRCC	CHAR	1	0	Price Condition Code
14	SPQ	☐	ADSPC_SPQ	CHAR3	CHAR	3	0	Standard Package Quantity
15	DIS	☐	ADSPC_DIS	CHAR2	CHAR	2	0	Discount Percent
16	PDP	☐	ADSPC_PDP	CHAR5	CHAR	5	0	Procurement Discount Percent
17	LTM	☐	ADSPC_LTM	CHAR3	CHAR	3	0	Lead Time
18	PRP	☐	ADSPC_PRP	ADSPC_PRP	CHAR	1	0	Proprietary Code
19	SIRPNR	☐	ADSPC_SIRPNR	ADSPC_OPN	CHAR	32	0	Selected Item - Part Number
20	SIRMFR	☐	ADSPC_SIRMFR	ADSPC_MFR	CHAR	5	0	Selected Item - Manufacturer Code
21	CSDDNR	☐	ADSPC_CSDDNR	ADSPC_OPN	CHAR	32	0	Control Specification/Drawing - Number
22	CSDMFR	☐	ADSPC_CSDMFR	ADSPC_MFR	CHAR	5	0	Control Specification/Drawing - Manufacturer Code
23	CPNPNR	☐	ADSPC_CPNPNR	ADSPC_OPN	CHAR	32	0	Category I Container - Part Number
24	CPNMFR	☐	ADSPC_CPNMFR	ADSPC_MFR	CHAR	5	0	Category I Container - Manufacturer Code
25	PSPPNR	☐	ADSPC_PSPPNR	ADSPC_OPN	CHAR	32	0	Preferred Spare Part Number
26	PSPMFR	☐	ADSPC_PSPMFR	ADSPC_MFR	CHAR	5	0	Preferred Spare Part - Manufacturer Code
27	MSQ	☐	ADSPC_MSQ	CHAR5	CHAR	5	0	Minimum Sales Quantity
28	EXP	☐	ADSPC_EXP	ADSPC_EXP	CHAR	6	0	Expiration Date
29	EFFDATE	☐	ADSPC_EFFDATE	ADSPC_EFFDATE	NUMC	5	0	Effective Date
30	OBJ	☐	ADSPCIP_RANGE	ADSPCIP_RANGE	CHAR	20	0	Object for Status Management
31	DELFLG	☐	ADSPC_DELETION_FLAG	CHAR1	CHAR	1	0	Deletion Flag for IP
32	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPCIPPDS	CLIENT	SPCIPPDR	CLIENT		1	N
2	SPCIPPDS	MFR	SPCIPPDR	MFR		1	N
3	SPCIPPDS	PNR	SPCIPPDR	PNR		1	N
4	SPCIPPDS	SQNBR	SPCIPPDR	SQNBR		1	N

History

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