IBIB

Transparent Table Application Table
31 Fields 2 CDS Views

IB: Installed Base/IBase

IBIB is an SAP database table in S/4HANA. IB: Installed Base/IBase. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DigitalVehicleBaseHeader view_entity from BASIC Installed Base Header
P_IBaseHeader view from BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ibase IB_IBASE Installed Base
crnam BU_CRUSR Created by
crtim ICRTS Created On/At
upnam IB_IBIB_UPNAM Changed by
uptim IB_IBIB_UPTIM Changed On/At
ibtyp IB_IBTYP IBase Category
compind IB_COMPIND Comp.Store
confind IB_CONFIND Config.Store
filid IB_FILID Reference to File
valtyp IB_VALTYP Validity type
intst IB_INTSTATE Internal Status
sttyp IB_STTYP Status Type
ib_guid IB_RECNO Record number
ib_guid_16 GUID_16 GUID 16
objnr J_OBJNR Object number
extid IB_EXTID External ID
mlang IB_MLANG Primary lang.
authg IB_AUTHG Authoriz. group
vbeln VBELN_VA Sales Document
posnr POSNR_VA Item
mstone OBOM_WB_MSTON Milestone
counter OBOM_WB_VERS1 Version
cuobj CUOBJ Int. object no.
plant WERKS_D Plant
matnr MATNR Material
kalnr CK_KALNR1 ProdCostEst.No.
kbid ATKBID ATKBID
clang CLANG Config. Lang.
cstatus ATIBSTATUS ATIBSTATUS
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- IB: Installed Base/IBase
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IBIB (
    MANDT,       -- Client [MANDT]
    IBASE,       -- Installed Base [IB_IBASE]
    CRNAM,       -- Created by [BU_CRUSR]
    CRTIM,       -- Created On/At [ICRTS]
    UPNAM,       -- Changed by [IB_IBIB_UPNAM]
    UPTIM,       -- Changed On/At [IB_IBIB_UPTIM]
    IBTYP,       -- IBase Category [IB_IBTYP]
    COMPIND,     -- Comp.Store [IB_COMPIND]
    CONFIND,     -- Config.Store [IB_CONFIND]
    FILID,       -- Reference to File [IB_FILID]
    VALTYP,      -- Validity type [IB_VALTYP]
    INTST,       -- Internal Status [IB_INTSTATE]
    STTYP,       -- Status Type [IB_STTYP]
    IB_GUID,     -- Record number [IB_RECNO]
    IB_GUID_16,  -- GUID 16 [GUID_16]
    OBJNR,       -- Object number [J_OBJNR]
    EXTID,       -- External ID [IB_EXTID]
    MLANG,       -- Primary lang. [IB_MLANG]
    AUTHG,       -- Authoriz. group [IB_AUTHG]
    VBELN,       -- Sales Document [VBELN_VA]
    POSNR,       -- Item [POSNR_VA]
    MSTONE,      -- Milestone [OBOM_WB_MSTON]
    COUNTER,     -- Version [OBOM_WB_VERS1]
    CUOBJ,       -- Int. object no. [CUOBJ]
    PLANT,       -- Plant [WERKS_D]
    MATNR,       -- Material [MATNR]
    KALNR,       -- ProdCostEst.No. [CK_KALNR1]
    KBID,        -- ATKBID [ATKBID]
    CLANG,       -- Config. Lang. [CLANG]
    CSTATUS,     -- ATIBSTATUS [ATIBSTATUS]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, IBASE)
);

Learn More