topic Re: Editing Logical Database in Application Development and Automation Discussions

Editing Logical Database

Former Member — Tue, 29 May 2007 02:59:12 GMT

Hi Experts,

I need to add a new select-option in an already existing LDB. I was able to add the new select-option but I cannot add the selection text. I go to SE36 and select Selection Text then click Change. But it does not allow to add a new selection text.

Points will be rewarded ASAP!

Thanks

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:10:23 GMT

why don't copy into Z logical database and use Z logical databse in report program,

if it is z logical database then you can add ur own text and own select-options.

do not modify sap standard Logical database and this LDB is applicable to so many sap standard programs.

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:21:32 GMT

that is what i did, but i can't still add a selection text

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:26:04 GMT

I am not at system but i hope you could add in sldb transaction ,

goto sldb transaction and use ur ldb name and select selection text and come to change mode,

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:40:23 GMT

Its same as SE36.. but there still no luck.. i don't know whats the problem. I tried creating a LDB from scratch and i was able to add with no problem.

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:42:59 GMT

try this..


TABLES: pernr.

data: i_tab type standard table of RSSELTEXTS with header line.

initialization.

i_tab-name = 'PNPPERNR'.
i_tab-kind = 'S'.
i_tab-text = 'Employee ID'.
append i_tab.

CALL FUNCTION 'SELECTION_TEXTS_MODIFY'
EXPORTING
program = 'ZESO_TEST'
tables
seltexts = i_tab
* EXCEPTIONS
* PROGRAM_NOT_FOUND = 1
* PROGRAM_CANNOT_BE_GENERATED = 2
* OTHERS = 3
.
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:46:32 GMT

That was a nice FM but that was not really what I wanted.. I solved the problem by regenerating the database program Thanks a lot

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:48:37 GMT

but i wonder how did u change the selection texts by regenerating the database program??????????????

Re: Editing Logical Database

Former Member — Tue, 29 May 2007 03:56:29 GMT

Here what i did:

1. Added the additional select-option in Selection.

2. Regenerate the database program

3. Added texts to the new select-option.

and it worked!