Document Header Text in BKPF

[Former Member]

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.

[Former Member]

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.

[Former Member]

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....

[Former Member]

Hi

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

[ThomasZloch]

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

[Former Member]

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.

[Former Member]

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

Rob