IBIB SAP (IB: Installed Base/IBase) Table details

Dictionary Type: Table
Description: IB: Installed Base/IBase




ABAP Code to SELECT data from IBIB
Related tables to IBIB
Access table IBIB




Table field list including key, data, relationships and ABAP select examples

IBIB is a standard SAP Table which is used to store IB: Installed Base/IBase data and is available within R/3 SAP systems depending on the version and release level.

The IBIB table consists of various fields, each holding specific information or linking keys about IB: Installed Base/IBase data available in SAP. These include IBASE (IBase: Number of the Installed Base/IBase), CRNAM (User who created the object), CRTIM (Time (UTC) at which the object was created), UPNAM (Last User to Change Object).. 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. .

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)

Text table = IBIBT


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
IBASEIBase: Number of the Installed Base/IBase IB_IBASENUMC18ALPHAIB_INSTANCEIIBIBIBM
CRNAMUser who created the object BU_CRUSRCHAR12USNAM
CRTIMTime (UTC) at which the object was created ICRTSDEC15TSTPSBCOS_TSTMP
UPNAMLast User to Change Object IB_IBIB_UPNAMCHAR12USNAM
UPTIMTime of Last Change (in UTC) IB_IBIB_UPTIMDEC15TSTPSBCOS_TSTMP
IBTYPIB: Installed Base Category IB_IBTYPCHAR2T371AIB_IBTYPH_IB_IBTYP
COMPINDIB: Component Store Indicator (Not Currently Used) IB_COMPINDCHAR1XFELD
CONFINDIB: Installed Base Used for Variant Configuration IB_CONFINDCHAR1XFELD
FILIDIB: Identification for a Group of Physical Files IB_FILIDCHAR2T371BCHAR2
VALTYPIB: Validity type for the installed base IB_VALTYPNUMC1IB_VALTYP
INTSTIB: Internal Status of the IBase IB_INTSTATENUMC1IB_INTSTATE
STTYPIBase: Status Type IB_STTYPCHAR2T371STIB_STTYP
IB_GUIDIB: Unique record number IB_RECNOCHAR22SYSUUID_22
IB_GUID_16GUID in 'RAW' format GUID_16RAW16SYSUUID
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
EXTIDIB: External Name/ID of Installed Base IB_EXTIDCHAR30CHAR30
MLANGPrimary language for object texts IB_MLANGLANG1T002ISOLASPRAS
AUTHGIBase: Authorization Group for IBase IB_AUTHGCHAR4Assigned to domainIB_AUTHG
KBIDConfiguration: Temporary Data Element for SCEKB-KBID ATKBIDNUMC6NUMC6
CLANGConfiguration: Characteristic Valuation Language CLANGLANG1Assigned to domainISOLASPRAS
CSTATUSInstalled base (IBase) status from configuration perspective ATIBSTATUSCHAR2CHAR2

Key field Non-key field



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

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

SELECT SINGLE *
FROM IBIB
INTO CORRESPONDING FIELDS OF WA_IBIB
WHERE...

How to access SAP table IBIB

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!