topic Re: sqvi problem in Application Development and Automation Discussions

sqvi problem

Former Member — Mon, 17 Mar 2008 12:45:06 GMT

hi experts,

can i calculate difference between two dates and print the calculated date in another column.

pls provide soln on urgent basis.

thanks,

Re: sqvi problem

Azeemquadri — Mon, 17 Mar 2008 12:47:28 GMT

colum1 = date1

colum2 = date2

colum3 = date1 - date2. " colum3 is difference in dates.

Re: sqvi problem

Former Member — Mon, 17 Mar 2008 12:50:02 GMT

I think that is possible.

You migt have to declare a field group in the Infoset. and in the Infoset you will have to write code to perform this logic.

Let me know if you need any more information.

Hope this helps.

Thanks,

Balaji

Re: sqvi problem

Former Member — Mon, 17 Mar 2008 12:54:56 GMT

hi Balaji,

as i don't have knowledge about infoset can u explain me the step how to perform the infoset in detail by giving some simple solution.

thanks in advance.

Re: sqvi problem

Former Member — Mon, 17 Mar 2008 13:09:13 GMT

Hi,

Try like this:

DATA: EDAYS LIKE VTBBEWE-ATAGE,

EMONTHS LIKE VTBBEWE-ATAGE,

EYEARS LIKE VTBBEWE-ATAGE.

PARAMETERS: FROMDATE LIKE VTBBEWE-DBERVON,

TODATE LIKE VTBBEWE-DBERBIS DEFAULT SY-DATUM.

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = FROMDATE

i_date_to = TODATE

I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = EDAYS

E_MONTHS = EMONTHS

E_YEARS = EYEARS.

WRITE:/ 'Difference in Days ', EDAYS.

WRITE:/ 'Difference in Months ', EMONTHS.

WRITE:/ 'Difference in Years ', EYEARS.

INITIALIZATION.

FROMDATE = SY-DATUM - 60.

Regards,

Bhaskar

Re: sqvi problem

Former Member — Mon, 17 Mar 2008 13:22:12 GMT

hi azeem,

can u explain in detail.

thanks.

Re: sqvi problem

Former Member — Mon, 17 Mar 2008 13:27:47 GMT

thanks bhaskar for the code but how can i add a new column of difference in sqvi

Re: sqvi problem

Former Member — Tue, 18 Mar 2008 06:15:54 GMT

1. In SQVI check the Infoset name associated with the query you are trying to run.

2. Go to SQ02 using the infoset name.

3. Select "Field Groups" on the toolbar. Add the field in this field group.

4. Go to the "Code" tab on the next screen.

5. Select "Code Section" as "Record Processing" and write the code to populate the

column.

6. Activate the Infoset and then activate the Query also.

Hope this helps.

Thanks,

Balaji

Re: sqvi problem

Former Member — Tue, 18 Mar 2008 09:17:51 GMT

INFOSET NUMBER IS GENERATED BUT I AM NOT ABLE TO FIND OUT INFOSET NAME

PLS GUIDE ON THIS.

THANKS IN ADVANCE