Which tables storing the attachment?

[Former Member]

Dear all expert,

May i know which of the tables in CRM storing the attachment? My situation is like:all the Sales Rep. will upload document, picture and other file type. Now i need to develop a report which can return the attachment and when user run the report, they just need to click on the attachment to browse the attachment. how can i develop this type of report?

Thank You.

[Former Member]

Hi Anbu,

Thank you for your reply. Can i just have the tables? because im using cyrstal report in developing the report instead of ABAP programming. As my superior say that they had just implement Business Object, they don't want to waste so much time on developing report using ABAP. So, they hope that i will be able to help them to develop a report by using Business Object crystal report. So it is kind of you for replying my thread and i do hope to know which table is storing the attachment such as .gif, .jpg, .doc and so on which is uploaded to CRM by our sales representatif.

Thank You.

[Former Member]

Hi,

I had done with the concatenate function. what my problem now is to call a web url frm the crm into crystal report. the URL is as below:

http://sbdevcrm.silverstone.com.my:8000/sap/bc/contentserver/020?get&pVersion=0046

&contRep=CRMORDER *{CRMORDERPHIO.STOR_CAT}

&docId=DFAB31A583CDF1F1BD9E005056A1554D

&compId=Logo *{CRMORDERPHIO.PROP09}

& ".gif"

&accessMode=r

&authId=CN%3DCR1

&expiration=99991231235959

&secKey

=MIH4BgkqhkiG9w0BBwKggeowgecCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGBxzCBxAIBATAZMA4xDDAKBgNVB

AMTA0NSMQIHIBAHGQISUDAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcN

MTEwMTA3MDYzMTA0WjAjBgkqhkiG9w0BCQQxFgQUrjTK9qbkl60OovmDRfUFYN5PBCMwCQYHKoZIzjgEAwQvMC0CFQC13oWG

9qN9TtekzRCqLaOg7VsdHwIUWALOOyi7L0%2BxjriG34ULOmLlNeo%3D

can i know how to replace the docId, accessMode, authId, secKey from tables? everytime when click on a attachement, we can direct browse the attachement from CR.

Thank You.

[Former Member]

Usw this class :CL_BSP_WD_APPL_MODEL

• Build base

lr_model = cl_bsp_wd_appl_model=>get_appl_model( iv_bsp_appl = 'CRM_UI_START'

iv_model_type = 'CL_BSP_WD_APPL_MODEL_RTTI' ).

lv_url = lr_model->get_start_url( ).

CONCATENATE lv_url '&contRep=' INTO lv_url. Similarly you have to concatenate the value and the field .

Regards

Anbu B

Edited by: Anbu B on Jan 10, 2011 11:52 AM

[Former Member]

The table names are CRMORDERLOIO,CRMORDERPHIO.

To read & display and write thE ATTACHED document use this class cl_crm_documents .

Regards

Anbu B