• No results found

EDIDS TABLES

In document Interview Questions(All Interview) (Page 51-69)

193.) How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?

A.)

194.)What is distribution Model? A.)

195.) Difference between MACRO and SUBROUTINE ?

A.) we cant pass the values in macros and macros cant be called in the other report just as external subroutine. report specific.

196.) what is a binary search ? and how it is useful in a sorted internal table ?

A.) Definition: Search a sorted array by repeatedly dividing the search interval in half. Begin with an interval

covering the whole array. If the value of the search key is less than the item in the middle of the interval, narrow the interval to the lower half. Otherwise narrow it to the upper half. Repeatedly check until the value is found or the interval is empty.

197.) when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal table. What will be the result? (2nd internal table contains records).

A.)

198.) what is the difference between standard and sorted internal tables? (in performance wise A.) Standard tables:This is the most appropriate type if you are going to address the individual table entries using the index. Index access is the quickest possible access. You should fill a standard table by appending lines (ABAP APPEND statement), and read, modify and delete entries by specifying the index (INDEX option with the relevant ABAP command). The access time for a standard table increases in a linear relationship with the number of table entries. If you need key access, standard tables are particularly useful if you can fill and process the table in separate steps. For example, you could fill the table by appending entries, and then sort it. If you use the binary search option with key access, the response time is logarithmically proportional to the number of table entries.

Sorted tables:This is the most appropriate type if you need a table which is sorted as you fill it. You fill sorted tables using the INSERT statement. Entries are inserted according to the sort sequence defined through the table key. Any illegal entries are recognized as soon as you try to add them to the table. The response time for key access is

logarithmically proportional to the number of table entries, since the system always uses a binary search. Sorted tables are particularly useful for partially sequential processing in a LOOP if you specify the beginning of the table key in the WHERE condition.

199.)What is TYPE-POOLS SLIS?

A.) It is the type group/library which consists of all global type definitons w.r.t the alv grid structure.

200.)

Difference between top-of-page and top-of-page during at line- selection? How to create a check box/option button in a list?

How to create a button in selection screen ?

If you write a write statement after end-of-selection, will that be triggered ? What is the difference between end-of-page and end-of- selection? What is the Size of the internal tables ?

What is open sql vs native sql ?

201.)

Among "Move" and "Move Corresponding", which is efficient one and why ?

A.) 202.)

