CG36 usable for business

gernotditten · ‎2021 Mar 18

Dear experts,

we set up our system to also upload inbound documents like supplier SDS, REACH information sheets on Raw Materials etc.

There are still a lot of documents that weren't uploaded yet. The business can do it one by one in CG36VEN. The upload of a whole bunch from a daughter company is done by an external consultant via CG36.

Now I was asked if it is not possible to hand over CG36 to the business. According to my knowledge the creation of the input file is not easy. I'm not an expert here.

Did anybody of you had a similar requirement and how was this solved? Or maybe you can come up with ideas?

My ideas are:

1) Writing an ABAP where you can upload some file and that creates the file structure for CG36 (and provides all checks) and then call CG36 directly (for sure access to the import folder must be given so that the documents can be put there).

2) Call CG36VEN multiple times in a program filling the relevant fields also from an imported file in an LSMW.

Thank you in advance.

Best regards,

Gernot

Ralph_P · ‎2021 Mar 19

Hello Gernot,

I understand you need a possibility to create the dat-files necessary for the mass import of inbounds. Why don't you create an Excel macro that reads in the names of the pdf-files. Other needed information like language, version, country etc. can be entered quite easily into the Excel file using existing functionalities or simply manually. Via another Excel macro you can then create all dat-files.

Ralph

christoph_bergemann · ‎2021 Mar 19

Dear Gernot

regarding:

2) Call CG36VEN multiple times in a program filling the relevant fields also from an imported file in an LSMW.

I am not aware of any option to use here LSMW direct.

Regarding:

1) Writing an ABAP where you can upload some file and that creates the file structure for CG36 (and provides all checks) and then call CG36 directly (for sure access to the import folder must be given so that the documents can be put there).

To use "CG36" you need

1.) very high access rights

2.) you need access to some "SAP application folders" (in most cases on UNIX level)

Therefore: in > 80 % of the cases the "move" of the documents is done by conultants (in most cases external) as the need to do an import is only rare

Coming back to ABAP

Any kind of report (Inbound (Pdf)) or normal WWI can be distributed by using "ALE"

Here now in theory LSMW comes in place. LSMW can generate "ALE" data structures

Never seen one company using this alternative.

Using CG36VEN you can not do an upload to the so called "document class" (Doc-X export/import). This is oly possible using CG36.

The issue is not the ABAP part. The problem is the "input" (refering to "Now I was asked if it is not possible to hand over CG36 to the business. According to my knowledge the creation of the input file is not easy. I'm not an expert here.)

and yes you are correct. The input file is "easy" ( i can not confrim that it is not easy to understand the structure) but it is very time consuming to generate it as you need to do it "one by by one" and there is no real option for "automating" something

You would need an EXCEL file like:

doument file name; spec ID, Generation variant, Language

Defining the "target" (this is the "key" file). Then you can consume this using ABAP (+ the document).

If you design the ABAP correct: You can upload the documents from your "client" and avoid the use of SAP application folders.

Overall: sorry to say: this is a customer specific topic. Any company use a different solution.

C.B.

PS: check e .g. https://blogs.sap.com/2017/09/04/data-migration-in-ehs-classic/

But you will find many similar questions/discussions here

e.g. like https://answers.sap.com/questions/12966823/sap-ehs-data-migration-of-from-ecc-to-s4.html

https://answers.sap.com/questions/12852451/cg36ven-additional-information.html

https://answers.sap.com/questions/12981710/report-import-using-cg36cg36ven.html

https://answers.sap.com/questions/12270764/import-reports---create-key-file.html