Skip to Content
author's profile photo Former Member
Former Member

Define incoming template in RoHS

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Jun 07, 2012 at 07:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded