Adding two tables for textblocks in XML Structure CMS006

Kaneez Jowaheer

I am trying to add a custom section for table MSYTXH and MSYTXL in the XML structure of MMS480PF for the line section to obtain text from MMS001 textblocks. The prefix for MSYTXH is TH. But another table (OSYTXH) with the same prefix (TH) is already present in another section of the structure.

So I changed the prefix for MSYTXH to MH as seen in the screenshot below:

Then I did the join with MITMAS

For my header part I am able to retrieve my fields and values.

But now I have to join MSYTXL with MSYTXH to obtain the lines part. I added the custom section to the section of MSYTXH

But for the join since there are different prefix, the section is not retrieved in the XML Structure.

Is there a workaround to be able to use the 2 tables and retrieve the fields from MSYTXL?

Thank you

0712131256598360.doc

Denis MARETTE

In your approach, there will be a limitation linked to the fact that you can't link one table (the text header table) with another (the text line table) with a 1:1 ratio.
So, at best, you'll have the first line, the last line or a specific line (see my example).

I hope that it would be helpful