topic Re: Parameters table to store hardcoded values in Application Development and Automation Discussions

Parameters table to store hardcoded values

Former Member — Mon, 16 Jul 2007 13:57:32 GMT

All,

I was wondering if there is a table that exists to store hard coded values.

In my program, I need to retrieve a characteristics in table ausp where atinn = '0000000002’.

When created in TST, the value was not '000000002' but '0000000011’.

I want to avoid hard coding the value '0000000011’ in the query and instead retrieve it from a table.

I know I can create a custom table, but I was wondering what is the best practice for hard coded value and if a table already exists for this?

Thanks in advance,

Isabelle

Re: Parameters table to store hardcoded values

Former Member — Mon, 16 Jul 2007 14:03:51 GMT

Hi Isabelle,

You don't need to have a table to store hard coded values.

YOu can declare parameters for the user to enter the values:

parameters p_atinn type ausp-atinn default '0000000011’.

or use constants statement like this:

constants c_atinn type ausp-atinn value '0000000011’.

REgards,

Ravi

Re: Parameters table to store hardcoded values

RichHeilman — Mon, 16 Jul 2007 14:06:48 GMT

Do not sue the ATINN field at all, this number is generated and may be different between systems. Always use the characterisitic name instead. You can get this value by going to table CABN, field ATNAM.

Regards,

Rich Heilman

Re: Parameters table to store hardcoded values

Former Member — Mon, 16 Jul 2007 16:30:07 GMT

Thank you for your help.

Isabelle