Q
Problem solve Get help with specific problems with your technologies, process and projects.

Transfering case sensitive fields between legacy system and R/3

I need to compare two text fields during loading of data from a legacy system into an R/3 system. The content of...

the external fields are in upper case while the R/3 contains a mix of upper and lower case. The select is as follows: SELECT SINGLE vkbur INTO (iall-vkbur) FROM tvkbt WHERE bezei = iall-zvkbur_t AND spras = 'E'. With this select the sy-subrc is 4 because nothing is found. Is there a way to change the command the way that the select is independent from upper/lower case?


There is no ABAP way of doing this directly (though it may be possible using EXEC SQL, depending on your environment.) The solution I'd suggest would be to read the whole of tvbkt into an internal table of the same structure + an extra field to hold the uppercase version of vkbur. Loop through your table, translating to upper case.

Then use READ TABLE ... WHERE ... instead of the select single.
This was last published in June 2002

Dig Deeper on SAP ERP software

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close