Top 100+ Sap Abap Web Dynpro Interview Questions And Answers
Question 1. What Is An Abap?
Answer :
ABAP (Advanced Business Application Programming) is a high degree programming language created by the German software program organization SAP. It is currently positioned as the language for programming SAP's Web Application Server, a part of its NetWeaver platform for constructing business programs. Its syntax is truly just like COBOL.
Question 2. What Is An Abap Data Dictionary?
Answer :
ABAP four information dictionary describes the logical structures of the gadgets used in software improvement and indicates how they're mapped to the underlying relational database in tables/views.
SAP ABAP Interview Questions
Question three. What Are Domains And Data Element?
Answer :
Domains : Domain is the crucial item for describing the technical traits of an characteristic of an business objects. It describes the fee variety of the field.
Data Element : It is used to explain the semantic definition of the table fields like description the sphere. Data element describes how a field may be exhibited to cease-consumer.
Question four. What Is Foreign Key Relationship?
Answer :
A dating which may be described between tables and must be explicitly defined at discipline level. Foreign keys are used to make sure the consistency of facts. Data entered need to be checked towards present facts to make certain that there are now contradiction. While defining overseas key dating cardinality needs to be unique. Cardinality mentions what number of structured statistics or how referenced facts are feasible.
SAP ABAP Tutorial
Question 5. Describe Data Classes?
Answer :
Master statistics: It is the records that's seldom modified. Transaction data: It is the facts which is frequently changed. Organization records: It is a customizing records that is entered inside the machine when the machine is configured and is then hardly ever changed. System statistics:It is the facts which R/three system desires for itself.
Sap Abap Hr Interview Questions
Question 6. What Are Indexes?
Answer :
Indexes are described as a replica of a database desk decreased to particular fields. This information exists in sorted shape. This sorting shape ease speedy access to the sphere of the tables. In order that different fields are also examine, a pointer to the associated report of the real table are covered within the index. The indexes are activated along side the table and are created robotically with it within the database.
Question 7. Difference Between Transparent Tables And Pooled Tables?
Answer :
Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the desk in database. Its shape corresponds to single database field. Table within the database has the same call as within the dictionary. Transparent desk holds software records. Pooled tables. Pooled tables inside the dictionary has a many-to-one relation with the desk in database. Table within the database has the special call as in the dictionary. Pooled desk are saved in desk pool on the database level.
SAP ABAP Web Dynpro Tutorial SAP ABAP Dictionary Interview Questions
Question eight. What Is An Abap/four Query?
Answer :
ABAP/four Query is a effective device to generate easy reviews with none coding. ABAP/four Query can generate the following 3 easy reviews:
Basic List: It is the easy reviews.
Statistics: Reports with statistical features like Average, Percentages.
Ranked Lists: For analytical reports. - For growing a ABAP/four Query, programmer has to create user organization and a purposeful organization. Functional group may be created the usage of with or without logical database desk.
Finally, assign consumer institution to useful organization. Finally, create a query at the purposeful group generated.
Question nine. What Is Bdc Programming?
Answer :
Transferring of large/outside/legacy records into SAP machine the usage of Batch Input programming. Batch input is a automated technique known as BDC(Batch Data Communications). The principal factor of the transfer is a queue document which gets the information vie a batch input packages and agencies related statistics into “classes”.
SAP ABAP Enhancement Interview Questions
Question 10. What Are The Functional Modules Used In Sequence In Bdc?
Answer :
These are the three practical modules which might be utilized in a chain to perform a facts switch correctly the use of BDC programming:
BDC_OPEN_GROUP - Parameters like Name of the consumer, sessions and consumer name are particular in this useful modules.
BDC_INSERT - It is used to insert the statistics for one transaction into a session.
BDC_CLOSE_GROUP - This is used to shut the batch input session.
Question eleven. What Are Internal Tables?
Answer :
Internal tables are a popular data kind object which exists simplest at some stage in the runtime of this system. They are used to perform desk calculations on subsets of database tables and for re-organizing the contents of database tables according to users want.
SAP ABAP Module Pool Interview Questions
Question 12. What Is Its?
Answer :
ITS is a Internet Transaction Server. ITS forms an interface between HTTP server and R/3 gadget, which converts screen supplied information through the R/3 device into HTML documents and vice-versa. Merits of ITS: A complete net transaction can be advanced and examined in R/3 machine. All transaction additives, which include the ones used by the ITS out of doors the R/3 machine at runtime, may be stored inside the R/three device. The benefit of automatic language processing in the R/3 system can be utilized to language-established HTML documents at runtime.
SAP ABAP Interview Questions
Question 13. What Is Dynpro?
Answer :
DynPro is a Dynamic Programming which is a mixture of display and the associated glide logic Screen is likewise called as DynPro.
Question 14. What Are Screen Painter And Menu Painter?
Answer :
Screen painter : Screen painter is a device to layout and hold display screen and its factors. It permits consumer to create GUI displays for the transactions. Attributes, layout, filed attributes and waft good judgment are the factors of Screen painter. Menu painter: Menu painter is a device to layout the interface components. Status, menu bars, menu lists, F-key settings, capabilities and titles are the components of Menu painters. Screen painter and menu painter both are the graphical interface of an ABAP/four packages.
Question 15. What Are The Components Of Sap Scripts?
Answer :
SAP scripts is a word processing tool of SAP which has the following additives: Standard textual content. It is like a trendy regular files. Layout sets. - Layout set includes the subsequent additives: Windows and pages, Paragraph codecs, Character formats. Creating paperwork within the R/three machine. Every layout set includes Header, paragraph, and man or woman string. ABAP/4 application.
SAP ABAP Report Developer Interview Questions
Question 16. What Is Alv Programming In Abap? When Is This Grid Used In Abap?
Answer :
ALV is Application List viewer. Sap offers a hard and fast of ALV (ABAP LIST VIEWER) feature modules which can be placed into use to embellish the output of a document. This set of ALV functions is used to decorate the clarity and functionality of any file output. Cases arise in sap when the output of a file includes columns extending greater than 255 characters in period. In such instances, this set of ALV capabilities can help select selected columns and set up the distinctive columns from a record output and also shop special editions for report show. This is a completely green tool for dynamically sorting and arranging the columns from a document output. The report output can include up to ninety columns within the show with the wide array of display alternatives.
Question 17. What Are The Events In Abap/4 Language?
Answer :
Initialization, At choice-display, Start-of-selection, cease-of-choice, pinnacle-of-web page, end-of-web page, At line-selection, At person-command, At PF, Get, At New, At LAST, AT END, AT FIRST.
SAP ABAP Data Dictionary Interview Questions
Question 18. What Is Cts And What Do You Know About It?
Answer :
The Change and Transport System (CTS) is a device that helps you to prepare development tasks inside the ABAP Workbench and in Customizing, and then shipping the adjustments among the SAP Systems and customers on your machine landscape. This documentation offers you with a top level view of a way to manipulate changes with the CTS and important records on putting in your system and patron panorama and selecting a transport strategy. Read and observe this documentation when planning your improvement mission.
Sap Abap Hr Interview Questions
Question 19. What Are Logical Databases? What Are The Advantages/ Dis-benefits Of Logical Databases?
Answer :
To read data from a database tables we use logical database. A logical database gives study-handiest access to a collection of associated tables to an ABAP/4 program.
Advantages:
take a look at capabilities which check that user enter is complete, accurate,and possible.
Meaningful statistics choice.
Critical authorization exams for database accesses.
Accurate study get entry to performance at the same time as retaining the hierarchical information view decided via the application common sense.
Dis advantages:
If you donot specify a logical database within the program attributes,the GET occasions by no means occur.
There is not any ENDGET command,so the code block related to an event ends with the following occasion statement (along with every other GET or an END-OF-SELECTION).
Question 20. What Is A Batch Input Session?
Answer :
BATCH INPUT SESSION is an intermediate step among internal table and database desk. Data at the side of the motion is stored in consultation ie facts for display fields, to which screen it's miles exceeded, software name in the back of it, and the way subsequent display is processed.
SAP ABAP ALV Reports Interview Questions
Question 21. How To Upload Data Using Catt ?
Answer :
These are the stairs to be followed to Upload records via CATT: Creation of the CATT test case & recording the pattern facts input. Download of the source file template. Modification of the supply file. Upload of the facts from the source report.
Question 22. What Is Smart Forms?
Answer :
Smart Forms lets in you to create paperwork the usage of a graphical layout tool with strong capability, colour, and extra. Additionally, all new paperwork evolved at SAP can be created with the new Smart Form solution.
Question 23. How Can I Make A Differentiation Between Dependent And Independent Data?
Answer :
Client dependent or unbiased switch necessities include purchaser unique or move purchaser gadgets within the change requests. Workbench objects like SAPscripts are customer precise, a few entries in customizing are patron impartial. If you show the object listing for one change request, after which for every item the item attributes, you may locate the flag purchaser specific. If one item inside the mission list has this flag on, then that shipping might be customer dependent.
Question 24. What Is The Difference Between Macro And Subroutine?
Answer :
Macros can best be used inside the program the are defined in and only after the definition are expanded at compilation / technology. Subroutines (FORM) may be called from each this system the are described in and different packages . A MACRO is extra or less an abbreviation for a few traces of code which are used more than a couple of times. A FORM is a neighborhood subroutine (which may be referred to as external). A FUNCTION is (extra or much less) a subroutine that is called external. Since debugging a MACRO is not virtually viable, prevent the usage of them (I’ve never used them, but seen them in movement). If the subroutine is used handiest local (referred to as inner) use a FORM. If the subroutine is called external (used by more than one software) use a FUNCTION.
SAP ABAP Dictionary Interview Questions
Question 25. What Is The Differences Between Structure And Table In Data Dictionary In Abap?
Answer :
Structure and desk each are 2/2 matrices but there are numerous variations among desk and structure.
Table can store the records physically but a shape dose not keep.
Table could have primary key however a shape dose not have.
Table may have the technical characteristic but a shape dose no longer have.
Shape would not incorporate technical attributes.
Shape does not include primary key.
Shape doesn't shops underline database degree.
Question 26. How We Format The Data Before Before Write Statement In Report ?
Answer :
We can layout the reports output with the aid of the use of the loop occasions like:
1.In the beginning
2.At new
3.At closing .And so on....
Question 27. What Is The Difference Between Table And Template?
Answer :
table is a dynamic and template is a static.
SAP ABAP Enhancement Interview Questions
Question 28. When Do We Use End-of-choice?
Answer :
End-of-choice occasion are mostly used while we're writing HR-ABAP code. In the HR-ABAP code, statistics is retrived within the Start-of-choice event and Printing at the listing and all will be accomplished in End-of-choice occasion.
Question 29. In Events Start-of-selection Is Default Event. When We Have To Use This Event Explicitly? Why?
Answer :
The default occasion within the ABAP is Start-of-selection.We have to call explicitely this occasion when you are writing apart from ths occasion that is while you write AT SELECTION-SCREEN EVENTS OR INITIALIZATION EVENT etc,you need to explicitely point out the Start-of-selection occasion even as you are writing the good judgment. Before these events known as ,all the code you have written come into this default Start-of-choice display event.
Question 30. What Is The Differences Between Abap And Ooabap. In Which Situation We Use Ooabap?
Answer :
OOABAP is used to expand BSP/PCUI programs and additionally anthing involved item oriented like BADIs, SmartForms..And many others.Where as ABAP is used to broaden traditional packages in R/3.
Question 31. What Is Table Buffer? Which Type Of Tables Used This Buffer?
Answer :
buffer is not anything but a memory location. Desk is buffered way that table facts is available on utility server. While you name records from database table it'll come from application server.Transperent and pooled tables are buffered. Cluster tables can't buffered.
Question 32. What Is The Use Of Pretty Printer ?
Answer :
Exactly wherein are we able to link the practical module to abap coding.
Pretty Printer is used to layout the ABAP Code we write in ABAP Editor ,like KEY WORDS in Capitals and final are in small letters which is likewise rely on device settings.
We can call the characteristic module inside the ABAP Code .Press the Pattern button on Appl. Device bar then u gets container in which u write the feature module NAME which u need to name in the code through deciding on the radio button CALL FUNCTION. In this way we link function module to ABAP Code.
Question 33. What Is The Difference Between Sap Memory And Abap Memory?
Answer :
data sending among major periods the use of get parameter and set parameter is sap memory.
Information sending among inner periods using import or export parameters is abap reminiscence.
SAP ABAP Module Pool Interview Questions
Question 34. What Is The Difference Between Type And Like?
Answer :
TYPE, you assign datatype at once to the information object while asserting.
LIKE,you assign the datatype of every other object to the asserting information object. The datatype is referenced in a roundabout way.
Question 35. What Is Tcode Se16. For What Is It Used. Explain Briefly?
Answer :
SE16 is a T-code for item browser. Generally used to look the fields of SAP Tables and respective facts.
Question 36. What Are Different Abap/four Editors? What Are The Differences?
Answer :
The 2 editors are se38 and se80 both have the abap editor in vicinity. In se38 you may cross create packages and consider online reviews and basically do all thedevelopmet of gadgets in this editor. In se80 (item navigator) there are additional capabilities along with creating applications,module pool , characteristic organization ,classes, programs (where you can create ur programs) and BSP packages .
SAP ABAP Report Developer Interview Questions
Question 37. What Is Difference Between Dialog Program And A Report?
Answer :
Report is a excecutable software.
Dialog is a module pool software.It needs to be achieved thru a transaction best. Dialog programming is used for personalization ofscreens.
Question 38. How Do You Connect To The Remote Server If You Are Working From The Office For The Client In Remote Place?
Answer :
WAS web utility server or ITS are generally used for this reason. If you're sitting at your office with a server that's in the gadget and the alternative server is at the clients vicinity you can generate IDOC, intermidiate files which bring the records you want to transfer or the files you need to switch, these IDOC are interpretted via the machine on the recieving cease with the message class with which it is sure with. If you need to logon a machine which may be very remote..Then faraway login may be used this depends at the net velocity.
Question 39. Explain About Roll Area , Dispatcher, Abap-processor?
Answer :
Dispatcher recieves the request from patron and assigns the request to one of the paintings manner.
Roll vicinity: Each workprocess works in a particular memory that reminiscence is referred to as Role Area, which includes User context and session facts.
ABAP- Processor :is an interpretor that could execute good judgment
Question 40. What Is Lock Object ?
Answer :
LockObjects used to synchornize get entry to of several users the use of equal information.
SAP ABAP Data Dictionary Interview Questions
Question forty one. Why Bapi Need Then Bdc?
Answer :
BAPI'S provide the standard interface to different packages apart from SAP and within differnt vesions of SAP too. Also it is OOD bases so doesn't depends on screen float. BDC gets failed if we make modifications for display screen modifications via IMG customization.
Question forty two. What Are The Advantages And Disadvantages Of Using Views In Abap Programming ?
Answer :
blessings:
view is used to retrieve the information very fastly from the database tables.
Reminiscence wastage is decreased.
Faster than joins to retrieve the information from database tables.
Dangers:
view isn't a box,it will now not keep the records.
View reminiscence isn't always everlasting memory.
SAP ABAP ALV Reports Interview Questions
Question 43. How Data Is Stored In Cluster Table?
Answer :
A cluster desk conatins facts from mulitple DDIC tables. It stores facts as a call fee pair ( varkey, vardata).
Question 44. Have You Used Performance Tuning? What Major Steps Will You Use For These?
Answer :
First of all tunning can be executed In three approaches: disk i/o ,square tunning , memory tunning, Before tunning u have to get the popularity of your database the usage of Oracle application known as statpack , tkprof, then you definitely should pass for tunning.
Question forty five. What Type Of User Exits Have You Written?
Answer :
There are 4 types
function exit
menu go out
display screen exit.
Discipline go out.
These are the person exits
Question 46. How Can You Debug A Script Form?
Answer :
SE71 -> supply the form name -> utilities -> activate debugger.
Question 47. How Do We Debug Sapscript?
Answer :
First we need to put Break point in Print software wherein ever you want to prevent the execution. After in SE71 give your shape call and visit Utilities-->Active De-bugger. Then visit your transcation like VF03(for Invoice or Credit memo) etc to peer the print preview or print the shape execute it. When you execute it the the shape Debugging will get activated and you could see your Form execution grade by grade.
Question 48. What Are The Different Types Of Data Dictionary Objects?
Answer :
Data Dictionary Objects are:
Tables.
Views.
Domain.
Data Element.
Type Groups.
Search Helps/Matchcode Objects.
Lock items.
Structures.
Table Types.
Question forty nine. What Is The Step By Step Process To Create A Table In Data Dictionary?
Answer :
steps to create database tables:
visit promote.
Provide name the database desk.
Provide brief description for the table.
Give delivery elegance call as A and information browser / desk view maint as Display/maintenence allowed.
Choose fields tab.
Deliver subject name information type(consumer described detail kind/integrated-type),short textual content.
Select technical settings tab ,deliver facts elegance as appl0 and size category as zero.
Keep it.
Move utillities menu click table contents choose create and input the field values then select show in desk contents and u can view the table values with area lables.
Question 50. Can A Transparent Table Exist In Data Dictionary But Not In The Data Base Physically?
Answer :
NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE BOTH IN THE DICTIONARY AS WELL AS IN THE DATABASE,EXACTLY WITH THE SAME DATA AND FIELDS. No, at the factor you may prompt your desk a equal obvious table goes to be create in database.
Question 51. What Are The Domains And Data Elements?
Answer :
domains:
domain names are the dictionary objects which are assigned with constants and statistics sorts.
Records factors:
records factors are dictionary gadgets that are assigned with the domain names.
Makes use of:
facts factors are used to create relation between tables.
Data elements are used to transfer the data from one R/3 to some other R/three.
To create seek enables.
Question 52. In The 'choose' Statement What Is "group By"?
Answer :
Group by using clause is used to fetch the information from the table by means of the specified area ex.Pick out matter (*) from emptable organization by using deptno wherein deptno = 1. It is used to find the range of personnel gift inside the specified branch no.
Question 53. How Can I Copy A Standard Table To Make My Own Z_table?
Answer :
WE CAN CREATE A STRUCTURE LIKE THE SAME STRUCTURE AS DATABASE TABLE AND WE CAN USE
SELECT* FROM DATABASE TABLE INTO TABLE ITAB.
OR
INSERT INTO ITAB VALUES DATABASE TABLE.
Question fifty four. What Is Sap R/three?
Answer :
SAP R/three refers to Systems Application and Product for statistics processing Real-time having a three tier architecture i.E. Presentation layer, Application layer and Database layer.
Question fifty five. What Are The Contents In Technical Specifications?
Answer :
There are 5 contents in Technical Settings: Data Class, Size Category, Buffering Permission, Buffering Type and Logging.
Question fifty six. What Is An Instance?
Answer :
When you call a feature module, an example of its feature institution plus its information, is loaded into the reminiscence region of the inner session. An ABAP software can load several times through calling feature modules from distinct feature agencies.
Question 57. What Is Function Group? Difference Between Function Group And Function Module?
Answer :
Function Groups act as bins for Function Modules that logically belong together.
Function Groups:
These can't be defined in a Function Module.
It cannot be referred to as.
They are boxes for Function Module.
Function Modules:
These have to be described in a Function Group.
It can be known as from any software.
They are not boxes for Function Group.
Question 58. What Is The Difference Between 'pick Single * ' And 'choose Upto 1 Rows'?
Answer :
Select single *- It can work on the paintings region now not at the inner table. It has no endselect.
Select * upto 1 rows- It can be implemented in Internal desk and work location both. It has endselect.
Question fifty nine. What Function Does Data Dictionary Perform?
Answer :
Central information repository for software and machine facts. The ABAP Dictionary includes facts definitions (metadata) that assist you to describe all the statistics systems inside the system (like tables, perspectives, and statistics types) in one location. This eliminates redundancy.
Question 60. What Is View? Different Types Of View. Explain?
Answer :
View - A view is a virtual desk containing fields from one or extra tables. A digital table that does not incorporate any statistics, however instead offers an utility-oriented view of one or more ABAP Dictionary tables.
Different Types of View:
Maintenance
Database – It is on greater than tables.
Projection – It is best on one desk.
Help.
Question sixty one. What Is Sequence Of Event Triggered In Report?
Answer :
There are 6 activities in record:
Initialization.
At Selection-Screen.
Start-of-Selection.
Get.
Get Late.
End-of-Selection.
Top-of-Page.
End-of-Page.
At Line Selection.
At User Command.
At PF (nn).
Question sixty two. What Are Standard Layouts Sets In The Sap Script?
Answer :
There are 4 preferred layouts inside the SAP Script:
Header.
Logo.
Main Window.
Footer.
Question 63. What Are The Various Types Of Selection Screen Event?
Answer :
SELECTION-SCREEN BEGIN OF BLOCK ABC WITH FRAME TITLE T01.
SELECTION-SCREEN BEGIN OF SCREEN 500 AS WINDOW.
CALL SELECTION-SCREEN 500 STARTING AT 10 10.
Question sixty four. What Are The System Fields? Explain?
Answer :
The ABAP system fields are lively in all ABAP programs. They are filled by using the runtime environment, and you may query their values in a application to find out particular states of the system. Although they're variables, you need to now not assign your own values to them, seeing that this could overwrite facts this is vital for the ordinary running of the program. However, there are some isolated cases wherein you may want to overwrite a machine variable. For instance, by using assigning a new price to the sector SY-LSIND, you may manage navigation within info lists.
Question sixty five. What Is Sap Script? What Is The Purpose Of Sap Script? Difference Between Sap Script And Report?
Answer :
SAP Script – It is the integrated text management system of the SAP R/three System. Two kinds – PC Editor & Line Editor.
Reports - It is the manner to display statistics fetched from database desk onto screen or without delay output it to a printer. Two kinds – Classical and Interactive.
Question sixty six. What Is A Logical Database?
Answer :
Logical Databases are special ABAP applications that retrieve facts and make it available to application applications. Use of LDB – is used to study records from database tables by means of linking them to executable ABAP applications.
Question 67. What Are The Events Used For Logical Database?
Answer :
Two Events –
GET - This is the maximum important occasion for executable programs that use a logical database. It takes place whilst the logical database has examine a line from the node and made it available to the program in the work area declared using the statement NODES. The intensity to which the logical database is study is determined via the GET statements.
PUT - The PUT declaration directs this system go with the flow in keeping with the shape of the logical database.
Question 68. What Is The Difference Between Get And Get Late?
Answer :
GET - After the logical database has read an access from the node.
GET LATE - After all the nodes of the logical database had been processed which can be within the database hierarchy.
Question sixty nine. What Are The Data Types Of Internal Tables?
Answer :
There are 3 kinds:
Line.
Key.
Table.
Question 70. What Are The Events Used In Abap In The Order Of Execution?
Answer :
Events are:
1.INITIALIZATION.
2. AT SELECTION-SCREEN.
Three. AT SELECTION-SCREEN ON <field>.
4. START-OF-SELECTION.
5. TOP-OF-PAGE.
6. TOP-OF-PAGE DURING LINE SELECTION.
7. END-OF-PAGE.
8. END-OF-SELECTION.
9. AT USER-COMMAND.
10.AT LINE-SELECTION.
11.AT PF<NN>.
12.GET.
Thirteen.GET LATE.
14. AT User Command.
Question seventy one. What Are Interactive Reports?
Answer :
An output list which shows simply the primary info & permit person to engage, in order that a brand new list is populated based totally on consumer-selection. With interactive listing, the consumer can actively manage records retrieval and show during the session.
Question 72. What Are The Commands Used For Interactive Reports?
Answer :
Top-of-Page in the course of line-choice.
Question seventy three. What Is The Difference Between Primary Key And Unique Key?
Answer :
Primary Key – It can accepts zero value and can't be NULL.
Unique Key – It can be NULL.
Question 74. What Is The Transaction Code For Table Maintenance?
Answer :
SM30.
Question seventy five. If U Are Using Logical Databases How Will U Modify The Selection-screen Elements?
Answer :
Select-alternatives : dname for deptt-dname.
Question seventy six. What Is An Rfc?
Answer :
Remote Function Call.
Question 77. What Is The Significance Of Hide?
Answer :
It stores the press value and show the related file inside the secondary list.
Question 78. Where Do U Code The Hide Statement?
Answer :
In a LOOP declaration.
Question seventy nine. Types Of Bdc's?
Answer :
There are varieties of BDC’s:
Transaction Method.
Session Method.
Question eighty. What Are The Events Used In Interactive Reports?
Answer :
There are three events of Interactive Reports:
At PF(nn).
At line-choice.
At consumer-command.
Question eighty one. What Is An Rdbms?
Answer :
RDBMS – Relational Database Management System. It facilitates to create relationship between two or more desk.
Question eighty two. What Are Joins And Different Types Joins?
Answer :
There are 4 varieties of Joins:
Self Join.
Inner Join.
Outer Join.
Equi Join.
Question eighty three. How Do U Display A Data In A Detail List?
Answer :
By the usage of two statements:
Top-of-web page at some stage in line-choice
At line-selection
Question 84. What Are The Types Of Windows In Sap Script?
Answer :
There are five Standard Layouts in SAP Script:
Page.
Window.
Page Window.
Paragraph Format.
Character Format.
Question 85. What Are The Function Modules Used In A Sap Script Driver Program?
Answer :
There are 3 functions used in SAP Script:
OPEN_FORM.
WRITE_FORM.
CLOSE_FORM.
Question 86. What Are Extracts?
Answer :
Extracts are dynamic sequential datasets wherein extraordinary strains may have exclusive systems. We can get right of entry to the character statistics in an extract dataset using a LOOP.
Question 87. What Is Luw?
Answer :
Logical Unit of Work.
Question 88. Different Types Of Luws. What Are They?
Answer :
Two styles of LUW are:
DB LUW - A database LUW is the mechanism used by the database to make sure that its records is usually consistent. A database LUW is an inseparable sequence of database operations that ends with a database dedicate. The database LUW is both completely performed by the database gadget or never. Once a database LUW has been successfully performed, the database could be in a steady country. If an errors happens within a database LUW, all the database modifications due to the fact the beginning of the database LUW are reversed. This leaves the database within the nation it had before the transaction started.
SAP LUW - A logical unit together with conversation steps, whose modifications are written to the database in a single database LUW is known as an SAP LUW. Unlike a database LUW, an SAP LUW can span several dialog steps, and be finished using a series of different work processes.
Question 89. How Do U Find Out Whether A File Exits On The Presentation Server?
Answer :
eps_get_directory_listing for listing.
Question ninety. If Internal Table Used In For All Entries In Empty Then What Happens?
Answer :
No, information can be displayed.
Question ninety one. If I Forgot Some Command In Sap Script E.G.: Suppress Zero Display - How To Do Find It?
Answer :
Suppressing of whole monitors is possible with this command. This command allows us to carry out screen processing "within the historical past". Suppressing displays is beneficial whilst we're branching to listing-mode from a transaction conversation step.
Question 92. How To Write A Bdc - How Do U Go About It?
Answer :
Steps for writing BDC:
inSE38.
Declare Tables, Data (for ITAB) and Data (for BDCITAB).
Call function 'Upload'.
Write code for the First Screen, Radio Button, Filename, Change Button, Second Screen, Utilities (Create Entries), Third Screen and Save.
Call transaction 'SEll' the use of BDCITAB mode 'A'.
Save, Check Errors, Activate and Execute.
Question 93. How Do U Move On To The Next Screen In Interactive Reporting?
Answer :
Write code of the following:
Top-of-Page throughout line-choice.
At line-selection.
Question ninety four. Function Modules Used In F4 Help?
Answer :
There are two styles of function modules utilized in F4 help:
F4IF_FIELD_VALUE_REQUEST.
F4IF_INT_TABLE_VALUE_REQUEST.
Question ninety five. Work Most On Which Module: Name A Few Tables?
Answer :
Sales & Distribution Module:
Sales Document: Item Data – VBAP.
Sales Document: Partner – VBPA.
Sales Document: Header Data – VBAK.
Sales Document Flow – VBFA.
Sales Document: Delivery Item Data - LIPS.
Customer Master – KNA.
Material Data – MARA.
Conditions (Transaction Data) - KONV.
Question ninety six. What Is Read Line?
Answer :
READ LINE and READ CURRENT LINE – These statements are used to read information from the traces of existing list levels. These statements are carefully linked to the HIDE method.
Question 97. What Are The Differences Between Sap Memory And Abap Memory?
Answer :
ABAP Memory is a reminiscence area within the inner session (roll place) of an ABAP program. Data within this location is retained within a series of software calls, allowing you to pass statistics between applications that call each other. It is likewise viable to skip facts between classes the use of SAP Memory.
SAP Memory is a memory location to which all sessions inside a SAPgui have get right of entry to. You can use SAP reminiscence both to skip records from one software to another within a session (as with ABAP reminiscence) or to skip information from one session to every other.
Question 98. What Are Differences Between At Selection-display screen And At Selection-display screen Output?
Answer :
AT SELECTION-SCREEN event is triggered in the PAI of the selection display screen once the ABAP runtime surroundings has passed all the input facts from the choice screen to the ABAP software.
AT SELECTION-SCREEN OUTPUT - This occasion block allows you to regulate the choice display screen immediately before it's far displayed.
Question ninety nine. What Is Get Cursor Field?
Answer :
GET CURSOR announcement transfers the name of the screen detail on which the cursor is located in the course of a consumer movement into the variable <f>.
GET CURSOR FIELD <f> [OFFSET <off>] [LINE <lin>] [VALUE <val>] LENGTH <len>].
Question a hundred. What Is The Inside Concept In Select-alternatives?
Answer :
Select-alternatives specify are displayed on the choice display screen for the person to enter values.
Different Properties of Select-alternatives:
Visible Length.
Matchcode Object.
Memory ID.
Lowercase.
Obligatory.
No Display.
Modify ID.
Question one zero one. What Is The Difference Between Free And Refresh?
Answer :
Free - You can use FREE to initialize an internal table and launch its memory space with out first the usage of the REFRESH or CLEAR statement. Like REFRESH, FREE works on the desk body, now not on the desk work location. After a FREE announcement, you could address the inner table again. It nonetheless occupies the amount of reminiscence required for its header (presently 256 bytes). When you top off the table, the system has to allocate new reminiscence space to the lines.
Refresh - This continually applies to the frame of the desk. As with the CLEAR declaration, the memory utilized by the table earlier than you initialized it stays allotted. To launch the reminiscence space, use the declaration.
Question 102. Can We Have More Than One Selection-display screen And How?
Answer :
Yes, we can have more than one choice screen:
Selection-screen begin of block honey with frame identify textual content-a hundred and one.
Select-alternatives : deptno for zrekha_deptt-deptno.
Selection-screen end of block honey.
Selection-display screen begin of block honey1 with frame name textual content-102.
Select-alternatives : dname for zrekha_deptt-dname.
Selection-display give up of block honey1.
Question 103. How To Declare Select-alternative As A Parameter?
Answer :
SELECT-OPTIONS: specify are displayed on the selection screen for the consumer to enter values.
Parameters: dname like dept-dname.
Select-options: dname for dept-dname.
Question 104. How Can U Write Programmatically Value Help To A Field Without Using Search Help And Match Codes?
Answer :
By the usage of two types of function modules to be called in SAP Script:
HELP_OBJECT_SHOW_FOR_FIELD.
HELP_OBJECT_SHOW.
Question a hundred and five. What Are The Differences Between Se01, Se09 And Se10?
Answer :
SE01 - Correction & Transport Organizer.
SE09 - Workbench Organizer.
SE10 - Customizing Organizer.
Question 106. What Are Tables?
Answer :
Tables : ZREKHA_EMP. It creates a shape – the table work region in a application for the database tables, perspectives or shape ZREKHA_EMP. The desk work area has the same name as the item for which we created it. ZREKHA_EMP should be declared within the ABAP dictionary. The name and series of fields within the desk work location ZREKHA_EMP corresponds precisely to the collection of fields within the database desk, view definition inside the ABAP dictionary.
Question 107. What Is The Use Of Table Maintenance Allowed?
Answer :
Mark the Table maintenance allowed flag if users with the corresponding authorization may also change the records in the table the use of the Data Browser (Transaction SE16). If the facts in the table should best be maintained with packages or with the table view maintenance transaction (Transaction SM30), you must now not set the flag.
Question 108. How To Define Selection Screen?
Answer :
Parameters, Select-options & Selection-Screen.
Question 109. What Is The Difference Between Tables And Structures?
Answer :
Tables:
Data is completely stored in tables inside the database.
Database tables are generated from them.
Structure:
It carries records briefly for the duration of software run-time.
No Database tables are generated from it.
Question 110. What Is The Difference Between Open_form And Close_form?
Answer :
OPEN_FORM – This module opens format set printing. This feature must be called up before we are able to paintings with different layout set function like WRITE_FORM.
WRITE_FORM – Output text detail in form window. The special detail of the layout set window entered is output. The detail have to be defined inside the format set.
CLOSE_FORM – End layout set printing. Form printing started out with OPEN_FORM is completed. Possible remaining operations at the form closing opened are accomplished. Form printing have to be completed with the aid of this characteristic module. If this is not done, nothing is printed or displayed on the screen.
Question 111. What Are The Page Windows?
Answer :
Page Window- In this window, we outline the margins for left, width, higher and peak for the layout of Header, Logo, Main, & Footer.
Question 112. How To Debugg A Script?
Answer :
Go to SE71, provide layout set name, go to utilities choose debugger mode on.
Question 113. How Many Maximum Sessions Can Be Open In Sapgui?
Answer :
There are most 6 periods open in SAPgui.
Question 114. What Are Session Method And Call Transaction Method And Explain About Them?
Answer :
Session approach – Use the BDC_OPEN_GROUP to create a consultation. Once we have created a session, then we are able to insert the batch enter records into it with BDC_INSERT. Use the BDC_INSERT to feature a transaction to a batch enter session. We specify the transaction that is to be started out in the call to BDC_INSERT. We need to offer a BDCDATA structure that contains all the records required to technique the transaction completely. Use the BDC_CLOSE_GROUP to shut a consultation after we have inserted all of our batch enter data into it. Once a consultation is closed, it is able to be processed.
Call Transaction - In this approach, we use CALL TRANSACTION USING to run an SAP transaction. External information does now not need to be deposited in a consultation for later processing. Instead, the entire batch enter method takes vicinity inline in our software.
Question 115. If You Have 10000 Records In Your File, Which Method You Use In Bdc?
Answer :
Call transaction is faster then session approach. But generally we use consultation method in real time...Due to the fact we will switch huge amount of statistics from inner desk to database and if any errors in a session, then system will now not entire till session get accurate.
Question 116. What Are Different Modes Of Call Transaction Method And Explain Them?
Answer :
There are three modes of Call Transaction method:
A – Display All Screens.
E – Display Errors.
N – Background Processing.
Question 117. What Is The Typical Structure Of An Abap Program?
Answer :
HEADER, BODY, FOOTER.
Question 118. What Is The Alternative To Batch Input Session?
Answer :
Call Transaction Method & Call Dialog.
Question 119. What Are The Problems In Processing Batch Input Sessions? How Is Batch Input Process Different From Processing On Line?
Answer :
Two Problems: -
If the user forgets to opt for preserve session then the consultation might be mechanically removed from the session queue (log remains). However, if consultation is processed we may additionally delete it manually.
If consultation processing fails, facts will not be transferred to SAP database table.
Question a hundred and twenty. Is Session Method, Asynchronous Or Synchronous?
Answer :
Synchronous.
Question 121. How To Schedule A Report In Background? What Is The Use Of Background Job Please Explain About It?
Answer :
There are three methods to schedule in background:
SM36
SE38
SA38
The simplest of the three is SA38.
In foreground jobs are simplest allowed a certain quantity of runtime. Long running jobs usually instances out in foreground, and must be run background. Some clients has day-give up jobs to fill custom tables, and those best run overdue at night time, so they are scheduled as heritage jobs as nicely. There can be any of one hundred reasons why you need a job to run in background as opposed to foreground, and those are handiest 2 of them.
Question 122. What Are Hashed Tables?
Answer :
Hashed tables - This is the maximum appropriate kind for any desk wherein the principle operation is fundamental get admission to. You can not get right of entry to a hashed table the use of its index. The response time for key get admission to stays steady, no matter the quantity of desk entries. Like database tables, hashed tables continually have a unique key. Hashed tables are useful if you need to construct and use an inner desk, which resembles a database desk or for processing huge amounts of data.
SAMPLE PROG: THIS DOES NOTHING.
REPORT Z_1 .
TABLES: MARA.
DATA: I TYPE HASHED TABLE OF MARA WITH UNIQUE KEY MATNR.
Question 123. What Are Pooled Table?
Answer :
Table swimming pools (swimming pools) and desk clusters (clusters) are unique desk types within the ABAP Dictionary. The statistics from numerous distinctive tables can be stored together in a table pool or desk cluster. Tables assigned to a table pool or table cluster are known as pooled tables or cluster tables.
A desk within the database in which all information from the pooled tables assigned to the table pool are saved corresponds to a table pool. The definition of a pool consists essentially of key fields (Tabname and Varkey) and a protracted argument area (Vardata).
Table Clusters Several logical statistics records from specific cluster tables may be stored together in a single bodily document in a desk cluster.
A cluster key includes a chain of freely definable key fields and a area (Pageno) for distinguishing continuation records. A cluster additionally includes an extended area (Vardata) that contains the contents of the data fields of the cluster tables for this key. If the facts does now not healthy into the lengthy subject, continuation statistics are created. Control facts on the shape of the facts string continues to be written at the start of the Vardata subject.
Question 124. What Are The Types Of Tables?
Answer :
Transparent table.
Cluster table are facts dictionary table items.
Indexed table.
Internal tables.
Pool table.
Sorted desk.
Hash desk.
Question a hundred twenty five. For Sales Document: Item Data, Which Table Is Used?
Answer :
VBAP – Sales Document, Sales Document Item, Material Number, Material Entered, Batch Number, Material Group, Target Quantity in Sales Document.
Question 126. What Is Cardinality?
Answer :
For cardinality one out of (domain or facts element) should be the identical for Ztest1 and Ztest2 tables. M:N Cardinality specifies the quantity of structured(Target) and unbiased (source) entities which may be in a relationship.
Question 127. What Do You Define In The Domain And Data Element?
Answer :
Domain - Technical details are described in Domain like statistics type, wide variety of decimal places and length.
Data Element – Functionality information are described in Data factors – Field Text, Column Captions, Parameters ID, and Online Field Documentation.
Question 128. What Are The Fields In A Bdc_tab Table?
Answer :
PROGRAM, DYNPRO, DYNBEGIN, FNAM, FVAL.
Question 129. What Is The Structure Of A Bdc Sessions?
Answer :
BDCDATA (popular structure).
Question a hundred thirty. What Has To Be Done To The Packed Fields Before Submitting To A Bdc Session?
Answer :
Fields converted into character type.
Question 131. What Is Difference Between Session Method And Call Transaction?
Answer :
Call Transaction –
1. Single transaction.
2. Synchronous processing.
3. Asynchronous and Synchronous update.
Four. No session log is created.
Five. Faster.
Session –
1. Multiple Transaction.
2. Asynchronous processing.
3. Synchronous replace.
4. Session log is created.
Five. Slower.
Question 132. What Are Different Data Types In Abap/4?
Answer :
Elementary -
Predefined: C, D, F, I, N, P, T, X.
User defined: TYPES.
Structured -
Predefined: TABLES.
User described: Field Strings and internal tables.
Question 133. In An Abap/four Program, How Do You Access Data That Exists On Presentation Server Vs On An Application Server?
Answer :
Using loop statements and Flat.
Question 134. What Are Presentation And Application Servers In Sap?
Answer :
The software layer of an R/three System is made up of the utility servers and the message server. Application packages in an R/3 System are run on utility servers. The software servers talk with the presentation additives, the database, and additionally with each different, using the message server.
Question a hundred thirty five. How Do You Use Tab Sets In Layout Sets?
Answer :
Define paragraph with defined tabs.
Question 136. What Takes Most Time In Sap Script Programming?
Answer :
LAYOUT DESIGN AND LOGO INSERTION.
Question 137. How Do You Number Pages In Sap Script Layout Outputs?
