On lead selection for node inside node showing empty table

Hi all,

I am a novice .Please solve my problem . i have created a node inside a node in view context

context

L EKKO (Cardinality : 0..n , selection 0..1)

. L EKPO (Cardinality : 0..n , selection 0..1 )

. @ EBELN

. @ EBELP

. @ MATNR

.@EBELN

@BUKRS

@LIFNR

@--indicates attributes

In WDDOINIT i have written the following code :

*************************************************************************************************************************************************

""""""""""CODE FOR EKKO
DATA LO_ND_EKKO TYPE REF TO IF_WD_CONTEXT_NODE.

DATA LS_EKKO TYPE WD_THIS->ELEMENT_EKKO.
DATA LT_EKKO TYPE WD_THIS->ELEMENTS_EKKO.

* navigate from <CONTEXT> to <EKKO> via lead selection
LO_ND_EKKO = WD_CONTEXT->GET_CHILD_NODE( NAME = WD_THIS->WDCTX_EKKO ).

SELECT EBELN BUKRS AEDAT lifnr FROM EKKO
INTO CORRESPONDING FIELDS OF TABLE LT_EKKO UP TO 100 ROWS
WHERE EBELN LIKE '45000174%'.

SORT LT_EKKO BY EBELN.

LO_ND_EKKO->BIND_TABLE( NEW_ITEMS = LT_EKKO SET_INITIAL_ELEMENTS = ABAP_FALSE ).

"""""""""""CODE FOR EKPO
DATA LO_ND_EKPO TYPE REF TO IF_WD_CONTEXT_NODE.

DATA LS_EKPO TYPE WD_THIS->ELEMENT_EKPO.
DATA LT_EKPO TYPE WD_THIS->ELEMENTS_EKPO.
DATA LT_EKPOI TYPE IF_VIE1=>ELEMENTS_EKPO.

* navigate from <CONTEXT> to <EKPO> via lead selection
LO_ND_EKPO = WD_CONTEXT->PATH_GET_NODE( PATH = `EKKO.EKPO` ).

SELECT EBELN EBELP AEDAT MATNR BUKRS MENGE MEINS NETPR
INTO TABLE LT_EKPO FROM EKPO FOR ALL ENTRIES IN LT_EKKO
WHERE EBELN = LT_EKKO-EBELN.

SORT LT_EKPO BY EBELN EBELP.

LO_ND_EKPO->BIND_TABLE( NEW_ITEMS = LT_EKPO SET_INITIAL_ELEMENTS = ABAP_FALSE ).

******************************************************************************************************************************************

In ONLEADSELECTION EVENT

******************************************************************************************************************************************

DATA LO_ND_EKKO TYPE REF TO IF_WD_CONTEXT_NODE.
DATA LO_EL_EKKO TYPE REF TO IF_WD_CONTEXT_ELEMENT.
DATA LS_EKKO TYPE WD_THIS->ELEMENT_EKKO.

* navigate from <CONTEXT> to <EKKO> via lead selection
LO_ND_EKKO = WD_CONTEXT->GET_CHILD_NODE( NAME = WD_THIS->WDCTX_EKKO ).

* get element via lead selection
LO_EL_EKKO = LO_ND_EKKO->GET_ELEMENT( ).

* get all declared attributes
LO_EL_EKKO->GET_STATIC_ATTRIBUTES(
IMPORTING
STATIC_ATTRIBUTES = LS_EKKO ).
"""""""""FOR EKPO
DATA LO_ND_EKPO TYPE REF TO IF_WD_CONTEXT_NODE.

DATA LT_EKPOL TYPE WD_THIS->ELEMENTS_EKPO.

DATA LT_EKPO TYPE WD_THIS->ELEMENTS_EKPO.

DATA LS_EKPO TYPE WD_THIS->ELEMENT_EKPO.

* navigate from <CONTEXT> to <EKPO> via lead selection
LO_ND_EKPO = WD_CONTEXT->PATH_GET_NODE( PATH = `EKKO.EKPO` ).

LO_ND_EKPO->GET_STATIC_ATTRIBUTES_TABLE( IMPORTING TABLE = LT_EKPO ).

LOOP AT LT_EKPO INTO LS_EKPO WHERE EBELN = LS_EKKO-EBELN.

APPEND LS_EKPO TO LT_EKPOL.

ENDLOOP.

* navigate from <CONTEXT> to <EKPO> via lead selection
LO_ND_EKPO = WD_CONTEXT->PATH_GET_NODE( PATH = `EKKO.EKPO` ).

LO_ND_EKPO->BIND_TABLE( NEW_ITEMS = LT_EKPOL SET_INITIAL_ELEMENTS = ABAP_FALSE ).

CLEAR LT_EKPO.

*************************************************************************************************************************************

in the output i wanted to display two tables EKKO and EKPO .If i select one record in ekko i should get its corresponding items data in ekpo.

But when the output is displayed its showing both ekko data and all the records in ekpo irrespective of the lead selection.when

selecting any other row in ekko using the lead selection it is showing empty ekpo table.

condition : i wanted to fetch the data from database using select only in wddoinit of view (not involving component controller context )

and use that data to populate ekpo table in lead selection and also the context nodes should be node inside node.

Debugging: i found that in the leadselection action get static attributes is not fetching any data (i.e., LT_EKPO is empty ).

For more details see the attached screen shots

Please help.