How to find selection items lists in SAP -

in sap there dropdown fields list of items countries, nationalities, titles, etc.

i need copy such lists excel can select 1 value, can not copy available values directly(?).

in current case field's dynpro-name p0002-titel, has many entries want copy excel. don't have developer key, can few tas se16.

what's easiest way me values i'm looking without having search through tables or copy single values 1 one?

as far know cannot copy values directly dropdown lists in sapgui.

solution 1

programs build these lists in various ways (db table, direct values), go se16 after guessing db table fieldname, if lucky values there. check domain's attributes behind dynpro field, if contains value table, should find values there se16.

solution 2

sapgui stores dropdown values in cache in xml format. can find these cache files in [users directory]\[user]\appdata\local\sap\sap gui\cache\. filenames start datap_sapvalueset , 1 file contains 1 field's value set. if directly search given value in directory can find coressponding file.

the found xml can processed in online xml parser. used this tool convert xml excel format.

steps examine data:

1, open file in text editor (for example notepad++). change xml encoding utf-8

<?xml version="1.0" encoding="sap*"?> -> <?xml version="1.0" encoding="utf-8"?>

3, close file, rename cache file .xml, reopen it.

4, remove before <?xml tag after last tag (so xml validates)

5, upload file mentioned page , download excel file after converting.

6, data can found on line tab. this screenshot of result of language dropdown (the list in hungarian solution works non-english languages also).

ps: combobox fields (the dynpro field) valueset id attached (that's unique id see in file) can found if turn on sapgui trace (with verbose option). think thats little overhead, can find search.