How to display a field from different business view

Hi,

I am new to development. I have a simple business scenario but not being able to figure out how to resolve it

I have two sections. Primary section is linked with business view (V4211A - Sales order details) and the other section is linked with business view (F0101A - address book) and I have create a sub section join to link both sections. Now I want to display field (AC02 from address book business view) in the first section (sales detail section) but cant simply drag it there. I tried to create a variable in primary section and pass the value thru ER (initialization section) but it shows nothing.

Please help me how can I get proper value from address book business view in sales order detail section.

Regards


Jameel
 

craig_welton

Legendary Poster
Try creating a new business view that joins F4211 to F0101 on whichever address number you require (AN8, SHAN etc). (You may also look for an existing one, of course.) Then all the AB columns will be available with the sales order lines.

Craig
 
Try creating a new business view that joins F4211 to F0101 on whichever address number you require (AN8, SHAN etc). (You may also look for an existing one, of course.) Then all the AB columns will be available with the sales order lines.

Craig



Hi Craig,

Thanks for your reply. Unfortunately I have a Custom Business view (F4211 union F42119) and I cant create a join with F0101
 
Hi Craig,

Thanks for your reply. Unfortunately I have a custom business view (F4211 union F42119) which wont allow me to create a join with F0101
Cant I handle it thru report or Event variables. ?\
Regards

Jameel
 
Discover how to build no-code data integrations and business process automations.

craig_welton

Legendary Poster
Then just do a Fetch Single table IO on F0101 and retrieve the value of AC02 into a Report Variable in your do section. No need for the other section. Not the optimal performance but you're stuck because of the union.

Craig
 
Top