Comments
SAP LDB SELECTIONS EXAMPLE documentation, setup help and example usage
ARTICLE
Example of a Selection Include
A logical database TEST_LDB has the structure shown in Example of a Logical Database . The generated proposal for the selection include is then as follows:
* 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:
* 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 the node LFC1 defined for field selections, the following additional program lines are generated:
SELECTION-SCREEN DYNAMIC SELECTIONS FOR TABLE LFB1.
SELECTION-SCREEN FIELD SELECTION FOR TABLE LFC1.
This automatically generated selection include can be complete, for example, as follows:
SELECT-OPTIONS slifnr FOR lfa1-lifnr.
SELECT-OPTIONS sbukrs FOR lfb1-bukrs.
SELECT-OPTIONS sgjahr FOR flc1-gjahr.
SELECT-OPTIONS sbelnr FOR bkpf-belnr.
* Self-defined parameters:
PARAMETERS pstida LIKE sy-datum FOR NODE bkpf.
* Dynamic selections for LFA1 and LFB1:
SELECTION-SCREEN DYNAMIC SELECTIONS FOR NODE: lfa1, lfb1.
* Field selection for LFB1 and LFC1:
SELECTION-SCREEN FIELD SELECTION FOR NODE: lfb1, lfc1.
A selection is made from the available selection criteria and is given a name. The additional parameter pstida is declared and associated with the node BKPF . Dynamic selections are defined for the tables
LFA1 and LFB1 . The tables LFB1 and LFC1 are defined for field selections.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved
