Skip to Content
0
Dec 27, 2022 at 09:46 AM

Have a Parameter but dont want it to show up in SAP

25 Views

if {?@Whs48} = True
then
(not HasValue({?@SELECT distinct "U_XIS_BRANCH" FROM OINV}) OR {Command.U_XIS_BRANCH}= {?@SELECT distinct "U_XIS_BRANCH" FROM OINV})
and

(not HasValue({?@Select * from OITM}) OR {Command.ItemCode} = {?@Select * from OITM}) and
(not HasValue({?DateRange@}) OR {Command.DocDate} = {?DateRange@})
and 
{Command.DiscPrcnt} = {?Discount@}
else
(not HasValue({?@SELECT distinct "U_XIS_BRANCH" FROM OINV where "U_XIS_BRANCH" <> '48' order by "U_XIS_BRANCH"}) OR {Command.U_XIS_BRANCH} = {?@SELECT distinct "U_XIS_BRANCH" FROM OINV where "U_XIS_BRANCH" <> '48' order by "U_XIS_BRANCH"}) and
(not HasValue({?@Select * from OITM}) OR {Command.ItemCode} = {?@Select * from OITM}) and
(not HasValue({?DateRange@}) OR {Command.DocDate} = {?DateRange@}) and
{Command.DiscPrcnt} = {?Discount@}

image.png

This Issue I am having is I needed to create a parameter that will display all the warehouses if they decide to choose that they want to see warehouse 48 now because I created this parameter it appears in SAP is there a better way to do this? If not how can i remove the option in SAP

Attachments

image.png (6.7 kB)
image.png (11.1 kB)