topic Re: To select the field dynamically while fetching th e data in Application Development and Automation Discussions

To select the field dynamically while fetching th e data

kavya_2017 — Fri, 20 Aug 2010 12:50:39 GMT

Hi Experts,

We have fields like TKG001, TKG002, TKG003 etc in COST table...

My requirement is that we want the value present in the field TKG0** where ** is the month of system data.

Do we have any method to extract the field dynamically from the table.

Please suggest me how can i achieve the requirement.

Thank you,

Regards,

Kavya

Re: To select the field dynamically while fetching th e data

Former Member — Fri, 20 Aug 2010 12:57:38 GMT

Dear Kavya,

Could you please elaborate your query ? If you want to extract data through any programme you can always define some variable according to the no. of a particular month.

Anyway, please elaborate on your requirement.

Regards

Re: To select the field dynamically while fetching th e data

bbalci — Fri, 20 Aug 2010 13:00:58 GMT

Hello

You can use dynamic field specification

Check this :

REPORT x.

DATA :

      BEGIN OF lw_field,
        field(20),
      END OF lw_field,
      lt_field LIKE STANDARD TABLE OF lw_field.

START-OF-SELECTION.

  lw_field-field = 'BUKRS'.
  APPEND lw_field TO lt_field.

  lw_field-field = 'GJAHR'.
  APPEND lw_field TO lt_field.


  SELECT (lt_field)   "<-- Internal table contains your dynamically specified in parenthesis 
  FROM bkpf
  INTO TABLE itab.

  BREAK-POINT.

Re: To select the field dynamically while fetching th e data

RaymondGiuseppi — Fri, 20 Aug 2010 13:02:18 GMT

Yes [SELECT|http://help.sap.com/abapdocu_70/en/ABAPSELECT.htm] statement allow a dynamic [SELECT - columns|http://help.sap.com/abapdocu_70/en/ABAPSELECT_CLAUSE_COLS.htm#&ABAP_ALTERNATIVE_3@3@] syntax - Check the sample at the bottom of the last link.

Regards,

Raymond

Re: To select the field dynamically while fetching th e data

Former Member — Fri, 20 Aug 2010 13:52:29 GMT

A simpler way would be to select the twelve fields and then decide which one to use while processing the internal table.

Re: To select the field dynamically while fetching th e data

kavya_2017 — Tue, 24 Aug 2010 12:37:14 GMT

Hi Bulent and Raymond,

Your answer solved my problem,

Thank you