Sub Agreement XML import error: XML import could not process field: CONTRACT_UNIQUE_DOC_NAME

[Former Member]

Hi All,

I am importing Sub Agreement in XML format and getting below error.

XML import could not process field: CONTRACT_UNIQUE_DOC_NAME

unsupported null bind parameter no. 0

Below is the XML.

<?xml version="1.0" encoding="UTF-8"?>

<sapesourcing xsi:noNamespaceSchemaLocation="Contracts.xsd" defaultlanguage="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <objects>

    <object classname="contracts.Agreement">

<fields> 

                                <CONTRACT_UNIQUE_DOC_NAME>P-XXXX-00001</CONTRACT_UNIQUE_DOC_NAME>

                                <DISPLAY_NAME>Testing Agreement Name 1 </DISPLAY_NAME>

                                <CALC_METHOD>UNIT_PRICE_ENTERED</CALC_METHOD>

                                <UNIQUE_DOC_NAME>S0002510</UNIQUE_DOC_NAME>

                                <STATUS>In Process</STATUS>

                                <COMPANY>TEST</COMPANY>

                                <LOCATION>Location_114</LOCATION>

                  </fields>

    </object>

  </objects>

</sapesourcing>

If anyone is successful in importing Sub Agreement in XML format?  also please validate the above xml structure?

Note: I am able to load  Sub Agreement using CSV. But in our scenario data comes in XML format.

Thanks & Regards

Sai

[Former Member · Accepted solution]

SAP response: The fix for this issue has been prepared and planned to be checked in

in versions 7.0.11, 9.0.18 and 10.0.02

Regards,

Sai

[former_member89217]

Hello Sai,

How exactly did you determine this content and format?  Were you successful at importing the parent agreement as XML?  I don't believe this is a supported process.

Regards,

Gary

[Former Member]

Hi Gary,

I am able to load below objects in XML format without any issues. And I am using Scheduled Task of type “Data Import Monitor” to load them.

1)  Project (1100)

2)  Master Agreement (1004)

3) Extension Collections for Project

4) Extension Collections for Master Agreement

1. 1) Working XML Structure for Project(1100) .

<?xml version="1.0" encoding="UTF-8"?>

<sapesourcing xsi:noNamespaceSchemaLocation="Projects.xsd" defaultlanguage="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <objects>

    <object classname="projects.projects">

      <fields>

<UNIQUE_DOC_NAME>S0004392</UNIQUE_DOC_NAME>

  <DISPLAY_NAME>Test Project</DISPLAY_NAME>

.....

1. 2) Working XML Structure for Master Agreement (1004) object.
   <?xml version="1.0" encoding="UTF-8"?>
   <sapesourcing xsi:noNamespaceSchemaLocation="Contracts.xsd" defaultlanguage="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <objects>
   <object classname="contracts.Contract">
   <fields>
   <UNIQUE_DOC_NAME> 00215944</UNIQUE_DOC_NAME>
   <DISPLAY_NAME>TEST MA</DISPLAY_NAME>
   <DOCUMENT_DESCRIPTION>Contract Desc</DOCUMENT_DESCRIPTION>
   ……

1. 3) Working XML Structure for Extension Collections for Project(1100).
   <?xml version="1.0" encoding="UTF-8"?>
   <sapesourcing xsi:noNamespaceSchemaLocation="Projects.xsd" defaultlanguage="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <objects>
   <object classname="projects.projects">
   <fields>
   <UNIQUE_DOC_NAME> S0004392</UNIQUE_DOC_NAME>
   </fields>
   <collections>
   <Z_DETAILS replace="true">
   <object classname="extension_collections">
   <fields>
   <NAME>Sai</NAME>
   <EMAIL>Sai@test.com</EMAIL>
   </fields>
   </object>
   <object classname="extension_collections">
   <fields>
   <NAME>Krishna</NAME>
   <EMAIL>krishna@test.com</EMAIL>
   </fields>
   </object>
   </ Z_DETAILS >
   </collections>
   </object>
   </objects>
   </sapesourcing>

1. 4) Working XML Structure for Extension Collections for Master Agreement (1004).
   <?xml version="1.0" encoding="UTF-8"?>
   <sapesourcing xsi:noNamespaceSchemaLocation="Contracts.xsd" defaultlanguage="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <objects>
   <object classname="contracts.Contract">
   <fields>
   <UNIQUE_DOC_NAME>00215944</UNIQUE_DOC_NAME>
   </fields>
   <collections>
   <ZLINKS replace="true">
   <object classname="extension_collections">
   <fields>
   <LINK_NAME>SAP</ LINK_NAME>
   < LINK_URL> http://www.sap.com/index.html </ LINK_URL >
   </fields>
   </object>
   <object classname="extension_collections">
   <fields>
   <LINK_NAME>SCN Sourcing</ LINK_NAME>
   < LINK_URL>http://scn.sap.com/community/sourcing</ LINK_URL >
   </fields>
   </object>
   </ ZLINKS >
   </collections>
   </object>
   </objects>
   </sapesourcing>

Could you please help me with the right XML Structure for Agreement( 1003)?

Regards,
Sai