https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011081#M2038452 <P>Hi!<BR /><BR />I am sorry if this has been asked before, I havent been able to find anything related to this in the discussions, but I feel like this is a fairly basic question.<BR />For a smartform, I'm trying to get the data from a database table into an internal table, but for some reason the datum field gets changed, and not just the order but the numbers in general.<BR />Does anyone know if this makes sense, and how I can change it back? I've attached a picture of the database table entries, internal table entries, and how I get the data into the internal table.<BR />Thank you so much in advance!<BR /><BR />How I get the data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_1-1738952499991.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223620i9A12792EEA20163A/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_1-1738952499991.png" alt="RomyA_1-1738952499991.png" /></span></P><P>Entries in database table:&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_2-1738952550281.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223621iA57821B880FD36C3/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_2-1738952550281.png" alt="RomyA_2-1738952550281.png" /></span><BR />Entries in internal table in debugger:&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_3-1738952566950.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223622i831FE70CFF2AF6CE/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_3-1738952566950.png" alt="RomyA_3-1738952566950.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P> Fri, 07 Feb 2025 18:24:58 GMT RomyA 2025-02-07T18:24:58Z https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011081#M2038452 <P>Hi!<BR /><BR />I am sorry if this has been asked before, I havent been able to find anything related to this in the discussions, but I feel like this is a fairly basic question.<BR />For a smartform, I'm trying to get the data from a database table into an internal table, but for some reason the datum field gets changed, and not just the order but the numbers in general.<BR />Does anyone know if this makes sense, and how I can change it back? I've attached a picture of the database table entries, internal table entries, and how I get the data into the internal table.<BR />Thank you so much in advance!<BR /><BR />How I get the data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_1-1738952499991.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223620i9A12792EEA20163A/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_1-1738952499991.png" alt="RomyA_1-1738952499991.png" /></span></P><P>Entries in database table:&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_2-1738952550281.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223621iA57821B880FD36C3/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_2-1738952550281.png" alt="RomyA_2-1738952550281.png" /></span><BR />Entries in internal table in debugger:&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RomyA_3-1738952566950.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223622i831FE70CFF2AF6CE/image-size/medium?v=v2&amp;px=400" role="button" title="RomyA_3-1738952566950.png" alt="RomyA_3-1738952566950.png" /></span></P><P>&nbsp;</P><P><BR /><BR /></P> Fri, 07 Feb 2025 18:24:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011081#M2038452 RomyA 2025-02-07T18:24:58Z https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011329#M2038454 <P>It's an old ABAP concept. Search in forum and doc the ABAP statements <A href="https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abapconvert_date.htm" target="_self">CONVERT, DATE, INVERTED-DATE (ABAP Keyword Documentation)</A>.</P> Sat, 08 Feb 2025 07:25:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011329#M2038454 Sandra_Rossi 2025-02-08T07:25:22Z https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011464#M2038456 <P>Use the conversion exit:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="thomas_mller13_0-1739040265121.png" style="width: 400px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/223759i0CB052F36FDB7ADC/image-size/medium?v=v2&amp;px=400" role="button" title="thomas_mller13_0-1739040265121.png" alt="thomas_mller13_0-1739040265121.png" /></span></P><P>&nbsp;</P> Sat, 08 Feb 2025 18:44:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/datum-field-gets-changed-when-getting-data-from-database-into-itab/m-p/14011464#M2038456 thomas_mller13 2025-02-08T18:44:32Z