How to display a field from different business view

[Jameel Ahmed]

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]

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

 

[Jameel Ahmed]

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

 

[Jameel Ahmed]

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

 

[craig_welton]

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