Ansicht
Dokumentation

J_1GVL_VL - Material Valuation

ROGBILLS - Synchronize billing plans   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Description

This program reads the 'online material book table' or 'material ladger' table J_1GVL_ML (henceforth AML) and valuates materials. The movements of valuated materials in table J_1GVL_ML are updated using the valuation prices. The valuation procedure is based on filling internal tables according to the transaction category field TRACT. These internal tables are in turn used by the valuation routines.

Special transaction categories

The following transaction categories have special meaning and should be used only as described here. Other transaction categories can be freely defined but the program must be edited if they are to be assigned a special meaning (see 'enhancements' below!):

PU: purchasing account FI postings. Fills tables TBL_PURCH (per purchase order item) and TBL_PU (summarized per material).

GR: goods receipts and invoice verification in purchasing. Fills TBL_PURCH (per purchase order item) and TBL_GR (summarized per material).

PD: production against order. Fills TBL_PROD.

CP: consumption to production. Fills TBL_ANALP with relation between consumed and produced material.

FS: fason expenses. Fills TBL_COST.

PF: fason production. Fills both TBL_COST and TBL_PROD

OI: other imports whioch carry their own value as input to the valuation equation. Fills TBL_OIDT.

RV: revenue. Fills TBL_REV. Not used by valuation, but used from program that effects the A/L postings.

SA: consumption towards assemply method 1 (treat disassemply as reverse assemply). Fills table TBL_ANALS.

AP: production from disassemply-method 1. Treat as SA.

SP: production from assemply-method 1. Fills TBL_OIDT (per material and TRACT).

AA: consumption towards disassemply-method 1. Treat as reverse assemply, thus same as SP.

OA: consumption to assemply-method 2, same as SA.

OD: consumption to disassemply-method 2 (treat materials resulting from disassemply as products): fills TBL_ANALS but reduces the quantity of the disassempled material according to the quantity and value of the co-products. Method 2 will require cyclic valuation if both assemply and disassemply occurs within same valuation period.

IA: in from assemply-method 2, same as SP

ID: in from disassemply-method 2, same as IA. All that are marked as consumptions fill tables TBL_ANAL (per material) and TBL_CANAL (per TRACT as well).

DT: stock in transit. Irrelevant for valuation, but fills TBL_CANAL with two lines, one with quantity = VLTR_QS and tract = 'TR', and one with tract = 'DI' and opposite quantity.

T2: incoming transfer with value at source plant. Fills TBL_INTR.

Valuation Assumptions

All valuation methods solve the equation IS + PU + PD + OI = RM + CO, where:

• IS = initial stock

• PU = purchases (including GR/IR)

• PD = production costs including direct material cost (PC) plus all forms of expenses

• OI = other imports, by definition = movements that carry 'own' value other than purchases or production

• RM = remaining stock

• CO = all other movements that aquire value through the valuation process, such as:

• cost of goods sold

• consumption to production

• physical inventory movements

It has to be stressed, that in the case of multiple phase production the cost of components (PC) for a semifinished material produced in phase i, for example, is defined as the sum of the product: "Quantity consumed to production x Consumption price of consumed material" over all these components. Note that consumption price by construction implicitly includes production costs for lower production phases ( <= i - 1 ).

It is also noted that when valuating materials, the rule of 'selecting the minimum price between historic cost and current replacement cost' is not applied directly. Rather, there is an option to modify the RM stock prices according to this rule AFTER the valuation program has run (preferably at the year end closing). With this method the consumption price is not affected and therefore price changes according to 'selecting the minimum' rule do not have to 'propagate' upward the production chain. The resulting deviations from the valuation equation are displayed in the Warehouse book saparately.

Only WMA and WMAPL valuation methods are supported with linear system cyclic valuation.

The following two assumptions pertain to the LIFO anf FIFO methods:

• The OI transactions can also be used as part of the LIFO/FIFO layer (selection screen).

• The FIFO/LIFO layer is constructed on the basis of Goods Receipts for a given purchase order line item. The value of each Goods Receipt is obtained by collecting the total value of the PO line item (invoices + subsequent D/C + GR/IR) and distributing the amount on the Goods Receipts based on GR quantity.

Currently supported valuation methods

FIFO (First In First Out): Remaining stock 'covered' by most recent purchases, uniform 'consumption' price. OI transactions can also contribute in building the layer.

LIFO (Last In First Out): Remaining stock 'covered' by initial stock; when this is insufficient, by older purchases; uniform 'consumption' price. OI transactions can or cannot contribute in building the layer.

WMA: Remaining stock and consumptions have identical price. Supports co-products, and cyclic valuation with linear system.

WMAW: WMA with Work in Progress (WIP). Does not support linear cyclic valuation or co-products. Production orders characterized as WIP are valuated with SAP price and the difference from the actual value is defined as WIP.

WMAPL: WMA for Plant level valuation. Variation of WMA in which plant transfers are treated as input with values determined at the source plant. This makes sense for valuation at plant level and requires the treatment of potential circular transfers. Supports cyclic valuation with linear system, but not co-products.

FIX: Fixed price (only for by-products, does not support purchases and other imports).

Enhancement options (for developers)

Self-defined valuation methods can be freely created in customer exit include ZXJ1GVL (see also note 1138580).

Follow the procedure:

1. Define the new valuation method, say 'MYVAL' in customizing of 'Valuation Methods'.
2. Create customer exit include ZXJ1GVL. Note that ZXJ1GVL is already included in main valuation program J_1GVL_VL, therefore it's not required to repair the standard program.
3. Edit ZXJ1GVL with your new valuation method. You may use one of the standard ones (FIFO, WMA) in program J_1GVL_VLI03 as template.
4. If additional information is required that is not available in the already used internal tables, you can:
1. define the new internal table(s) in program ZXJ1GVL.
2. Create a form 'CUSTOMER_FUNCTION' in ZXJ1GVL. Localization is delivered with this form nonexistent. If found, it is executed during access of J_1GVL_ML in form 'READ_ONLINE_WHB'.
3. Edit the form 'CUSTOMER_FUNCTION' in order to append data to these new internal tables.
4. In 'MYVAL' form edit the additional internal tables filled in 'CUSTOMER_FUNCTION' as needed.

By searching in program J_1GVL_VL for string "enhancement" you can track down all spots of the code where customer exit routines are called.

Valuation of cyclic production

In the case of cyclic production the valuation equation for the materials 'belonging' to a cycle are coupled and must be solved simultaneously.

As a first step the program determines the smallest sets of materials that are to be valuated as a system. After that the the application can apoply the following method to each such set:

• Exact solution of the coupled (linear) equations using the Gauss Jordan method. Currently, this method is only supported for WMA valuation and the valuation method in the customizing is overriden by WMA once cyclic valuation starts.

• Iterative solution. This is not restricted to WMA but is slower and in principle may not converge.

• Customer-specific algorithms (for example, a generalization of the linear system approac to work with WMAW method...) can be freely created by including a form 'CUSTOMER_CYCLIC' in program ZXJ1GVL (see above).

Closed 'paths' of assembly / material transfer (mov. 309 / 310) are also recognized by the alsgorithm that constructs the irreducible sets.

Note that all these methods entail the denger of arriving at extremely large or even negative prices!

TXBHW - Original Tax Base Amount in Local Currency   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 9944 Date: 20240520 Time: 074240     sap01-206 ( 153 ms )