Santosh_mali
17th August 2022, 22:09
Hi,

We have requirement to add few fields from Ship from BP(tccom121) to Business Partner overview session(tccom100).
I have tried first with using Input/ref. on form field with value : tccom100.bpid, tccom121.sfbp but it is not returning any data so I am fetching value in before.display in program script and displaying on session. now data is visible on session but easy filtering is not being enabled for new fields on Web UI.

I have attached screenshot for form field information.

Please let me know how to resolve this issue.

andreas.toepper
25th August 2022, 09:19
Using the Inpur/Ref field never worked for me.
To enable the easy filtering für a secondary table, it worked for me, to select the table in a query extension.

here's an example of adding whinh430 as secodary table to a session, which uses the maintable whinh431:

query.extend.select( "whinh430.* ", EXTEND_APPEND)
query.extend.from( "whinh430 ", EXTEND_APPEND)
query.extend.where( "whinh431.shpm REFERS TO whinh430 UNREF CLEAR ", EXTEND_APPEND)

I think this will work with maintable tccom120 and secondary table tccom121, too.

andreas.toepper
25th August 2022, 09:34
Sorry, deleted.