cancel
Showing results for 
Search instead for 
Did you mean: 

How to generate or get key file for released reports?

devdatt_khedekar
Participant
0 Kudos

Dear Experts,

I was finally able to find the program RCVDCREO with which mass download of MSDS seems possible. However Mass download was needed to comply with Chemtrec regulations and sending these MSDSs to chemtrec ftp after downloading it from SAP. Chemtrec wants a key file for each MSDS and these MSDS are almost 40,000 in number. No idea how to create Key files for them in the below mentioned format.

DTY  =SDB

SID  =000000000006

PRN  =IS 279 496 US SanitIP red PP25KG

STA  =V

LAC  =D

CPN  =Ferro GmbH

FFT  =PDF

MAT  =000000000001338300

Accepted Solutions (1)

Accepted Solutions (1)

christoph_bergemann
Active Contributor
0 Kudos

Dear Devdatt

Check:

https://help.sap.com/saphelp_erp2004/helpdata/en/a7/287cd20a6c11d28a220000e829fbbd/content.htm

Chapter: Report Export Process (Dok-X)

Step 1: Understand the data structure shown => this data structure is used for "standard" import in SAP EHS of an "inbound" report. The values shown are stored on document level as values in characteristics of a class.

The topic of report import has been addressed very open here.Therefore please check e.g: Report Import: Process - Basic Data and Tools (EHS-BD) - SAP Library

Chapter "Report import process" and any subsequent chapter related to that

Step 2: think about options

a.) Use an userexit in CG54

b.) use report export (via report distribution)

Before handyou need to understand the values.

DTY  =SDB                                                                      = for Safety data sheets this is always "SDB"

    SID  =000000000006                                                  = this is the scecification key on which the report exists

PRN  =IS 279 496 US SanitIP red PP25KG               = this is a material name/tex (refer to MAT below)

STA  =V                                                                                = this is always "V"

LAC  =D                                                                                = this ios the language of the report in "one digit" code D = DE; this value (or can be related to) is based on language of release report in CG54

CPN  =Ferro GmbH                                                            = this is "simply" your company name

CPN  =PDF                                                                           = in most cases exchange of documents are done oin "pdf" format; therefore CPn = pdf

MAT  =000000000001338300                                        = this is a material number as assigne to your specification

You might now ask: why do they need the stuff? IN most cases these values can be used for either "information" only perspective or for "selection/search" perspective

Check: consolut - EHS_SRE_IMG_121 - Report Export by Program: Check Additional Settings and

consolut - EHS_SRE_IMP_70_OA - EHS: Maintain File Names and File Paths (Cross-Client) as well

http://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_SRE_IMP_120

EH&S 2.2B Patch Level: Additional documentation

CVER_DOKX_EXPORDS_DELETE EHS: User exit: Delete completed Dok-X export orders - Function - ABAP - SA...

http://www.consolut.com/en/s/sap-ides-access/d/s/doc/YD-EHS_UEXIT_DIST

EH&S - .key file creation - interface | SCN is dealing with the other way around (import)

Check as well:

SAP Function Modules Documentation Repository - Function Module Index CVE9_RDO_DOKX_DOCFILE_CREATE -...

SAP Function Modules Documentation Repository - Function Module Index CVER_DOKX_EXPORDS_DELETE - CVE...

CVE9_RDO_DOKX_KEYFILE_CREATE - Function - ABAP - SAP

CVE9_RDO_DOKX_EXPORDS_CREATE - Function - ABAP - SAP

CVE9_RDO_DOKX_EXPORDS - Function - ABAP - SAP

CVE9_RDO_DOKX_DOCFILE_CREATE - Function - ABAP - SAP

etc.

C.B.

devdatt_khedekar
Participant
0 Kudos

Dear Christoph,

Thanks for very knowledgeable advice. You mentioned in step 2 a) to use user exit in CG54, could you please elaborate on this. I mean which is the user exit, how to activate or use it for report export as well as key file generation.

christoph_bergemann
Active Contributor
0 Kudos

Dear Devdatt

the UserExit option is something which you can use at different places. There is no default implementation delivered.

Check e.g.

and these exits:

C1G20001EHS: Menu exit 1: Report management
C1G20002EHS: Menu exit 2: Report management
C1G20003EHS: Menu exit 1 report information system
C1G20004EHS: Menu exit 2 report information system

The option you would like to use depends on your requirement. Anything in CG54/CG50 is "manually". Therefore you need to prepare always a report tree and then you can use the exits. But for the "export" option you need to generate the report tree as well (in CG54 only ! no export option in CG50 !). Therefore you can use the same "starting" situation. The export option might be better as you can prepare "subsequent" shipment orders; The topic of "download" has been discussed very often here. E.g. check:

C.B.

devdatt_khedekar
Participant
0 Kudos
Document TypeSpecification IDStatusLanguage KeyCompany NameFile Format TypeFile NameValidity DateVersion Country
DTY   SID   STA   LAC   CPN   FFT FNA  DAT VER   CTY 
SDB000000000006VSFerro (Belgium) SprlPDF10093044.PDF15.07.201100003.00000ES

From which tables in SAP, the above fields are picked up?

Former Member
0 Kudos

I believe the program RCVDCREO should create the key files for you rather than you having to create these yourself.  If it isn't, I would check your configuration.  The key file is written by the user exit category SRE_EXPKEY and user exit name CMTR_EXPKY.   Check the flow logs to ensure the user exit is being called correctly.  If you need additional fields, you can have an ABAPer make a copy of this function module and enhance it to fit your needs.

To answer your question, the information is maintain in CVDDH or ESTDH.  The first table contains the report distribution orders and will contain the information you're looking for based on the reports you've exported.   The second table is the report header table and will also contain the same information however it will contain additional reports such as historical or not released.

devdatt_khedekar
Participant
0 Kudos

In our case it is not creating key files but .k files which is not as per the format which is mentioned above. It only gives us SUB id and material number information. When you say above that please check your configuration, could you please elaborate what changes in configuration to be added or corrected to get this running properly.

Former Member
0 Kudos

Ok, so it sounds like the config is setup correctly but the format isn't what you're looking for.  Please check which function module is maintained in SPRO->Environmental Health adn Safety->Basic Data and Tools->Basic Settings-> Manage User Exits.  Find the entry for user exit category SRE_EXPKEY and user exit name CMTR_EXPKY.  You can replace this with your own copy which can create the key file based on the report shipping order.  Ideally, you can copy the logic in "CVE9_RDO_DOKX_KEYFILE_CREATE" since this has the format you want.

Of course, you could do this as Chrisoph suggested and use CG54 to export the reports.  If setup(most likely it is), this will create the keyfiles with the format he mentioned.  Go to CG54, create hitlist of the substances and reports you want to export.  Select All. Go to menu Report->Export and select "DOKX_EXOMN Export Orders for Transferred Reports". 

christoph_bergemann
Active Contributor
0 Kudos

Dear Devdatt

e.g. refer to:

EH&S - .key file creation - interface | SCN

http://www.stechno.net/sap-notes.html?view=sapnote&id=111841

The function module dedicated to create the key file is:

CVE9_RDO_KEYFILE_CREATE - Function - ABAP - SAP

But this is used "autmatic" if you prepare the EXP_CALL as part of the repport distrbution process correct. Check e.gSAP Function Modules Documentation Repository - Function Module Index CVE9_RDO_DOKX_DOCFILE_CREATE -... (sorry: only german documentation)

As mentioned: the normal case to handle this demand is by using the "report distribution fiunction". If proper set up is done that it shouldwork as explained by Peter

C.B.

Answers (0)