2008 Feb 21 4:30 AM
hi
i need to attach the T.code to Custom table to allow data display and access by users. this should be SE16 data browser view.
how to do this? pls help me
points will be reward
Thanks
Kumar
2008 Feb 21 5:08 AM
First u have to do some steps in table maintainance..
Here are the summarized steps for Table Maintenance
1) Go to SE11
2) In Delivery and Maintenance TAB
i) Delivery Class as A ( most of the times)
ii) Data Browser/Table View Maint. as "Display/Maintenance Allowed"
3) Enter the required fields.
4) Goto Technical Settings.Enter the appropriate data
5) Then go to Utilities-->Table Maintenance Generator
i) Enter the Authorization Group (Varies from project to project...when no authorization required give &NC& )
ii)Function Group as "Table Name"
iii)Package varies from project to project
iv)Maintenance Type as "One Step"
a)Give overview Screen Number (Your own number..but remember)
b)Single Screen "Any number"(it can be 0 also)
6) Then click on the white color create button on menu bar(Create)
7) To view the maintenance Screen Transaction is SM30(There you need to give the table name)
😎 If you want to change the description of the fields,alignment,mandatory,greying the fields,Validations and many more
goto SE51 enter program name as "SAPL(TABLE NAME) EX:SAPLZH116 and enter the screen number what you gave in the step 5,iv,a.
9)If u want to have a transaction to table maintenance
a)Go to SE93
b)Choose "Transaction with Parameters" Radio button
c)Give the Package Name which is given in 5,iii
d)Give transaction as SM30
e)Choose Skip Initial Screen
f)In GUI Support Choose all the three options
g) In the default values Tab
Name of the Screen Field Value
UPDATE X
VIEWNAME (Enter Table Name)
After doing this goto se93..in 9(a)
1.In the home page create a prgm name..
2.give the description below description choose anyone suitable to ur project
3.Give the program name and screen number
4.In sap gui area enable all the check boxes...
Regards,
2008 Feb 21 4:56 AM
hi kumar,
we can create transaction for report, module pool, parameters & varients.
i hope we cant create t-code for a table.
reward if helpful.
if u got any idea that we can crate, plz share it.
2008 Feb 21 5:06 AM
Hi Need to create t.code to view table contents. this is to be similiar to se16 data browser
2008 Feb 21 5:08 AM
First u have to do some steps in table maintainance..
Here are the summarized steps for Table Maintenance
1) Go to SE11
2) In Delivery and Maintenance TAB
i) Delivery Class as A ( most of the times)
ii) Data Browser/Table View Maint. as "Display/Maintenance Allowed"
3) Enter the required fields.
4) Goto Technical Settings.Enter the appropriate data
5) Then go to Utilities-->Table Maintenance Generator
i) Enter the Authorization Group (Varies from project to project...when no authorization required give &NC& )
ii)Function Group as "Table Name"
iii)Package varies from project to project
iv)Maintenance Type as "One Step"
a)Give overview Screen Number (Your own number..but remember)
b)Single Screen "Any number"(it can be 0 also)
6) Then click on the white color create button on menu bar(Create)
7) To view the maintenance Screen Transaction is SM30(There you need to give the table name)
😎 If you want to change the description of the fields,alignment,mandatory,greying the fields,Validations and many more
goto SE51 enter program name as "SAPL(TABLE NAME) EX:SAPLZH116 and enter the screen number what you gave in the step 5,iv,a.
9)If u want to have a transaction to table maintenance
a)Go to SE93
b)Choose "Transaction with Parameters" Radio button
c)Give the Package Name which is given in 5,iii
d)Give transaction as SM30
e)Choose Skip Initial Screen
f)In GUI Support Choose all the three options
g) In the default values Tab
Name of the Screen Field Value
UPDATE X
VIEWNAME (Enter Table Name)
After doing this goto se93..in 9(a)
1.In the home page create a prgm name..
2.give the description below description choose anyone suitable to ur project
3.Give the program name and screen number
4.In sap gui area enable all the check boxes...
Regards,
2008 Feb 21 5:17 AM
After creating table maintenance for the required table do as below.
1. Transaction: SE93
2. Enter Short Text
3. Select Radio button "Transaction with Parameters(Parameter Transaction)"
4. Next screen, give transaction as *SM30*
5. Check "Skip Initial Screen"
6. Under Detault Values tab give two rows
a. VIEWNAME for screen field and <your table name> for value
b. UPDATE for screen and 'X' as value
7. Save and Execute.
Rewards Point If helpful
2008 Feb 21 9:02 AM
Hi,
We can create a Transaction Code for a Custom table. You can follow the below steps to achieve the same. The below mentioned points worth consider after the creation of a Custom Table.
open the custom table in the change mode.
goto 'Utilities' and choose 'Table Maintenance Generator', which will navigates to you to the Transaction Code: SM30.
fill the authorization group, function group, development class, choose one step or two step for Maintenance.
choose create button in the application tool bar.
Now goto TCode: SE93
give the transaction code name.
Choose "Transaction with Parameters" Radio button.
check the 'Skip Initial Screen'.
In the default values Tab
Name of the Screen Field Value
Update X.
View Name - give our custom table name.
save the transaction code.
NOW YOU CAN USE THIS TRANSACTION CODE TO ACCESS THE CUSTOM TABLE.