Upload (Attach) documents to a custom application

[Former Member]

Hi Experts,

We have a requirement.

our finance team is getting the Bank Guarantee in Hard copy.

And at present they are maintaining  all the Details(Like bank name, bank address, Value, customer, customer name, Guarantee valid from & to ) in Excel sheet and the scanned document in a folder on their desktop.

Now they want to bring into SAP.so for that data to maintain I created a Z Table & Maintained all the data & given a Z report for seeing the data.

But they want to upload (Attach) the scanned copy of that Bank guarantee to the corresponding document in z table. so how to upload the scanned (pdf or image or word) copy into sap and they want to open & see in the sap itself.

already I searched the sdn, for GOS creation for custom program , but that document is for 4.6c version.we are on ecc 6.0 version.

So please suggest a solution , how to upload  & manage the documents.

Thanks in advance,

Regards,

Venkat

[Former Member]

Hi,

If I understand what you need, follow my remarks:

Firstly put in the detail table that you already created a field with an unique key, as a sequential number (SNR0 transaction) or UUID (Created by CL_SYSTEM_UUID class), and then create a new table to store the data files.

This second table need to be linked with the another one, to do it link using the field created above and include at least 2 fields: LENGHT as integer (INT4) and DATA as binary string (XSTRING).

With this table will be possible to save the file data, to get and put on costumer's computer you can use a report with ALV or create a Web Dynpro to do all needed tasks, and if you choose an ALV and all documents are images you can use the class CL_GUI_HTML_VIEWER to show it.

I need to remember too that would be nice if you use the CL_ABAP_GZIP class before save to compress the file and save space on database...

Best regards!

[shadab_maldar]

Hi venkat,

You can attach all the documents in DMS and save this DMS number into your Z table(Linking with bank guarantee details).

Regards,

Shadab Maldar.