CCM -- db tables

[Former Member]

Hi

1.Please can you help to know all the db tables where Master, Supplier,procurement catalogues data resides.

2. Also, please help how we can access the CCM part in SRM 5.5 server. What is the detailed path ?

[Former Member]

Hi,

All the CCM tables are stored under Table names </CCM/>

Tables to find product ID for catalogs are /CCM/D_CTLG and

/CCM/D_ITM_TXT

You can also check these reports in SE38... There are more of them, do a search on /CCM/*

Report Name Description. Attention / additional hints

/CCM/CLEANUP_CATALOG Deletion / Cleanup of catalogs. May be dangerous since all catalogs can be deleted via this report! The report is needed if an upload crashed in order to delete the temp. version of the uploaded catalog.

/CCM/PATCH_CATALOG Needed if data migration was necessary between two support packages in order to migrate the data.

/CCM/VERIFY_CATALOG Prints out a list of the database content of a catalog.

Options on the selection screen for Item valuations, includes deleted objects, views etc.

/CCM/CATALOG_CME_DATA Shows the predefined characteristics / data types

Shows the characteristics / data types of a catalog.

Can be used to check the data (e.g. alias, aspects) of predefined characteristics

/CCM/VISUALIZE_MAPPING Displays the mapping tables for a given catalog ID

/CCM/INITIALIZE_CME Initializes the predefined data types / characteristics. Used to initialize the catalog

BR,

Disha.

Do reward points for useful answers.

[Former Member]

Hi

CCM- CAT can be accessed through browser for

Edit catalog

Create Catalog

Edit suplier master data

Dispay log

The link to the browser can be seen in SE80

BSP Application > /CCM/CAT>double click CAT_home.htm-->Select Properties tab --> Scroll down to see the url link.

Vasu

[Former Member]

Hi,

Look at these tables

/CCM/D_ITM

/CCM/D_ITM_TXT

/CCM/D_CTLG

/CCM/D_CTY

Rgds,

Ramakrishna

[Former Member]

Think you have got the required table names

for accessing catalogs in SRM server

in addition to Vasu

the user need to have the role

/ccm/catalog_manager

then the service srm_cse should be active and should have a log on service user (eg. srdcatalog) which should be SU01 user in CCM-CSE if on seperate client/server.

under SRM IMG->SRM->srm server->master data ... you should define the call structure for the master/procurement catalog.

this catalog ID should be present in the attribute CAT for the employee user.

Under SRM IMG->cross applns->catalog content management... the config should be complete.

For further details refer CCM config guide on service.sap.com/ibc-srm

BR

Dinesh