Edit Row Macro

[Former Member]

Hello All,

We have a demand planning book with weekly bucket. It has 10 weeks in future and 10 weeks in History.

Now for one particular key figure, I want to create a macro that will always make the first 4 weeks of that key figure editable (unlock) for the users and keep remaining 6 weeks as locked (non editable).

I am not sure which macro function can be used for this requirement.

Kindly advice.

Thanks,

Sanju

[Former Member · Accepted solution]

Hi Sanju,

Please look at the Standard Examples given by SAP which will give you a good reference or else let us know so that we can help you further.

Use COL_INPUT for your macro and look at the following example

Goto Transaction: /n/sapapo/advm-----> SAP EXAMPLE AND TEMPLATE MACROS >

(1) Make 2nd Column read only

(2) Make 2nd column ready for input

The macro creation should be very easy as it is a simple requirement.

Kindly close the thread, If you feel that you have been answered and

GOOD LUCK

Regards

Kumar Ayyagari

[Former Member · Accepted solution]

Thanks for guidance

[Former Member]

normally you will set history as not editable by configuring your planning book directly by setting the planing start date

in your macro set COL_INPUT(0) for column 5 to 10

But this is not necessary if your business requirement specifies that you enter some KF values in the history

In this case you will need to make input from in the planning book maintainance start from -10

and in your macro set COL_INPUT(0) for column -10 to 0 and 5 to 10

[Former Member]

Hi Sanju,

Use the following:

ROW_INPUT()

ROW_INPUT( X ) sets the input status of a row. If X = 1, the status of the cell is set to ready-for-input. If X = 0, the status of the cell is set to read-only. The argument can be either a number that you enter in an Operator/function dialog box, or one of the macro elements cell, row, or column from the planning table or the auxiliary table. You can apply this function to a row or cell. In the attributes of the row or cell, set the Scope of change to Attributes.

**************************

For reference:

CELL_INPUT()

Syntax

CELL_INPUT( Read_only_mode )

Read_only_mode: Whole number value 0, 1, or 2

Description

The CELL_INPUT function sets the ready for input status of a cell. The Read_only_mode parameter determines the status. The value 0 sets the cell's status to Not ready for input. The value 1 sets the cell's status to Ready for input. The value 2 determines that the cell adapts the status of the corresponding row. If no status has been set for the row, the value 2 determines that the cell adapts the status of the corresponding column.

************************

COL_INPUT()

COL_INPUT( X ) sets the input status of a column. If X = 1, the status of the column is ready for input. If X = 0, the status of the column is read-only. The argument can be either a number that you enter in an Operator/function dialog box, or one of the macro elements cell, row, or column from the planning table or the auxiliary table. You can apply this function to a column or cell of the planning table. In the attributes of the column or cell, set the Scope of change to Attributes. This applies to Grid 1. To refer to Grid 2 use X = 20 for read-only, and X = 21 for ready for input. Similarly X = 10 and X = 11 to refer just to GRID 1.

**************

Regards

Kumar Ayyagari

Message was edited by:

Kumar Ayyagari