topic Re: Adding a function module into a SQ01 Query in Application Development and Automation Discussions

Adding a function module into a SQ01 Query

former_member805659 — Mon, 14 Jul 2014 05:44:00 GMT

Hi ABAP Gurus,

I was trying to extract few dates from TSEGE Table, by linking the VTTK - HANDLE. We are trying to look at maintaining dates of shipment that were not previously used in our company.

When I tried extracting the dates from TSEGE, they come as timestamped UTC. I was told to use the function module IB_CONVERT_FROM_TIMESTAMP with CET in a query by an external consultant we use for our services. I am familiar with creating simple queries in SQVI and convert them to SQ01, also I know to create queries in SQ01 itself. But do not know how to add a function module into an SQ01 Query.

After checking a few threads, I realise that I should be creating a field and entering the code of the function module.

Is there any way, anybody could instruct me in simple terms how do I go about adding a function module.

Your help will be greatly appreciated.

Thanks in advance!

Re: Adding a function module into a SQ01 Query

Former Member — Mon, 14 Jul 2014 09:23:16 GMT

Hi Dsouza,

you can add any FM or code in SQ02 infoset area not in SQ01.

when you convert your query in SQ01 then tat time system should be having infoset SQ02 .

you can go with your infoset in SQ02 and add code in inside SQ02 for validation or updating/adding new fields in infoset etc.

Please check and let us know if you have any doubt.

Regards,

Prasenjit

Re: Adding a function module into a SQ01 Query

jogeswararao_kavala — Mon, 14 Jul 2014 10:12:34 GMT

First you need to create an Infoset (SQ02). Here you will have your Additional field to hold the converted time. Following is an example of using FM in an Infoset (SQ02). Here first we created an Additional field mnthr in the Extras tab and gave the FM code shown in the coding section of this Additional field..

Take this Additional field into FieldGroups of the Infoset along with other fields of your report. Generate Infoset. Now you will create an Infoset Query (SQ01) based on this Infoset, where this calculted Additiona filed will be available to you.

Jogeswara Rao K

Re: Adding a function module into a SQ01 Query

former_member805659 — Mon, 21 Jul 2014 08:36:24 GMT

Dear Jogeswara,

I have after reading a few threads, understood this small code and changed to my specification

To convert UTC Start time from TSEGE

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'

EXPORTING

I_TIMESTAMP = TSEGE-EVEN_TSTFR

I_TZONE = CET

IMPORTING

e_datlo = date

e_timlo = time

To convert UTC Start End from TSEGE

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'

EXPORTING

i_timestamp = TSEGE-EVEN_TSTTO

i_tzone = CET

IMPORTING

e_datlo = date

e_timlo = time

I hope the above codes are correct. If yes, I have a doubt: TSEGE-EVEN_TSTFR & TSEGE-EVEN_TSTTO have different time in the same field, "Actual" & "Forecast", which is determined by TSEGE-EVEN_VERTY wherein 1 is Actual and 0 is Forecast. Is this something I would have to put in the code, or something that would work in the query "Selection Fields"?

Thanks again!

Re: Adding a function module into a SQ01 Query

jogeswararao_kavala — Mon, 21 Jul 2014 08:47:57 GMT

You may have to manage through if condition like

If TSEGE-EVEN_VERTY = '1'.

Call function .....

...........

else.

Call Function ....

...........

Endif.

Re: Adding a function module into a SQ01 Query

former_member805659 — Mon, 21 Jul 2014 08:55:12 GMT

If TSEGE-EVEN_VERTY = '1'.

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'.

EXPORTING

i_timestamp = TSEGE-EVEN_TSTFR.

i_tzone = CET.

IMPORTING

e_datlo = date.

e_timlo = time.

else

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'.

EXPORTING

i_timestamp = TSEGE-EVEN_TSTFR.

i_tzone = CET.

IMPORTING

e_datlo = date.

e_timlo = time.

Endif.

Is the above fine now?

Re: Adding a function module into a SQ01 Query

jogeswararao_kavala — Mon, 21 Jul 2014 09:02:04 GMT

Yes I am hinting at htat only. Rest take care of syntax.

But there is soemthing wrong. You have put same field value (TSEGE-EVEN_TSTFR) at both the CALL FUNCTION

Re: Adding a function module into a SQ01 Query

former_member805659 — Mon, 21 Jul 2014 09:16:37 GMT

The problem is TSEGE-EVEN_TSTFR holds both the values, Actual and Forecast and is differentiated by

TSEGE-EVEN_VERTY = '1'. or TSEGE-EVEN_VERTY = '0'.

So in this case, I cannot use, IF I will have to use "When"