SAP ABAP Table SPCIPEFF (Effectivity Range)

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	SPCIPEFF	Table Relationship Diagram
Short Description	Effectivity Range

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	SPCIPCSN
2	SQNBR	☑	ADSPC_SQNBR	ADSPC_SRNBR	NUMC	5	0	Sequence Number	SPCIPCSN
3	PNR	☑	ADSPC_PNR	CHAR15	CHAR	15	0	Part Number	SPCIPCSN
4	MFR	☑	ADSPC_MFR	CHAR5	CHAR	5	0	Manufacturer Code	SPCIPCSN
5	CSNSRNBR	☑	ADSPC_SRNBR	ADSPC_SRNBR	NUMC	5	0	Serial number	SPCIPCSN
6	SRNBR	☑	ADSPC_SRNBR	ADSPC_SRNBR	NUMC	5	0	Serial number
7	EFF	☐	ADSPC_EFF	ADSPC_EFF	CHAR	6	0	Effectivity Range Code
8	OBJ	☐	ADSPCIP_RANGE	ADSPCIP_RANGE	CHAR	20	0	Object for Status Management
9	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	SPCIPEFF	CLIENT	SPCIPCSN	CLIENT		1	N
2	SPCIPEFF	CSNSRNBR	SPCIPCSN	SRNBR		1	N
3	SPCIPEFF	MFR	SPCIPCSN	MFR		1	N
4	SPCIPEFF	PNR	SPCIPCSN	PNR		1	N
5	SPCIPEFF	SQNBR	SPCIPCSN	SQNBR		1	N

History

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