When you call a characteristic module, an example of its feature organization plus its records, is loaded into the memory location of the internal consultation. An ABAP program can load several instances through calling feature modules from distinctive feature agencies.
SAP R/three refers to Systems Application and Product for records processing Real-time having a 3 tier architecture i.E. Presentation layer, Application layer and Database layer.
Function Groups act as bins for Function Modules that logically belong collectively.
Function Groups
1) These can not be defined in a Function Module.
2) It can not be called.
3) They are boxes for Function Module.
Function Modules
1) These should be described in a Function Group.
2) It may be known as from any application.
3) They are not boxes for Function Group.
Central records repository for software and gadget records. The ABAP Dictionary consists of information definitions (metadata) that let you describe all the statistics systems within the device (like tables, perspectives, and records kinds) in one region. This eliminates redundancy.
Domain – Specifies the technical attributes of a facts detail – its facts type, length, feasible values, and look at the display. Each records element has an underlying domain. A single area may be the idea for numerous records factors. Domains are items inside the ABAP Dictionary.
Data Element – Describes the enterprise characteristic of a table field. Its technical attributes are primarily based on a domain, and its enterprise feature is described via its field labels and documentation.
Aggregate Object – Views, Match Code and Lock objects are known as combination items due to the fact they are shaped from several associated desk.
View – A view is a virtual desk containing fields from one or more tables. A virtual desk that doesn’t include any information, however rather presents an utility-oriented view of 1 or greater ABAP Dictionary tables.
No, we cannot print decimals in type N due to the fact decimal places aren’t approved with N information type.
Float Data Type: It can’t be declared in Parameters.
Packed Number: It can be declared in Parameters.
For e.G.
PARAMETERS : A(4) TYPE P DECIMALS 2, B(four) TYPE P DECIMALS 2.
DATA : C(four) TYPE P DECIMALS 2.
C = A + B.
WRITE : / ‘THE SUM IS’ , C.
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.
The ABAP gadget fields are lively in all ABAP programs. They are stuffed by using the runtime surroundings, and you may question their values in a application to find out unique states of the system. Although they are variables, you should no longer assign your very own values to them, seeing that this can overwrite facts this is important for the normal going for walks of this system. However, there are a few isolated instances in which you may want to overwrite a device variable. For instance, via assigning a new fee to the sphere SY-LSIND, you can manage navigation within details lists.
SAP Script – It is the included textual content management device of the SAP R/three System.
Two types:
Reports – It is the way to display records fetched from database desk onto screen or without delay output it to a printer.
Two types:
SY-TABIX – Current line of an internal desk. SY-TABIX is ready by the statements below, however best for index tables. The subject is both now not set or is about to 0 for hashed tables.
* APPEND units SY-TABIX to the index of the closing line of the table, that is, it carries the overall variety of entries within the desk.
* COLLECT sets SY-TABIX to the index of the prevailing or inserted line within the desk. If the desk has the kind HASHED TABLE, SY-TABIX is about to zero.
* LOOP AT units SY-TABIX to the index of the modern line at the beginning of each loop loss. At the end of the loop, SY-TABIX is reset to the fee that it had before getting into the loop. It is ready to 0 if the table has the type HASHED TABLE.
* READ TABLE units SY-TABIX to the index of the desk line read. If you operate a binary seek, and the gadget does no longer discover a line, SY-TABIX includes the full quantity of strains, or one extra than the whole variety of strains. SY-INDEX is undefined if a linear seek fails to go back an entry.
* SEARCH FOR units SY-TABIX to the index of the desk line wherein the hunt string is discovered.
SY_INDEX – In a DO or WHILE loop, SY-INDEX carries the wide variety of loop passes such as the modern-day pass.
Logical Databases are unique ABAP packages that retrieve statistics and make it available to utility packages.
Use of LDB – is used to read facts from database tables via linking them to executable ABAP applications
SAP ABAP Web Dynpro Tutorial
Question 17. Explain What Are The Events Used For Logical Database?
GET – This is the maximum important event for executable packages that use a logical database. It happens while the logical database has examine a line from the node and made it available to the program inside the work region declared using the declaration NODES desk Tag. The depth to which the logical database read is decided with the aid of the GET statements
PUT – The PUT declaration directs the program float in step with the structure of the logical database.
Sap Abap Hr Interview Questions
Question 18. What Is The Difference Between Get And Get Late?
GET – After the logical database has read an access from the node desk Tag.
GET LATE – After all the nodes of the logical database have been processed which might be under
in the database hierarchy.
SAP BI Interview Questions
Question 19. What Are The Data Types Of Internal Tables?
Answer:
There are 3 types:
Line
Key
Table
Question 20. What Are The Events Used In Abap In The Order Of Execution?
Answer:
The Events utilized in ABAP are:
1. INITIALIZATION
2. AT SELECTION-SCREEN
3. AT SELECTION-SCREEN ON
four. START-OF-SELECTION
five. 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
12. GET
thirteen. GET LATE.
14. AT User Command
SAP ABAP Dictionary Interview Questions
Question 21. Explain What Are Interactive Reports?
Answer:
An output listing which shows simply the simple information & permit person to have interaction, so that a new listing is populated based totally on user-choice. With interactive list, the person can actively manage records retrieval and show at some point of the session.
Question: 22. What Are The Commands Used For Interactive Reports?
Answer:
Top-of-Page all through line-choice.
Question: 23. What Are The System Fields You Have Worked With? Explain?
Answer:
I had labored with the subsequent (30) gadget fields:
1) SY-DBSYS – Central Database
2) SY-HOST – Server
3) SY-OPSYS – Operating System
four) SY-SAPRL – SAP Release
five) SY-SYSID – System Name
6) SY-LANGU – User Logon Language
7) SY-MANDT – Client
eight) SY-UNAME – Logon User Name
9) SY-DATLO – Local Date
10) SY-DATUM – Server Date
eleven) SY-TIMLO – Local Time
12) SY-UZEIT – Server Time
thirteen) SY-DYNNR – Screen Number
14) SY-REPID – Current ABAP application
15) SY-TCODE – Transaction Code
16) SY-ULINE – Horizontal Line
17) SY-VLINE – Vertical Line
18) SY-INDEX – Number of modern loop Pass
19) SY-TABIX – Current line of inner table
20) SY-DBCNT – Number of table entries processed
21) SY-SUBRC – Return Code
22) SY-UCOMM – Function Code
23) SY-LINCT – Page Length of listing
24) SY-LINNO – Current Line
25) SY-PAGNO – Current Page Number
26) SY-LSIND – Index of List
27) SY-MSGID – Message Class
28) SY-MSGNO – Message Number
29) SY-MSGTY – Message Type
30) SY-SPONO – Spool wide variety throughout printing
SAP ABAP Enhancement Interview Questions
Question 24. What Is The Transaction Code For Table Maintenance?
Answer:
SM30.
SAP MM Interview Questions
Question 25. Explain What Is The Difference Between Primary Key And Unique Key?
Answer:
Primary Key – It can accepts zero value and can not be NULL.
Unique Key – It may be NULL.
Question: 26. If You Are Using Logical Databases How Will You Modify The Selection-display Elements?
Answer:
Select-alternatives : dname for deptt-dname.
SAP ABAP Module Pool Interview Questions
Question 27. What Is An Rfc?
Answer:
Remote Function Call.
SAP BASIS Interview Questions
Question 28. Explain What Are The Events In Screen Programming?
Answer:
PBO (Process Before Output) – Before the screen is displayed, the PBO occasion is processed.
PAI (Process After Input) – When the person interacts with the display, the PAI occasion is processed.
POH (Process On Help) – are precipitated while the user requests field assist (F1). You can software the right coding inside the corresponding event blocks. At the end of processing, the gadget incorporates on processing the contemporary display.
POV (Process On Value) – are brought on while the consumer requests feasible values help (F4). You can software an appropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the modern display screen.
Question 29. What Is The Significance Of Hide?
Answer:
It stores the press value and show the associated record in the secondary listing.
SAP ABAP Report Developer Interview Questions
Question 30. Where Do You Code The Hide Statement?
Answer:
In a LOOP assertion.
Question: 31. What Are The Types Of Bdc S?
Answer:
There are two types of BDC’s:
Transaction Method
Session Method
Question 32. Advantages And Disadvantages Of Different Types Of Bdc S?
Answer:
Transaction Method:
It is quicker than consultation technique.
While executing, it begins from starting.
Session Method:
It is slower than transaction approach.
While executing, it does no longer start from beginning.
SAP ABAP Data Dictionary Interview Questions
Question 33. What Are The Events Used In Interactive Reports?
Answer:
There are three events of Interactive Reports:
At PF(nn)
At line-choice
At user-command
SAP ABAP Web Dynpro Interview Questions
Question 34. What Is An Rdbms?
Answer:
RDBMS – Relational Database Management System. It helps to create courting between two or more desk.
Question: 35. What Will You Code In Start-of-choice & End-of-choice ?
Answer:
START-OF-SELECTION
SELECT * FROM DEPTT INTO CORRESPONDING FIELDS OF ITAB
WHERE DEPTNO IN DEPTNO.
APPEND ITAB.
ENDSELECT.
LOOP AT ITAB.
WRITE : / 10 ITAB-DEPTNO.
HIDE : ITAB-DEPTNO.
ENDLOOP.
END-OF-SELECTION
Question 36. What Are Joins And Different Types Joins?
Answer:
There are four kinds of Joins:
Self Join
Inner Join
Outer Join
Equi Join
SAP Workflow Interview Questions
Question 37. How Do You Display A Data In A Detail List?
Answer:
By the use of two statements:
Top-of-web page all through line-choice
At line-selection
Question 38. What Are The Types Of Windows In Sap Script?
Answer:
There are 5 Standard Layouts in SAP Script:
Page
Window
Page Window
Paragraph Format
Character Format
Question 39. 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 40. What Are Extracts?
Answer:
Extracts are dynamic sequential datasets wherein extraordinary traces will have specific structures. We can access the character records in an extract dataset the use of a LOOP.
Sap Abap Hr Interview Questions
Question 41. What Is Luw?
Answer:
Logical Unit of Work.
Question: 42. Different Types Of Luws. What Are They?
Answer:
Two kinds of LUW are:
DB LUW – A database LUW is the mechanism utilized by the database to ensure that its data is always regular. A database LUW is an inseparable sequence of database operations that ends with a database commit. The database LUW is both fully achieved by the database gadget or under no circumstances. Once a database LUW has been efficiently finished, the database might be in a steady nation. If an errors takes place within a database LUW, all of the database changes on the grounds that the start of the database LUW are reversed. This leaves the database within the nation it had earlier than the transaction began.
SAP LUW – A logical unit together with dialog steps, whose adjustments are written to the database in a unmarried database LUW is known as an SAP LUW. Unlike a database LUW, an SAP LUW can span numerous dialog steps, and be completed using a series of different work procedures.
SAP ABAP Dictionary Interview Questions
Question forty three. How Do You Find Out Whether A File Exits On The Presentation Server?
Answer:
eps_get_directory_listing for listing.
Question: forty four. Systems Fields Used For Interactive Lists And Lists?
Answer:
Interactive System Fields: SY-LSIND, SY-CPAGE, SY-LILLI, SY-LISEL, SY-LISTI, SY-LSTAT, SY-STACO, SY-STARO.
Lists: SY-COLNO, SY-LINCT, SY-LINNO, SY-LINSZ, SY-PAGNO, SY-TVAR0…..SY-TVAR9, SY-WTITL.
Question forty five. Logo In Sap Script?
Answer:
RSTXLDMC OR
Steps for making and inserting Logo in SAP Script:
First Procedure:
1) Draw the image
2) Save it
3) /nSE78
four) Write name & Choose Color
five) Click on Import
6) Browse photo
7) Enter
Second Procedure:
1) /nSE71
2) Insert
three) Graphics
four) Click on saved on document server
five) Execute
6) Choose name of BMAP
Question: forty six. What Are The Difference Between Call Screen And Leave Screen?
Answer:
Call Screen: Calling a single display screen is a unique case of embedding a display series. If you want to prevent the referred to as display screen from covering the modern display screen completely, you could use the CALL SCREEN statement with the STARTING AT and ENDING AT
CALL SCREEN a thousand.
CALL SCREEN 1000 STARTING AT 10 10 ENDING AT 20 20.
LEAVE SCREEN: assertion ends the cutting-edge display and calls the following screen.
LEAVE SCREEN.
LEAVE TO SCREEN 2000.
Question 47. If Internal Table Used In For All Entries In Empty Then What Happens?
Answer:
No, records could be displayed.
Question: forty eight. If I Forgot Some Command In Sap Script E.G.: Suppress Zero Display – How To Do Find It?
Answer:
Suppressing of entire displays is viable with this command. This command lets in us to perform display processing “within the heritage”. Suppressing screens is beneficial while we’re branching to list-mode from a transaction dialog step.
Question: 49. How To Write A Bdc – How Do You Go About It?
Answer:
Steps for writing BDC
1) /nSE38
2) Declare Tables, Data (for ITAB) and Data (for BDCITAB)
three) Call feature ‘Upload’.
4) Write code for the First Screen, Radio Button, Filename, Change Button, Second Screen, Utilities (Create Entries), Third Screen and Save.
Five) Call transaction ‘SE11’ using BDCITAB mode ‘A’.
6) Save, Check Errors, Activate and Execute.
Question: 50. How Do You Move On To The Next Screen In Interactive Reporting?
Answer:
Write code of the subsequent:
Top-of-Page during line-choice
At line-choice
Question fifty one. Create Any Functions? How To Go About It?
Answer:
Steps for developing the Functions:
First Procedure:
1) /nSE37
2) Goto
three) Function Group (FG)
4) Create Group
five) Name of FG (ZREKHA_FG)
6) Short Text
7) Save
eight) Local Object
Second Procedure:
1) Environment
2) Inactive Object
three) Function Group (ZREKHA_FG)
4) Activate
5) Back
Third Procedure:
1) Name of Function Module (ZREKHA_FM)
2) Create
3) Write FG Name (ZREKHA_FG)
four) Short Text
five) Save
Fourth Procedure:
Call characteristic ‘ZREKHA_FM’.
Question: 52. What Are The Function Modules Used In F4 Help?
Answer:
There are two sorts of feature modules utilized in F4 help:
F4IF_FIELD_VALUE_REQUEST
F4IF_INT_TABLE_VALUE_REQUEST
Question 53. Work Most On Which Module: Name A Few Tables?
Answer:
Sales & Distribution Module
1) Sales Document: Item Data – VBAP
2) Sales Document: Partner – VBPA
three) Sales Document: Header Data – VBAK
4) Sales Document Flow – VBFA
5) Sales Document: Delivery Item Data – LIPS
6) Customer Master – KNA1
7) Material Data – MARA
8) Conditions (Transaction Data) – KONV
Question: fifty four. What Are The System Table Used In Abap?
Answer:
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 – KNA1
Material Data – MARA
Conditions (Transaction Data) – KONV
Question 55. What Is Read Line In Abap?
Answer:
READ LINE and READ CURRENT LINE – These statements are used to study information from the strains of current list ranges. These statements are intently related to the HIDE method.
Question: 56. Can There Be More Than 1 Main Window In Sap Script?
Answer:
No, there cannot be extra than 1 fundamental window in SAP Script due to the fact in WRITE_FORM, it asks for the parameter Window a good way to create the trouble.
WRITE_FORM
Exporting
Element
Window
Question fifty seven. What Are The Differences Between Sap Memory And Abap Memory?
Answer:
ABAP Memory is a reminiscence region in the inner session (roll vicinity) of an ABAP software. Data inside this region is retained inside a series of program calls, permitting you to bypass records between programs that name each other. It is also feasible to bypass information among classes using SAP Memory.
SAP Memory is a reminiscence region to which all periods inside a SAPgui have get right of entry to. You can use SAP reminiscence either to pass records from one program to every other inside a consultation (as with ABAP reminiscence) or to pass data from one session to every other.
Question: 58. What Are Differences Between At Selection-display screen And At Selection-display Output?
Answer:
AT SELECTION-SCREEN – occasion is triggered within the PAI of the selection screen once the ABAP runtime surroundings has surpassed all the input records from the selection display screen to the ABAP software.
AT SELECTION-SCREEN OUTPUT – This event block permits you to alter the choice screen directly earlier than it’s miles displayed.
Question: fifty nine. What Is Get Cursor Field?
Answer:
GET CURSOR announcement transfers the name of the display screen element on which the cursor is located for the duration of a consumer movement into the variable .
GET CURSOR FIELD [OFFSET ] [LINE ] [VALUE ] LENGTH ].
Question: 60. What Is The Inside Concept In Select-alternatives?
Answer:
Select-alternatives specify are displayed on the choice display screen for the consumer to go into values.
Different Properties of Select-options:
1) Visible Length
2) Matchcode Object
3) Memory ID
four) Lowercase
5) Obligatory
6) No Display
7) Modify ID
Question: sixty one. What Is The Difference Between Free And Refresh?
Answer:
Free – You can use FREE to initialize an inner desk and release its memory area without first the use of the REFRESH or CLEAR assertion. Like REFRESH, FREE works on the desk frame, now not at the table paintings vicinity. After a FREE assertion, you can deal with the inner desk once more. It still occupies the amount of reminiscence required for its header (currently 256 bytes). When you replenish the desk, the machine has to allocate new memory area to the strains.
Refresh – This always applies to the body of the desk. As with the CLEAR assertion, the reminiscence used by the table earlier than you initialized it remains allotted. To launch the memory space, use the announcement
Question: sixty two. Can We Have More Than One Selection-display And How?
Answer:
Yes, we are able to have multiple choice display screen.
Selection-screen start of block honey with body identify textual content-one zero one.
Select-alternatives : deptno for zrekha_deptt-deptno.
Selection-display screen end of block honey.
Selection-screen start of block honey1 with body name text-102.
Select-alternatives : dname for zrekha_deptt-dname.
Selection-display cease of block honey1.
Question: 63. How To Declare Select-choice As A Parameter?
Answer:
SELECT-OPTIONS: specify are displayed on the selection screen for the consumer to go into values.
Parameters: dname like dept-dname.
Select-alternatives: dname for dept-dname.
Question: 64. How Can You Write Programmatically Value Help To A Field Without Using Search Help And Match Codes?
Answer:
By the usage of types of characteristic modules to be referred to as in SAP Script:
HELP_OBJECT_SHOW_FOR_FIELD
HELP_OBJECT_SHOW.
Question sixty five. What Are The Differences Between Se01, Se09 And Se10?
Answer:
SE01 – Correction & Transport Organizer
SE09 – Workbench Organizer
SE10 – Customizing Organizer
Question 66. What Is The Use Of Table Maintenance Allowed?
Answer:
Mark the Table maintenance allowed flag if users with the corresponding authorization may alternate the data in the table using the Data Browser (Transaction SE16). If the facts in the desk should most effective be maintained with packages or with the table view maintenance transaction (Transaction SM30), you should no longer set the flag.
Question: sixty seven. How To Define Selection Screen?
Answer:
Parameters, Select-alternatives & Selection-Screen.
Question: 68. What Are The Check Tables And Value Tables?
Answer:
Check Table: The ABAP Dictionary allows you to define relationships among tables the use of foreign keys. A structured desk is referred to as a foreign key desk, and the referenced table is called the check table. Each key discipline of the check desk corresponds to a area inside the overseas key desk. These fields are called overseas key fields. One of the foreign key fields is designated because the check area for checking the validity of values. The key fields of the check table can serve as input assist for the check subject.
Value Table: Prior to Release four.Zero, it was possible to use the price desk of a site to provide enter assist. This is now not feasible, broadly speaking due to the fact sudden outcomes ought to occur if the value table had more than one key discipline. It became not possible to restrict the other key fields, which supposed that the surroundings of the field changed into now not considered, as is normal with test tables.In cases wherein this type of price assist turned into appropriate, you may reconstruct it by using developing a seek assist for the records elements that use the area in query, and the usage of the price desk as the choice technique.Check desk will be at field degree checking.Value table will be at area stage checking ex: scarr desk is take a look at desk for carrid.
Question 69. What Is The Difference Between Tables And Structures?
Answer:
Tables:
Data is completely saved in tables inside the database.
Database tables are generated from them.
Structure:
It contains facts temporarily at some point of application run-time.
No Database tables are generated from it.
Question 70. What Are Lock Objects?
Answer:
Reason for Setting Lock: Suppose a journey agent want to ebook a flight. The patron wants to fly to a selected city with a positive airline on a certain day. The reserving have to simplest be viable if there are nevertheless free places at the flight. To avoid the possibility of overbooking, the database entry corresponding to the flight should be locked against get entry to from different transactions. This ensures that one person can find out the variety of unfastened locations, make the reserving, and alternate the range of loose locations with out the facts being changed inside the period in-between by some other transaction.
Question: 71. What Is The Difference Between Open_form And Close_form?
Answer:
OPEN_FORM – This module opens layout set printing. This characteristic ought to be called up earlier than we can work with different layout set feature like WRITE_FORM.
WRITE_FORM – Output textual content element in form window. The certain element of the format set window entered is output. The element need to be described inside the layout set.
CLOSE_FORM – End format set printing. Form printing began with OPEN_FORM is finished. Possible remaining operations at the form remaining opened are accomplished. Form printing need to be completed by using this function module. If this isn’t completed, nothing is outlined or displayed at the display.
Question 72. What Are The Page Windows? How Many Main Windows Will Be There In A Page Window?
Answer:
Page Window: In this window, we outline the margins for left, width, top and top for the layout of Header, Logo, Main, & Footer.
Question: seventy three. How To Debug A Script In Abap?
Answer:
Go to SE71, supply format set call, visit utilities pick out debugger mode on.
Question: 74. How Many Maximum Sessions Can Be Open In Sapgui?
Answer:
There are maximum 6 periods open in SAPgui.
Question: seventy five. What Are System Variable In Abap?
Answer:
System variables have been predefined by SAP. We can use those variables in formulation or, as an example, to pass on sure portions of statistics to a function module. How the characteristic called through the characteristic module behaves depends at the type of information passed on.
Question: 76. What Is The Difference Between Sum And Collect?
Answer:
Sum: You can handiest use this announcement within a LOOP. If you operate SUM in an AT – ENDAT block, the system calculates totals for the numeric fields of all strains within the modern-day line group and writes them to the corresponding fields in the paintings area. If you operate the SUM assertion outside an AT – ENDAT block (single entry processing), the gadget calculates totals for the numeric fields of all strains of the inner table in each loop skip and writes them to the corresponding fields of the work location. It therefore only makes experience to apply the SUM declaration in AT…ENDAT blocks. If the table consists of a nested desk, you cannot use the SUM declaration. Neither can you operate it in case you are the usage of a discipline image in preference to a piece place within the LOOP assertion.
COLLECT : It allows you to create unique or summarized datasets. The system first tries to discover a desk access corresponding to the table key. The key values are taken either from the header line of the inner table itab, or from the explicitly-specified work region wa.
Question: seventy seven. What Is The Typical Structure Of An Abap Program?
Answer:
HEADER, BODY, FOOTER.
Question: 78. What Are Field Symbols And Field Groups? Have You Used Component Idx Of Structure Clause With Field Groups?
Answer:
Field Symbols – They are placeholder or symbolic names for the other fields. They do no longer physically reserve area for a area, however point to its contents. It can point to any data objects.
Field-symbols
Field Groups – Field agencies does now not reserve storage space however includes guidelines to current fields.
An extract dataset consists of a chain of information. These facts may additionally have distinct structures. All information with the same shape form a report type. You need to define every file kind of an extract dataset as a area group, the use of the FIELD-GROUPS statement.
Field-corporations
Question: seventy nine. What Is A Batch Input Session?
Answer:
BATCH INPUT SESSION is an intermediate step between internal desk and database table. Data along with the movement is stored in session i.E. Statistics for screen fields, to which display it’s miles exceeded, application call behind it, and how next display screen is processed.
Create consultation – BDC_OPEN_GROUP
Insert batch enter – BDC_INSERT
Close session – BDC_CLOSE_GROUP
Question 80. What Is The Alternative To Batch Input Session?
Answer:
Call Transaction Method & Call Dialog.
Question: eighty one. A Situation: An Abap Program Creates A Batch Input Session. We Need To Submit The Program And The Batch Session In Background. How To Do It?
Answer:
Go to SM36 and create heritage task via giving activity call, task magnificence and task steps (JOB SCHEDULING).
Question: 82. What Is The Difference Between A Pool Table And A Transparent Table And How They Are Stored At The Database Level?
Answer:
Pool Table :
Many to One Relationship.
Table in the Dictionary has the exceptional name, specific range of fields, and the fields have the one-of-a-kind call as inside the R3 Table definition.
It can maintain simplest pooled tables.
Transparent Table :
One to One dating.
Table within the Dictionary has the identical call, identical variety of fields, and the fields have the same call as in the R3 Table definition.
It can hold Application statistics.
Question 83. What Are The Problems In Processing Batch Input Sessions? How Is Batch Input Process Different From Processing On Line?
Answer:
Two Problems: –
If the consumer forgets to opt for maintain consultation then the session will be mechanically eliminated from the session queue (log stays). However, if consultation is processed we can also delete it manually.
If consultation processing fails, records will no longer be transferred to SAP database table.
Question 84. Is Session Method, Asynchronous Or Synchronous?
Answer:
Synchronous.
Question: 85. What Are The Different Types Of Data Dictionary Objects?
Answer:
Different varieties of facts dictionary gadgets:
1) Tables
2) Views
3) Data factors
4) Structure
five) Domains
6) Search Helps
7) Local Objects
eight) Matchcode
Question: 86. How Many Types Of Tables Exist And What Are They In Data Dictionary?
Answer:
4 Types of Tables:
Transparent tables – Exists with the equal shape each in dictionary as well as in database exactly with the same information and fields. Both Open SQL and Native SQL can be used.
Pool tables – Pooled tables inside the dictionary has a many-to-one relation with the table in database. Table inside the database has the extraordinary name as inside the dictionary. Pooled desk are saved in table pool on the database level.
Cluster tables – These are logical tables which might be arranged as information of obvious tables. One can’t use Native SQL on these tables (best Open SQL). They are not doable without delay using database gadget tools.
Internal tables – Internal table is a temporary table stored inside the RAM of the utility server. It receives created at some point of this system execution and gets deleted as soon as the program ends.
Question 87. What Is The Step-via-step Process To Create A Table In Data Dictionary?
Answer:
Steps to create a desk:
Step 1: developing domains (facts type, discipline period, Range).
Step 2: developing data factors (residences and sort for a table field).
Step three: growing tables (SE11).
Question 88. Can A Transparent Table Exist In Data Dictionary But Not In The Database Physically?
Answer:
No, Transparent desk do exist with the identical shape each in the dictionary as well as inside the database, exactly with the same statistics and fields.
Question: 89. In Sap Scripts, How Will You Link Form With The Event Driven?
Answer:
In PAI, define feature code and write code for the equal.
Question: ninety. Can You Create A Table With Fields Not Referring To Data Elements?
Answer:
YES. E.G.:- ITAB LIKE SPFLI.
Here we’re regarding a records object (SPFLI) not information element.
Question: 91. What Is A Collect Statement? How Is It Different From Append?
Answer:
Collect: If an entry with the same key already exists, the COLLECT statement does not append a brand new line, but adds the contents of the numeric fields inside the paintings area to the contents of the numeric fields inside the current access.
Append : Duplicate entries takes place
Question ninety two. What Is Open Sql Vs Native Sql?
Answer:
Open SQL – These statements are a subset of widespread SQL. It consists of DML command (Select, Insert, Update, Delete). It can simplify and speed up database get admission to. Buffering is in part saved inside the working memory and shared memory. Data in buffer isn’t always always updated.
Native SQL – They are loosely integrated into ABAP. It permits get right of entry to to all capabilities containing programming interface. They are not checked and transformed. They are sent at once to the database machine. Programs that use Native SQL are specific to the database machine for which they had been written. For e.G. To create or exchange table definition within the ABAP.
Question: 93. What Does An Exec Sql Stmt Do In Abap? What Is The Disadvantage Of Using It?
Answer:
To use a Native SQL assertion, you ought to precede it with the EXEC SQL declaration, and comply with it with the ENDEXEC assertion as follows:
EXEC SQL [PERFORMING
