Field and table names on Email item in Agent Inbox

[Former Member]

Hello Gurus,

I have to provide Table & Field names to BW for creating reports based on Email Items received in Agent Inbox, the list is given below

Date Email Received

Sender

Sender Email Address

Sold To Customer ID

Sold To Country ID

Category

Subject

Due Date

Status

Person Responsible

Group Responsible

Number of Attachment/Attachment's

Completion date

Interaction Id

can you please tell me how to get the field and table names for this workflow items, i saw the table name SWWIHEAD but it doesn't give much information around my requirement.

Thanks

Chandu

[Former Member]

Hello Bruce and Srinivas,

Apologies for the Delayed response, i will go through your answers and get back to you.

Best Regards

Chandu

[former_member210661]

Hello Chandrashekar,

you can go through this link i have maintain all the tables nd there use..

this link will help you..

Thanks & Regards,

Srinivas.

[bruce_li]

Hi Chandu,

I think you can consider following tables.

Transparent Table  SWWWIHEAD

Transparent Table  CRMD_ERMS_HEADER

Transparent Table  CRMD_ERMS_E21O

Transparent Table  CRMD_ORDERADM_H

PS: You can find CON_ID in Transparent Table  CRMD_ERMS_HEADER, then you

can use this CON_ID to find the ORDER_GUID from Transparent Table  CRMD_ERMS_E21O.

Then you can use GUID to find the relevant entry from Table:          CRMD_ORDERADM_H.

Then by using of table CRMD_ORDERADM_H, I think you can find all necessary fields.

Best Regards,

Bruce