Making Siebel Interviews easy

What are different types of tables in Siebel?

Tables in Siebel can be broadly classified into two types

  • Repository Tables
  • Data Tables


Repository Tables: Tables that are used to store Meta data about Siebel Objects are repository tables. Following are examples of Repository tables

S_APPLET: Stores Siebel Applets information
S_BUSCOMP
: Stores Siebel Business Component Information
S_WFR_PROC:
Stores Siebel Workflow Process Information

Data Table: Tables that are used to store Siebel User data are known as data tables. They can be further classified into following types

Base Tables: Stores data about various siebel entities such as opportunity, quotes service requests. Following are examples of Base Tables

S_OPTY: Used to store Opportunity Information
S_SRV_REQ: Used to store Service Request Information
S_EVT_ACT: Used to Activities Information
S_DOC_QUOTE: Used to store Quote Information

Extension Tables: These tables are extension of base tables and are connected via implicit join and are used to store custom information for various entities. They have _X suffix to their name

S_OPTY_X: Extension table for opportunities
S_DOC_QUOTE_X: Extension table for quotes
S_EVT_ACT_X: Extension table for activities

Interface Tables: Used export and import data from external applications. They have EIM prefix with table name. Every base table and extension table has its corresponding EIM tables. Examples of EIM Tables are

EIM_OPTY: Opportunity EIM Table
EIM_ACTIVITY: Activities EIM Table

XM Tables: These tables are used where M: M relationships have to be established. These tables have XM suffix after their name. Most of the base tables have corresponding XM tables. Examples of XM Tables are

S_OPTY_XM: XM table for Opportunity
S_DOC_QUOTE_XM: XM table for Quote

I know this is not an exhaustive list and there are some other terms for other types of table that are present in Siebel. Please help here by contributing to create a complete exhaustive list.

  • Kevin

    I also want to know:
    If an EIM table can be created by ourselves?
    If yes, is there any special steps we have to follow?

    Please suggest.

    Thanks

  • neel

    No, I don’t think so.

    EIM tables have mapping with Base Tables. We cannot create new Base Tables so there can be no new EIM Tables.

    You can extend EIM tables though

  • Ashish Sharma

    Hi,

    A new base table can be created. This option is available in New Object Wizard.

    But as per my knowledge a new EIM table can not be created.

    Thanks
    Ashish

  • Ashish Sharma

    Hi,

    We can create base tables. This is available in New Object wizard. However a new EIM table can’t be created.

    A new base table has a prefix as CX_

    The new base tables can be mapped to some existing EIM table or can be imported by Business services.

    Thanks
    Ashish

  • Devu Nair

    A new base table can be created. This option is available in New Object Wizard.

    Even new EIM tables can also be created by us for the new base table what we create.

  • sam

    Hi,
    I think we can not create new base table. why you are ******** me?
    [edited]

  • Siebel Guru

    We can create a our own tables which is actually a custom tables. we can make this table to behave like base table or EIM table.

  • Kerthana

    full material will be provided for only one pdf file

  • Hanumanth

    Good Article