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

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 this warning, you should:
  
  
  Change the data type of the key figure fields in the InfoCube or the underlying database table to a suitable type:
  
  Use DEC (packed decimal) for numeric key figures.
  Use CURR for currency key figures.
  
  
  
  Adjust the InfoCube definition:
  
  In the Data Warehouse Workbench (transaction RSA1), edit the InfoCube.
  Change the key figure data types to DEC or CURR.
  Reactivate the InfoCube.
  
  
  
  If the table is custom or external, modify the table structure to replace FLTP or INT key figure fields with DEC or CURR types.
  
  
  Rebuild or reload the InfoCube after making the changes.
  
  
  
  Related Information:
  
  SAP Note / Documentation: SAP recommends using DEC or CURR data types for key figures to ensure correct aggregation and calculation.
  Impact of ignoring the warning:
  
  Using FLTP can cause rounding errors in reports.
  Using INT can limit the ability to store decimal values, leading to inaccurate reporting.
  
  
  Transaction Codes:
  
  RSA1: Data Warehouse Workbench (to maintain InfoCubes)
  SE11: Data Dictionary (to check table definitions)
  
  
  Best Practice:
  
  Always define key figures with decimal data types.
  Avoid floating point and integer types for key figures in BW InfoCubes.
  
  
  
  
  If you need help identifying which fields are causing the issue, you can check the table structure in SE11 or review the InfoCube key figure definitions in RSA1.
  
  Summary:
  
  The WXP302 warning indicates that key figure fields use inappropriate data types (FLTP or INT). Change these fields to DEC or CURR to ensure proper data handling and avoid calculation errors in SAP BW InfoCubes.