Question Re: Export Extension to Excel As Text Data Type in Spend Management Q&A https://community.sap.com/t5/spend-management-q-a/export-extension-to-excel-as-text-data-type/qaa-p/8421826#M131199 <HTML><HEAD></HEAD><BODY><P>The big texts are stored in the DB as BLOBS. I donu2019t believe itu2019s possible to extract the contents of the big text to excel using the query definition. </P><P></P><P>Regards,</P><P>Vikram</P></BODY></HTML> Fri, 16 Dec 2011 00:59:22 GMT vikram_shanmugasundaram 2011-12-16T00:59:22Z Export Extension to Excel As Text Data Type https://community.sap.com/t5/spend-management-q-a/export-extension-to-excel-as-text-data-type/qaq-p/8421825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I created new extension as TEXT data type, and i would like to export this text to excel from report (query already created).</P><P></P><P>The issue is I know only the extension field as TEXT Preview meaning :</P><P></P><P>Extension field : <STRONG>KPI_PROGREPORT_TEXT_PREVIEW</STRONG></P><P></P><P><STRONG>select KPI_PROGREPORT_TEXT_PREVIEW from FCI_DYN_$2147482948</STRONG></P><P></P><P>Result of query is limited : KPI_PROGREPORT_TEXT_PREVIEW containing limited characters - 1000 characters (3000 byte)</P><P></P><P>The extension field value is containing more than 1000 charcters ( = value displaying on the project screen)</P><P></P><P><STRONG>My question</STRONG> : How to find the correct field to have the full TEXT (TEXT value displaying on the project screen, and not the Preview one ?</P><P></P><P>Any other way to get the TEXT from query as displayed on th project screen ?</P><P></P><P>Thanks in advance for your suggestions.</P><P></P><P>Kind Regards,</P><P></P><P>Anacia</P></BODY></HTML> Thu, 15 Dec 2011 14:18:14 GMT https://community.sap.com/t5/spend-management-q-a/export-extension-to-excel-as-text-data-type/qaq-p/8421825 Former Member 2011-12-15T14:18:14Z Re: Export Extension to Excel As Text Data Type https://community.sap.com/t5/spend-management-q-a/export-extension-to-excel-as-text-data-type/qaa-p/8421826#M131199 <HTML><HEAD></HEAD><BODY><P>The big texts are stored in the DB as BLOBS. I donu2019t believe itu2019s possible to extract the contents of the big text to excel using the query definition. </P><P></P><P>Regards,</P><P>Vikram</P></BODY></HTML> Fri, 16 Dec 2011 00:59:22 GMT https://community.sap.com/t5/spend-management-q-a/export-extension-to-excel-as-text-data-type/qaa-p/8421826#M131199 vikram_shanmugasundaram 2011-12-16T00:59:22Z