topic how to call 50 fields from table example sflight into sql statement in Application Development and Automation Discussions

how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 16:13:01 GMT

hi experts i have to write a prog with 3 tables and in 1st table I have to call 50 fields carrid connid fldate price......... till 50.

it takes lot of time to write each and every field.so, how to call those fields in sql statement any short cut or tips...

thank you in advance

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 16:30:22 GMT

It probably takes less time to type them in than asking the question here and waiting for an answer.

Rob

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 16:37:12 GMT

Hi Akshay,

Interesting requirement you have, one way off the top of my head i can think possible doing this would be to dynamically generate parts of the sql statement using concatenation of strings.

To do this i would use the FM GET_COMPONENT_LIST which will return all the details about your ITAB. Then use a loop to loop through the result set and concatenate the field names into a string variable. Once you have done that you just use the string variable in place of the field names in the sql statement and SAP will run the query. I've done this before when i had to take dynamic list of conditions into consideration.

The code for the sql should look something like this Select (select_condition) FROM table_name ....

the ( ) are required for ABAP to treat the string as actual input into the sql. Below is an example i've done in a program before

TABLE = 'Z_SPL_AUDIT'.

CONCATENATE WHERE_CLS_1 '=' STATUS INTO WHERE_CLS_1 SEPARATED BY ' '.

CONCATENATE DATE_FIELD 'BETWEEN' DATE_LOW 'AND' DATE_HIGH INTO WHERE_CLS_2 SEPARATED BY ' '.

SELECT * FROM (TABLE) INTO CORRESPONDING FIELDS OF TABLE REPORT_T_FINAL

WHERE (WHERE_CLS_1) AND (WHERE_CLS_2).

The only unknown i have is i have not tried this dynamic approach in the actual Select portion only in the table and where clause but i would expect it to work still.

Hope this helps,

Geoffery

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 16:41:25 GMT

Hi,

Is this an interview question?

Why not just use select * into corresponding.

The structure of the internal table though has to have the 50 fields with the exact same name that it appears in database.

Kind regards, Rob Dielemans

Re: how to call 50 fields from table example sflight into sql statement

matt — Wed, 06 Jan 2016 17:01:00 GMT

SE11. Copy and paste. Simples.

Re: how to call 50 fields from table example sflight into sql statement

VenkatRamesh_V — Wed, 06 Jan 2016 17:02:19 GMT

Hi Akshay,

Try,

DATA: BEGIN OF TY_MARA,

MATNR TYPE MARA-MATNR,

ERSDA TYPE MARA-ERSDA,

ERNAM TYPE MARA-ERNAM,

LAEDA TYPE MARA-LAEDA,

END OF TY_MARA.

Just copy the fields to select Query.

Hope it helpful,

Regards,

Venkat.

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 17:12:44 GMT

it doesn't matter with no. if i have to write 250 fields then it takes time right.

ex:-

select carrid connid fldate price........250th field.

how to write above mentioned example of sql stat

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 17:14:47 GMT

bro i know that technique.

i want sol for the below shown example

ex:-

select carrid connid fldate price........250th field.

how to write above mentioned example of sql stat

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 17:16:56 GMT

how to cop from se11.

should i copy each and every field. if so, for n example i have 250 fields then what should i do.

my requirement is show below as example.

ex:-

select carrid connid fldate price........250th field.

how to write above mentioned example of sql stat

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 17:21:42 GMT

this is not a interview question.

if i use select * into corresponding then performance drops.

Regards

Akshay Labhishetty

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 17:25:11 GMT

No - INTO CORRESPONDING won't give much of a performance hit. There are plenty of discussions on that topic in the ABAP space.

Rob

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 17:29:01 GMT

Have you tried Ctrl + Y to copy the fields from SE11?

-Chandra

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 17:32:13 GMT

no. will it happen.

if so

i need particular fields then what shuld i do

Re: how to call 50 fields from table example sflight into sql statement

Former Member — Wed, 06 Jan 2016 17:42:17 GMT

Are you saying that you need the first 50 fields in the structure or 50 particular fields?

In any event, I think you have enough answers to do this.

Rob

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Wed, 06 Jan 2016 18:01:05 GMT

I need solution for both the case.

i.e For 1st 50 and for particular 50.

Re: how to call 50 fields from table example sflight into sql statement

matt — Wed, 06 Jan 2016 19:02:13 GMT

If you have to manually put in more than ~20 fields then you're doing something wrong. Maybe the spec is wrong, maybe the requirement is silly. But chances are - it isn't necessary.

Re: how to call 50 fields from table example sflight into sql statement

matt — Wed, 06 Jan 2016 19:04:12 GMT

SELECT * may be a performance hit - especially with HANA. I've had massive gains in non-HANA and HANA systems by replacing * with a field list. However, as I said above, I can't think I've ever had to do more that ~20 fields. The fact is very very few realistic programs actually need more data than that.

SELECT INTO TABLE and SELECT INTO CORRESPONDING FIELDS OF TABLE are, as you say, performance-wise pretty much identical.

Re: how to call 50 fields from table example sflight into sql statement

matt — Wed, 06 Jan 2016 19:05:22 GMT

If you cannot answer the question of why you need to have such a ridiculously high number of fields I will lock this thread.

You've already had a lot of guidance over what appears, frankly, to be quite a trivial issue.

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Thu, 07 Jan 2016 02:54:50 GMT

Yea i know that i dont have requirement with 50 fileds. If the requirement comes then what should i do.

Re: how to call 50 fields from table example sflight into sql statement

former_member609183 — Thu, 07 Jan 2016 02:56:35 GMT

My friend gave me a task to write a report of any table with all the fields present in it. So i am asking here.