How To Fix WXP302 - Database table &1 contains key figure field types FLTP or INT


SAP Error Message - Details

  • Message type: E = Error

  • Message class: WXP - Retail Planning

  • Message number: 302

  • Message text: Database table &1 contains key figure field types FLTP or INT

  • Show details Hide details
  • What causes this issue?

    Database table &V1& contains key figure fields that belong to category
    "FTLP" (floating point number) or "INT" (integer). You cannot execute
    planning for these key figure fields.

    System Response

    INCLUDE ISR_VERARBEITUNG OBJECT DOKU ID TX

    How to fix this error?

    If you want to plan these key figure fiels, change the data type in
    maintenance for your database table to "QUAN" (quantity field), "CURR"
    (currency field), "DEC" (general decimal field), or "NUMC" (numerical
    indicator field).
    If you do not make these changes, you cannot use the fields concerned.

    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 WXP302 - Database table &1 contains key figure field types FLTP or INT ?
    Certainly! Here's a detailed explanation for the SAP error message:
    
    SAP Error Message:
    WXP302: Database table &1 contains key figure field types FLTP or INT
    
    
    Cause: This warning message occurs during the creation or activation of an InfoCube or during the data modeling process in SAP BW (Business Warehouse). The system checks the data types of the key figure fields in the database table associated with the InfoCube. The message indicates that the database table (name substituted for &1) contains key figure fields with data types FLTP (floating point) or INT (integer). These data types are not recommended for key figures in InfoCubes because: FLTP (floating point) fields can lead to rounding errors and precision issues in calculations. INT (integer) fields are not suitable for key figures that require decimal places or aggregation with decimal precision. SAP BW expects key figures to be of type DEC (packed decimal) or CURR (currency), which support precise arithmetic operations and aggregation.
    Solution: To resolve

    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