In editable alv i am using MT_MOD_CELLS data is incorrect

[jp_2303]

Hi Experts 


I have created a editable alv report and i am getting the value using MT_MOD_CELLS in that i am getting a wrong value .


for example 
value A = 9000 given in the output of the report 

but its taking 90.00 

[Sandra_Rossi]

I don't know what your exact case is, but if it's a currency amount linked to a currency field whose value in the same line is a currency key with 0 decimal (e.g. COP, JPY, etc.), it's normal to have 90.00 (concept of currency in ABAP: https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abenddic_currency_fie...). It could be also due to a conversion routine.

[jp_2303]

Hi Sandra

my problem is i am using DEC length 7 decimal place is 2  data type for the field but when i see in mt_good_cell its showing as P(8) with 2 decimals

[Sandra_Rossi]

So, you have changed your DDIC definition and you need to refresh the ALV buffer by running the program BALVBUFDEL. Then restart your program.

NB: please provide your code, or it can take time.

[jp_2303]

Hi Sandra,

i have tried what u have suggested but no improvement i have attached the code snippet and the debugger ss with this.


  LT_MODI[] = P_DATA_CHANGED->MT_GOOD_CELLS.

  SORT LT_MODI BY ROW_ID FIELDNAME.
  IF LT_MODI[] IS NOT INITIAL.
*    GT_MODI[] = LT_MODI[].
  ENDIF.

  CLEAR: LWA_MODI.
  LT_MODI_U[] = LT_MODI[].

  LOOP AT LT_MODI INTO LWA_MODI.
    LWA_MODI-FIELDNAME = 'FRIEGHT'.
    APPEND LWA_MODI TO LT_MODI_U.
    CLEAR : LWA_MODI.
  ENDLOOP.

  IF LT_MODI_U[] IS NOT INITIAL .
    LT_MODI[] = LT_MODI_U[].
  ENDIF.

  ASSIGN WA_FINAL TO <FS_FINAL>.

  LOOP AT LT_MODI INTO LWA_MODI.
    READ TABLE GT_FINAL ASSIGNING <FS_FINAL>
             INDEX LWA_MODI-ROW_ID.
    IF LWA_MODI-FIELDNAME EQ 'KMS'.
      ASSIGN COMPONENT LWA_MODI-FIELDNAME OF STRUCTURE
      <FS_FINAL> TO <LFS_VAL>.
      CALL METHOD P_DATA_CHANGED->GET_CELL_VALUE
          EXPORTING
            I_ROW_ID = LWA_MODI-ROW_ID
            I_FIELDNAME = LWA_MODI-FIELDNAME
            IMPORTING
              E_VALUE = <LFS_VAL>.

[jp_2303]

Hi Sandra

[Sandra_Rossi]

The issue is more about how the internal table field and Field Catalog are defined (currency amount and currency key fields), not about how you read the screen. Also, run "ALV SOS" to see inconsistencies in the Field Catalog (search the forum).

[jp_2303]

Hi Sandra

thanks for your reply yes my issue is solved .

[michal_keidar · Accepted solution]

Hi,

Can you please try to remove the .txt extension from the file?
It's mentioned in our guide not to use extension:
https://www.sap.com/documents/2016/05/64fa4c4f-747c-0010-82c7-eda71af511fa.html (page 31)

Hopefully this will resolve your error.

Regards,
Michal.

[eralper_yilmaz · Accepted solution]

Hello Michal,

Thank you for the answer. That solved my problem 🙂

I could connect without an issue. Although I had removed extensions before, I guess because of other problems that did not work in my earlier attempts.

[chitrajesil · Accepted solution]

Hi Michal,

I removed the txt.extension from the file, but it gives error as error 500 server error. why does this happen?

Regards

Chitra

[michal_keidar · Accepted solution]

Hi, you need to be more specific... Please provide screenshots of how you configured your destinations.

[chitrajesil · Accepted solution]

Hi Michal ,

It was an error in URL entry from my side in the destination file. Its working now.