Inventory management-historical inventory and sending and receiving storage series-Russian inventory report j3rflvmobved1

Document directory

• 1) Select the query conditions for the screen
• 2) query results

1. Overview:

The Russian inventory report j3rflvmobved is a report developed for Russia. It is a standard report of SAP and can be used. Compared with mb5b, it is more detailed, including but not limited to the following features

Business Requirements	J3rflvmobved	Mb5b
Searches for objects in special stock and summarizes the objects in special stock. For example, in the MTO mode, the receiving and receiving results are displayed based on the sales order number.	Supported	Not Supported
Search by inventory location and summarize by inventory location	Supported	Not Supported
Based on more filtering conditions: Search for material types and groups and display them in the results	Supported	Not Supported
The query result shows the sending and receiving amount.	Supported	Only factory-level support
Automatic offset between the offset credential and the offset credential	Supported	Limited support
Two-step inventory dump. When the sender has delivered the goods, the recipient has not yet received the business processing	Supported	Limited support

2. operation instructions 1) Select the query conditions on the screen

We can see that there are more query conditions than mb5b, such as inventory locations.

2) query results

Display receiving and storing records based on inventory locations and special inventory objects,

For on-the-way inventory and special inventory at the factory level, the inventory location should be replaced ****.

As shown in, we can view the inventory at the inventory location, and view the detailed quantity and amount of special inventory

By changing the format, you can adjust the format to a more readable format. The query results show a lot more fields than mb5b. For details, click the variant.

3. Description of the deposit amount and the effect of the price difference

The Inventory evaluation in SAP is at the factory level, which is why the amount cannot be displayed at the inventory location level selected in the report mb5b.

In this report, the amount of inventory locations is calculated dynamically when the program runs. The calculation process is as follows:

All services of a material in h001 of a factory are as follows:

Date	Business type	Inventory location	Quantity	Unit Price	Total factory inventory quantity	Factory Accumulation Inventory amount
May 2	Warehouse receiving	H110	1	10	1	10
May 2	Warehouse receiving	H120	2	10	3	30
May 5	Warehouse receiving	H110	100	10	103	1030
May 5	Warehouse receiving	H120	200	10	303	3030
May 10	Invoice verification	Materials use moving average price. invoice verification leads to an increase in inventory amount, and the cumulative inventory amount is 4545

The current date is 2011-5-20. You can use this table to query the sending and receiving status from April 1st to April 4th. the system processing steps are as follows.

1) obtain the current inventory.

Inventory amount in current factory: 4545

Inventory quantity at the current factory: 101 For h110 and 202 for H120

2) counting material creden from the end of the period to the current period: the system collects statistics on all material creden。 between January 1, and January 20.

The inventory changes in the h110 inventory location between the end of the period (January 1, May 4) and the current date (January 1, May 20) are equivalent to warehouse receiving-warehouse picking = 100, the number of changes in the inventory location H120 is equal to warehouse receiving-warehouse receiving = 200

Based on the amount of Accounting creden corresponding to the material credenMay 4, the inventory amount of the entire factory in December 1000 is calculated as 2000 +.

3). The inventory quantity and amount at the end of the rollback Period

The inventory amount at the end of the product is introduced. The inventory amount at the end of the product h001 is 4545-3000 = 1545.

The inventory quantity of each inventory location in the h001 Of The regressing Factory

The inventory quantity under h110 is 1

Inventory location H120 inventory quantity is 2

Calculate the inventory amount at the end of the period (January 1, May 4 ).

In h110, the inventory amount is 1/(1 + 2) * 1545 = 515.00

For H120, the inventory amount is 2/(1 + 2) * 1545 = 1,030.00

4) Similarly, the inventory quantity and amount at the inventory point at the beginning of the same period of time.

In this example, all are 0

5) Calculate the material creden between the beginning and end of the period, and obtain the inventory quantity and amount of the goods received and delivered.

In this example, the inventory location is h110, the receiving quantity is 1, and the receiving amount is 20

Inventory location H120, the number of goods received is 2, the amount of goods received is 40

PS: The amount here is doubled due to the system configuration of the test system.

6) differential processing

When the inventory location is h110, the initial inventory is 0, the inventory sending and receiving amount is 20, the ending amount is 515, and the difference amount is 495 yuan.

In the initial screen selection, click "separate price difference distribution"

You can allocate the spread to the sending and receiving amount, as shown in

You can also choose not to share the price difference, but to appear in a single column (additional value)

On the selection screen, you can click and to display details including the material credential number, price difference, and offset credential.

4. Description of the Offset credential

As shown in, this is all the business that occurs under the plant h001 of materials, two of which are written off, one of which is written off in the current month (July 1, April, another option is to write off the data every other month (January 1 ).

Execute the Russian inventory report

First, select the period from the beginning of April to the end of May. You can see that the offset creden。 are automatically offset by each other.

The number of shipping items is 100, and the number of shipping items is 100.

For the same filter condition, run the report "mb5b". The system displays that the number of shipping items is 11100, and the number of shipping items is 11100. The specific results are as follows:

In the filtering condition of the report mb5b, you can choose to move without offset ., The execution result is the same as that in the Russian report. The number of sent and received messages is 100.

The selected period is July, and the number of deliveries is 100.

Similar to mb5b, the offset of shipping will appear in the shipping quantity.

Note that if you select the filter condition of mb5b, the result is not blank.

Conclusion: Compared with mb5b, the Russian inventory report is more reasonable for the reversal operation.

If the offset and offset creden are in the same selection period, the two creden are automatically offset. If it is not in the same period, the offset of shipping will appear in the shipping quantity, and the offset of shipping will appear in the shipping quantity.

While mb5b is based on different query conditions. If selected, the records are simply excluded regardless of whether the offset creden and the offset creden are in the same period.

5. Notes

1) the evaluation method of the sales order inventory is m, and the evaluation method is a or blank.

2) Report Optimization

To improve efficiency, you can save the results in the data table and directly read the database table next time.

When saving data, you can only save the data for the entire month. At the same time, you can select a factory or company code + accounting subject to save the data.

To save data in a table, you must have all permissions of the permission object j_3rm_wrtb.

6. Conclusion:

A report in Russia is much more powerful than a report in mb5b. When using this report, we need to understand the overall logic, and pay attention to the handling of special situations, for example, the calculation logic of the inventory amount, the price difference allocation caused by invoice verification, and the two-step inventory allocation processing.

See sap note

SAP note 947515-j_3rmobved behavior and limitations