What is the date format for a Function Module.

[Former Member]

Hi Friends,

I am running a FM RRW3_GET_QUERY_VIEW_DATA with selection parameter as date.

May i know date format while providing date via I_T_PARAMETER.

Thanks in adavnce.

Regards,

Hrishikesh

[former_member199542]

Hi,

Go to SE37 -->  give this  ALINK_CALL_TRANSACTION    function module and exicute.

then you will get another screen, there you can give  SU01  and exicute ...

then you will get access to SU01 Tcode......

in the SU01 you can give your  UserName  and click on dispaly.... there you can check Defalut Date Format..

Hope this will be useful...

Please find below screen shots for your reference:

Regards,

Nagaraju K

[Former Member]

Hi,

In SU01, check the Defaults tab for the date format maintained and use that format in the Function Module.

Thanks,

Kokila

[Former Member]

HI Kokila,

I dont have access to this tcode.

[KodandaPani_KV]

Hi,

get the access from the basis team.

if don't have authorization SU01 - check with the basis team with your user ID.

check the default tab of date format - DD.MM.YYYY.

Thanks,

Phani.

[RamanKorrapati]

Hi,

By using above function module which report you want see the data?

at your source report may have selection  options on date field.

first check your report select options whether you used 0calday or 0calmonth or 0calyear.

based on that you need to pass.

Thanks

[Former Member]

Hi Ramanjaneyulu

the filled name is Key Date (ZVDMSKDD) and at source i am providing selection as 07/10/2014.

Regards,

Hrishikesh

[RamanKorrapati]

as stated above you can use date as 07/08/2014 and lets run it.

Even by entering single date above FM will won't run.

Because i_t_paramter - you need to pass multiple values along with high and low ranges.

On Google there are some useful pdfs are exist,

Please search and read them once. you may get idea how they used.

[Former Member]

Hi Raman,

Please see the I_T_PARAMTER values in anshu's reply.

Let me know if it is correct.

[RamanKorrapati]

Use date formate as 10/07/2014 or 07/10/2014

[Former Member]

Hi Raman,

With this formats also I am getting an error as Specify a value for Key Field.

Please suggest.

[Former Member]

Not sure but can you try 20141007 and see if that works.

[RamanKorrapati]

Hi

Can you run your bex query with keydate ZVDMSKDD - 07/10/2014.

lets see whether its shows output or not.

if not then you need to use another date which source have the data.

Thanks

[Former Member]

Hi Raman,

I ran it and i got the output.

What else can we try?

[Former Member]

Hi Jai,

Tried this also.Same issue is appearing.

[anshu_lilhori]

I think it should be in DD.MM.YYYY format.Please try it.

Regards,

AL

[Former Member]

No. It is not DD.MM.YYYY.

I am getting an error saying specify a value  for variable Key Date.

[anshu_lilhori]

You need to pass the value to the input variables of the query which are mandatory.BTW can i know how are you using that FM .

Regards,

AL

[Former Member]

Hi Anshu,

I am running the FM with tcode SE37. Also i am providing mandatory selections only which is Key Date.The I_T_PARAMETER are as follows.