SAP table IBIB (IB: Installed Base/IBase)
SAP table IBIB has 2 primary key fields being MANDT,IBASE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
IBase: Number of the Installed Base/IBase
NUMC
18
0
IB_IBASE
CRNAM
User who created the object
CHAR
12
0
BU_CRUSR
CRTIM
Time (UTC) at which the object was created
DEC
15
0
ICRTS
UPNAM
Last User to Change Object
CHAR
12
0
IB_IBIB_UPNAM
UPTIM
Time of Last Change (in UTC)
DEC
15
0
IB_IBIB_UPTIM
IBTYP
IB: Installed Base Category
CHAR
2
0
T371A
IB_IBTYP
COMPIND
IB: Component Store Indicator (Not Currently Used)
CHAR
1
0
IB_COMPIND
CONFIND
IB: Installed Base Used for Variant Configuration
CHAR
1
0
IB_CONFIND
FILID
IB: Identification for a Group of Physical Files
CHAR
2
0
T371B
IB_FILID
VALTYP
IB: Validity type for the installed base
NUMC
1
0
IB_VALTYP
Possible values
1
Without validity
2
Temporal validity
INTST
IB: Internal Status of the IBase
NUMC
1
0
IB_INTSTATE
Possible values
0
Not specified
1
Actual status
STTYP
IBase: Status Type
CHAR
2
0
T371ST
IB_STTYP
IB_GUID
IB: Unique record number
CHAR
22
0
IB_RECNO
IB_GUID_16
GUID in 'RAW' format
RAW
16
0
GUID_16
OBJNR
Object number
CHAR
22
0
*
J_OBJNR
EXTID
IB: External Name/ID of Installed Base
CHAR
30
0
IB_EXTID
MLANG
Primary language for object texts
LANG
1
0
T002
IB_MLANG
AUTHG
IBase: Authorization Group for IBase
CHAR
4
0
*
IB_AUTHG
VBELN
Sales Document
CHAR
10
0
VBELN_VA
POSNR
Sales Document Item
NUMC
6
0
POSNR_VA
MSTONE
OEWB: Milestone
CHAR
4
0
OBOM_WB_MSTON
COUNTER
OEWB: Version
NUMC
4
0
OBOM_WB_VERS1
CUOBJ
Configuration (internal object number)
NUMC
18
0
CUOBJ
PLANT
Plant
CHAR
4
0
WERKS_D
MATNR
Material Number
CHAR
40
0
MATNR
KALNR
Cost Estimate Number - Product Costing
NUMC
12
0
*
CK_KALNR1
KBID
Configuration: Temporary Data Element for SCEKB-KBID
NUMC
6
0
ATKBID
CLANG
Configuration: Characteristic Valuation Language
LANG
1
0
*
CLANG
CSTATUS
Installed base (IBase) status from configuration perspective
CHAR
2
0
ATIBSTATUS
_DATAAGING
Data Filter Value for Data Aging
DATS
8
0
DATA_TEMPERATURE
IBIB foreign key relationships
Table
Field
Check Table
Check Field
0 IBIB
FILID
T371B IB: Groups of Database Tables
FILID
1 IBIB
IBTYP
T371A IB: Installed Base Category
MANDT
1 IBIB
IBTYP
T371A IB: Installed Base Category
IBTYP
0 IBIB
MLANG
T002 Language Keys (Component BC-I18)
SPRAS
1 IBIB
STTYP
T371ST IBase: Status Type
STTYP