IBAN maintenance in Z* table

[Former Member]

Hi everyone,

I'm sure you faced this issue before, but I searched the Forum and found nothing

The point is: I have created a Z* table with its maintenance view, which stores some (national) bank accounts. Now I would like to take some advantage of the IBAN-functionality that SAP provides. So I thought to create a new column in the table control (as a pushbutton), just like tx FK02 does.

It works fine when I want to read the DB so as to know if the IBAN is already stored, and then I update the icon in the pushbutton (you know: ICON_ENTER_MORE and ICON_DISPLAY_MORE). When you push this button, I call FM 'MAINTAIN_IBAN_DIAL', and that shows the IBAN info (if any).

But the problem is this one: imagine I pushed the button for a national bank account which does not yet have an IBAN code. So I show the IBAN popup (with no data). Now the user enters the IBAN code and presses ENTER. Well, I cannot manage how I am supposed to tell the maintenance view to update the data, 'cause if I try to save the entries, SAP shows the message (SV)043 "Data already saved", and the IBAN info is not inserted/updated into the DB.

Any ideas? Thanks very much in advance. BR,

Alvaro

[Former Member · Accepted solution]

Hi Alvaro,

Is the IBAN code part of the maintenance view?

Need to add it to the Maintenance view and set the maintenance attribute of the field to 'H' (you can find the column between <i>Field Name</i> and <i>key</i> in the maintenance view definition under the <i>View Fields</i> tab) in the view.

Use event 21 in the <i>table maintenance generator</i> (<i>Environment -> Modifications -> Events</i>) to populate the IBAN code accepted on the screen. Now the save will work as the field is changed in the maintenance view.

Good Luck!

Rishi

[Former Member · Accepted solution]

Hi Rishi,

Still two questions:

- When you say "set the maintenance attribute of the field to 'H'", I cannot find this field in my SAP (I'm using 46C). Anyway, I assume that you're trying to tell me that I add the field IBAN (34 characters) as <i>hidden</i>, isn't it?

- So your idea is to store the IBAN together with the national bank code in the same Z* table. Well... that's fine... but what I would like to do is:

1. add a pushbutton-field into the table maintenance

2. if the user presses this buton, call FM 'MAINTAIN_IBAN_DIAL' and 'MAINTAIN_IBAN_FROM_DATA' to store the IBAN info

3. when the user presses "Save" in the table maintenance, the IBAN info should be updated in the DB.

So I have to control an extra ok-code (which is associated to the IBAN-pushbutton). Is it possible via the events?

Thanks again very much for your time&help. BR,

Alvaro

[Former Member · Accepted solution]

Hi Alvaro,

Yes, I took forever to find the field too (One of those SAP quirks). Once in the view maintenance, <b>scroll the table control to the left (in the view flds tab)</b>, you will find the column in the table control right before the checkbox for the "Key" field.

1. I would create the maintenance view as 2 step (overview and single screen) with the pushbutton on the single screen as it is easier to access the single entry there and managing the OK code.

2. This will be managed via a PAI module in the detail screen, check for OK_CODE and call the required FM's.

3. Use event 21 to store the data into the hidden field.

Look at the following link for additional help on creating maintenance views and for the events available and some samples.

http://help.sap.com/saphelp_46c/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

Get back it additional help is required.

Rishi