AL

[Former Member]

HI GURUS

PLZ GIVE ME SAMPLE EXAM FOR PROVIDING DYNAMIC SEARCH HELP

[Former Member]

Hi babu,

Go thro this link. hope it helps u.

http://help.sap.com/saphelp_47x200/helpdata/en/67/93b80f14a911d2953c0000e8353423/frameset.htm

Regards...

Arun.

Reward points if useful.

[Former Member]

HI Babu,

Check this Example.

----

---

• Include DBTEST_LDBSEL

• It will be automatically included into the database program

----

---

• If the source is automatically generated,

• please perform the following steps:

• 1. Replace ? by suitable names (at most 8 characters).

• 2. Activate SELECT-OPTIONS and PARAMETERS (delete stars).

• 3. Save source code.

• 4. Edit database program.

*

• Hint: Syntax-Check is not possible within this Include!

• It will be checked during syntax-check of database program.

----

---

• SELECT-OPTIONS : ? FOR LFA1-LIFNR.

• Parameter for search pattern selection (Type SY-LDB_SP):

• PARAMETERS p_sp AS SEARCH PATTERN FOR TABLE LFA1.

• SELECT-OPTIONS :

• ? FOR LFB1-LIFNR,

• ? FOR LFB1-BUKRS.

• SELECT-OPTIONS :

• ? FOR LFC1-LIFNR,

• ? FOR LFC1-BUKRS,

• ? FOR LFC1-GJAHR.

• SELECT-OPTIONS :

• ? FOR BKPF-BUKRS,

• ? FOR BKPF-BELNR,

• ? FOR BKPF-GJAHR.

• Enable DYNAMIC SELECTIONS for selected nodes :

• Enable FIELD SELECTION for selected nodes :

If the nodes LFA1 and LFB1 are defined for dynamic selections, and node LFC1 is defined for field selections, the following lines of code will also be generated:

SELECTION-SCREEN DYNAMIC SELECTIONS FOR TABLE LFA1.

SELECTION-SCREEN DYNAMIC SELECTIONS FOR TABLE LFB1.

SELECTION-SCREEN FIELD SELECTION FOR TABLE LFC1.

The automatically-created selection include could be modified as follows:

• Selection criteria:

SELECT-OPTIONS SLIFNR FOR LFA1-LIFNR.

SELECT-OPTIONS SBUKRS FOR LFB1-BUKRS.

SELECT-OPTIONS SGJAHR FOR LFC1-GJAHR.

SELECT-OPTIONS SBELNR FOR BKPF-BELNR.

• Self-defined parameters:

PARAMETERS PSTIDA LIKE SY-DATUM FOR NODE BKPF.

• Dynamic selections for LFA1 und LFB1:

SELECTION-SCREEN DYNAMIC SELECTIONS FOR NODEE: LFA1, LFB1.

• Field selection for LFB1 and LFC1:

SELECTION-SCREEN FIELD SELECTION FOR NODE: LFB1, LFC1.

Here, selections are chosen from the available selection criteria and are given names. An additional parameter PSTIDA is declared and linked to the node BKPF. Dynamic selections are defined for the tables LFA1 and LFB1. Field selections are defined for tables LFB1 and LFC1.

Regards,

Ameer Baba.

[seshatalpasai_madala]

Hi,

Check Where-used-list for Fm's F4IF_INT_TABLE_VALUE_REQUEST

and F4IF_FIELD_VALUE_REQUEST.

These function modules are used for providing Value helps.

Regards,

Sesh