topic Exclude one field from Logical Database's dynamic selection screen in Application Development and Automation Discussions

Exclude one field from Logical Database's dynamic selection screen

Former Member — Fri, 07 Nov 2008 07:59:55 GMT

Hi Guru,

I have a requirement to amend a program to exclude the document number field (bsik-belnr) from the dynamic selection-screen of the logical database KDF(Vendor Database) so that the program will not filter according to the document number.

I have use the below syntax in my zprogram.

selection-screen exclude select-options: doc-no.

However I get syntax error "The addition EXCLUDE is only allowed in INCLUDE DBKDFSEL".

Please advice.

Best Regards,

Fung

Re: Exclude one field from Logical Database's dynamic selection screen

Former Member — Fri, 07 Nov 2008 08:35:35 GMT

Hi Fung,

You need to use the Statement EXCLUDE in the below manner.

SELECTION-SCREEN BEGIN OF VERSION vers text.

...

SELECTION-SCREEN EXCLUDE {PARAMETERS para}

| {SELECT-OPTIONS selcrit}

| {RADIOBUTTON GROUPS radi}

| {BLOCKS block}

| {IDS id}.

...

SELECTION-SCREEN END OF VERSION vers.

These statements define a version vers of the standard selection screen for the logical database.

You must specify a positive figure a maximum of three characters in length for vers, and for text,

a text symbol from the database program in the form text-###, where ### represents the three-character

ID of the text symbol. You can only make SELECTION-SCREEN statements that have EXCLUDE additions, and these only within the first and last statements.

I think you are getting that error because you have not done it this way.

Regards,

Amit.

Re: Exclude one field from Logical Database's dynamic selection screen

Former Member — Fri, 07 Nov 2008 09:09:37 GMT

Hi Amit,

Thanks for your reply.

However, can u advice step by step how can I locate the selection screen version from the logical database? How can I know the doc-no field is from which version? In this Include program DBKDFSEL(for Logical DB KDF), I find part of code as shown below:

selection-screen begin of version 900 text-900.

selection-screen exclude select-options: kd_augdt.

selection-screen end of version 900.

But this is not the field that I want to exclude. I need to exclude bsik-belnr field from the dynamic selection screen. Where can I find the selection technical name for this document number field(bsik-belnr)?

Kindly advice.

Best Regards,

Fung

Re: Exclude one field from Logical Database's dynamic selection screen

Former Member — Fri, 07 Nov 2008 09:29:57 GMT

The selection part of the logical database defines input fields for selecting data.

The runtime environment displays these on the selection screen when you run an executable program linked to the logical database.

Include called DB<ldbname>SEL.

SELECTION-SCREEN BEGIN OF VERSION ver TEXT-xxx.

SELECTION-SCREEN EXCLUDE ... .

.......................

SELECTION-SCREEN END OF VERSION ver.

Defines a selection screen version (with a three-character name ver ). Between BEGIN OF VERSION and END OF VERSION , you can exclude selection screen objects for the version ver , i.e. remove them from the selection screen with SELECTION-SCREEN EXCLUDE.

SELECTION-SCREEN DYNAMIC SELECTIONS FOR TABLE dbtab

If one of these tables is active in the report (i.e. it is declared under TABLES or lies somewhere on the path from the root of the database hierarchy to a table declared with TABLES ), a pushbutton called 'Dynamic selections' appears on the selection screen.