SAP Table IBSP

IB: Installed Base Component - Enhancement/Specialization

IBSP (IB: Installed Base Component - Enhancement/Specialization) 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 IBSP to other SAP tables.

IBSP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
SP_RECNO IB: Unique record number IB_RECNO CHAR 22 0
VALFR IBase: Valid From IB_VALFR DEC 15 0
VALTO IBase: Valid To IB_VALTO DEC 15 0
AENNR Change Number AENNR CHAR 12 0
DELFLAG Yes/No (X/ ) OAX CHAR 1 0
X Yes
NULL No
SP_INSTANCE IB: Component (instance) IB_INSTANCE NUMC 18 0
INSTANCE IB: Component (instance) IB_INSTANCE NUMC 18 0
AMOUNT Quantity field, length 13, with +/- sign MENGV13 QUAN 13 3
UNIT Base Unit of Measure MEINS UNIT 3 0
EQUNO IB: Equipment number IB_EQUNR CHAR 18 0
MATNO Material Number MATNR CHAR 18 0
SERNO IB: Serial numbers IB_SERNO CHAR 18 0
PLANT Plant WERKS_D CHAR 4 0
BATCH Batch Number CHARG_D CHAR 10 0
REVLV Revision Level REVLV CHAR 2 0
DEVICEID IB: Identification IB_DEVICEID CHAR 40 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
CRNAM User who created the object BU_CRUSR CHAR 12 0
CRTIM Time (UTC) at which the object was created ICRTS DEC 15 0
UPNAM Last user to change object BU_CHUSR CHAR 12 0
UPTIM Time (UTC) at which the object was last changed IUPTS DEC 15 0