regarding the table design

[Former Member]

Hi gurus,

I am a BW guy and i am very new to ABAP..i am having a scenario in which i have to track the employee's in and out time into the office and the visitor came through that employees reference...

Here my problem is i know that i have to design a screen in se51 to give all these input but i dont have any table to get these data ie emp id,empname,manager id,timein,timeout,etc...can anyone help me to create a table to get these data and the steps and code to link these table when i am giving an input in the screen painter.. i hope u understand my question..i would really apprecite and assign the maximum points

for every valuable answer...

Thanks

Rk

[Former Member]

Hi Karthik,

First u need to create a table using the fields which u have mentioned above.

Steps to create a Table

First u need to create the Domains in SE11 for all the fields.For example u want emp id,empname,manager id,timein,timeout fields.

Creation of Domain

Goto SE11 and select Domain radio Button and give the name of the Domain. The Custom name start with either Z or Y. Let us say we are creating Empid domain. So give name as ZEMPID_DM and click on Create Push button.

Now u get a screen Dictionary: Maintain Domain

Here u need to give the Short Description first and Data type and the Number of characters in Definition Tab

The DATA TYPE describes the data format at the user interface.

To see the data types place the cursor on the field and press F4. Now u get all the Data types present. Select any one Data type. Generally for Employee IDs we take Data type as Numeric NUMC and give the length of that data type. Now Save the Domain first . U can see the SAVE push button on the standard tool bar on top or press Ctrl+S to save .Now it asks for a Package. U need to save them under one package so give some package name and click on save button. Now Check for Consistencies by pressing Check button on the Application tool bar or press Ctrl+F2 after that Activate the Domain by pressing Activate Push button beside Check button on the application tool bar.

Now u can find the Status Active beside the Domain name. Like this u need to create all the Domains.

Creation of Data Elements

Goto SE11 select DATA TYPE radio button and give the data element name that u want to create. we will take an example to create the Employee ID data element. Give name ZEMPID_DE and click on Create push button.

Now u get a small pop-up Create Type ZEMPID_DE in that u can see three radio buttons

1. Data element

2.Structure

3.Table type

select Data element and press enter.

Now get a screen Dictionary : Maintain Data Element give short description and give the Domain name what we have created before ZEMPID_DM and now Maintain the Field Label. U can see the TAB named Field Label select that and maintain the Field label there. Give the name of the data element u are creating i.e., Emp ID. Maintain them in short, Medium, Long and heading also. Now Save the Data element first . U can see the SAVE push button on the standard tool bar on top or press Ctrl+S to save .Now it asks for a Package. U need to save them under one package so give some package name and click on save button. Now Check for Consistencies by pressing Check button on the Application tool bar or press Ctrl+F2 after that Activate the Domain by pressing Activate Push button beside Check button on the application tool bar.

Now u can find the Status Active beside the Data Element name. Like this u need to create all the Data Elements.

Creation of the Table

Goto Se11 initial Screen. Select the radio button Database table

and give some name to the table like ZEMP_DATA. Press Create Push button.

Here give short Description and u need to give the Delivery Class and Data Browser/Table View Maint. Give the Delivery class as A or C and Data Browser/Table View Maint. as Display/Maintenance Allowed.

Now select the Fields tab and give the filed names u want and beside that give the appropriate data element name what we have created. U need to check KEY and Initial Value check boxes to the fields u want.

Now after filling all fields and data elements, u need to fill the Technical Settings.

Press the Technical settings push button on the application tool bar. Now u can see a screen Dictionary: Display Technical Settings. Here Data Class, Size category and Buffering .

Now Save and Activate. Come back to the Main screen Save and Activate here also. You can see the Status Active beside the table name.

we can use the table only if all the objects (Domain, Dataelement and Table) are in active state.

If u have any doubts please goto to the below link.

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/7e/c81e1252c511d182c50000e829fbfe/content.htm

Here are some of the links to create Module pool (SE51).

http://help.sap.com/erp2005_ehp_03/helpdata/EN/d1/801b50454211d189710000e8322d00/frameset.htm

http://help.sap.com/erp2005_ehp_03/helpdata/EN/d1/801b5d454211d189710000e8322d00/frameset.htm

http://abaplovers.blogspot.com/2008/03/sap-abap-tutorial-module-pool.html

http://abap-gallery.blogspot.com/2007/08/screen-painter.html

Reward if helpful

raam

raam

[Former Member]

Hi

Thanks for your reply..really it was helpfull for me ...

Regards,

Rk

[Sm1tje]

I don't think there really is a need for you to create a new database table when all you need is a report for displaying the data which is already stored in SAP db tables, right?

All you really need is a report (SE38) of type 'executable program' with a selection screen for your input field(s). Next in the report select the data from the SAP database tables and output the data.

[Former Member]

hi

Here this is related to BW ,,,there is no DB tables that cotains this data already ..i have to create my own tables..

Regards,

RK