Grey out Cell of KF for Inactive Products in Planning Book

[sameer_karbotker]

Hi ,

Threre are few of Inactive Product's for which Users accidently enters Sales Plan in Planning Book.

Inactive Products have status 'I' in Infoobject 'ZSKSTATUS' which is Navigation Attributes [ZDP_PRSKU__ZSKSTATUS]

Can we Grey out cell for KF 'Sales Plan' for Inactive Products. This will not alow users to enter any Sales Plan for Inactive Products.

What I am looking for is .....

If Value of Info-object [ZDP_PRSKU__ZSKSTATUS] is 'I' then Cell is greyed out using function CELL_INPUT = 0

Can anybody pls provide which Function / Syntax to use to check Inactive Products.

Thanks in advance,

Sameer

[sameer_karbotker]

Hi ,

I could obtain what I wanted using Functions ACT_IOBJNM_VALUE & ROW_INPUT.

Below is Macro details.

MACRO : Grey-out KF Depot Plan for Inactive SKUs

New step : ( 3 Iterations : M 12.2011; M 02.2012 )

IF

Is Product SKU = Inactive ?

ACT_IOBJNM_VALUE( 'ZDP_PRSKU__ZSKSTATUS' )

=

'I'

Row: Depot Plan ( Attributes ) =

ROW_INPUT( 0 )

ELSE

Row: Depot Plan ( Attributes ) =

ROW_INPUT( 1 )

ENDIF