Catalog data in SRM

[Former Member]

Hi,

We have a requirement in srm 4 of sending mails to buyers, before the catalog end date. To fulfil this requirement we intend to write a report/program.

Can anybody help with how do we retrieve the catalog name, catalog item, the catalog valid to date and the catalog item valid to date. Which tables in SRM have this data and how do we retrieve it or is there any function module which can give us this data.

Any help would be greatly appreciated.

Thanks and Regards,

Jayesh

[former_member184214 · Accepted solution]

Hello,

look at /CCM/* tables.

You will need to find GUIDS for items taht you are looking for.

HTH

Gordan

[Former Member · Accepted solution]

Thanks Gordan.

I have already tried that. None of the tables seem to have values in the Valid_To field. Any help on how to get the data would be greatly appreciated.

Regards,

Jayesh

[former_member184214 · Accepted solution]

Hello,

did you try table /ccm/d_ctlg?

Gordan

[Former Member · Accepted solution]

Thanks Gordon. Sorry for the delay in replying back.

I have already tried /ccm/d_ctlg. The valid to field has value 0 for all rows.

Thanks and Regards,

Jayesh