‎2006 Sep 12 7:21 PM
Hii all,
I have created a ztable and want to use a new transaction (custom tcode) for the table maintenance. How can i do that. Can anyone give me steps of how to achieve?
Another thing is, is it possible to create a table with the name starting with Z_ ?
coz when i do that, a message is displayed stating that 2nd and 3rd places cannot have under-scores in names..
Thanks
‎2006 Sep 12 7:29 PM
Hi,
1)
GOTO SE93 Enter the transaction code..
Enter the description and choose " Transaction with parameters (paramter transaction)".
In the transaction enter SM30 and check the skip initial screen.
In the bottom of the screen for the default values enter the values..
<b>NAME OF THE SCREEN FIELD VALUE</b>
VIEWNAME ZTABLE
UPDATE 'X'
2) It is not possible to create a customer with 'Z_'.
Thanks,
Naren
‎2006 Sep 12 7:27 PM
1) Create a table maintainance/View for the Z* Table.
Once you create the view goto SE93>Select Parameter transaction and give the short desc.>
Give the transaction as SM30(Skip the first screen-optional)>Check all check boxes under GUI support>In the default values(grid)section first row give the VIEWNAME as you created initially and the second row UPDATE as X.
2)The SAP naming convention reserves underlining in the second or third position for special objects. The object which you are processing does not belong to these special objects.
<b>Procedure</b>
Correct your entry. The second and third positions of the object name may not contain underlining.
‎2006 Sep 12 7:29 PM
Hi,
1)
GOTO SE93 Enter the transaction code..
Enter the description and choose " Transaction with parameters (paramter transaction)".
In the transaction enter SM30 and check the skip initial screen.
In the bottom of the screen for the default values enter the values..
<b>NAME OF THE SCREEN FIELD VALUE</b>
VIEWNAME ZTABLE
UPDATE 'X'
2) It is not possible to create a customer with 'Z_'.
Thanks,
Naren
‎2006 Sep 12 7:37 PM
Suggestion,
If possible, make the transaction the same as the table name. That way, there is only one name to remember.
Rgrds,
Dan Perecky
p.s. Please indicate if helpful. Thanks.
‎2006 Sep 12 7:39 PM
Hai Shakir,
1. specially function group.. what is its significance
When we generate table maintenance,
the system , based upon the table fields,
automatically,
generates
PROGRAM CODE, SCREEN FOR ENTERING DATA,
LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA
ETC.
2. All this are BUNCHED under
a FUNCTION GROUP
(if you open that function group in se80, after
creatting table maintenacne,
u will see the program code, screens, gui status etc)
3. Hence, to BUNCH all these various objects,
SAP uses the concept of function group.
*----
4. And also why do we need to give two screens there
Its not necessary to have to screens.
5. ONE SCREEN MEANS:
only one screen with table control to enter data
TWO SCREEN means :
first screen : only primary key fields will appear
second screen : rest of the fields will appear to enter data
6. When the table consists of many fields,
its practically more convenient to have two screens,
so that all fields come vertically downwards.
(instead of scrolling horizontally in the table
control, in case of one screen concept)
The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.
yes u need to create a FG and the use it in Table maint. gen.
http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.
Also, Check out this weblog on table maintenance:
/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance
Table maintenance - parameter transaction:
Easier way is to regenerate the table maintenance.
In SE11 take the table and go in Change mode.
Then go to Utilities->Table Maintenance Generator.
In the next screen press the Change button. In the resulting
screen check the boxes
which are relevant and press enter.
Regards
Sreeni