Removing logical database use from a report

[Former Member]

Hello Experts,

There is a custom report that uses logical database DDF.

Please let me know how I can reconstruct this report such that it does not use logical db.

The GET KNA1... statements need to be replaced with custom select Queries.

Please let me know how GET works and how I can replace it with SELECT.

Thank You.

Regards,

Sraddha.

[Former Member]

Hello Experts,

There is a custom report that uses logical database DDF.

Please let me know how I can reconstruct this report such that it does not use logical db.

The GET KNA1... statements need to be replaced with custom select Queries.

Please let me know how GET works and how I can replace it with SELECT.

Thank You.

Regards,

Sraddha.

[Former Member]

Hi Sraddha,

kindly follow below steps in achieving you requirements.

1. Analyse where all the data fetched using logical db is being used.

2. Declare the internal table containing the required fields.

3. Fetch the data from the KNA1 table using the SELECT statement.

4. Read the internal table containing the data fetched where ever necessary.

Thanks & Regards,

Venugopal M N

[Former Member]

Hi Sai,

To understand logical database and its funtionality, I would suggest you to do some reading. PFB some references.

http://help.sap.com/saphelp_46c/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm

http://scn.sap.com/message/1036644

Basically, LDB provides some good features like

1) a pre-defined selection screen which handles all user inputs and validations

2)  pre defined set of data based upon the user selection.

thus, we need not worry about from which tables to fetch data. Direct GET command fetches the required data.

Now to recreate the program w/o LDB, you will have to understand current program logic thoroughly and see which tables are being used and how the data is fetched/manipulated from tables. You will have to then build a logic wherein you will write the select statements such that you get exactly the same data set that was being provided by the LDB. and then rest of the functionality can remain same as previous, to achieve the desired output. Also you will have to check for the validations/authorizations part if you remove the LDB.

hope this helps you in some way.

Regards,

Deepak.

[Former Member]

Hi Sai,

To remove LDB from a Cust. Report

Go to se38

Give the Prog name .

Click on Attributes , Select Change Mode ,

A Sub screen will be displayed ,from that go to Logical database tab .

if u don't want to call LDB , Remove the name of LDB.

Thanks  & Regards ,

G.Kranthi

[RaymondGiuseppi]

Call transaction SE36 and analyze the logical database structure AND code, code must be analyzed for structure nodes not directly read from database. (*)

Then build your own selection-screen and access to database, copy required code, and remove ldb from program attributes.

Regards,

Raymond

(*) and for some tables, e.g.  BSID is defined, but BSAD MUST be read too.