Unable to retrive XML file from MDM to SRM

[former_member353792]

Hi  ,

From the FM  BBP_WS_IMPORT_SC_DATA I am able to see that the data

retrieving from OCI is in the  HTML and not via XML .

As per the  note  SAP Note 1387519 - OCI 4.0 Documentation - Wrong parameter  description

its mentioned that

The parameters ~xml_type and ~xmldocument should not be maintained in the

catalog call structure (TX. SPRO).

This parameters have to be sent from the catalog.

Can anyone help me in enabling the XML format for retreving the data  from MDM.

Regards

Arun. 

[jason_boggans · Accepted solution]

Hi Arun,

The function BBP_WS_IMPORT_SC_DATA interprets both HTML and XML data, it is in the function BBP_WS_MAP_OCI_TO_SC that the decision is made as to whether the data is passed in XML format or just HTML, here the check is made:

IF NOT iv_xml_type IS INITIAL AND NOT iv_xml_document IS INITIAL

                                AND et_oci_item_data[] IS INITIAL

                                AND et_oci_longtext[] IS INITIAL.

So if in the call structure the xml type is defined and the xml document is not initial the xml transformation is called in the function MAP_XML_TO_ITABS, here:

IF xml_type = 'ESAPO-3.5'.

*   Transfrom OCI XML data via XSLT to RFC structures

    TRY.

        CALL TRANSFORMATION bbp_oci_xml_to_rfc

          SOURCE XML IV_XML_DOCUMENT

          RESULT sc_items = lt_sc_items.

      CATCH CX_ROOT INTO lr_exception.

*      CATCH cx_xslt_runtime_error.

        RAISE xslt_failure.

    ENDTRY.

  ENDIF.

Regards,

Jason

[former_member353792 · Accepted solution]

Hi Jason,

Thanks for the reply. Can you help us in mainatining the call structure for MDM

Current values are

~xml_type          ESAPO-3.5                         Fixed Value

~xmldocument    OpenCatalogInterface.xsd    Fixed Value

Is this the correct?

For this config. we are getting the fields 

         iv_xml_type  is initial and  iv_xml_document is initial

and    et_oci_item_data[] is not initial ( contains selected MDM item data )

and    et_oci_longtext[] is not initial ( contains selected MDM item long text data )

Because of this the FM MAP_XML_TO_ITABS is not getting triggered.

waiting for your reply.

Thanks in Advance.

Regards,

Arun.

[jason_boggans · Accepted solution]

Hi Arun,

The xmldocument should not be called OpenCatalogInterface.xsd, this XSD is the Format by which you should build this document, the xsd is the structure which should be adhered to when returing the document to SRM.

Otherwise you can debug the function mentioned.

Regards,

Jason

[former_member353792 · Accepted solution]

Hi Jason ,

I debugged the code to find where the fileds ~xml_type and ~xmldocument   should have

populated to trgigger the function   MAP_XML_TO_ITABS .This is from the Kernal Syntax

as shown below..      

I refered your old thread http://scn.sap.com/thread/1729153 ,

I am also facing the same problem

For enabling the xml variant of the oci, we need to pass two parameters in the call structure. 

~xmltype = ESAPO3.5

~xmlDocument = ????

can you help me in sending the xsd and guide me .

The below shown is the call structure maintained correct me if i am wrong in any of the parameters.

Regards,

Arun.

[Former Member · Accepted solution]

Hi ,

In External Web Services , maintain XML as Technical Type of Services in web service ID instead of HTML and try...

Thanks

Arun

[Former Member · Accepted solution]

Hello Josan,

We am trying to  integrate our Asp.net application[Website] from punch out catalog to SAP SRM Module.

I have go through the OCI_40_EN.pdf. and as Arun mentioned that  SAP Note 1387519 - OCI 4.0 Documentation - Wrong parameter  description

but we are not clear with the below line

The parameters ~xml_type and ~xmldocument should not be maintained in the

catalog call structure (TX. SPRO).

This parameters have to be sent from the catalog.

i have create a sample demo with the help of following link

http://help.sap.com/saphelp_crm20c/helpdata/en/0f/f2573901f0fe7ce10000000a114084/frameset.htm

Pls check the Example of XML version.

In that they have mention about the XML tag for the "example.xml" file

<xml id="xmlid" src="example1.xml"></xml>

Can u pls explain me the techincal process flow of sending and retrieving the XML file.

Waiting for your reply

Thank you

Sagar Khairnar

[Former Member]

Dear Arun,

The parameters xml type and xml document are to be send from the catalog and not send to it.

While transferring make sure that the same is send. You may utilise the HTTPFox plugin in Mozilla Firefox to check the data transferred between catalog and SRM.

If the same is send, make sure that the data retrieved from the catalog has the catalog item details as

"NEW_ITEM-".

You can find the return data from the catalog if you execute the below URL(constructed based on your call structure):

http://indblrp2p03:50600/srm-mdm/srm_mdm?username=User1&password=User1&server=INDBLRP2P03&port=2345&...

With the above URL check how the data is returned back. Use HTTPFOX if the parameters xml type and xml document are send.

If the same are send and still the data is not found, you may try implementing the Note 1294571.

Warm Regards,

Sarath