值流监视器-解释和建议

Note 744090 - Value Flow Monitor: Explanation and recommendations

After the material ledger period-end closing, differences thatcannot be explained or that have to be balanced remain on the pricedifference accounts.
Notes 908776, 524289, 450219 and 323719 provide explanations andpossible reasons.
You use the Value Flow Monitor (transaction CKMVFM) to analyze thenot distributed or not included differences. The Value Flow Monitoris the enhancement of the Value Flow Analyzer from Release 46C. Asof Release 470, the Value Flow Monitor is available in the standardsystem with Enterprise Extension 110.
This note explains the functions of the Value Flow Monitor. Inaddition, this note also contains recommendations for the(performance) usage of the Value Flow Monitor.
This note is constantly being improved and updated.

Other terms

Not distributed, not included, price limiter quantity,CKMLPP-PBPOPO, transaction CKMVFM, programML_VALUE_FLOW_MONITOR

Reason and Prerequisites

After the material ledger period-end closing, differences thatcannot be explained or that have to be balanced remain on the pricedifference accounts.

Solution

For the Value Flow Monitor to workcorrectly, program errors were solved using thefollowingnotes:
1121070, 1119516, 1088394, 1086064, 1046705, 1041453, 1040061,1032547, 975447, 965058, 962259, 959316, 957133, 951512, 890578,878365, 875669, 857043, 856837, 805391, 803383, 800762, 783347,767958, 755401, 745766, 718227, 710018, 603966, 614354, 621340.This list is updated when required.
Implement these notes in your system.
If you use the functions of the alternative valuation run, you mustimplement Note 857671. As a result, required current datadefinitions are created.
If you do not use and do not plan to use thealternative valuation runfunction, implement a decoupling of the functionsusing Note 768814.
Explanations for the selection screen:
Select either the option to display all materials or the option todisplay only materials with open differences. In this version ofthe Value Flow Analyzer (Release 46C), you could choose between thenot distributed or not included options. You can use the Value FlowMonitor (Release 470, Enterprise Extension 110) to analyzeadditional materials with price determination control 2. You cannotmap the original selection options to these materials and,therefore, they are changed accordingly.
You may enter a threshold value for differences that are notdistributed and/or not included. This means you can prevent thesystem from displaying materials, for which rounding differencesoccurred.
If you enter only one threshold value, thetransaction may display materials for which differences are belowthis threshold. For these materials, category differences occur forwhich no threshold was entered. This system response ensures thatno information is lost.
However, you may only be interested in differences that are notdistributed. In this case, select a threshold low enough to ensurethat only rounding differences are not displayed. If you select thenot included differences, select a threshold large enough to makesure that it will not be exceeded.
If you select option "Reconciliation FI withML", the system automatically selects the relevantprice difference accounts for the reconciliation of FI accountswith the Material Ledger. The program analyzes all accounts thatthe chart of accounts of the company code to be analyzed providesfor price differences. In particular, the followingaccount keys are provided in the standard system:'AKO', 'AUM', 'KDM', 'KDV', 'PRD', 'PRV', 'PRY', 'UMB','UMD'.
Sometimes you may have to use other accounts for price differencesor to control further postings to the accounts mentioned above.Take this into account in the analysis or contact us for a relevantchange.
Important: The reconciliation between FI and ML only returnshelpful results if you did not activate the summarization of FIdocuments. If special stocks are analyzed, the updating of thetable ACCTIT must also be activated.
If you activated a summarization of FI documents, the"Reconciliation FI with ML" option does not deliver any helpfulresults or does not delivery any results at all.
When you summarize FI documents, the values that are defined by thematerial are deleted from the relevant tables. For this reason, theinformation necessary for the selectable reconciliation can nolonger be determined as differentiated.
The system cannot determine all of the information from the FIdocuments that is required for analyzing special stocks. The tableACCTIT provides the missing information. If you did not activateupdating for the table ACCTIT, the differences of the specialstocks are assigned to the stock material. The total of thedifferences for a material is then correct. However, it is notclear whether the differences are relevant for the warehouse stockor special stock.
If you do not select the "Reconciliation FI with ML" option, theupdating of the table ACCTIT is not relevant.
For performance reasons, you must create an extract for each run.You use Note 912984 to implement this change. If you select a name,for which an extract already exists, the system overwrites this onthe database.
If the saved extract data requires too many resources on yourcomputer, you can deleteit.  You must thenimplement Note 999197.
Recommendations for the selection to improve the performance:
To analyze the FI accounts, all FI documents (BSEG records) of theselected time period must be read. This can result in majorperformance problems. The runtime and the required memory areconsiderably affected. Therefore, the analysis of alternativevaluation runs is critical for performance.
Different procedures are recommended to work around thisdifficulty.
First of all, execute the transaction without analyzing the FIaccounts and clarify which materials need a more detailed analysis.It is not performance-critical to execute this transaction becausethe BSEG records are not read in this case. Execute the transactiona second time and only analyze the materials that raise criticalquestions. This time, choose option "Reconciliation FI with ML".There should be no performance problems because the scope of theselected data is now much smaller.
A further option is to create a database extract in the background.This can then be used regardless of performance problems in theupdate run for the analysis.
To improve performance, you must implement the followingnotes:
1045124, 973647, 924343, 912984, 855568, 849398, 849065, 770270,768815, 715186.
Explanations for each view:
Monitor
The monitor is the "initial view" after you start thetransaction.
The total of all postings without or with material reference isdisplayed on the selected accounts. Materials are subdividedaccording to price determination control 2 and3.  The listing is sortedaccording to material category and plant.
The total of all FI postings relating to material on the selectedaccounts is displayed in the "FI balance" column.
In the "FI/ML balance" column, the system lists the differencesthat accumulate in the Material Ledger.
The diode in the FI column is red when the values in the columnsnamed above differ from one another. This diode is only significantif the material status is unequal to "Price determined" or "ClosingEntry reversed". The material status is apparent from the SP, MP, Ccolumns (single-level price determined, multiple-level pricedetermined or entered at closing). In the situations mentionedabove, differences are only determined in the Material Ledger, butnot yet posted in FI.
As for materials, you can go from the "Monitor" view to FI postingsfor a more detailed analysis. The FI postings are then sorted andtotaled according to account and transaction key.
This move is also possible for postings without materialreference.
Analysis "Not distributed"
The logic currently implemented in the pricedetermination allows for a stock coverage check to take place. Ifthe existing differences cannot be absorbed by the stock, adistorted price may be determined. Due to the price limiter logic,the differences are distributed according to stock. Differencesthat cannot be absorbed by the stock are determined as notdistributed. You can investigate this phenomenon using the ValueFlow Monitor. The price limiter quantity ("PL Quantity" column)specifies for which number of material pieces differences weredetermined. You can set the price limiter quantity to zero. Thenall differences can be absorbed by the stock. No morenon-distributed rows are created. In the "Price PB = 0" column, thenewly created price is displayed.
The diode in the "VB" column specifies whether the price limiterquantity can be set to zero. If it is red, the price will benegative when you reset the price limiter quantity. If this is thecase, use transaction MR22 to post a revaluation.
If the diode is green, you can delete the price limiter quantity.Then the relevant entry in the database (field CKMLPP-PBPOPO ) isdeleted and the material status is reset to "Quantities and Valuesentered". You have to execute the price determination for thematerial once again.
You do not have to use the stock coverage check during single-levelprice determination. If you implement Note 855387, you have theoption to turn on the stock coverage check using the selectionparameter. Then you no longer have to reset the price limiterquantity.
You can carry out the price determination without stock coveragecheck but with thresholds. Heavy price distortions are output aserrors.
Then you can examine the relevant materials using the Value FlowMonitor and determine the price accordingly (MR22, determine pricewith stock coverage check, confirm distortedprice).
In the "Monitor" and "Analysis not distributed" view, you can go toa detailed analysis of the non-distributed values. The documentthat causes the non-distributed values is displayed. You cannavigate to the source document.
Material list
A flat ALV list is delivered when all other views are executed asALV trees. You have the option to sort or filter the data accordingto an ALV list or to apply functions to the values. You cannot dothis on the other views. The "Material list" view does not containany additional information, only additional options.