topic funtion module and logic help in Application Development and Automation Discussions

funtion module and logic help

Former Member — Wed, 22 Oct 2008 10:56:22 GMT

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 — Wed, 22 Oct 2008 11:00:37 GMT

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 — Wed, 22 Oct 2008 11:08:41 GMT

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 — Wed, 22 Oct 2008 11:58:56 GMT

Are you able to get data now ?

Former Member — Wed, 22 Oct 2008 12:01:04 GMT

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 — Wed, 22 Oct 2008 12:09:13 GMT

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.