topic Re: Largest date value from table in Application Development and Automation Discussions

Largest date value from table

Former Member — Sun, 07 Sep 2008 15:25:35 GMT

Hi experts,

I wasnt to find the largets which inturn would be latest date available in TCUR table as part of currency translation. Please give you suggestion on code in this.

Regards

John

Re: Largest date value from table

former_member585060 — Sun, 07 Sep 2008 15:54:57 GMT

Hi,

Fetch the data from TCURR table to an Internal table.

Sort that Internal Table DESENDING by DATE field.

Now in the Internal table the first record will be the Recent or Highest date record in the TCURR table.

Use READ statement with SY-INDEX 1 to get the first record.

Regards

Bala Krishna

Re: Largest date value from table

Former Member — Sun, 07 Sep 2008 15:59:31 GMT

Hi Balakrishna,

Thanks a lot for your promp response, I will try that and let you know.

Have a gr8 evening

Regards

Sudha

Re: Largest date value from table

Former Member — Mon, 08 Sep 2008 06:34:02 GMT

Hi Sudha,

try this function module then CONVERT_TO_LOCAL_CURRENCY

Regards.

Eshwar.

Re: Largest date value from table

Former Member — Sat, 20 Sep 2008 12:04:35 GMT

Issue solved

Re: Largest date value from table

Former Member — Thu, 16 Oct 2008 15:12:58 GMT

Hi Bala Krishna,

I have a requirement like this,

We need to upload special charecteristics in to the cube, it is getting loaded to ODS but not to cube.

Can you please sugegst the code to upload special charecteristcs like ( & ) - like this there are many, can u suggest the way i can write the code to upload these special chrs to cube.

Regards

Roopa