Define incoming template in RoHS

[former_member686534]

Hi All -

I am new in EHS module . I am facing one issue looking help from your side .

Actually I want to upload specification from /n/tdag/CPI04  , its accepting XML format .  Now I want to replace this XML by the XLS format .

Customer is giving me data in XLS format , so I want to make some changes in that XLS and want to upload specification by this XLS directly .

if you can check config in SPRO there is EHS ROHS--->DATA EXCHANGE-->INCOMING TEMPLATE  ,here FM has been defined for XML and TXT ,

like Identification , preporcessing , processing , map and save .

can you help me to know which FM will be used to upload XLS format ? Is there any standard FM is available or we need to go for custom ?

Please help me know one thing more to go custom development  for this is feasible or not ?

your valuable inputs required . waiting for your reply . If there is any confusion on my post please let me know I will clear it in simple words .

Cheers

Vikram

[christoph_bergemann · Accepted solution]

Dear Vikram

we are not using this functionality but may be I can provide some hints:

The XML file is based on a XML schema. The processing of data is only possible if the XML file fulfills this schema. XML is now "standard" to exhange data in the chemical industry. Therefore SAP provided this solution and no XLS upload

To my knowledge no alternative is there (no SAP standard FM). Therefore you need to prepare your own coding (and you need to understand the XML coding structures to prepare a corresponding FM)

I would suggest:

1.) Try to understand the XML schemas

2.) try to understand the XLS structure provided

3.) try to "map" them

You will find in internet numerous "parsers" and other programs or tools which can be used to "process" a XLS file using some logic to generate the XML file which must fulfill the required schema

May be read cross this link as well:

http://scn.sap.com/message/13295847

With best regards

C.B.

PS:

I assume we are talking about this feature ?:

http://help.sap.com/saphelp_rc20sp02/helpdata/en/ef/6c9146a78c488f8ed1069c64ea28b5/content.htm

[former_member686534 · Accepted solution]

Hi Bergemann  -

First off thanks for your nice help .  I have one small query to you that where we define XML Schema in the SAP system ?

I am getting one default XML in mail attachment  when I go to Task management  . Can I change or add more field to that XML  by changing XML Schema ?

Cheers

Vikram

[christoph_bergemann · Accepted solution]

Dear Vikram

SAP provide a number of processes to handle XML data structure. First:

You need understand:

what is a XML schema?

PLease refer to standard internet pages like:

http://www.w3schools.com/schema/default.asp

http://www.w3.org/XML/Schema

http://en.wikipedia.org/wiki/XML_Schema

Then try to understand solutiosn which SAP is providing (I am not talking about SAP XI/PI):

Refer e.g. to: http://scn.sap.com/thread/1289115

http://sample-code-abap.blogspot.de/2009/05/processing-xml-with-xslt-transformation.html

etc.

Now regarding your other topic:

I am getting one default XML in mail attachment  when I go to Task management  . Can I change or add more field to that XML  by changing XML Schema ?

You will get a XML file. This file "fits" to a XML Schema (e.g. refer to the aboe mentioned links). This XML Schema (which is defined by industry/authority etc.) need to be valid so that you can use XML data to be exchanged. Therefore you can not "adapt"/"Change" the XML but you can only change XML file in such a way that it is "valid" according to XML schema.

Regardinng XML processing in general: please check the "ABAP" Forum. I assume you will find examples

May be this helps

With best regards

C.B.