topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Fri, 24 Nov 2006 09:37:59 GMT

Could any one can send me the step by step process of creating table. It's urgent...

Thank you.....

Re: Table

Former Member — Fri, 24 Nov 2006 09:39:22 GMT

Please check this thread

https://forums.sdn.sap.com/click.jspa?searchID=169277&messageID=1737026

Re: Table

former_member404244 — Fri, 24 Nov 2006 09:42:11 GMT

Hi,

Goto SE11 tcde,enter the table name and press on create vutton.

Now give the DELIVERY CLASS,and in data browser option give TABLE MAINTAINENCE ALLOWED .

nOW SPECIFY the fields in fileds list.

For currency and amount fields u need to specify the reference fields.then create the technical settings .give the data class and size category there.then activate ur table....Thats it.If u want u can maintain the table in SM30 tcode.

regards,

Nagaraj

Re: Table

Former Member — Fri, 24 Nov 2006 09:43:39 GMT

Hi,

Check out the link, you will get a better picture of it.

Regards,

Hemanth

Re: Table

Former Member — Fri, 24 Nov 2006 09:44:30 GMT

Hi Abhay,

Refer the following link:

<b>Reward points if it helps.</b>

Re: Table

Former Member — Fri, 24 Nov 2006 09:46:43 GMT

HI,

HOPE THIS WILL HELPS U LOT,

Step1 :-Create a Domain

1. Begin at the Dictionary: Initial Screen. (To get there from the SAP main menu, choose the menu path Tools->ABAP/4 Workbench, Development->ABAP/4 Dictionary.)

2. Enter the domain name in the Object Name field.

3. Choose the Domains radio button.

4. Press the Create pushbutton. You then see the Dictionary: Maintain Domain screen. The fields containing question marks are required fields.

5. Type a description of the domain in the Short Text field.

6. Fill in the Data Type field. You can put your cursor in this field and press the down arrow to display a list of allowed data types. Pick one from the list or type one in.

7. Enter a field length.

8. Press the Activate button on the Application toolbar to both save and activate the domain. The Create Object Catalog Entry screen is displayed.

9. Press the Local Object button. You are returned to the Dictionary: Maintain Domain screen.

10. Press the Back button on the Standard toolbar. This returns you to where you began this procedure, the Dictionary: Initial Screen.

Step2 :- Create a Data Element

1. Begin at the Dictionary: Initial Screen. (To get there from the SAP main menu, follow the menu path Tools->ABAP/4 Workbench, Development->ABAP/4 Dictionary.)

2. Type the data element name in the Object Name field.

3. Choose the Data Elements radio button.

4. Press the Create button. The Dictionary: Change Data Element screen appears.

5. Type short text for the data element.

6. Type a domain name and press the Enter key. If the domain exists and is active, its data type and length will appear. If you don't see a data type and length after pressing Enter, verify the name of the Data Element. If the name is correct, verify that it is active by opening a new session (use menu path System->Create Session) and displaying it in the Data Dictionary.

7. Enter field labels in the Field Label Short, Medium, Long, and Header fields. The value in the Short field should be a maximum of 10 characters, Medium should be a maximum of 15, and Long should be a maximum of 20. The value in the Header field should be the same length or shorter than the output length in the domain.

8. Press the Save button on the Standard toolbar. The Create Object Catalog Entry screen is displayed.

9. Press the Local Object button. You are returned to the Dictionary: Change Data Element screen. The Status fields contain the values New and Saved and the message "Saved without check" appears at the bottom of the window in the status bar. The Documentation button (among others) appears on the Application toolbar.

10. Press the Documentation button. The Change Data Element: Language E screen is displayed. Here you can type end user documentation. This documentation is displayed when the user requests F1 help for fields created using this data element. The first line contains the characters &DEFINITION&. This is a heading; do not change this line. Type your documentation beginning on line two. Press the Enter key to begin each new paragraph.

11. Press the Save Active button on the Application toolbar to save your text. The message "Document was saved in active status" appears in the status bar.

12. Press the Back button on the Standard toolbar. You are returned to the Dictionary: Change Data Element screen.

