CPI: XML to Query mapping

[#1]

Hi guys,

I have problems in my CPI-DS dataflow from S4H to IBP:

I want to do a mapping from an XML file to a normal Query transformation. But CPI does not let me draw a line between the two transformations. The only possibility is to make a line between the XML transformation and the Target Query.
Is it not possible to connect XML and Query transformations?

Additionally when I connect the XML transform to the Target Query, the attribute mapping is always giving me this error: "Table <XML_Transformation_Output.LOC_RES_TAB> for column <WERKS> does not occur in the FROM clause. For a top-level query, all columns must belong to some table in the FROM clause."

I don't see, where the error in my mapping is. Maybe one of you can see my error source?

Thanks for your help!

Martin

[former_member678011 · Accepted solution]

Hi Martin,

I have Tried to created a similar flow : Xml map to Target_Query.

Step1:

Xml map transform- check the iteration rule applied and it should have the schema as (as per your structure it may vary but all the parent nodes must be present)-

Selected Scheme - Transform4.XXXXCreatePlannedOrder.ImHeader.item

Step 2:

Xml map to Target Query-

Here i mapped Material to MSG1 so the mapping should be Transform4.XXXXCreatePlannedOrder.ImHeader.item.Material , Please check your Xml map transform for the iteration rule and xml structure.

XML_Transformation_Output.LOC_RES_TAB.WERKS (your scenario) = is not having the full structure. Kindly check and revert back if this solves your Query 🙂

Regards,

Sibi

[sutterm]

Hi Ajay: I already checked this. Unfortunately no improvement.

Hi Sibi: What do you mean with "XML_Transformation_Output.LOC_RES_TAB.WERKS (your scenario) = is not having the full structure."?

[former_member678011]

Hi Martin,

XML_Transformation_Output.LOC_RES_TAB.WERKS (your scenario) = is not having the full structure.

If you compare the above mapping with mine -"Transform4.XXXXCreatePlannedOrder.ImHeader.item.Material" From the Root level "Transform4" till the field "Material" all the intermediate steps are represented in the mapping with dot separated "." ,Kindly check your Xml structure or add an "Xml Map" transform & apply Iteration rule and map it on the next step with Target_Query.

Regards,

Sibi

[ajayprakash]

Hi Martin,

Did you check the filter conditions, if it has got the right format of tablename.columnname ?

KBA 2925750 may help you.

Thanks

Ajay