funtion module and logic help

[former_member631462]

hello experts,

i want to

Pass VBRK-WAERK and VBRK-FKDAT into TCURR-FCURR and TCURR-GDATU for TCURR-KURST=ZCUS. Get UKURS for corresponding entry.

here one problem is the GDATU is specified as a whole month for eg( 01.07.2008) , means the data with 1st of the month to 31st of the month .

where as VBRK-FKDAT is specified as exact date eg (21.07.2008).

so if we pass VBRK-FKDAT to TCURR it wont fetch any record.

So please kindly help me out with the logic and the function module involved.

Thanks in advance.

[Former Member]

Hi,

Before passing date to where condtion or FM use,

CONVERT DATE VBRK-FKDAT INTO INVERTED-DATE dat2.

and then pass dat2.

Thanks & Regards,

Navneeth K.

[Former Member]

gdatu is inverted date, which you can get by calling CONVERSION_EXIT_INVDT_INPUT with the date field.

if you have the 1st of the month for gdatu, then change your fkdat to start of the month then convert to inverted date format

[Former Member]

Are you able to get data now ?

[former_member631462]

yes i am able to but i want to know how to convert the FKDAT to the stating date of the month...

if there any function module or logic plz kindly let me know

thank you.

[Former Member]

You can directly use string operation like:

v_fkdat is of format yyyymmdd

concatenate v_fkdat0(4) v_fkdat4(2) '01 to v_fkdat1

v_fkdat1 is the first date of the given month and year.