topic Re: LDB doubt in Application Development and Automation Discussions

LDB doubt

Former Member — Thu, 01 Mar 2007 09:02:45 GMT

REPORT yjsample4 .

tables : bsik, t001.

START-OF-SELECTION.

GET BSIK.

IF bsik IS NOT INITIAL.

APPEND bsik TO g_t_bsik.

ENDIF.

END-OF-SELECTION.

SELECT * FROM bsik INTO TABLE g_t_bsik1 WHERE lifnr IN kd_lifnr.

LOOP AT g_t_bsik.

cnt = cnt + 1.

WRITE:/ cnt, g_t_bsik-bukrs, g_t_bsik-belnr.

ENDLOOP.

In above program attributes please assign LDB name as KDF and keep break point at REPORT yjsample4 . If we go through debugging mode it is going into three function modules and doing some validations and giving the records in output. which are not same if we select the same from SELECT * FROM bsik INTO TABLE g_t_bsik1 WHERE lifnr IN kd_lifnr.

Can any body help me. What is happennig? I need to remove LDB(Avoiding LDB usage) and need to replace with SELECT statement...

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 09:15:21 GMT

KDF is Vendor Database.

Note

The report SAPDBKDF controls access to the vendor data base from a Financial Accounting point of view. Since the program only contains physical accesss routines for the logical data base, it cannot be started separately.

Technical documentation

In the standard system, a basic selection screen (screen number 1000) and 4 screen variants are delivered for the logical data base SAPDBKDF. The basic selection screen contains all available data base selections. If you make changes to data base selections (for example, defining a new selection parameter or extending the vendor number to 10 characters), then this screen is regenerated automatically by the system. It can then be used immediately by all reports that use the logical data base DDF. Screen variants are available in reporting by entering the screen number in the attributes.

Available fields

The available fields on a screen are indicated with an 'X'.

Selection screen variant

Field name 1000 900 901 902 903

Vendor number X X X X X

Company code X X X X X

Fiscal year X X X X

Key date of OIs X X

Clearing date X X

Table selection

In order to improve performance, individual tables can be excluded from selection. The following fields can be set in the application report at the time of INITIALIZATION or at the START OF SELECTION:

B0SG-XAGSL (blank as a default): if this field is set, then only A and B segments are read; in this case, only A segments for which there are no B segments are selected - this is normally not the case.

B0SG-XBNKL ('X' as a default): if this field is left blank, then the bank data is not read.

B0SG-XSTDL ('X' as a default): if this field is left blank, then the tax data is not read.

B0SG-XMNDL ('X' as a default): if this field is left blank, then the dunning data is not read.

Authorization checks

account type authorization (F_BKPF_KOA)

company code authorization (F_LFA1_BUK, F_BKPF_BUK)

account authorization (F_LFA1_BEK)

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 10:49:10 GMT

Harsha Thanks for your Response,

Is it possble to remove LDB from program or Not? Can I code same functionality in the program it-self or not? If possible please let me know the same How?

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 10:51:00 GMT

If you want to remove the LDB, go to the ATTIBUTES section of the program, remove the LDB name and save it.

Activate the program.

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 11:11:39 GMT

Hello Ravi kanth,

It is not a problem. I need to replace the same functionality with coding..Please run given program in debugging by keeping break point at REPORT. You can find out what functionality it is doing...

Re: LDB doubt

suresh_datti — Thu, 01 Mar 2007 11:15:18 GMT

there is function module 'LDB_PROCESS" or something like that which will let you use the LDB fucntionality without having to tie it in the Attributes. Di you try that?

~Suresh

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 11:20:55 GMT

HI Sekhar,

Please remove the logical database and replace it with directly using code for select statement.You have only 2 tables to access t001 and bsik.

The most common use of logical databases is to read data from database tables and linking them to executable ABAP programs .Since U have only one table to select U can defenitly remove that.

Regards

Avi..

Re: LDB doubt

Former Member — Thu, 01 Mar 2007 13:01:31 GMT

Hi Avi,

Yes i can replace GET BSIK with SELECT stament, but it is giving different values. You are saying to use BSIK and T001 tables. But how?

If you go with debugging as i mentioned above..it is going into 3 Function modules.

INIT_T001

READ_T001

DOCUMENT_DUE_DATE.

Even i could not understand from where it going into those FMs.

If i can understand this i can replace GET BSIK with SELECT statement..