on 12-11-2013 10:46 PM
I am having a problem properly formatting some XML. We added an Extension Collection to the Material Master in Sourcing for holding a list of Purchase Org Objects. I have been trying to modify the standard XML PI uses when it receives a MAT_MAS IDoc. I have done many iterations of the XML. Some that succeed with Warnings and some that succeed, but don't add the Object to the Extension Collection. I have tried the following. How do I format the XML so I can add the Purchase Org Object to the Extension Collection?
Import Successful But empty row in Collection
<collections>
<WMT_PORGS>
<object classname="masterdata.POrg">
<fields>
<WMT_PORG>
<EXTERNAL_ID>CA01</EXTERNAL_ID>
<BUSINESS_SYSTEM>DR4CLNT420</BUSINESS_SYSTEM>
<DISPLAY_NAME>Purchasing Org CA</DISPLAY_NAME>
<DOCUMENT_DESCRIPTION>Purchasing Org CA</DOCUMENT_DESCRIPTION>
</WMT_PORG>
</fields>
</object>
</WMT_PORGS>
</collections>
Successful Import But empty row in Collection
<collections>
<WMT_PORGS>
<object classname="masterdata.POrg">
<EXTERNAL_ID>CA01</EXTERNAL_ID>
<BUSINESS_SYSTEM>DR4CLNT420</BUSINESS_SYSTEM>
<DISPLAY_NAME>Purchasing Org CA</DISPLAY_NAME>
<DOCUMENT_DESCRIPTION>Purchasing Org CA</DOCUMENT_DESCRIPTION>
</object>
</WMT_PORGS>
</collections>
Successful Import But empty row in Collection
<collections>
<WMT_PORGS>
<object>
<fields>
<WMT_PORG>
<object classname="masterdata.POrg">
<EXTERNAL_ID>CA01</EXTERNAL_ID>
<BUSINESS_SYSTEM>DR4CLNT420</BUSINESS_SYSTEM>
<DISPLAY_NAME>Purchasing Org CA</DISPLAY_NAME>
<DOCUMENT_DESCRIPTION>Purchasing Org CA</DOCUMENT_DESCRIPTION>
</object>
</WMT_PORG>
</fields>
</object>
</WMT_PORGS>
</collections>
Succeeded with Warnings But empty row in Collection
Succeeded with Warnings
..Record 1. Warning: ID: exception.common.importer.field.cannot_resolve_external_ref |
..Record 1. Warning: Value for business system is missing. Enter a business system. |
..Record 1. Warning: Referenced Master Data not found for field WMT_PORG : EXTERNAL_ID:CA01, LOGICAL_SYSTEM:null |
<collections>
<WMT_PORGS>
<object classname="masterdata.POrg">
<fields>
<WMT_PORG>CA01</WMT_PORG>
</fields>
</object>
</WMT_PORGS>
</collections>
This is what I mean by "empty row in Collection"
Mike,
<WMT_PORG> under <WMT_PORGS> is already an extension field can you supply it with some data there and check.. {Ex: <WMT_PORG>CA01</WMT_PORG>}
Do you also have the extension definitions for externalId., Biz system, name & description fields?
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response. In the message body I have the 4 interations I have tried. " <WMT_PORG>CA01</WMT_PORG>}" is one of those.
"Do you also have the extension definitions for externalId., Biz system, name & description fields?"
the Purchase Org is a Master Data Object. I used those in the XML.
Succeeded with Warnings But empty row in Collection
Succeeded with Warnings
..Record 1. Warning: ID: exception.common.importer.field.cannot_resolve_external_ref |
..Record 1. Warning: Value for business system is missing. Enter a business system. |
..Record 1. Warning: Referenced Master Data not found for field WMT_PORG : EXTERNAL_ID:CA01, LOGICAL_SYSTEM:null |
<collections>
<WMT_PORGS>
<object classname="masterdata.POrg">
<fields>
<WMT_PORG>CA01</WMT_PORG>
</fields>
</object>
</WMT_PORGS>
</collections>
Hello Joerg,
Thanks for your suggestion, but unfortunately this does not work as P.org is object reference in my extenstion definition setup. We also tried adding Z_PORG.BUSINESSSYSTEM, but this also does not work.
I checked what Ed Suggested about the import of collection objects, and he was correct. The issue is fixed in SP17. So for now we are going with the field as free text.
Thanks,
Arahanth
User | Count |
---|---|
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.