How To Fix AD059 - Format CURR/QUAN requires you to specify a reference field


SAP Error Message - Details

  • Message type: E = Error

  • Message class: AD - Data Dictionary application messages

  • Message number: 059

  • Message text: Format CURR/QUAN requires you to specify a reference field

  • Show details Hide details
  • What causes this issue?

    You have defined a field that has format CURR or QUAN and, thus,
    contains currencies or quantity units.

    System Response

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

    How to fix this error?

    Assign a field containing currency amounts a reference field with the
    CUKY format
    Assign a field containing quantity data a reference field with the UNIT
    format

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message AD059 - Format CURR/QUAN requires you to specify a reference field ?

    The SAP error message AD059 ("Format CURR/QUAN requires you to specify a reference field") typically occurs when you are trying to use a currency or quantity field in a report or a data structure without specifying a reference field that defines the context for that currency or quantity. This is particularly relevant in the context of ABAP programming or when defining data elements in the Data Dictionary.

    Cause:

    1. Missing Reference Field: The error arises when a currency (CURR) or quantity (QUAN) field is defined without a corresponding reference field that indicates the unit of measure or currency type.
    2. Incorrect Data Element Definition: If you are defining a data element for a currency or quantity field, you must specify a reference field that provides the necessary context.
    3. Inconsistent Data Structure: If you are working with a structure or table that includes CURR or QUAN fields, and the reference field is not defined, this error will occur.

    Solution:

    1. Define a Reference Field: Ensure that the currency or quantity field has a corresponding reference field defined in the Data Dictionary. This reference field typically indicates the currency type (for CURR) or the unit of measure (for QUAN).

      • For example, if you have a currency field AMOUNT, you should also have a reference field like CURRENCY that specifies the currency type (e.g., USD, EUR).
    2. Check Data Element Settings: If you are creating or modifying a data element, make sure that the "Reference Field" property is set correctly. This can be done in the Data Element definition in the ABAP Dictionary (transaction SE11).

    3. Review Table/Structure Definitions: If the error occurs in a table or structure, check the definitions of the fields to ensure that all CURR and QUAN fields have appropriate reference fields defined.

    4. Use Correct Data Types: Ensure that you are using the correct data types for currency and quantity fields. For example, CURR should be defined with a reference to a currency field, and QUAN should be defined with a reference to a unit of measure.

    Related Information:

    • Data Dictionary (SE11): Use transaction SE11 to access the Data Dictionary and check the definitions of data elements, tables, and structures.
    • ABAP Programming: If you are writing ABAP code, ensure that you are correctly defining the data types and their references in your program.
    • SAP Documentation: Refer to SAP Help documentation for more details on data types and their usage in ABAP.

    By ensuring that all currency and quantity fields have the necessary reference fields defined, you should be able to resolve the AD059 error.

    • Do you have any question about this error?


      Upgrade now to chat with this error.


Instant HelpGet instant SAP help. Start your 7-day free trial now.


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