HIDE

[Former Member]

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

[Former Member]

hi,

use AT USER COMMAND

[Former Member]

2ND SEC LIST KUNNR IS NOR WORKING

[Former Member]

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.

[Former Member]

OH OK..

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

[matt]

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

[Former Member]

Sorry Matt

[Former Member]

but i dont know your requirement exactly,

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

[Former Member]

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.

[Former Member]

see this example

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

Regards,

Srinivas

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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