Kontakt

Ansicht
Dokumentation

SMOE_SMOESUBSIT_SEL - Select all from table SMOHSUBSIT

SMOE_SMOESUBSIT_SEL - Select all from table SMOHSUBSIT

General Data in Customer Master   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

Selection function module for table SMOHSUBSIT.

The function module generates dynamically a where clause. Within one row of the internal table IO_SMOHSUBSIT 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:

  • SMOHSUBSIT
  • SMOHSUBSCR
  • SMOHPUBL
  • SITE_ID
  • ACTIVE
  • ACTDEL

Example

First row:,,IO_SMOHSUBSIT-SMOHPUBL='A1', IO_SMOHSUBSIT-SITE_ID='A2'

Second row:,,IO_SMOHSUBSIT-ACTIVE='T', IO_SMOHSUBSIT-ACTDEL='F', ,,,,,,,,,,IO_SMOHSUBSIT-DELETED='1'

Resulting where clause looks like:

(smohpubl='A1' and site_id='A2' and deleted='0') or (active='T' and actdel='F' and deleted='0')

Notes

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

Further information





Parameters

IO_SMOESUBSIT
I_CLIENT_SPECIFIED
O_RETURN

Exceptions

Function Group

SMOE_INDIRECTION

General Material Data   General Material Data  
This documentation is copyright by SAP AG.

Length: 1513 Date: 20240523 Time: 111046     sap01-206 ( 24 ms )