Skip to Content
avatar image
Former Member

How to Populating single prompt from two different table in SAP BO 4.1?

Hi Team,

Need your Help !!

I want to add @prompt in BO Report for “POLE” so Users can select the desired “POLE” data only, but this object coming from two different table like :-

“T_OWNED” AND “T_LEASED”, Now need to pull the data from both the table for single prompt - “POLE”.

Example :

(

T_OWNED.POLE IN @prompt('Contract Pole:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'All' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'ALL' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'all' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

)

Or

(

T_LEASED.POLE IN @prompt('Contract Pole:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'All' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'ALL' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'all' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

)

Please advise what are the option we can use but end result should be , When users run the report then only one Prompt come for both the table.

Note:- I am using SAP BO 4.1.

Thanks

Santosh Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers