What is the step by step process to create a table in data dictionary?
SAP ABAP questions and answers
(Continued from previous question...)
What is the step by step process to create a table in data dictionary?
Answer1
steps to create database tables
1.go to se11
2.give name the database table
3.give short description for the table
4.Give delivery class name as A and data browser / table view maint as Display/maintenence allowed
5.select fields tab
6.give field name data type(user defined element type/built-in-type),short text
7.select technical settings tab ,give data class as appl0 and size category as 0
8.save it
9.go utillities menu click table contents select create and enter the field values then select display in table contents and u can view the table values with field lables
Answer2
bottom to top approach:
_________________________
step 1:
creating a domain:
*se11,select the object type as domain ,name it ,create,description,enter the datatype and length(size),save ,activate
step2:
creating a dataelement;
se11,select the object type as :date element,name it ,create,desc,assign it with a domain what we created now,save,activate it.
step3:
creating a table;
se11,select the object type as table,name it, create,
enter the field name and assign it with the data element instead of assigning a datatype to it,
like this create req fields:
on behalf of this:
table maintainence:
assign the type of the table ie.,A C G L S
NEXT
maintaince:
allowed,not allowed ,allowed with restricions
______________________________________________
fields of a table:(as descripted above)
___________________________________________
techical settings:
A0
OR
A1
AND
BUFFERED OR NON-BUFFERED
(Continued on next question...)
Other Interview Questions
- What is an ABAP?
- What is an ABAP data dictionary?
- What are domains and data element?
- What is foreign key relationship?
- Describe data classes.
- What are indexes?
- Difference between transparent tables and pooled tables.
- What is an ABAP/4 Query?
- What is BDC programming?
- What are the functional modules used in sequence in BDC?
- What are internal tables?
- What is ITS?
- What is DynPro?
- What are screen painter and menu painter?
- What are the components of SAP scripts?
- What is ALV programming in ABAP? When is this grid used in ABAP?
- What are the events in ABAP/4 language?
- What is CTS and what do you know about it?
- What are logical databases? What are the advantages/ dis-advantages of logical databases?
- What is a batch input session?
- How to upload data using CATT ?
- What is Smart Forms?
- How can I make a differentiation between dependent and independent data?
- What is the difference between macro and subroutine?
- What is the differrences between structure and table in data dictionary in ABAP?
- What is the difference between collect and sum?
- How we format the data beofore before write statment in report ?
- What is the difference between Table and Template?
- When do we use End-of-selection?
- In evevts start-of-selection is default event. When we have to use this event explicitly? Why?
- What is the differences between ABAP and OOABAP. In which situation we use OOABAP?
- What is table buffer? Which type of tables used this buffer?
- What is the use of pretty printer ? Exactly where can we link the functional module to abap coding.
- What is the difference between SAP memory and ABAP memory?
- What is the difference between Type and Like?
- What is Tcode SE16. For what is it used. Explain briefly?
- What are different ABAP/4 editors? What are the differences?
- What is difference between dialog program and a report?
- How do you connect to the remote server if you are working from the office for the client in remote place.
- Explain about roll area , Dispatcher, ABAP-Processor.
- Which one is not an exit comand ? (Exit, cencle, stop, back)
- What is Field sysmbol ?
- What is lock object ?
- Why BAPI need then BDC ?
- What are the advantages and disadvantages of using views in ABAP porgramming ?
- How data is stored in cluster table?
- Have you used performance tuning? What major steps will you use for these?
- How to create client independent tables?
- What type of user exits have you written?
- How can you debugg a script form?
- How do we debug sapscript?
- What are the different types of data dictionary objects?
- What is the step by step process to create a table in data dictionary?
- Can a transparent table exist in data dictionary but not in the data base physically?
- What are the domains and data elements?
- What is a collect statement? How is it different from append?
- On ABAP: Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
- In the ‘select’ statement what is “group by”?
- How can I copy a standard table to make my own z_table?
- From Excel to ABAP - Is batch mode possible ?
- Q: Is there any standard SAP report which gives a count of the number of times a program is executed ?
- Q: When we create a customer the information is updated in structure RF02D and the some tables like KNA1 are updated. How can we find the tables for master data transactions?
- Q: How can we use CAD with SAP ?
- Q: How can I access SAP through Internet?
- Q: How can we transport the standard text?
- Q: How to find what transactions a particular user was running for a given period in the past (Eg: from 1st of a month )
- Q: We want protect/lock a field so that only selected people can change the value while others can only read. How to set the authorizations?
- Q: How to lock an user defined transaction for some time during which no user can access the same?
- Q: Our ABAP program is working properly in Foreground. Can I schedule it for background processing on the weekend?
- Q: How can we send a mail to the user intimating him that his report/BDC is completed in background?
- We get the total number of pages as expected by using 'SAPSCRIPT-FORMPAGES' in a duplex layout....
- Q: Can I Print a logo on an Invoice?
- We want to move a SAP table to an Access table using TABLE_EXPORT_TO_MSACCESS_RFC Importing parameters are ...
- Q: We want an RFC do the following transactions - MB1A, MB1C,>MB01 (goods receipt/issue).
- Q: In a Dev instance, we want to transport a modification to a layout set from one client to another. What is the best way?
- Q: We need to keep track of the transports that need to flow through to other systems (ie, DEV, TST, TRN, PRD etc). Is there a way do this?
- How can we want to add this additional field from a different table?
- We need to download an internal table to the Presentation Server(local workstation) ....
- We are calling transaction VL01 in batch input to create deliveries using a program for delivery due list ...
- Q: What are some sample Direct input data transfer programs?
|