Calculation Field in Query

[former_member198406]

Hi,

I am devloping a query report of the confirmation details of process order.

In which the execution start/finish date & time are confirmed during the confirmation process.

The report of the same can be derived from COOISPI under operations.

But, I want to calculate the duration on the basis of start/finish date & time. which is not available in standard COOISPI report or in table.

I have created the query using the same tables as in COOISPI - operations. And now, I want to add an extra field which is not a part of the table. Also, how to assign a formula = (end date+end time)-(start date + start time)?

I am not an ABAP person. I am just a simple PP/QM person. So, I don't know more about the same.

Thanks in advance.

Dipesh

[former_member198406]

Hello Dipesh,

You need to create an additional field. Did you create an Infoset for this query (transaction code SQ02).

1. After you create your table joins, select pushbutton labeled "Extras." Select create icon, then enter field name and select radiobutton "Additional field" on popup box for Additonal information. On popup box "Additional field" enter the new field text information, type and length.

2. You should see your new field in a list on the right-side of screen. Select "CodingforAddition" icon. Program your logic here.

3. Make sure you add your new field to a field group. Generate your infoset.

4. Call transaction SQ03 and assign your Infoset to a user group.

5. Call transaction SQ01 and create a query based on the Infoset you created.

Kind Regards,

Rae Ellen Woytowiez

[Former Member]

Hello Dipesh,

You need to create an additional field. Did you create an Infoset for this query (transaction code SQ02).

1. After you create your table joins, select pushbutton labeled "Extras." Select create icon, then enter field name and select radiobutton "Additional field" on popup box for Additonal information. On popup box "Additional field" enter the new field text information, type and length.

2. You should see your new field in a list on the right-side of screen. Select "CodingforAddition" icon. Program your logic here.

3. Make sure you add your new field to a field group. Generate your infoset.

4. Call transaction SQ03 and assign your Infoset to a user group.

5. Call transaction SQ01 and create a query based on the Infoset you created.

Kind Regards,

Rae Ellen Woytowiez

[former_member198406]

Thank you very much for the solution.

This would be helpful to me any many functional consultant.