Complete tables of Incidents in Solman 7.2

[former_member598198]

Hi Experts,

My Scenario is that we are integrating the Solman ITSM with IBM control desk using WEB service from PI system.

Here is the working model , Incidents created in my Solman system are replicated to the external system for further processing.once the issue is closed in the external system it has to be updated in the Solman system of that particular incident.

From my Solman system i will provide the list of incident fields that will pass the info to WEB service and the same will be passed to the external system and in the same way the updated ticket info in external system need to be updated in Solman of that particular incident.

To develop the code in my Solman system i need all the table details which are associated with incidents. given the list of Incident Fileds that required.1.ID 2.Description 3.Sold-To Party 4.Reported By 5.Support Team 6.Message Processor 7.Status 8.Priority 9.Category 10.Text 11.System Details 11.Attachments 12.Created 13. Changed.

Kindly help me in getting the details of the above mentioned incident fields.

[former_member376419]

Hello Naresh,

Did you find the details of the table related to incidents (1.ID 2.Description 3.Sold-To Party 4.Reported By 5.Support Team 6.Message Processor 7.Status 8.Priority 9.Category 10.Text 11.System Details 11.Attachments 12.Created 13. Changed.) ?

Thanks

BR,

Daniil

[former_member684517]

Hello there, Im looking for time recording table, I need to create reports about this times which are added by each consultant in each incident we have in our service desk, which makes it realy tough to keep a track on it without access to this table, any thoughts would be really appreciate it, thanks

[RajeshKumarR]

Hi Naresh,

Please check the below link for more details on Content Management

https://blogs.sap.com/2013/11/22/a-collection-of-technical-details-about-content-management/

In the above link point no. 5 deals with Attachment storage. The link is given below.

https://blogs.sap.com/2013/11/28/how-is-attachment-physically-stored-in-database-table-in-cm-framewo...

Regards,

Rajesh

[RajeshKumarR]

Hi Naresh,

Please use the below tables.

CRMD_ORDERADM_H - Business Transaction
CRMD_ORDERADM_I - Business Transaction Item
CRM_JEST - Individual Object Status
CRM_JCDS - Change Documents for System/User Statuses (Table JEST)
CRMD_PARTNER - Partners

Regards,
Rajesh

[former_member598198]

Hi Rajesh,

Thanks for your update.

may i know the table where attachments will be stored.

Regards,

Naresh Y