Kontakt

Ansicht
Dokumentation

SMOE_SUBSCR_SEL - Select all from tables SMOHSUBSCR

SMOE_SUBSCR_SEL - Select all from tables SMOHSUBSCR

Fill RESBD Structure from EBP Component Structure   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

Selection function module for table SMOHSUBSCR.

The function module generates dynamically a where clause. Within one row of the internal table IO_SMOHSUBSCR the filled values of the fields are concatenated by a 'and'; the several rows are concatenated by a 'or'. The function module selects automatically only for the records which are not deleted (DELETED='0').

Supported fields for selection are:

  • SMOHSUBSCR
  • SMOHPUBL
  • SUBSCRNAME (like)
  • ACTIVE
  • TEMPLATE

Example

First row:,,IO_SMOHSUBSCR-SMOHPUBL='A1', IO_SMOHSUBSCR-SUBSCRNAME='A2'

Second row:,,IO_SMOHSUBSCR-ACTIVE='B1', IO_SMOHSUBSCR-TEMPLATE='B2', ,,,,,,,,,,IO_SMOHSUBSCR-DELETED='1'

Resulting where clause looks like:

(smohpubl='A1' and subscrname like 'A2' and deleted='0') or (active='B1' and template='B2' and deleted='0')

Notes

Be careful that only records are returned which are not deleted (see example).

Further information





Parameters

IO_SMOHSUBSCR
I_CLIENT_SPECIFIED
I_INDUSTRY_DEPENDENT
O_RETURN

Exceptions

Function Group

SMOE_DATABASE_CARE

Vendor Master (General Section)   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 1617 Date: 20240523 Time: 095827     sap01-206 ( 26 ms )