Ansicht
Dokumentation

OIJW_UPDATE_WL_NOM_DBTABLES - OIL-TSW: Update Nomination related DB tables for the WL entries.

ABAP Short Reference   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Functionality

This module uses data in internal tables to update OIJWL, OIJNOMH, OIJNOMI, OIJNOMHWL, OIJNOMIWL, and OIJRDNOM database tables.

PARAMETERS:

All the tables here have a field called "upd_flag" that can have any of the following four values:

I,,- Record will be inserted

M,,- Record will be modified

D,,- Record will be deleted

space- Don't touch the record.

T_OIJWL_TAB - Contains worklist entries (all I, M, D, space).

T_NOMH_TAB - Contains oijnomh records to be updated (M) and others (space)

T_NOMI_TAB - Contains OIJNOMI records to be updated (M) and others (space)

T_NOMHWL_TAB - Contains OIJNOMHWL records (I,D, space)

T_NOMIWL_TAB - Contains OIJNOMIWL records (I,D, space)

T_RDNOM_TAB - Contains OIJNOMIWL records (M)

Exceptions:

DB_ACCESS_ERROR - not caught

The function module carries out the following procedure.

First, it deletes all entries from the above internal tables that have the upd_flag set to space. Database records corresponding to these do not need updating. Then it calls a series of forms that will perform the updates, one for each table.Within these forms, wherever possible, the function module attempts to update from internal tables into the database tables all at once.

Form update_oijwl

Here, before carrying out a delete, update, or insert, the form separates the records marked "D", "M", and "I" respectively into separate internal tables. The form then issues SQL commands to update, delete, and insert from the respective internal tables. These may fail .

Form update_oijnomhwl

This form is the same as that for update_oijwl above, but OIJNOMHWL records are not updated.

Form update_oijnomiwl

This form is the same as that for update_oijwl above, but OIJNOMIWL records are not updated.

Form update_oijrdnom

This form is the same as that for update_oijwl above but it only updates any OIJRDNOM records and does not insert or delete.

Form update_oijnomh

The internal table corresponding to OIJNOMH does not have all the fields of the table. So, to update the records in OIJNOMH, the system sets individual field values (namely, WORKLIST, AENAM, AEDAT, and AEZEIT). To do these updates all at once, the system uses ranges from tables loaded with key-value NOMTK of OINOMH. Only two such tables are needed because the worklist field can have only two states, either on or off, and the other three fields have the same value in either case.

Form update_oijnomi

In this form, we perform inline updates to the database, setting the worklist field to ON or OFF depending upon the value in the internal table field.

The form loops over the internal table containing all the records to be updated, iand f the worklist indicator is ON, it updates the database record with this value. Otherwise, it updates the record with the indicator set as OFF.

Example

Notes

Further information

Parameters

I_PRINT
T_NOMHWL_TAB
T_NOMH_TAB
T_NOMIWL_TAB
T_NOMI_TAB
T_OIJWL_TAB
T_RDNOM_TAB

Exceptions

DB_ACCESS_ERROR

Function Group

OIJW

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

Length: 3761 Date: 20240523 Time: 133231     sap01-206 ( 71 ms )