‎2008 Aug 06 1:37 PM
Hi there, please help
I've created a parameter transaction(ZTRN) for a view maintenance(ZVIEW) with the ff
Skip initial screen = X
VIEWNAME = 'ZVIEW'
UPDATE = X.
How can i change this transaction/view so that only 1 record can be maintained, i.e how/what
parameters to provide before calling the transaction so that only one record can be maintained. With the above settings all records are displayed.
I've tried using UPDATE_LTD = X but its not helping either.
Thanks in advance
‎2008 Aug 06 1:40 PM
I don't think this is possible in the way you want it to. What you could do is use the standard events provided by the maintenance view. In these event create a check that only one record can be changed or even displayed.
I don't have a SAP system to give you an example but I can refer you to this:
[Maintenance events|http://help.sap.com/saphelp_nw70/helpdata/EN/91/ca9f0ea9d111d1a5690000e82deaaa/content.htm]
Edited by: Micky Oestreich on Aug 6, 2008 2:41 PM
‎2008 Aug 06 1:41 PM
Hi,
In the table, activate Display Maintenance with restrictions.
Best regards,
Prashant
‎2008 Aug 06 2:05 PM
Hi Prashant,
I've tried it but then i get an error "View/Table ZVIEW can only be displayed and maintained with restrictions", i get the same error even in sm30.
Micky is this possible,
What i wanted to do here was then to call the transaction in this way
CALL TRANSACTION ZTRN AND SKIP FIRST SCREEN USING BDC_TAB
with BDC_TAB having all the unique key in order to select only 1 record.
‎2008 Aug 06 2:14 PM
Hi,
You need to create table maintainance generator with Two Step instead of one.
If you create it with One step, then you need create entry in Overview screen itself.
if it is two step, then you will be able to create the new entry in seperate screen, i.e. one record at a time.
Let us know this is what your requirement is ?
Regards,
Shrinivas
‎2008 Aug 06 1:41 PM
Hi!
It can be performed maybe through authorization.
When you created the processing screen with the table maintenance generator, you entered an authority group.
With this authority group, you might restrict the entries.
However I did not test it yet...
Just give it a shot.
Regards
Tamá
‎2008 Aug 06 2:08 PM
Hi,
IF thats the case, do a BDC on SM30, select radio button CONDITION & then select the check box for the fields which you feel should be entered to get only a single record.
Best regards,
Prashant
‎2008 Aug 06 2:20 PM
I feel your problem could be solved if you create your table maintainence as a 2 step maintenance type instead of a single step process in SE11(table maintenance generator)..
‎2008 Aug 06 4:59 PM
I appreciate all your help, i managed to get it correctly here is what i did.
I exported structure to memory with all the unique key and then called the transaction
CALL TRANSACTION ZTRN from the the first program.
And then on the view maintenance's function module side (TABLEPROC_ZVIEW), i first try
to import the structure and if succesfull then i delete all the records in TOTAL(internal table that
have all records in ZVIEW) except then one that matches the record in that structure. If after import
SY-SUBRC <> 0 and then i just leave the internale as it is.
Thanks.