Kontakt

Ansicht
Dokumentation

SMOE_PUBL_SEL - Select all from table SMOHPUBL

SMOE_PUBL_SEL - Select all from table SMOHPUBL

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

Functionality

Selection function module for table SMOHPUBL.

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

  • SMOHPUBL
  • SMOVERS
  • INDUSTRY
  • PUBL_NAME (like)
  • SHORT_NAME (like)
  • BULK_REPL
  • INTERLNK
  • SMOACTV

Example

The current INDUSTRY is 'CG'.

First row:,,IO_SMOHPUBL-SMOHPUBL='A1', IO_SMOHPUBL-SMOVERS='A2'

Second row:,,IO_SMOHPUBL-INDUSTRY='B1', IO_SMOHPUBL-PUBL_NAME='B2', ,,,,,,,,,,IO_SMOHPUBL-DELETED='1'

Resulting where clause looks like:

(smohpubl='A1' and smovers='A2' and industry='CG' and deleted='0') or (industry='B1' and publ_name like 'B2' and deleted='0')

Notes

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

Further information





Parameters

IO_SMOHPUBL
I_DELETED
I_INDUSTRY_INDEPENDENT
I_RETURN_ACTIVE
O_RETURN

Exceptions

Function Group

SMOE_DATABASE_CARE

PERFORM Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 1808 Date: 20240605 Time: 085621     sap01-206 ( 36 ms )