Getting results from LDB (Logical Database)

[Former Member]

Hi All,

I have a requirement where i need to pass LDB results to external application. It can be any LDB. Like in SE36 we put the LDB name and execute and final results are shown in ALV. I dont need it to display in ALV but from my custom program, need that output table which stores these results.

I tried using LDB_PROCESS but that need custom subroutine names to pass in that, i tried passing the same and results also came but thing is every logical database will have different tables in that, it'll be impossible to create those many subroutine to handle each and every table. So i need a generalized solution like se36 processes the data for any LDB.

Is anyone knows how can i achieve this?

Regards

Munish Garg

9041793217

[Former Member]

Hi All,

I have a requirement where i need to pass LDB results to external application. It can be any LDB. Like in SE36 we put the LDB name and execute and final results are shown in ALV. I dont need it to display in ALV but from my custom program, need that output table which stores these results.

I tried using LDB_PROCESS but that need custom subroutine names to pass in that, i tried passing the same and results also came but thing is every logical database will have different tables in that, it'll be impossible to create those many subroutine to handle each and every table. So i need a generalized solution like se36 processes the data for any LDB.

Is anyone knows how can i achieve this?

Regards

Munish Garg

9041793217

[Former Member]

Hi,

To which application you want to pass the data ?

Do you want to export data executing a program in SAP ? or you want to access data from SAP when your (external) application runs ?.

Regards

Bikas

[Former Member]

Hi Bikas,

It can be either way....we have an external application, if it can access the results directly through any RFC then it is the best otherwise i need to fetch data within SAP and then pass it on.

Problem is how to get the results of LDB?

Regards

Munish Garg

[Former Member]

Hello

Generally any LDB will have a event which triggers the data to be populated in the tables/memory. Now these data retrieval is written in a sub-routine "Perform PUT_<eventnamt>". So any LDB will have the sub-routine named "PUT_<eventname>" in its main program. May be you can create the sub-routine name dynamically using this method.

Regards

Ranganath

[Former Member]

I can see the PUT_<tabname> is some cases but not all.....

Also it gives record one by one and also in sequence of tables in LDB.

Problem is to get consolidated output value table.......

[Former Member]

problem solved by creating a dynamic program and using GET statements and Field groups in that and later submit tht dynamic program in my original program.