topic Re: HIDE in Application Development and Automation Discussions

HIDE

Former Member — Thu, 13 Nov 2008 10:52:01 GMT

HI FRIENDS...IAM GETTING BASIC LIST , WHEN I CLICK ON BASIC LIST SEC LIST IS M GETTING SEC LIST BUT 2ND SEC LIST IS NOT GENERATINGNOT COMING...

ONCE CHECK MY CODE FROM "WHEN 2" LINE..

&----

*& Report ZABHI_HIDE *

*& *

&----

*& *

&----

REPORT ZABHI_HIDE .

TYPES: BEGIN OF IT_T001,

BUKRS TYPE BUKRS,

BUTXT TYPE BUTXT,

ORT01 TYPE ORT01,

LAND1 TYPE LAND1,

WAERS TYPE WAERS,

END OF IT_T001.

DATA: T_T001 TYPE STANDARD TABLE OF IT_T001,

WA_T001 TYPE IT_T001.

TYPES: BEGIN OF IT_KNB1,

BUKRS TYPE BUKRS,

KUNNR TYPE KUNNR,

AKONT TYPE AKONT,

END OF IT_KNB1.

DATA:T_KNB1 TYPE STANDARD TABLE OF IT_KNB1,

WA_KNB1 TYPE IT_KNB1.

TYPES: BEGIN OF IT_EKKO,

KUNNR TYPE KUNNR,

AEDAT TYPE ERDAT,

LIFNR TYPE ELIFN,

SPRAS TYPE SPRAS,

END OF IT_EKKO.

DATA: T_EKKO TYPE STANDARD TABLE OF IT_EKKO,

WA_EKKO TYPE IT_EKKO.

DATA:V_BUKRS LIKE KNB1-BUKRS.

SELECT-OPTIONS: S_BUKRS FOR V_BUKRS .

START-OF-SELECTION.

SELECT BUKRS

BUTXT

ORT01

LAND1

WAERS FROM T001 INTO TABLE T_T001

WHERE BUKRS IN S_BUKRS.

LOOP AT T_T001 INTO WA_T001.

WRITE:/ WA_T001-BUKRS,

WA_T001-BUTXT,

WA_T001-ORT01,

WA_T001-LAND1,

WA_T001-WAERS.

HIDE: WA_T001-BUKRS.

WA_T001-BUTXT,

WA_T001-ORT01,

WA_T001-LAND1,

WA_T001-WAERS.

ENDLOOP.

AT LINE-SELECTION.

CASE SY-LSIND .

WHEN 1.

SELECT

BUKRS

KUNNR

AKONT

FROM KNB1 INTO TABLE T_KNB1

WHERE BUKRS = WA_T001-BUKRS.

*ENDCASE.

LOOP AT T_KNB1 INTO WA_KNB1.

WRITE:/

WA_KNB1-BUKRS,

WA_KNB1-KUNNR,

WA_KNB1-AKONT.

HIDE: WA_KNB1-KUNNR.

ENDLOOP.

WHEN 2.

SELECT KUNNR

AEDAT

LIFNR

SPRAS

FROM EKKO INTO CORRESPONDING FIELDS OF TABLE T_EKKO

WHERE KUNNR = WA_KNB1-KUNNR.

LOOP AT T_EKKO INTO WA_EKKO.

WRITE:/ WA_EKKO-KUNNR,

WA_EKKO-AEDAT,

WA_EKKO-LIFNR,

WA_EKKO-SPRAS.

ENDLOOP.

ENDCASE.

Edited by: gundala abhilash on Nov 13, 2008 11:52 AM

Re: HIDE

Former Member — Thu, 13 Nov 2008 10:54:17 GMT

hi,

use AT USER COMMAND

Re: HIDE

Former Member — Thu, 13 Nov 2008 10:57:04 GMT

2ND SEC LIST KUNNR IS NOR WORKING

Re: HIDE

Former Member — Thu, 13 Nov 2008 10:59:28 GMT

see this example

[link1|http://help.sap.com/saphelp_nw70/helpdata/en/9f/dba42335c111d1829f0000e829fbfe/content.htm]

Regards,

Srinivas

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:00:47 GMT

hi,

WHEN 2.

SELECT KUNNR

AEDAT

LIFNR

SPRAS

FROM EKKO INTO CORRESPONDING FIELDS OF TABLE T_EKKO

WHERE KUNNR = WA_KNB1-KUNNR.

and WA_KNB1-KUNNR will get only WHEN 1.

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:03:10 GMT

OH OK..

THEN WHT SHOULD I TAKE IN DE PLACE OF WA_KNB1-KUNNR...???

Re: HIDE

matt — Thu, 13 Nov 2008 11:03:27 GMT

Please do not post in ALL CAPITALS..

Also, surround any abap in tags.

All these things make your posting easier to read, and therefore more likely to be answered.

matt

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:05:33 GMT

Sorry Matt

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:06:02 GMT

if i take wa_ekko-kunnr intead of wa_knb1-kunnr ..its working but how can it be wa_ekko-kunnr when i hide wa_knb1-kunnr

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:08:04 GMT

but i dont know your requirement exactly,

if you want display the list remove where condition from select query.

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:09:29 GMT

Hi,

Move your HIDE statment in the event AT LINE-SELECTION and see. Read the help for this event and your issue should be solved.

regards,

Advait

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:14:38 GMT

Use AT USER-COMMAND event to get the second screen.

after that you should write the thing you have written in "WHEN 2".

See in the "WHEN 1" you are hiding the value of KUNNR and using that value you are retrieving values in the select written in "WHEN 2".

Now if you use AT USER-COMMAND event and write the selection written in "WHEN 2" you will get the second list apropriately.

I guess it will work.

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:16:13 GMT

hi,

if you use wa_ekko-kunnr intead of wa_knb1-kunnr ..its working

but how can it be wa_ekko-kunnr when i hide wa_knb1-kunnr

means wa_ekko-kunnr is intial and in select query if you write this condition you will get data from ekko where kunnr is intial.

Re: HIDE

Former Member — Thu, 13 Nov 2008 11:34:55 GMT

Hi Abhilash,

Your code is correct. I hope you dont have any documents in your system for the KUNNR value in EKKO table. Please check in debug mode. Generally EKKO will have LIFNR as significat role rather than KUNNR.

Thanks,

Vinay