topic Re: Table maintainance Generator in Application Development and Automation Discussions

Table maintainance Generator

Former Member — Tue, 11 Dec 2007 14:15:49 GMT

Hi ,

My requirment is after creating table maintainance generator,if we click on maintain button the entries of the table will be displayed. If we double click on any field the corresponding transaction need to be opened.If any one knows this problem please send the solution.

Re: Table maintainance Generator

JozsefSzikszai — Tue, 11 Dec 2007 14:22:31 GMT

hi Srihari,

you have to change the generated FM behind the table maintenance view. The name of the function group you can see in SE11 (where you created the maintenance view). In SE80 you can have a look, basically you have to change the PAI module of the generated FM.

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 14:24:10 GMT

go to that screen logic and write your code for double-click action in PAI.

-Muktar

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 14:43:21 GMT

Hi Eric,

Thanks for giving good suggestion, actually i am doing the same only, but i am confusing on which code i need to write there. Please give me a some sample code there i have to write. Thanks in advance.

regards

Srihari.

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 14:46:00 GMT

Hi muktar,

Thanks for giving advice , could please give me the code for that one..Thanks in advance.

Regards

Srihari.

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 14:57:00 GMT

Hi Sri,

When you create a View, you would have to assign that view to a function group before generating it. Create a function group in SE37 and assign that to your View while genration. Then once your view is generated and you display values get into debug mode (/h) and note the program name. It would be SAPLZ..... where Z..... is your function group name. Goto SE38 and display that program and you should find a couple of includes under

"* general include-files (never change, please) *".

one for subprograms and the other for PAI modules. copy the second include into a Zname. In this program (Zname) you'll find a case statement for "FUNCTION". and the value for FUNCTION when you duoble clicked is "DETA". you would find a perform statement under DETA. Comment that and add your own code to display the transaction you want to.

Hope it Helps.

Mouli

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 15:36:43 GMT

thanks for that,

pls will you send peace of code for that its really urgent.

regards,

srihari.

Re: Table maintainance Generator

Former Member — Tue, 11 Dec 2007 15:41:16 GMT

Add a perform following the steps i mentioned in my previous post.

eg.

CASE FUNCTION...

WHEN 'DETA'.

PERFORM GOTO_TCODE.

...

FORM GOTO_TCODE

GET CURSOR FIELD ZVIEWNAME-KUNNR VALUE V_KUNNR.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = V_KUNNR

IMPORTING

OUTPUT = V_KUNNR.

SET PARAMETER ID 'KUN' FIELD V_KUNNR.

CALL TRANSACTION 'XD03' AND SKIP FIRST SCREEN.

ENDFORM. " GOTO_TCODE

This is an example which i've taken for a view showing KUNNR and its NAME1 from KNA1. and when you double click on the Cusotmer Number KUNNR it takes you to XD03.

Hope it Helps

Mouli

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 04:42:16 GMT

Hi mouli,

Thanks for giving code.I wrote the code as you suggest.After that i activate the function group.After that i go to table maintainance generator ,double click on purchase order , the message comes "the function code is not set".Please guide what i have to do.Thanks in Advance.

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 07:01:48 GMT

Hi experts,

I added the code as mouli suggested. But the problem is when i double click it field in table maintainance generator the message comes " Function code is not selected".Please give me the valuble suggestion.Its really urgent.Please.

Thanks in advance.

Regards

Srihari.

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 07:06:51 GMT

Ok follow these steps.

Step1. Create a Z Function Group ( say eg. ZFG)

Step2. Create a view of your requirement.

step3. Generate the view by assiging your ZFG to you view.

Step4. Once view is generated you can dsiplay the view in SM30.

Step5. Now in the display mode double click on the PO number and get into debugging mode. (/h Mode)

Step6. Note the name of the main program.

Step7. Get into SE38 in change mode for the program whcih you noted.

Step8. You would notice a few includes listed. Your piece of code should sit in the second include under the comment

"* general include-files (never change, please) *"

Copy the second include into a Z name, add that in place of the other.

Step9. Your code should sit under

CASE FUNCTION ......

WHEN 'DETA'.

PERFORM GOTO_TOCDE.

FORM GOTO_TCODE

GET CURSOR FIELD ZVIEWNAME-EBELN VALUE V_EBELN.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = V_EBELN

IMPORTING

OUTPUT = V_EBELN.

SET PARAMETER ID 'BES' FIELD V_EBELN.

CALL TRANSACTION 'ME23N' AND SKIP FIRST SCREEN.

ENDFORM. " GOTO_TCODE

Hope it Helps.

Mouli

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 09:57:54 GMT

Hi experts,

Actually what happening after creation of table maintainance generator is , when i am double clikc on the field the message comes as "Funcction code can be selected" . Any one tell me whats actually this meaning.How to overcome this problem and go to the relevant transaction when i double click the respective field.I already coded as above mouli suggested , but still i face the same problem. Please give the answers . Thanks in advance.

regards

Srihari.

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 10:16:56 GMT

Can you call me on my mobile?

You could get it from my Business Card

- Mouli

Re: Table maintainance Generator

Former Member — Wed, 12 Dec 2007 13:15:03 GMT

Hi mouli,

Thanks for giving valuble answer.Its really thanks a lot.

Regards

Srihari.