Displaying data fetched from database

[Former Member]

Hi Experts,

I am having a BAPI (fetches the data from datbase) has to be connected with the WebDynpro.And the data has to be displayed as a tree but in a table.Please tell me how to do that.Requires immediate response.

Regards

Nutan

[Former Member]

HI Nutan,

For backend access u can use these

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-tec...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d352a790-0201-0010-5082-b1a...

for creating tree structure in a table, check this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-tec...

for sample application check here

https://www.sdn.sap.com/irj/sdn/webdynpro?rid=/library/uuid/49f2ea90-0201-0010-ce8e-de18b94aee2d#31

regards

Sumit

[Former Member]

Hi Sumit,

Your reply has helped me a lot. But my requirement is like this:

1.> Fetch data from backend.

2.> Display data dynamically as a tree in a table.

3.> Table will have a check box also for each row.After selecting the check box and submitting it.Automatic folder creation should happen in KM.

I have achieved till now:

1.> Integration of tree structure in a table.But that was static means tree structure was pre-defined.

2.> Fetching data from backend using BAPI and displaying on a table.

Please help. Urgent requirment.

Regards,

Nutan

[Former Member]

Hi Experts,

Please help me to get the data.I have followed the same process to access the database but no output i am getting.But the method created in custome controller is called and message is also displayed.But no error it is showing.Please tell me where i am wrong.

Regards

Nutan

[Former Member]

Hi Nutan,

follow these steps:

1.Create a new WD Project.

2. Right click on models and select create model.

3. Select import Adaptive RFC Model.

3. Give any name and package to your model.

select WD_MODELDATA_DEST/or if you have defined any other name for

your JCo destination for default logical system name for model instances.

select WD_RFC_METADATA_DEST /or if you have defined any other

name for your JCo destination for default logical system name for RFC

metadata.

4. Select single server/Load Balancing as per your system.

Give name, system number, client, logon name, password and language of

your R/3 system.

5. Search for the BAPI name and select the BAPI on search and click NEXT.

You have imported RFC Model by this time.

Now create a WD component and then you will find Used Models. Select the name of the model just created above.

6. Open Data Modeler(Right Click on your component name and select Open Data Modeler). Do mapping here from model to controller and from controller to view as per your requirement.

7. To execute BAPI create an element of the input node of your BAPI, set any parameters if required and bind it again to the input node.

say if name of your input node is input

IPrivate<viewname>.IinputElement element = wdContext.nodeInput().createInputElement();

element.set<parametername>("<value>");

wdContext.nodeInput().bind(element);

8. Last step is to execute BAPI

try

{

wdContext.currentInputElement().modelObject().execute();

//say name of your output node is output

wdContext.nodeOutput().invalidate();

}

Bind your output node the one that is found inside the input node to table or other UI element so that you can see the result of the BAPI after its execution.

Hope, this helps you. I haven't mentioned the steps for creation of JCO destinations with an assumption that you might have created them

Warm Regards,

Murtuza