Load additional Item Information in performant way
I face currently a challenge to load additional information for items in a performant way into multiline marketing document.
We have an UDT that holds additional technical information for items. It can be 10-20 lines with 3 columns with information for 1 item. UDT has columns ItemCode, Characteristic, Value. It should be shown like a table below each item line (Characteristic & Value). In the past we loaded the data with LD.Query. But this was already slow as LD.Query was run for every document row.
We added it now as own datasource in Layoutdefinition and linked it to SWA_LD_Document:Row via ItemCode. To display all lines from the UDT we packed it into an advanced databand. But performanc is now even worse because we have probably now more loops in loops.
How can we solve such a requirement in a performant way?
Any suggestions welcome.
Please sign in to leave a comment.