topic Re: Loading a range using macro in Application Development and Automation Discussions

Loading a range using macro

Former Member — Mon, 01 Aug 2005 18:09:20 GMT

Hello,

I have once come across a technique of loading a range using a macro that was stored in table TRMAC. Has anyone seen anything similar to this? I copied the code to a jump drive but have misplaced it. It was really a cool way to load a range with individual values.

Thanks,

Joe

Re: Loading a range using macro

RichHeilman — Mon, 01 Aug 2005 18:12:48 GMT

You don't have to store it in that TABLE. You can define the macro in your program.

ranges: r_datum for sy-datum.

Define build_range.
r_datum-sign = 'I'.
r_datum-option = 'EQ'.
r_datum-low = &1.
append r_datum.
end-of-definition.


* Now use the macro

build_range sy-datum.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

Re: Loading a range using macro

Former Member — Mon, 01 Aug 2005 18:25:59 GMT

Hi Joe;

Rich is right, you don't have to store it globally - you can just define it right in the program.

However, if you might want to check out this thread; it explains how to lock programs using a global macro.

Cheers,

John

Re: Loading a range using macro

Former Member — Mon, 01 Aug 2005 18:54:02 GMT

Thanks guys. One more thing. If I wanted to send a list of individual dates to that macro, what would the syntax look like? Would it be macro_name: date1,

date2,

date3.

I think this is what I saw once before.

Re: Loading a range using macro

Former Member — Mon, 01 Aug 2005 18:58:23 GMT

Yes, but without the commas. Here is an example:

set_fldcat_typ 'BLDAT' 'C' '13' 'Vend Doc Date' ' ' ' '.

-John

Re: Loading a range using macro

RichHeilman — Mon, 01 Aug 2005 19:00:22 GMT

ranges: r_datum for sy-datum.

[code]Define build_range.

r_datum-sign = 'I'.

r_datum-option = 'EQ'.

<b>r_datum-low = &1.

r_datum-high = &2.</b>

append r_datum.

end-of-definition.

Now use the macro

build_range <b>sy-datum sy-datum.[/</b>code]

Regards.

Rich Heilman

Re: Loading a range using macro

Former Member — Mon, 01 Aug 2005 19:16:33 GMT

Thanks again guys. Got it. I wanted to pass numerous single values to the macro and accomplished it like:

Build_macro: '64', '65', '66'.

This loaded the range with those three values.

Re: Loading a range using macro

RichHeilman — Mon, 01 Aug 2005 19:26:58 GMT

Oh, I misunderstood what you meant. I was think that you wanted to pass multiple values at one time to the range.

Regards,

Rich Heilman