F4IF_INT_TABLE_VALUE_REQUEST Problem

[amol_samte]

Hi Gurus,

I am getting blank values in for F4 help.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

      EXPORTING

       RETFIELD                    = 'SPART'

       DYNPPROG                 = SY-REPID

       DYNPNR                      = SY-DYNNR

       DYNPROFIELD            = 'S_SPART-LOW'

       VALUE_ORG               = 'S'

      TABLES

        VALUE_TAB              = GT_SPART runtime am getting 66 Values in internal table

     EXCEPTIONS

       PARAMETER_ERROR        = 1

       NO_VALUES_FOUND        = 2

       OTHERS                 = 3

              .

Regards,

Amol

[mayur_priyan]

Try,

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING

retfield                    = 'SPART'
dynpprog               = sy-cprog     <<<<<
dynpnr                   = sy-dynnr
dynprofield            = 'S_SPART-LOW'

value_org              = 'S'
TABLES
value_tab              = GT_SPART

return_tab                = gt_return   <<<<<<

Regards,

Mayur

[amol_samte]

Hi  Mayur,

Used but getting same problem.

[JK]

here an example which works, maybe this helps you:

report  z_multiple_choice                       .

constants: gc_field type fieldname value 'WERKS'.

data: gt_t001w like t001w occurs 0 with header line,

      gt_return like ddshretval occurs 0 with header line.

select * up to 50 rows from t001w into table gt_t001w.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

  exporting

    value_org       = 'S'

    ddic_structure  = 'T001W'

    retfield        = gc_field

    multiple_choice = 'X'

  tables

    value_tab       = gt_t001w[]

    return_tab      = gt_return[]

  exceptions

    parameter_error = 1

    no_values_found = 2

    others          = 3.

if sy-subrc <> 0.

  message id sy-msgid type 'I' number sy-msgno with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

describe table gt_return.

loop at gt_return.

  write: / gt_return-fieldval.

endloop.

[amol_samte]

Hi Jorg,

I am developing program in BW 7.4 system, hence no didc struct. would be available.

[JK]

so maybe this is the Problem you don't see values? how have you done your data Statements?

it might require data dictionary definitions.

[amol_samte]

Actually we are writing a program in that we are fetching data from differnt system .

Simply i have declared types gty_spart, data : gt_spart type standard table of gty_spart.

[Former Member]

Can you please elaborate the issue. What I understood is that the values are being fetched in debugging, but the output is not displayed .. is this the issue ?

[amol_samte]

Yes.

Values has been fetched but after that I am getting above screen which I have posted.

PS : I am using BW 7.4 SP 09

Regards,

Amol

[Former Member]

Hi Amol,

Try changing DYNPROFIELD  = 'S_SPART-LOW' to DYNPROFIELD  = 'S_SPART'

Let me know if it is resolved.

Regards,

Ashish.

[SharathYaralkattimath]

Check note 1880626 Released On 20.03.2014 19:11:52

[amol_samte]

Tried but no change.

[RaymondGiuseppi]

How did you define GT_SPART, does the structure contain a SPART field?

Regards,

Raymond

[amol_samte]

Yes Raymond,

DATA : BEGIN OF GW_SPART,

                SPART TYPE C LENGTH 2,

                VTEXT TYPE C LENGTH 20,

           END OF GW_SPART,

           GT_SPART LIKE  TABLE OF GW_SPART

Thanks,

Amol.

[amol_samte]

Hi Raymond,

Below is my code

DATA : BEGIN OF GW_SPART,
           SPART TYPE C LENGTH 2,
           VTEXT TYPE C LENGTH 20,
           END OF GW_SPART1,
           GT_SPART LIKE  TABLE OF GW_SPART.

DATA : RETURN_TAB TYPE STANDARD TABLE OF DDSHRETVAL.

SELECTION-SCREEN : BEGIN OF BLOCK BLK1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_FKDAT FOR GW_FKDAT NO INTERVALS OBLIGATORY,
                 S_SPART FOR GW_SPART_T.
SELECTION-SCREEN : END OF BLOCK BLK1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_SPART-LOW.
  CALL METHOD ZCL_DISPATCH_HANA=>F4_SPART_AMDP
                                                                          IMPORTING
                                                                                 EX_TSPAT = GT_SPART.
  IF GT_SPART IS NOT INITIAL.
   
    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
      EXPORTING
       RETFIELD               = 'SPART'
       DYNPPROG               = sy-cprog
       DYNPNR                 = '1000'
       DYNPROFIELD            = 'S_SPART'
       VALUE_ORG              = 'S'
      TABLES
        VALUE_TAB              = GT_SPART
        RETURN_TAB              = RETURN_TAB
     EXCEPTIONS
       PARAMETER_ERROR        = 1
       NO_VALUES_FOUND        = 2
       OTHERS                 = 3
              .
    IF SY-SUBRC <> 0.
* Implement suitable error handling here
    ENDIF.

  ENDIF.

[Former Member]

you need to pass value in field_tab parameter. This will resolve the issue.

  lt_fields TYPE ddfields,

  lwa_field TYPE dfies,

lwa_field-tabname = 'DFIES'.

lwa_field-fieldname = 'FIELDNAME'.

APPEND lwa_field TO lt_fields.

pass this LT_fields to parameter field_tab in tables

[RaymondGiuseppi]

No description of fields come from any ddic only Abap internal types. The first empty line under icons should contain header texts of columns

You must fill yourself the (not so) optional parameter "FIELD_TAB" (CL_ABAP_STRUCTDESCR)

Regards,

Raymond

[amol_samte]

Hi Raymond,

Can you explain me bit more..

I dont have table in BW system am getting data from ECC.

[amol_samte]

Hi Ashish,

in tabname we dont have table in BW system.

[RaymondGiuseppi]

So you should be able to get ddic information in ECC thru RFC FM (e.g. DDIF_FIELDINFO_GET on table TSPAT)

[amol_samte]

Thanks a lot Raymond,

Finally I got it what I was looking for because of your guidance....

Cheers,

Amol