on 03-10-2014 12:07 PM
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
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
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Devdatt
the UserExit option is something which you can use at different places. There is no default implementation delivered.
and these exits:
C1G20001 | EHS: Menu exit 1: Report management |
C1G20002 | EHS: Menu exit 2: Report management |
C1G20003 | EHS: Menu exit 1 report information system |
C1G20004 | EHS: 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.
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.
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.
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".
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.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.