topic Re: Writing Custom code in Adhoc Query in Application Development and Automation Discussions

Writing Custom code in Adhoc Query

former_member497886 — Wed, 02 Oct 2013 05:13:07 GMT

Hi All,

Scenario -

I have enhanced a info type say XXXX and added 2 fields in this, say F1 and F2.

The data for these 2 fields are not saved in PAXXXX. It is stored in custom table say T1.

Now I have added these 2 fields in Adhoc query under additional fields, but the data is not getting populated since it is not stored in info type table PAXXXX.

Is there any place to write the custom code for this or is there any other way of doing it.

Please suggest.

Thanks & Regards,

Mohammadi

Re: Writing Custom code in Adhoc Query

RaymondGiuseppi — Wed, 02 Oct 2013 06:44:47 GMT

Yes, there is such a place

...

When you created the fields, there was a field "Sequence of code", now in menu call Extras if not already done, display tab "code" and add Abap code to select data in "record processing" for this sequence.

Regards,

Raymond

Re: Writing Custom code in Adhoc Query

former_member497886 — Wed, 02 Oct 2013 14:13:54 GMT

Hi Raymond,

Thanks for reply.

Where exactly this "Sequence of code" comes, while creating the fields in infotype or adding the fields in Adhoc query.

Thanks,

Mohammadi

Re: Writing Custom code in Adhoc Query

RaymondGiuseppi — Wed, 02 Oct 2013 14:22:23 GMT

Which kind of AdHoc query are you asking for (this term can be used in BI, BW, Web applications, query, Infoset Query, etc. (or which transaction do you use if easier to answer) - Beware you may be required to access another transaction (e.g. SQ02 for Infoset) to fulfil your requirement.

Regards,

Raymond

Re: Writing Custom code in Adhoc Query

Former Member — Thu, 03 Oct 2013 09:38:23 GMT

Hi Mohammadi,

This is achievable, i had a similar requirement plz follow the below steps.

* Go to the field u have created in additional field (in sq02) , then right click and select " Field code".

* Write the abap logic to fetch the details from the custom table(T1 in your case) and pass it to the field (F1 or F2)

* Repeat this for the other field also.

Hope this helps.