How To Fix UPB165 - Only preceding rows of key figure scheme are allowed as reference rows


UPB165 - Overview

  • Message type: E = Error

  • Message class: UPB - BPS: Balance sheet planning messages

  • Message number: 165

  • Message text: Only preceding rows of key figure scheme are allowed as reference rows

  • Show details Hide details
  • What causes this issue?

    You have entered a row number as a reference row, which is greater than
    or equal to the row number of the current row.

    System Response

    The key figure scheme is inconsistent.

    How to fix this error?

    Correct your settings on the reference rows.

    Procedure for System Administrators

    The system issues an error message and will not allow you to continue with this transaction until the error is resolved.


    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message UPB165 - Only preceding rows of key figure scheme are allowed as reference rows ?
    The SAP error message UPB165, which states "Only preceding rows of key figure scheme are allowed as reference rows," typically occurs in the context of SAP Business Planning (BPC) or SAP Integrated Business Planning (IBP) when working with key figure schemes in planning models. This error indicates that there is an issue with how reference rows are defined in relation to the key figure scheme.
    
    Cause: The error is caused by attempting to use a reference row that is not positioned correctly within the key figure scheme. In SAP planning models, reference rows are used to derive values based on other rows. However, the system enforces a rule that only allows reference rows to refer to preceding rows in the scheme. If a reference row tries to refer to a row that is not before it in the sequence, this error will be triggered.
    Solution: To resolve the UPB165 error, you can take the

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker