Skip to Content
avatar image
Former Member

field is unknown. it is neither in one of specified tables nor defined by data statement

Hello,

I'm doing enhancement  to filter the data for the input parameters. Also I've coded implicit enhancement for the selection parameters to be displayed on standard IE05 selection screen.

Defined a block as follows in standard  program RIHEQUI20

selection selectio begin of block b1 with frame title text-099.

select-options:

                    cre_date for equi-zzcreate_date,

                    lp_pdate for equi-zzprint_date.

selection selectio end of block b1.

now to filter the data corresponding to the input in selection parameters i've explicit enhancement point in which added coded in where condition

as

zzcreate_date IN cre_date

AND zzprint_date IN lp_pdate

but error message showing the above heading

...

Solution for that....PLZ help!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Aug 24, 2014 at 08:43 AM

    Hi Sujeet,

    As Peter suggested, declare your Select options in the INCLUDE 'MIOLESEL'. This include has the Selection Screen declarations and is inside the include 'MIEQUI20'.

    And write your selection logic in the Include MIEQUI20. But, check whether MIEQUI20 is called in any other reports and if you need these changes for the other reports too, you can go ahead changing MIEQUI20 and MIOLESEL.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2014 at 12:58 PM

    Try another enhancement spot like in INCLUDE MIOLESEL.

    This is where the rest of the select-options have been declared as well.

    You can find this include in INCLUDE MIEQUI20

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2014 at 01:40 PM

    It's simply the order of your statements:

    first you have your INCLUDE with the SELECT statement and than you have your SELECT-OPTIONS (the data declaration). This will not work.

    The SELECT-OPTIONS must be declared earlier.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2014 at 08:13 AM

    It menas that the data declaration, at the point that you are utilizing the variable doesn't exist. Check your declarations.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sharmila Subramanian

      Mam,

      Tried to declare tables but system tells ''table already deaclared''..

      and the code for filtering is in include miequi20 in enhancement section i'm implementing explicit enhancement and adding own code to where clause..

  • avatar image
    Former Member
    Aug 22, 2014 at 09:10 AM

    Please check below snap for details

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2014 at 09:36 AM

    Hi Sujeet,

    The include statement should be after your enhancement block.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2014 at 12:52 PM

    Maybe a stupid question, but is the customer field zzcreate_date really part of EQUI? Is EQUI activated?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sir,

      customer fields are included in CI_EQUI and active.

      but problem its not getting filtered properly...

      what can be the solutions ...?