Tables for Catalog details...

[Former Member]

Hi,

I'm new to CCM. Can any one let me know the details of the tables or reports where I can find the following details:

1. Catalogue Number

2. Date on which catalogue was created

3. Who had created the catalog.

4 Whether any changes were done for the catalogue

5. When the changes were done & who had done the changes.

It will be really helpful if any one can send me the material on CCM.

Wishes & Regards,

Mahesh. J

[Former Member]

Hi

<b>Please give your email id in next reply so that i can send you very useful CCM documents as well.</b>

All the CCM tables are stored under Table names </CCM/>. You can also check these reports in SE38... There are more of them, do a search on /CCM/*.

Hope this will help.

Do let me know.

Regards

- Atul

[Former Member]

Hi Atul,

My mail id is mahesh.jonnadula@gmail.com

Best regards,

Mahesh. J

[Former Member]

Hi,

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

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.

<b>Pls reward points for useful answers.</b>

[Former Member]

Hi Disha,

Thank you very much for the information.

I tried to check the details in the Table CCM/D_ITM (Table for Catalog Item Header Data). But in the fields 'Created On' & 'Changed On' are shown in seconds format.

Can you let me know view these to fields in Date Format (DD-MM-YYYY).

Best Regards,

Mahesh. J

[Former Member]

Hi

Sent some useful details at your email id.

For change the date format, try this Code in a sample report.

• valid from / to

GET TIME STAMP FIELD ls_product-valid_from.

• valid from / to

GET TIME STAMP FIELD ls_product-valid_to.

Regards

- Atul

[Former Member]

Hi Atul,

Can you please re-send the materials related to CCM as I have not received them.

Thank you very much in advance.

Best Regards,

Mahesh. J