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


WXP302 - Overview

  • 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.


WXP302 - Details

  • 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.


WXP302 - Related SAP Errors

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant