Defining Update Formulas 

Use

Update formulas allow you to control which key figures should be updated depending on the allocations in the table/View V_PMCOCKF in an information structure.

Procedure

  1. Choose the menu bar sequence Logistics Data Warehouse ® Updating ® Updating Definition ® Specific Definition Using Update Rules ® Maintain formulas in the Customizing function of the Logistics Information System.
  2. Choose Plant Maintenance.
  3. Enter in the screen Maintain: On the screen Maintain: INST formulas enter the formula routine number and long text and save the data.
  4. You require the source text for a precise definition of the field assignments. In order to do this, copy the ABAP program as follows:

If you want to maintain formulas

Position the cursor

for a value/cost key figure

on formula routine 1

for a quantity / key figure in time

on formula routine 2

 

  1. Choose Source text. This will bring you to the ABAP program for the reference formula in the ABAP editor.
  2. Position the cursor in the second line of the column with line numbers and overwrite the line number with ww.
  3. Finally, scroll to the last but one line and again position the cursor in the column with line numbers. Overwrite the line number with ww.

    4. Leave the screen using the symbol Return.

  4. Position the cursor on the line containing the formula that you want to define and choose Source text.

    5. This brings you to the ABAP editor.

  5. Copy the ABAP program using the reference formula by placing the cursor in the column with the line numbers and enter w.

    6. Choose Continue.

  6. Overwrite the entries from the copy model by entering the name of the key figure from V_PMCOCKF (for example ZZGoodwill).

You replace the following entries by doing this:

COSTKEY01

in the case of a formula for a value or cost key figure which was created as a copy of the reference formula 1.

HOURKEY01

in the case of a formula for a quantity or key figure in time which was created as a copy of the reference formula 2.
  1. Choose the menu bar sequence Program ® Activate

    2. and return to the formula overview screen.

  2. To complete the editing process, position the cursor in the line containing the formula just defined and choose the menu bar sequence Edit ® Activate.