Solman 7.1 Sp5 Multilevel categorisation DB tables

[FrancoisCrous]

Hi All,

We recently upgraded Solman 7.0 to Solman 7.1 Sp5 and we have to redo many of our BW reports.  We don't use the standard BW extractors. 

Does anyone know what tables are used for storing the data on the WebGui?  I'm especially looking for the Multilevel Categorisation tables.

Regards,

Francois Crous

[Former Member · Accepted solution]

Hello Francois,

Please check this post http://scn.sap.com/thread/1412323

Here is a list of all Categorization tables:
CRMC_ERMS_CAT_HI (Hierarchy)
CRMC_ERMS_CAT_CT (Category Descriptions)
CRMC_ERMS_CAT_OK (Subject code mapping to Schema)
Other Schema  Tables:
CRMC_ERMS_CAT_AA
CRMC_ERMS_CAT_AB
CRMC_ERMS_CAT_AD
CRMC_ERMS_CAT_AL
CRMC_ERMS_CAT_AS
CRMC_ERMS_CAT_AT
CRMC_ERMS_CAT_CA
CRMC_ERMS_CAT_CD
CRMC_ERMS_CAT_CL
CRMC_ERMS_CAT_DT
CRMC_ERMS_CAT_DV
CRMC_ERMS_CAT_IC
CRMC_ERMS_CAT_ID
CRMC_ERMS_CAT_IN
CRMC_ERMS_CAT_LB
CRMC_ERMS_CAT_LN
CRMC_ERMS_CAT_LT
CRMC_ERMS_CAT_PA
CRMC_ERMS_CAT_PT
CRMC_ERMS_CAT_QU
CRMC_ERMS_CAT_SC
CRMC_ERMS_CAT_SP
CRMC_ERMS_CAT_ST

BR,

SAPFan