Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Lolalola
 | Femeie
22 ani
Cluj
cauta Barbat
26 - 80 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
If you are working with the SAP - VBA (Excel) or SAP - VBS interface, you might need to grab / insert data from / into certain SAP fields. For that you must know the field names.
Inserting data into fields can be recorded as VBS scripts, check:
For exporting data from SAP fields to Excel or VBS you will need to know field names. See below how you can find them out depending on the reach of your access in SAP.
1. If you are a normal user with limited access
- you can only check certain field names
- for some Z transactions (custom transactions) you can't check field names, you would need to go to point 2 and have special access to transaction SE12
- go into the desired transaction (eg. open VL02N)
- right click in the desired field
- select Help to open the help dialog box
- at the top of the dialog box there are some buttons, look for one picturing a hammer and a wrench (must be the 4th button from left to right, called Technical information)
- look for field name, eg. VBELN
- look for screen field, eg. LIKP-VBELN
2. If you have access to a developer module of SAP or you can access transaction SE12
- you must know the table where your field is located
- go into the transaction where you need to find the field name and right click somewhere on the SAP screen, or press F1 to open the help dialog box
- at the top of the dialog box there are some buttons, look for one picturing a hammer and a wrench (must be the 4th button from left to right, called Technical information)
- look for table name, eg. VTTK
- in SE12, in Database table write your table, eg. VTTK
- click the Display button
- check the Fields tab
Notes:
- another option to find table name would be to google the transaction
- some text fields won't allow using Help (F1). For those you must click inside them and look under them for a button called Detail - Click on detail -> GoTo -> Header
- there you will see the Text ID
|
|
| pus acum 3 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
Another thing that can be done is to show technical name for dropdown lists and technical names in general (display for all transactions):
1. In the main menu of SAP, Shift + F9 (or click on Extra - Settings) and select the checkbox "Display technical names"
2. In the main menu of SAP press Alt + F12 - Options - Visualization 1, and under Controls, select both checkboxes (Show keys within dropdown lists Sort by keys within dropdown lists for most efficient keyboard layout)
|
|
| pus acum 6 luni |
|