Not posible to use function ROW_INPUT() in background processing

[kartikr]

Hi,

I'm trying to execute a macro in background for changing the values of a KF but unable to do so, as i'm getting the below warning messages:

"It is not possible to use function ROW_INPUT() in background processing" (Warning message)

Macro Start Macros has been executed (Success message - green signal )

"No data has been changed; data must not be save" (Warning message).

Below is the screenshot of macro created.

Need your guidance on how to get this issue resolved.

Regards

Kartik

[babu_kilari4 · Accepted solution]

Hi Kartik,

In the screenshot mentioned by you, I don't see ROW_INPUT() being used by you. However, if you want to clear the values in the key figure, try to use the following syntax instead of using operator as 0.

Row: Keyfigurename ( From DD.MM.YYYY ) = Initial

This should help you reset the key figure data in background.

Hope this helps.

Babu Kilari

[kartikr · Accepted solution]

Hi babu,

As suggested by you i have maintained the same syntax but still getting the same warning message

while executing it in background.

In /sapapo/mc8t what should i maintain in macro selection  tab start/default??

Actually i would like to execute this macro in background and it should set 0/intial in that KF row for some time horizon.

Regards

Kartik Rohilla

[former_member187488 · Accepted solution]

Hi, you should select 'Marco' radio button instead of 'Start'/'Default'/'Exit'.

[babu_kilari4 · Accepted solution]

Hi Kartik,

I just ran the job with the same syntax and the macro works perfectly alright for me. I made it as a Start macro in my case. In my case, it was a different key figure. Not sure if it has something to do with a specific key figure. May be ROW_INPUT () function doesn't work for SNP related keyfigures when it was run in background.

Could you please have a look at the SAP note 1777042 (including dependent notes) and see if it can help you resolve this issue ? Alternatively, please try to raise an OSS message to seek SAP's advice on this.

Thanks
Babu Kilari

[kartikr · Accepted solution]

Hi Babu,

This is what have created:

i'll check the sap note and will revert back to you.

Regards

Kartik

[kartikr · Accepted solution]

Hi Ada,

let me try with 'Macro' option too then i'll revert back to you. and for your information the data view is for DP planning book and key figure are also for DP only we are not using SNP here.

Regards

Kartik Rohilla

[kartikr · Accepted solution]

Hi Ada,

I have chosen option 'Macro' and it ran successfully in background. Thanks a ton for that!!
But now i'm getting this warning message that " History cannot be entered in book, you cannot save data" is this normal or am i doing something wrong in here??

Regards

Kartik

[babu_kilari4 · Accepted solution]

Hello Karthik,

I guess you can ignore that message as even I did get that warning message. The screenshot I pasted above doesn't show that message though.

Hope this helps

Babu Kilari

[former_member187488 · Accepted solution]

Hello, in /sapapo/sdp8b, you should activate input for the historical periods for the planning book/data view

[kartikr · Accepted solution]

Hi Ada,

These settings are already there in the planning book/Data view. still getting the warning message. Also i have another if you could answer me "Is it possible that someone edited the Customer Master's Data in ECC so APO doesn't recognize the change and is recapturing ALL of the transactions under the "New" CVC??

Regards

Kartik

[former_member187488]

Hi Kartik, First I want to say, you can set a key figure to zero, no matter whether it is set "zero allowed" or not. So I don't think the error comes from this setting.

The macro function ROW_INPUT() cannot be executed in background. I think you have included this macro function in the start or default macro group of your data view. If it is an SNP data view, stard and default macros will be executed also in background process.

[satish_waghmare3]

Hello Kartik,

Please check Tcode :  /SAPAPO/MSDP_ADMIN. Click on your Planning Area. Goto Key figures Tab. Then Click on "Details" Button.  Find  the key figure in the list and scroll to see the properties of your Shipment History Key figure.

Based on the problem which you have mentioned, I think you should set the Zero Allowed flag for Shipment History Key figure. Then your macro will work fine, but do not include ROW_INPUT() in the macro. If there is a macro (start or default type) exist having ROW_INPUT() you will get those warning messages.

Please do read this helpful document on this topic.

FYI - ROW_INPUT() function will not help you to do so. You should not use that function while running the macro in background job.

Hope this will help.

Thank you
Satish Waghmare

[former_member182607]

Hi Kartik,

Hope your Shipment History KF is ZERO enabled.

Thx,

Subash

[kartikr]

Hi Subash,

Zero is allowed in KF shipment history.

Regards

Kartik