13. Press the Activate button on the Application toolbar. The value in the Status field changes to Act. and the message "was activated" appears in the status bar.

14. Press the Back button. You are returned to the Dictionary: Initial Screen.

Step3 :- Create a Transparent Table Using Preexisting Domains and Data Elements

1. Begin at the Dictionary: Initial Screen (To get there from the SAP main menu, use the menu path Tools->ABAP/4 Workbench, Development->ABAP/4 Dictionary).

2. Type the table name -lfa1 in the Object Name field.

3. Choose the Tables radio button.

4. Press the Create pushbutton. This takes you to the Dictionary: Table/Structure: Change Fields screen.

5. Enter short text describing the table.

6. Type an A in the Delivery Class field.

7. Tickmark the Tab.Maint.Allowed. check box.

8. In the Field Name column, enter the name of the first field of the table.

9. Tickmark the Key column if it forms part of the primary key.

10. Enter the name of a data element in the Data Elem. column.

11. Press the Enter key.

12. Look at the status bar. If you see the message "Data element is not active," the data element either does not exist or has not been activated. These are the possible reasons why you might see this message:

It has not been created.
A misspelling occurred when you created the data element.
The data element name is misspelled on the current screen.
The data element exists and the name is spelled correctly, but it is not active.

13. Check the name carefully. If the spelling is correct, double-click on it. If a data element of that name doesn't exist, you will see a dialog box titled Create Data Element. If the data element does exist, the data element itself will be displayed.

14. If you are now looking at the data element, notice the value in the Status field. The Status field must contain Act. to indicate that it is active. If it does not, press the Activate button and verify the status is now Act. (If it will not activate, turn to the Troubleshooter associated with the procedure for creating data elements.) Once the data element has been activated, press the Back button to return to the Dictionary: Table/Structure: Change Fields screen.

15. START=13

16. Repeat steps 8 though 12 for each of the remaining fields in the table (-lifnr and -name1).

17. Press the Save button on the Standard toolbar. You will then see the Create Object Catalog Entry screen.

18. Press the Local Object button. You are then returned to the Dictionary: Table/Structure: Change Fields screen.

19. Press the Technical Settings button on the Application toolbar. The ABAP/4 Dictionary: Maintain Technical Settings screen is displayed.

20. In the Data Class field, enter APPL0 (APPL0 with a zero, not with the letter O).

21. Enter 0 (zero) in the Size Category field.

22. Press the Save button.

23. Press the Back button. You are returned to the Dictionary: Table/Structure: Change Fields screen.

24. Press the Activate button on the Application toolbar. If the activation was successful, the message "was activated" appears in the status bar and the Status field contains the value Act.

25. Press the Back button to return to the Dictionary: Initial Screen.

Shan

Re: Table

Former Member — Fri, 24 Nov 2006 09:47:25 GMT

hi abhay,

goto se11..

select the radio button database table give the name..click on Create..

give short text

in Delivery and Maintenance Tab give the Delivery class

in Fields tab specify the fields...

click on technical Settings tab and give Data class and size

save and activate..

check these...

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ea43446011d189700000e8322d00/content.htm

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

hope this helps,

do reward if it helps,

Priya.

Re: Table

Former Member — Fri, 24 Nov 2006 09:51:19 GMT

Abhay

follow below steps

1) go to se11

click on the radio button tables, enter the name starting with z->create

give a short description->local object->save ->delivery class 'A'->if u want table maintenance ->check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

using sm30 you can create entries manually.

give points if helpfull

-Regards

charitha.

Re: Table

Former Member — Fri, 24 Nov 2006 09:52:03 GMT

Hi,

Do following steps useing se11

1.Create Domain

2.Create Data Element using the above created domain

(Create all domains and data element that u need for the table )

3.Create table - Table Name Ztest (eg) Click on Create button

4.Give Description of the table , Del Class (Select from the drop down list)

5.If u all table maintanence using sm30 later on then select the option for that just after del class .

6.Click on the field tab

7. Give all field name using the above created data element

8. Define key fields

9. Generate & Activate it , it will ask for package name, enter package name ....thats it....

If helpful pl reward.

Cheers.