744090 - Value Flow Monitor Explanation and recommendations

SAVE OFFLINE

SAP Note

 

  744090 - Value Flow Monitor: Explanation and recommendations Version   8     Validity: 07.10.2010 - active  

 

Language   English

Header Data Released On 07.10.2010 08:24:47 Release Status Released for Customer Component CO-PC-ACT Actual Costing/Material Ledger Priority Correction with medium priority Category Consulting

Symptom After the material ledger period-end closing, differences that cannot be explained or that have to be balanced remain on the price difference accounts. Notes 908776, 524289, 450219 and 323719 provide explanations and possible reasons. You use the Value Flow Monitor (transaction CKMVFM) to analyze the not distributed or not included differences. The Value Flow Monitor is the enhancement of the Value Flow Analyzer from Release 46C. As of Release 470, the Value Flow Monitor is available in the standard system with Enterprise Extension 110. This note explains the functions of the Value Flow Monitor. In addition, 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, program ML_VALUE_FLOW_MONITOR

Reason and Prerequisites After the material ledger period-end closing, differences that cannot be explained or that have to be balanced remain on the price difference accounts.

Solution For the Value Flow Monitor to work correctly, program errors were solved using the following notes: 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 must implement Note 857671. As a result, required current data definitions are created. If you do not use and do not plan to use the alternative valuation run function, implement a decoupling of the functions using Note 768814. Explanations for the selection screen: Select either the option to display all materials or the option to display only materials with open differences. In this version of the Value Flow Analyzer (Release 46C), you could choose between the not distributed or not included options. You can use the Value Flow Monitor (Release 470, Enterprise Extension 110) to analyze additional materials with price determination control 2. You cannot map the original selection options to these materials and, therefore, they are changed accordingly. You may enter a threshold value for differences that are not distributed and/or not included. This means you can prevent the system from displaying materials, for which rounding differences occurred. If you enter only one threshold value, the transaction may display materials for which differences are below this threshold. For these materials, category differences occur for which no threshold was entered. This system response ensures that no information is lost. However, you may only be interested in differences that are not distributed. In this case, select a threshold low enough to ensure that only rounding differences are not displayed. If you select the not included differences, select a threshold large enough to make sure that it will not be exceeded. If you select option "Reconciliation FI with ML", the system automatically selects the relevant price difference accounts for the reconciliation of FI accounts with the Material Ledger. The program analyzes all accounts that the chart of accounts of the company code to be analyzed provides for price differences. In particular, the following account 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 differences or to control further postings to the accounts mentioned above. Take this into account in the analysis or contact us for a relevant change. Important: The reconciliation between FI and ML only returns helpful results if you did not activate the summarization of FI documents. If special stocks are analyzed, the updating of the table ACCTIT must also be activated. If you activated a summarization of FI documents, the "Reconciliation FI with ML" option does not

deliver any helpful results or does not delivery any results at all. When you summarize FI documents, the values that are defined by the material are deleted from the relevant tables. For this reason, the information necessary for the selectable reconciliation can no longer be determined as differentiated. The system cannot determine all of the information from the FI documents that is required for analyzing special stocks. The table ACCTIT provides the missing information. If you did not activate updating for the table ACCTIT, the differences of the special stocks are assigned to the stock material. The total of the differences for a material is then correct. However, it is not clear whether the differences are relevant for the warehouse stock or special stock. If you do not select the "Reconciliation FI with ML" option, the updating 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 on the database. If the saved extract data requires too many resources on your computer, you can delete it.  You must then implement Note 999197. Recommendations for the selection to improve the performance: To analyze the FI accounts, all FI documents (BSEG records) of the selected time period must be read. This can result in major performance problems. The runtime and the required memory are considerably affected. Therefore, the analysis of alternative valuation runs is critical for performance. Different procedures are recommended to work around this difficulty. First of all, execute the transaction without analyzing the FI accounts and clarify which materials need a more detailed analysis. It is not performance-critical to execute this transaction because the BSEG records are not read in this case. Execute the transaction a second time and only analyze the materials that raise critical questions. This time, choose option "Reconciliation FI with ML". There should be no performance problems because the scope of the selected 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 the update run for the analysis. To improve performance, you must implement the following notes: 1045124, 973647, 924343, 912984, 855568, 849398, 849065, 770270, 768815, 715186. Explanations for each view: Monitor The monitor is the "initial view" after you start the transaction. The total of all postings without or with material reference is displayed on the selected accounts. Materials are subdivided according to price determination control 2 and 3.  The listing is sorted according to material category and plant. The total of all FI postings relating to material on the selected accounts is displayed in the "FI balance" column. In the "FI/ML balance" column, the system lists the differences that accumulate in the Material Ledger. The diode in the FI column is red when the values in the columns named above differ from one another. This diode is only significant if the material status is unequal to "Price determined" or "Closing Entry reversed". The material status is apparent from the SP, MP, C columns (single-level price determined, multiple-level price determined or entered at closing). In the situations mentioned above, differences are only determined in the Material Ledger, but not yet posted in FI. As for materials, you can go from the "Monitor" view to FI postings for a more detailed analysis. The FI postings are then sorted and totaled according to account and transaction key. This move is also possible for postings without material reference. Analysis "Not distributed" The logic currently implemented in the price determination allows for a stock coverage check to take place. If the existing differences cannot be absorbed by the stock, a distorted price may be determined. Due to the price limiter logic, the differences are distributed according to stock. Differences that cannot be absorbed by the stock are determined as not distributed. You can investigate this phenomenon using the Value Flow Monitor. The price limiter quantity ("PL Quantity" column) specifies for which number of material pieces differences were determined. You can set the price limiter quantity to zero. Then all differences can be absorbed by the stock. No more nondistributed rows are created. In the "Price PB = 0" column, the newly created price is displayed. The diode in the "VB" column specifies whether the price limiter quantity can be set to zero. If it is red, the price will be negative when you reset the price limiter quantity. If this is the case, 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) is deleted and the material status is reset to "Quantities and Values entered". You have to execute the price determination for the material once again. You do not have to use the stock coverage check during single-level price determination. If you implement Note 855387, you have the option to turn on the stock coverage check using the selection parameter. Then you no longer have to reset the price limiter quantity. You can carry out the price determination without stock coverage check but with thresholds. Heavy price distortions are output as errors. Then you can examine the relevant materials using the Value Flow Monitor and determine the price accordingly (MR22, determine price with stock coverage check, confirm distorted price). In the "Monitor" and "Analysis not distributed" view, you can go to a detailed analysis of the nondistributed values. The calculation of the not distributed differences that exist due to a price limiter quantity logic that is used are explained here (area of calculation). However, there may be not distributed differences that are not displayed in this area. There is no program error in these cases. For the explanation of these not distributed differences, see the other reasons listed in the related Note 908776. In addition, for the detailed analysis of the not distributed differences, the system displays the relevant documents that caused the not distributed values (area of relevant documents). You can navigate to the source document.

