Siebel Common Interview Question:

What is s_party table?

Submitted by: Administrator

S_PARTY Table is the Base Table for all the Party related tables.

S_ORG_EXT

S_CONTACT

S_USER

S_BU

and etc.

the party tables can have the implied joins. the party related BC's have the S_PARTY as the base table. so, any of these tables are extension tables.

S_PARTY table is the base table for P O P(Person, Organization, Position) tables. the above mentioned tables are examples of POP tables. these tables have implicit join with S_PARTY table. row_id of S_PARTY table is the par_row_id of P O P tables.
Submitted by: Administrator