the `select' statement what is group by ?

Can ‘where’ clause be used when updating database entries? How to create secondary index ?

What is the secondary index?

In ALV reporting when u execute your report which event gets triggered. what is the difference between FOR ALL ENTRIES and SELECT * FROM ? Difference between Read and Get cursor?

Among "Move" and "Move Corresponding", which is efficient one and why ? What is the difference between Initialization and parameters ?

What are the Different Types of tickets in Realtime Scenario ? deloitte

How to Raise a Particular Ticket in Realtime ? ibm

Can i know some of the Realtime tickets that anyone has been faced ? How to Solve a Particular Ticket in Realtime ?

What are Tickets in Realtime ?

What are Pull and Push Methods? accenture

203.) How to Reprocess an Idoc ?

204) What is the relation between Badi and Bapi ?

205.) 1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?

206.) Why we are using Macros instead of Function Modules 207.)What are lock objects?

A.) Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.

SAP Provide three type of Lock objects. - Read Lock(Shared Locked)

protects read access to an object. The read lock allows other transactions read access but not write access to

the locked area of the table - Write Lock(exclusive lock)

protects write access to an object. The write lock allows other transactions neither read nor write access to the locked area of the table.

- Enhanced write lock (exclusive lock without cumulating) works like a write lock except that the enhanced write lock also protects from further accesses from the

same transaction.

You can create a lock on a object of SAP thorugh

transaction SE11 and enter any meaningful name start with EZ Example EZTEST_LOCK.

Use: you can see in almost all transaction when you are open an object in Change mode SAP could not allow to any other user to open the same object in change mode.

Example: in HR when we are enter a personal number in master data maintainance screen SAP can't allow to any other user to use same personal number for changes. Technicaly:

When you create a lock object System automatically creat two function module.

1. ENQUEUE_<Lockobject name>. to insert the object in a queue.

2. DEQUEUE_<Lockobject name>. To remove the object is being queued through above FM.

208.)What is composite key?

A.) A table can have one or more primary key columns. EX: MARC (It contains both material number and plant as primary key)

and When you have such a table which define more than one column as your primary key, then it is called a composite primary key.

209.) In smart form how can we convert the decimal to whole no. for ex. i have date like 5.456. now i want convert to whole no. after point value more then 5 means the no should come 6. below 5 means its come 5. any body can help me with code. its urgent.

210.) i want to block some spaces after end of page in classical report?how to do that?

A.)Use RESERVE LINES STATEMENT

211.) i want to populate 10 fields in smartforms..uptil 9th it is taking but 10th one is not populating?what might be the

reason?

A.) Change the window height and also check windows are overlapping or not.

212.)How to insert Signature in Smartforms?

A.) INSERT-->GRAPHICS--->graphics means it takes BMP so here u have to add ur BMP file.

digital Signature : upload this digital Signature image to SAP . u have to two ways to upload image into SAP.

1.RSTXLDMC : which converts TIFF file to Standard text. 2.SE78 : which take BMP file into SAP and u can directly call this BMP in Smartforms.

213.) In the BADI,they are multiple Implementation.Could you please tell is there any procedure which are the implementation will execute and any order is the execute all the implementation for that Badi

A.) Compiler usually lists the implementations of a BAdI in an arbitrary sequence. You can modify this arbitrary sequence so that implementations are called in a way you define it. All you need to do is to implement a Sorter BAdI

(BADI_SORTER) and define a sub screen in an own function group. The sub screen allows you to enter data used for sorting.

The BADI_SORTER to determine sequence of implementation calls is a Single Use Filter dependent BAdI, i.e. for one

single filter value only one implementation is allowed. A situation results in runtime errors where in a customer environment a sorting mechanism is implemented and SAP delivers later the same.

214.) we can write the select query or any code after the end of selection? A.)Yes

215.) If we put Top of Page in between Start-of-selection and End-of-selection and what happenes

a.) Nothing will happen!

the run time system picks up the events always in its pre- defined order.eventough you code any event in any order always right event is picked and processed.

216.)ORDER OF EVENTS. LOAD-OF-PROGRAM INITIALIZATION AT_SELECTION_SCREEN_ON_OUTPUT AT_SELECTION_SCREEN_ON_FIELD AT_SELECTION_SCREEN_ON_VALUEREQUEST AT_SELECTION_SCREEN_ON_HELPREQUEST AT_SELECTION_SCREEN START_OF_SELECTION END_OF_SELECTION TOP_OF_PAGE END_OF_PAGE

INTERACTIVE REPORTS EVENTS

AT LINE SELECTION AT USER COMMAND AT PF

TOP OF PAGE DURING LINE SELECTION

217.) How to reprocess the failed IDOC? How wil u know idoc is failed?What are tcodes? A.) by using tcode for reprocessing IDocs BD87/bd88

218.) In Realtime, how you get flat file for BDC session method.. through email or any other source? Who will send you flat

file..your team lead or project lead or project manager etc?

A.) The flat file can be either be either placed in directories in Application Server (Tcode-AL11) or can be loaded from Presentation server (Local PC).

219.) What is pseudo comment (#EC) and How it is different from normal comments(i.e. '*' and '"')

A.) useful in extended synatax check to supress error message display

220.) What is a difference between - RETURN, EXIT, CHECK, STOP & REJECT - To leave the processing blocks

A.) STOP: This terminates the block and executes end-of selection. EXIT: It terminates the loop processing and process the next

statements.

CHECK: It evaluates the subsequent logical expression if it is true the processing continue with the next statement. CONTINUE terminates the current loop pass, returns the processing to the beginning of the loop and starts the next loop pass,

REJECT: it terminates the current event, even from loops or subroutines.

221.) While Transporting Smartform form Dev to Test to

Production, it is possible that Name of the Function Module change, Why? In which case it changes and in which case it remains same?

A.)

222.) Hello all ABAP gurus. I want to ask 2 3 qtns.1)How many layou types we have in smartforms & difference between them..? 2)how to do pagebreaks in SMARTFORMS..?

3)Do we develope Smartform from scratch or do we use standard smartforms in real time..? please rply me... & thanks in advance.

A.) Hi 1)layout type is one which we can modified the existing one or developed the new one from scratch.

2)in smartforms we will do the page breaks using of the command.

3) in real time it will depends on the requirement if client if the standard available we will continue with standard it is not available we will develope form scratch.

223.) Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three

windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?

224.) Hi to all abap guru's my question is how to print the page numbers like 2 4 6 on all pagess in smart forms

A.) declare a global variable pg_no. write a command-node like:- pg_no = sfsy-page * 2.

(dont forget to set input/output parameter as "PG_NO") now place a sec window with: &pg_no&

225.) Hi to all abap guru's my querry is as follows How to trigger the page break in smartforms forcibly ? and how to trigger

the page break in the scripts forcibly ? means for every 10 records i have to trigger the page break ? and in smart form also ?

A.) in SMARTFORMS.

as of me we have to use 'command' from create--->flowlogic--->command.

but dont write command node in main window by using this u can do page break.

in SAPSCRIPTS u have to use FM 'contorl_form'

CALL FUNCTION 'CONTROL_FORM' EXPORTING command = new-page * EXCEPTIONS * UNOPENED = 1 * UNSTARTED = 2 * OTHERS = 3 . IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

226.) Is BAdI client Indpendent A.)Yes

227.) In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.

A.)

228.) How we will handle the Page Breaking in Smart Form? A.) By using command Node

229.) I a custom table some one has edited and deleted something, So how we should maintain the log for changed and edited datas

A.) once the ztable fields is created, we will click the technical settings.in that, down we have check box called LOG DATA CHANGES.if we select the check box, the log is activated and changes to the existing data record by an application

program is recorded in a log table in the database.

230.) Hi Toall abap gurus what are the variants in alv reports ? and what is the use of reuse_alv_variants_get ?

and what is the purpose of i_save parmaetr in the resue_av_grid-display funmodule?

what is the purpose of reuse _av_default_varinat_get ?

A.)

A.)Variants in ABAP are like any other variants that we use in ABAP. It helps us get a default value on our screen fields. In short, it works like saving your pwds on your mail accounts. The reuse_alv_default_variant_get helps you to give a

default value( had you mentioned in the program ) to your screen field. This default variant is generally stored in the struc CS_VARIANT of your program.

i_save in reuse_alv_grid_display : As mentioned above cs_variant from the reuse_alv_default_variant_get is passed to your functional module via i_save..

If i_save = '' variants cannot be saved. i_save = X std save mode.

i_save = ' ' or X is variant globally available i_save = 'U' is user specific variant.

231.) while transporting any report program do we need to trasnport the text elements seprately or not reuired ? if it is so how do u transport the text elemtns ?

A.) Text elements or any GUI elements get stored in a separate repository called MIME in ABAP. If you want to transport text elements or GUI elements of your report, the only thing you have to take care is - Transport your report in a

specific package, Go to the Object navigator and make sure you transport the relevant text and GUI objects via the same package.

Transporting / not transporting purely depends on the requirement.

232.) Is there any other way to create data elements apart from se11 tocde as we dont use the se11 in real time generally ?

A.) ya we can create data element through se80. se80.

select dictionary then select data type.

here u can create data element.

In real time we cant use se11, se38 etc. So we can do everything in se80.

233.) How do u do performance analysis means and what is the diffrence between extended syntax check and code inspector and how do use them to test the performance of the any abap program ?

A.) Extended syntax check,ensures the removal of mistakes we overlook while coding.

advantages: obsolete stmts. autorization checks problematic stmts.

Code inspector is a tool that gives PERFOEMANCE OF PROGRAM. syntactical check

security check performance check search func.

234.) if i remove the select stmt from start-of-selection and put the select stmt in end-of-selection it is triggering then

what is the use of start-of-selection?

A.) Actually Start-of-selection is a default event that's been

you've used Initialization event or AT Selection Screen event, then you need to mention the Start-of-Selection event explicitly. The use of Start-of-Selection is to fetch the

data from the database.

235.) Which technical field in the BDCDATA table holds the last cursor position

A.)FVAL.

236.) What loop do you code for a READ DATASET Statement

A.)DO ..ENDDO. 237.

How do you write a squential file a.)TRANFER DATASET

238.)How do ur write a local sequential file? a.)Read dataset

239.) if i want to take some matter from a smart form to another smart form .then how is it possible?

A.) open smartform select node or text --> utilities --> download form -->save it by providing the location .

then,

open another smartform where you want paste that object put curser on the target

then utilities --> upload -->save smartform.

if clipboard space issue is there then download clipboard software for more space so, that u can copy larger containt .

240.) what is process code used in ale idocs ? A.) Process code is used to identify the fm which is post the data to SAP system.It is for inbound Idoc.

241.) how can i transport a idoc from development system to production system? in idoc we are doing bd64 for distribution model view is it mandatory for idoc? and is it possible without creating a distribution model view we can generate a idoc?

A.) In SM59 Lgoical Sytems area we will have to define the Source and Target client. Then partner profile has to be created to transport the Development to Production System. It's possible to generate an IDoc with out creating a

242.) what exact functionality of the END-OF-SELECTION event? and in a report im using the END-OF-PAGE and END-OF-SELECTION events which one will triggers first?

A.)

243.) 1. what r the step followed for ALE Idocs ? 2. what is process code ? where it is define A.)

244.) hi friends i am having one doubt. if i have main window in secondpage also in smart form wether it will trigger are not?

A.)

245.) WHAT IS DATA DICTIONARY??

AND WHICH OBJECT IN DATA DICTIONARY??? A.) It is centrally discribed and manages all the data

definitions used in the system.

246.) The structure of a table has been changed in the ABAP/4 Dictionary.

Which of the following adjustments in the relevant database table is correct, if you want to retain the previous data?

A.) The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System.

You can use the database utility to edit all the database

In document Interview Questions(All Interview) (Page 51-69)