SAP IBSP IB: Installed Base Component - Enhancement/Specialization Table data and field list

IBSP is a standard SAP Table which is used to store IB: Installed Base Component - Enhancement/Specialization data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The IBSP table consists of various fields, each holding specific information or linking keys about IB: Installed Base Component - Enhancement/Specialization data available in SAP. These include SP_RECNO (IB: Unique record number), VALFR (IBase: Valid From), VALTO (IBase: Valid To), AENNR (Change Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

IBSP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP IBSP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the IBSP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
SP_RECNO	IB: Unique record number	IB_RECNO	CHAR	22			SYSUUID_22
VALFR	IBase: Valid From	IB_VALFR	DEC	15		TSTPS	BCOS_TSTMP
VALTO	IBase: Valid To	IB_VALTO	DEC	15		TSTPS	BCOS_TSTMP
AENNR	Change Number	AENNR	CHAR	12	Assigned to domain	AENNR	AENNR	AEN
DELFLAG	Yes/No (X/ )	OAX	CHAR	1			X
SP_INSTANCE	IB: Component (instance)	IB_INSTANCE	NUMC	18		ALPHA	IB_INSTANCE	IBC
INSTANCE	IB: Component (instance)	IB_INSTANCE	NUMC	18		ALPHA	IB_INSTANCE	IBC
AMOUNT	Quantity field, length 13, with +/- sign	MENGV13	QUAN	13(3)			MENGV13
UNIT	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
EQUNO	IB: Equipment number	IB_EQUNR	CHAR	18	Assigned to domain	ALPHA	IB_EQUNR		IB_EQUI
MATNO	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
SERNO	IB: Serial numbers	IB_SERNO	CHAR	18		ALPHA	IB_SERNO		IB_SERNO
PLANT	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
BATCH	Batch Number	CHARG_D	CHAR	10	Assigned to domain		CHARG	CHA
REVLV	Revision Level	REVLV	CHAR	2		NUMCV	REVLV	RVS
DEVICEID	IB: Identification	IB_DEVICEID	CHAR	40			IB_DEVICEID
.INCLU--AP				0
UII	Unique Item Identifier	UII_CHAR72	CHAR	72			UII_CHAR72	UII	H_UII
CRNAM	User who created the object	BU_CRUSR	CHAR	12			USNAM
CRTIM	Time (UTC) at which the object was created	ICRTS	DEC	15		TSTPS	BCOS_TSTMP
UPNAM	Last user to change object	BU_CHUSR	CHAR	12			USNAM
UPTIM	Time (UTC) at which the object was last changed	IUPTS	DEC	15		TSTPS	BCOS_TSTMP

Key field

Non-key field

< IBSEL_TYPE_OF - Selection Criteria: Object IBSP0 - IB: Specialization (Include structure) >

How do I retrieve data from SAP table IBSP using ABAP code

The following ABAP code Example will allow you to do a basic selection on IBSP to SELECT all data from the table
DATA: WA_IBSP TYPE IBSP.

SELECT SINGLE *
FROM IBSP
INTO CORRESPONDING FIELDS OF WA_IBSP
WHERE...

How to access SAP table IBSP

Within an ECC or HANA version of SAP you can also view further information about IBSP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).