Material list A flat ALV list is delivered when all other views are executed as ALV trees. You have the option to sort or filter the data according to an ALV list or to apply functions to the values. You cannot do this on the other views. The "Material list" view does not contain any additional information, only additional options.

Validity Software Component From Rel. EA-APPL 110 200 500 600

To Rel. And Subsequent 110   200   500   600  

References This document refers to: SAP Notes 908776   Not included/not allocated and not distributed 875669   CKMVFM: Runtime error RAISE_EXCEPTION "NOT FOUND" 861709   CKMVFM: FI documents are not displayed 857671   CKMVFM: Change CKMLRUNSCALE to MLAVRSCALE 857043   CKMVFM: Short dump OBJECTS_NOT_NUMLIKE 856837   CKMVFM: Incorrect plus/minus sign with FI differences 855568   Transaction CKMVFM: Performance improvement 855387   Make the price limiter logic controllable 849398   CKMVFM: Performance 849065   CKMVFM: TSV_TNEW_PAGE_ALLOC_FAILED 805391   CKMVFM: No data is selected 803383   CKMVFM: C+073, error reading material ledger period records 800762   Transaction CKMVFM: Syntax error in Note 768814 783347   CKMVFM - Different corrections 770270   Transaction CKMVFM: Short dump TSV_TNEW_PAGE_ALLOC_FAILED. 768815   Transaction CKMVFM: Short dump TSV_TNEW_PAGE_ALLOC_FAILED 768814   Removing Value Flow Monitor - AVR 767958   CKMVFM: Program termination with message type X 755401   Enhancement Transaction CKMVFM: Extract and FI accounts 745766   CKMVFM: C+099 internal errors in FORM/FUNCTION TREE_SHOW 718227   Value Flow Monitor: Runtime error 715186   Transaction CKMVFM terminates with runtime error TIME_OUT 710018   CKMVFM: Status check when deleting price limiter quantity 621340   CKMVFM/CKMVAL (Value Flow Monitor): Enhancement of FI balanc 614354   CKMVFM,CKMVAL: Incorrect values in 'Not Allocated' column 603966   CKMVFM, CKMVAL: Runtime error COMPUTE_BCD_OVERFLOW 524289   Material ledger: Balance on price difference accounts 323719   Price Limiter and Price Limiter Quantities 48009   Tables ACCTHD, ACCTIT, ACCTCR: Questions and answers

This document is referenced by: SAP Notes (29) 800762   Transaction CKMVFM: Syntax error in Note 768814 803383   CKMVFM: C+073, error reading material ledger period records 805391   CKMVFM: No data is selected 715186   Transaction CKMVFM terminates with runtime error TIME_OUT 718227   Value Flow Monitor: Runtime error 849065   CKMVFM: TSV_TNEW_PAGE_ALLOC_FAILED 849398   CKMVFM: Performance 603966   CKMVFM, CKMVAL: Runtime error COMPUTE_BCD_OVERFLOW 524289   Material ledger: Balance on price difference accounts 614354   CKMVFM,CKMVAL: Incorrect values in 'Not Allocated' column 745766   CKMVFM: C+099 internal errors in FORM/FUNCTION TREE_SHOW 875669   CKMVFM: Runtime error RAISE_EXCEPTION "NOT FOUND" 621340   CKMVFM/CKMVAL (Value Flow Monitor): Enhancement of FI balanc 908776   Not included/not allocated and not distributed

783347   CKMVFM - Different corrections 770270   Transaction CKMVFM: Short dump TSV_TNEW_PAGE_ALLOC_FAILED. 48009   Tables ACCTHD, ACCTIT, ACCTCR: Questions and answers 323719   Price Limiter and Price Limiter Quantities 710018   CKMVFM: Status check when deleting price limiter quantity 755401   Enhancement Transaction CKMVFM: Extract and FI accounts 855387   Make the price limiter logic controllable 855568   Transaction CKMVFM: Performance improvement 856837   CKMVFM: Incorrect plus/minus sign with FI differences 857043   CKMVFM: Short dump OBJECTS_NOT_NUMLIKE 857671   CKMVFM: Change CKMLRUNSCALE to MLAVRSCALE 861709   CKMVFM: FI documents are not displayed 767958   CKMVFM: Program termination with message type X 768814   Removing Value Flow Monitor - AVR 768815   Transaction CKMVFM: Short dump TSV_TNEW_PAGE_ALLOC_FAILED