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 |
Possible values
|
||||||
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 |