‎2010 Jun 02 10:19 AM
Hii all,
i have a requirement like this:
1 st screen:
some number of Insurance Policies with radio button
after selecting any one policy ..it will navigate to 2 nd screen.
2nd Screen:
Raise a new enquiry
Existing enquiry ( drop- down list )
Approve/ Reject Existing
If its New Enquiry... 3rd screen will come.
3rd Screen: Raise a new enquiry
In Tabular format user will be able to enter data ,which has to save in Ztable for future.
Heading Comapny1 Comapny2 Comapny3
Premium1 100 200 150
Premium2 200 150 200
Total 300 .... ......
In above Ztable Heading Col. is fixed with data as Premium1, Premium2. In rest cols user will be able to enter data at run time & save it.
4th Screen: Existing enquiry
User can able to select an existing enquiry number from Drop Down list in screen 2nd.
On basis of enquiry number existing enquiry will be dispalyes in same format like screen 3rd.
Kindly reply how to solve this. With report i think we canot do, since many screens are there so, we can do by Module pool (may be i am wrong).
Any reply appreciated help me out Gurus.
Thanks & Regards
priyanshu
‎2010 Jun 02 10:29 AM
‎2010 Jun 02 10:31 AM
Hi Priyanshu,
It is possible to do the same with Report program too, where the driving screen is 1st Screen in your case, and based on the action you take or perform on the first screen you can call other screens.
It is better to opt for module pool, for better organization of the data.
Coming to the 4th screen where the existing enquiry details needs to be shown to the user based on the value entered on the second screen.
Here its simple, create the necessary variables or workarea used for the screen fields in screen 2, in your TOP include of the module pool program.
Automatically the data entered in screen 2 will be captured in those variable or workarea.
In screen 4, check for the initiality and get the data of that enquiry number entered in screen 2.
Kindly let me know in case of any issues.
Regards,
Shashikanth. D
‎2010 Jun 02 10:47 AM
Thanks Shashikanth.
I have done some part of this application. Now working on 3rd Screen--- here user data i am getting in Ztable but every time its getting overwrite with new entered values. how to Update ztable from Table control data? I am using -- In PAI
WHEN 'SAVE'.
LOOP AT i_zinsurance WHERE zsel = 'X'.
MODIFY i_zinsurance INDEX tabl_cntrl1-current_line.
MODIFY zinsurance FROM TABLE i_zinsurance[]." INDEX tabl_ctrl1-current_line.
ENDLOOP.
IF sy-subrc EQ 0.
COMMIT WORK.
endif.
How to get Total in Table control and populate there only?
Kindly help.
Regards
priyanshu
‎2010 Jun 02 10:53 AM
Hi Priyanshu,
if you want to modify single value or record use update stament, do not use modify.
With modify chnages all value.
UPDATE tablename SET fieldname = 'FIELDVALUE'
fieldname = 'FIELDVALUE'
WHERE condition.
Thanks
Vinod
‎2010 Jun 02 10:59 AM
Thanks for Reply Vinod.
i was trying with Update Statement but its not updating my Ztable.
Like: Update Zinsurance from I_zinsurance.
‎2010 Jun 02 11:21 AM
Priyanshu,
i think in your case there is no primary identification, thats why it is overwriting all the values.
Why dont you add a field with serial no and modfiy.
orelse select all the data into internal table before loop. add the present data into one more internal table, get the
whole data into final table and update the data.
actually this should not be done but worst case follow.
modify statement some acts strangley, for me also the same problem, but all my required fields or in chain and endchain,
fot this modify is not working, i removed chan endchain, then it is working.
thanks
Vinod
‎2010 Jun 02 11:36 AM
Ok vinod i will try this & let you know.. what i am getting.
For me also Modify was not working with Chain.. Endchain. I too removed that. Hope your idea will work.
Thanks
priyanshu
‎2010 Jun 02 10:41 AM
Hi Priyanshu,
it can be done using module pool, have you started working.
Cretae program using se80 with some name as 'SAPMZ*', it will be easy and look good.
thanks
Vinod
‎2010 Jun 02 10:43 AM
Hi Priyanshu,
i will help you out on this, please send a message to vinoddsmart.
thanks
Vinod
‎2010 Jun 02 10:56 AM
Hii vinod,
can u pls help me to out to get this.
Thanks & Regards
priyanshu
‎2010 Jun 02 2:47 PM
Moderator message - Please do not post your requirements and ask the forum to do your work for you - post locked Rob