Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Largest date value from table

Former Member
0 Likes
723

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

5 REPLIES 5
Read only

former_member585060
Active Contributor
0 Likes
653

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

Read only

0 Likes
653

Hi Balakrishna,

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

Have a gr8 evening

Regards

Sudha

Read only

0 Likes
653

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

Read only

Former Member
0 Likes
653

Hi Sudha,

try this function module then CONVERT_TO_LOCAL_CURRENCY

Regards.

Eshwar.

Read only

Former Member
0 Likes
653

Issue solved