topic Document Header Text in BKPF in Application Development and Automation Discussions

Document Header Text in BKPF

Former Member — Thu, 21 Feb 2008 12:05:27 GMT

Hello

In BKPF the document header text is case-sentive.If we search for eg. test* then it would return all the texts starting with test(in small) and if we search for TEST* it would return the texts starting with TEST and not test also.I have a select option(Document Header Text) on the selection screen and irrespective of the case it should select all the texts which i give the search for.For e.g if I give test* then it should return texts starting with (test as well as TEST).How can this be achieved?

Thanks.

Re: Document Header Text in BKPF

Former Member — Thu, 21 Feb 2008 12:10:24 GMT

do this way....

convert all char of select-option to lower case....

write a select statement and fetch data into internal table....

now, convert all char of select-option to upper case....

write a select statement and fetch data by appending the internal table....

Re: Document Header Text in BKPF

Former Member — Thu, 21 Feb 2008 12:12:21 GMT

You have to convert the value of the select option into upper case and append the same into select option and use EQ for the same

otherwise loop at select option and convert the same into visa versa

regards

Shiva

Re: Document Header Text in BKPF

ThomasZloch — Thu, 21 Feb 2008 12:12:44 GMT

what I know is that in order to work around that very problem, SAP has added special match code (or search help in today's speak) fields to some tables, which duplicate in upper case otherwise case sensitive data (e.g. SKAT-MCOD1).

I don't know a simple way to do what you're trying to do here, sorry. Would like to know as well.

Greetings

Thomas

Re: Document Header Text in BKPF

Former Member — Thu, 21 Feb 2008 12:25:09 GMT

Hi,

There is no simple solution to this. Either you build up a select-option yourself with all possible combinations of "test", "Test", "TEST" etc., or you would select all BKPF records in an internal table (usually not a good idea since this is normally a DB-table with many entries) and translate the BKTXT field to upper case and then select your records.

Regards,

John.

Re: Document Header Text in BKPF

Former Member — Thu, 21 Feb 2008 18:48:51 GMT

This is quite easy to do using native SQL (depending on your database system).

Rob