Walk-in Drive 31-may-2014 SAP ABAP - Developer/lead @ Mindtree Bangalore

Job Description

 General business process and integration knowledge in MM, SD, FI and IS Retail. Good Analytical skills and strong interpersonal skills. Candidate is required to analyze existing ABAP code.
Very good awareness of entire SDLC and processes related to SDLC.
Expertise with hands on development experience in RICEF (Reports, Interfaces, Conversion, Enhancements and Forms) and IDoc specifically.
Hands-on expertise in below areas of ABAP:

Reports: Classical, Interactive and ALV
Interfaces: BAPI, BDC and Flat file Interfaces
Enhancements: BADI, User Exits and Customer Exits
Proficiency in areas like Data Dictionary and Performance Tuning
OO ABAP expertise
ABAP Webdynpro
Interface Programming (SPROXY)
Adobe Forms
Workflows
IDOCs
Using the IT development standards, develop custom RICEF objects
Reviewing and understand the technical design document to ensure the development work is in compliance with the specifications.
Identifying and resolving issues by analyzing programs and determining solutions.
Assisting functional teams when necessary in the testing efforts.
Assisting junior developers when necessary in the development process.

For details Check below link

Walk-in Drive 31-may-2014 SAP ABAP - Developer/lead @ Mindtree Bangalore 

Walk-in Drive 31-may-14 SAP Bw-abap - Developer/lead @ Mindtree Bangalore

Job Description

 Experience in of SAP BI/BW Should have  at least 3 full life cycle SAP BW implementation , at least 2 with BI 7.0/BI 7.3
Should have thorough/Good knowledge of R/3-ECC Extraction, Data Modeling, BW-ABAP, BEx and Excel Workbooks experience
Should have experience working with different Source Systems
Should be able to design, prepare FS, TS independently.
Should be Very good in BW Technical and Functional
Should have experience writing/Developing Technical Specs for extraction, reporting, enhancements and conversion.
should interact with key stakeholders/support members in different areas of BW
Collaborate with onsite/offshore team with respect to all ongoing customer deliverables
Communication bridge between client and team where required
Clarify on Customer requirements, standards and define project scope to offshore teams
Knowledge in BW-IP is added advantage
Knowledge in BW Accelerator is added advantage
Knowledge in Business Objects is added advantage
Should have experience in working in UK and Other Countries is added advantage


For details check the below link

Walk-in Drive 31-may-14 SAP Bw-abap - Developer/lead @ Mindtree Bangalore 

SAP ABAP Interview Questions and Answers - 11

1. What is an ABAP data dictionary?- ABAP 4 data dictionary describes the logical structures of the

objects used in application development and shows how they are mapped to the underlying relational

database in tables/views.

2. What are domains and data element?- Domains:Domain is the central object for describing the

technical characteristics of an attribute of an business objects. It describes the value range of the field.

Data Element: It is used to describe the semantic definition of the table fields like description the field.

Data element describes how a field can be displayed to end-user.

3. What is foreign key relationship?- A relationship which can be defined between tables and must be

explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered

should be checked against existing data to ensure that there are now contradiction. While defining

foreign key relationship cardinality has to be specified. Cardinality mentions how many dependent

records or how referenced records are possible.

4. Describe data classes.- Master data: It is the data which is seldomly changed. Transaction data: It is

the data which is often changed. Organization data: It is a customizing data which is entered in the

system when the system is configured and is then rarely changed. System data:It is the data which R/3

system needs for itself.

5. What are indexes?- Indexes are described as a copy of a database table reduced to specific fields. This

data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that

other fields are also read, a pointer to the associated record of the actual table are included in the index.

Yhe indexes are activated along with the table and are created automatically with it in the database.

6. Difference between transparent tables and pooled tables.- Transparent tables: Transparent tables in

the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single

database field. Table in the database has the same name as in the dictionary. Transparent table holds

application data. Pooled tables. Pooled tables in the dictionary has a many-to-one relation with the table

in database. Table in the database has the different name as in the dictionary. Pooled table are stored in

table pool at the database level.

7. What is an ABAP/4 Query?- ABAP/4 Query is a powerful tool to generate simple reports without any

coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports.

Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical

reports. - For creating a ABAP/4 Query, programmer has to create user group and a functional group.

Functional group can be created using with or without logical database table. Finally, assign user group

to functional group. Finally, create a query on the functional group generated.

8. What is BDC programming?- Transferring of large/external/legacy data into SAP system using Batch

Input programming. Batch input is a automatic procedure referred to as BDC(Batch Data

Communications).The central component of the transfer is a queue file which receives the data vie a

batch input programs and groups associated data into “sessions”.

9. What are the functional modules used in sequence in BDC?- These are the 3 functional modules

which are used in a sequence to perform a data transfer successfully using BDC programming:

BDC_OPEN_GROUP - Parameters like Name of the client, sessions and user name are specified in

this functional modules. BDC_INSERT - It is used to insert the data for one transaction into a session.

BDC_CLOSE_GROUP - This is used to close the batch input session.

10. What are internal tables?- Internal tables are a standard data type object which exists only during the

runtime of the program. They are used to perform table calculations on subsets of database tables and

for re-organising the contents of database tables according to users need.

11. What is ITS? What are the merits of ITS?- ITS is a Internet Transaction Server. ITS forms an

interface between HTTP server and R/3 system, which converts screen provided data by the R/3 system

into HTML documents and vice-versa. Merits of ITS: A complete web transaction can be developed

and tested in R/3 system. All transaction components, including those used by the ITS outside the R/3

system at runtime, can be stored in the R/3 system. The advantage of automatic language processing in

the R/3 system can be utilized to language-dependent HTML documents at runtime.

© Manish Shankar

12. What is DynPro?- DynPro is a Dynamic Programming which is a combination of screen and the

associated flow logic Screen is also called as DynPro.

13. What are screen painter and menu painter?- Screen painter: Screen painter is a tool to design and

maintain screen and its elements. It allows user to create GUI screens for the transactions. Attributes,

layout, filed attributes and flow logic are the elements of Screen painter. Menu painter: Menu painter is

a tool to design the interface components. Status, menu bars, menu lists, F-key settings, functions and

titles are the components of Menu painters. Screen painter and menu painter both are the graphical

interface of an ABAP/4 applications.

14. What are the components of SAP scripts?- SAP scripts is a word processing tool of SAP which has

the following components: Standard text. It is like a standard normal documents. Layout sets. - Layout

set consists of the following components: Windows and pages, Paragraph formats, Character formats.

Creating forms in the R/3 system. Every layout set consists of Header, paragraph, and character string.

ABAP/4 program.

15. What is ALV programming in ABAP? When is this grid used in ABAP?- ALV is Application List

viewer. Sap provides a set of ALV (ABAP LIST VIEWER) function modules which can be put into

use to embellish the output of a report. This set of ALV functions is used to enhance the readability and

functionality of any report output. Cases arise in sap when the output of a report contains columns

extending more than 255 characters in length. In such cases, this set of ALV functions can help choose

selected columns and arrange the different columns from a report output and also save different

variants for report display. This is a very efficient tool for dynamically sorting and arranging the

columns from a report output. The report output can contain up to 90 columns in the display with the

wide array of display options.

16. What are the events in ABAP/4 language?- Initialization, At selection-screen, Start-of-selection,

end-of-selection, top-of-page, end-of-page, At line-selection, At user-command, At PF, Get, At New,

At LAST, AT END, AT FIRST.

17. What is CTS and what do you know about it?- The Change and Transport System (CTS) is a tool

that helps you to organize development projects in the ABAP Workbench and in Customizing, and then

transport the changes between the SAP Systems and clients in your system landscape. This

documentation provides you with an overview of how to manage changes with the CTS and essential

information on setting up your system and client landscape and deciding on a transport strategy. Read

and follow this documentation when planning your development project.

18. What are logical databases? What are the advantages/ dis-advantages of logical databases?- To

read data from a database tables we use logical database. A logical database provides read-only access

to a group of related tables to an ABAP/4 program. Advantages: i)check functions which check that

user input is complete, correct,and plausible. ii)Meaningful data selection. iii)central authorization

checks for database accesses. iv)good read access performance while retaining the hierarchical data

view determined by the application logic. dis advantages: i)If you donot specify a logical database in

the program attributes,the GET events never occur. ii)There is no ENDGET command,so the code

block associated with an event ends with the next event statement (such as another GET or an ENDOF-

SELECTION).

19. What is a batch input session?- BATCH INPUT SESSION is an intermediate step between internal

table and database table. Data along with the action is stored in session ie data for screen fields, to

which screen it is passed, program name behind it, and how next screen is processed.

20. How to upload data using CATT ?- These are the steps to be followed to Upload data through

CATT: Creation of the CATT test case & recording the sample data input. Download of the source file

template. Modification of the source file. Upload of the data from the source file.

21. What is Smart Forms?- Smart Forms allows you to create forms using a graphical design tool with

robust functionality, color, and more. Additionally, all new forms developed at SAP will be created

with the new Smart Form solution.

22. How can I make a differentiation between dependent and independent data?- Client dependent or

independent transfer requirements include client specific or cross client objects in the change requests.

 Finance  economy  finance & insurance money derivatives wall street young money  got money cash money  get money

SAP FICO Interview Questions and Answers - 7

SAP FINANCIALS – GENERAL LEDGER – Interview Q’s with A’s

Q.Give some examples of GL accounts that should be posted automatically through the system and how is this defined in the system. Ans: Stock and Consumption accounts are instances of GL accounts that should be automatically posted . In the GL account master record, a check box exists wherein the automatic posting option is selected called “ Post Automatically Only”

Q.What is a Account group and where is it used? Ans: An Account group controls the data that needs to be entered at the time of creation of a master record. Account groups exist for the definition of a GL account, Vendor and Customer master. It basically controls the fields which pop up during master data creation in SAP.

Q.What is a field status group? Ans: Field status groups control the fields which come up when the user does the transactions. There are three options for field selection. They are: Display only Suppressed Mandatory So basically you can have any field either for display only or you can totally suppress it or make it mandatory. The field status group is stored in the FI GL Master Record.

Q.What is the purpose of a “Document type” in SAP? Ans: A Document type is specified at the Header level during transaction entry and serves the following purposes: · It defines the Number range for documents · It controls the type of accounts that can be posted to eg Assets, Vendor, Customer, Normal GL account · Document type to be used for reversal of entries · Whether it can be used only for Batch input sessions Document Type is created for differentiating business transactions. Eg Vendor Invoice, Credit Memo, Accrual Entries, Customer Invoice. It is a two digit character.

 Q.What is a Financial Statement Version? Ans: A FSV (Financial Statement Version) is a reporting tool and can be used to depict the manner in which the financial accounts like Profit and Loss Account and Balance Sheet needs to be extracted from SAP. It is freely definable and multiple FSV's can be defined for generating the output for various external agencies like Banks and other Statutory authorities.

Q.How are input and output taxes taken care of in SAP? Ans: A tax procedure is defined for each country and tax codes are defined within this. There is flexibility to either expense out the Tax amounts or Capitalize the same to Stocks.

Q.What are Validations and Substitutions? Ans:Validations/Substitutions in SAP are defined for each functional area e.g. FI-GL, Assets, Controlling etc at the following levels 1. Document level 2. Line item level These need to be specifically activated and setting them up are complex and done only when it is really needed. Often help of the technical team is taken to do that.

 Q.Is it possible to maintain plant wise different GL codes? Ans: Yes. To be able to do so the valuation group code should be activated. The valuation grouping code is maintained per plant and is configured in the MM module. Account codes should be maintained per valuation grouping code after doing this configuration.

 Q.Is Business area at company code Level? Ans: No. Business area is at client level. What this means is that other company codes can also post to the same business area. Q.What are the different scenarios under which a Business Area or a Profit Center may be defined? Ans: This question is usually very disputable. But both Business Areas and Profit centers are created for internal reporting. Each has its own pros and cons but many companies nowadays go for Profit center as there is a feeling that business area enhancements would not be supported by SAP in future versions.There are typical month end procedures which need to be executed for both of them and many times reconciliation might become a big issue. A typical challenge in both of them is in cases where you do not know the Business Area or Profit Center of the transaction at the time of posting.

Q.What are the problems faced when a Business area is configured? Ans: The problem of splitting of account balance is more pertinent in case of tax accounts.

 Q.Is it possible to default certain values for particular fields? For e.g.company code. Ans: Yes it is possible to default values for certain fields where a parameter id is present. Step 1 Go to the input field to which you want to make defaults. Step 2 Press F1, then click technical info push button. This would open a window that displays the corresponding parameter id (if one has been allocated to the field) in the field data section. Step 3 Enter this parameter id using the following path on SAP Easy access screen System à User profile à Own data. Step 4 Click on parameter tab. Enter the parameter id code and enter the value you want as default. Save the user settings.

 Q.Which is the default exchange rate type which is picked up for all SAP transactions? Ans: The default exchange rate type picked up for all SAP transactions is M (average rate)

Q.Is it possible to configure the system to pick up a different exchange rate type for a particular transaction?

Ans: Yes it is possible. In the document type definition of GL, you need to attach a different exchange rate type.

 Q.What are the master data pre-requisites for document clearing? Ans: The Gl Account must be managed as an „open item management‟ . This checkbox is there in the General Ledger Master Record called Open Item Management. It helps you to manage your accounts in terms of cleared and uncleared items. A typical example would be GR/IR Account in SAP (Goods Received/Invoice Received Account)

Q.Explain the importance of the GR/IR clearing account. Ans: GR/IR is an interim account. In the legacy system of a client if the goods are received and the invoice is not received the provision is made for the same. In SAP at the Goods receipt stage the system passes an accounting entry debiting the Inventory and crediting the GR/IR Account .Subsequently when an invoice is recd this GR/IR account is debited and the Vendor account is credited. That way till the time that the invoice is not received the GR/IR is shown as uncleared items. Q.How many numbers of line items in one single entry you can have? Ans: The number of line items in one document you can accommodate is 999 lines.

 Q. A Finance Document usually has an assignment field. This field automatically gets populated during data entry. Where does it get its value? Ans: This value comes from the Sort key entered in the Gl master record.

 Q.How do you maintain the number range in Production environment? Do you directly create it in the Production box or do you do it by means of transport? Ans: Number range is to be created in the production client. You can transport it also by way of request but creating in the production client is more advisable.

 Q.In customizing “company code productive “means what? What does it denote? Once the company code is live(real time transactions have started) this check box helps prevents deletion of many programs accidentally. This check box is activated just before go live.

Q.What is done by GR/IR regrouping program? Ans: The balance in a GR/IR account is basically because of 2 main types of transactions:- Goods delivered but invoice not received – Here the Goods receipt is made but no invoice has yet been received from the vendor. In such a scenario GR/IR account will have a credit balance. Invoiced received but goods not delivered – Here the Invoice is received from the vendor and accounted for, but goods have not been received. In such a scenario GR/IR account will have a debit balance.The GR/IR account would contain the net value of the above two types of transactions. The GR/IR regrouping program analyses the above transactions and regroups them to the correct adjustment account. The balance on account of first transactions will be regrouped to another liability account and the balance on account of second transactions will be regrouped to an asset account.

Q.What are the functionalities available in the financial statement version? Ans: In the financial statement version the most important functionality available is the debit credit shift. This is more important in case of Bank overdraft accounts which can have a debit balance or a credit

balance. Thus in case of a debit balance you would require the overdraft account to be shown on the Asset side. In case of credit balance you would require the account to be shown on the Liability side.

 Q.Is it possible to print the financial statement version on a SAPscript form? Ans: Yes. It is possible to print the financial statement version on a SAPscript form.

Q.How do you configure the SAPscript form financial statement version? Ans: It is possible to generate a form from the financial statement version and print the financial statements on a SAPscript form. In the customizing for financial statement version select the FSV you created and choose Goto à Generate form à One column or Two column form.You can also copy form from the standard system.

 Q.Is it possible to generate a financial statement form automatically? Ans: Yes. It is possible to generate a form automatically.

 Q.Is it possible to keep the FI posting period open only for certain GL codes? Ans: Yes. It is possible to keep open the FI posting period only for certain GL codes.

Q.How do you keep the FI posting period open only for certain GL codes? Ans: In transaction code OB52 click on new entries and maintain an interval or a single GL code for the account type S with the posting period variant. If the GL codes are not in sequence then you need to maintain further entries for the posting period variant and account type S.

Q. Can posting period variant be assigned to more than 1 company code? Ans: Yes. Posting period variant can be assigned to more than one company code.

Finance  economy  finance & insurance money derivatives wall street young money  got money cash money  get money

SAP FICO Interview Questions and Answers - 6

SAP FINANCIALS – ENTERPRISE STRUCTURE – Interview Q’s with A’s

Q.What is a Company Code and what are the basic organizational assignments to a company code? Ans: Company Code is a legal entity for which financial statements like Profit and Loss and Balance Sheets are generated. Plants are assigned to the company code, Purchasing organization is assigned to the company code, and Sales organization is assigned to the company code.

Q.What is the relation between a Controlling Area and a Company code? Ans: A Controlling area can have the following 2 type of relationship with a Company code a. Single Company code relation b. Cross Company code relation this means that one single controlling area can be assigned to several different company codes. Controlling can have a one is to one relationship or a one is to many relationship with different company codes. Controlling Area is the umbrella under which all controlling activities of Cost Center Accounting, Product Costing, Profit Center and Profitability Analysis are stored. In a similar way Company Codes is the umbrella for Finance activities.

 Q.How many Chart of Accounts can a Company code have? Ans: A single Company code can have only one Chart of Account assigned to it. The Chart of Accounts is nothing but the list of General Ledger Accounts.

 Q.What are the options in SAP when it comes to Fiscal years? Ans: Fiscal year is nothing but the way financial data is stored in the system.SAP provides you with the combination of 12 normal periods and also four special periods. These periods are stored in what is called the fiscal year variant. There are two types of Fiscal Year Variant · Calendar Year – e.g. Jan-Dec · Year Dependent Fiscal Year .

Q.What is a year dependent fiscal year variant ? Ans:In a year dependent fiscal year variant the number of days in a month are not as per the calendar month. Let us take an example:- For the year 2005 the period January ends on 29th, Feb ends on 27th, March ends on 29. For the year 2006 January ends on 30th, Feb ends on 26th, March ends on 30th. This is applicable to many countries especially USA. Ever year this fiscal year variant needs to be configured in such a case

Q.How does posting happen in MM (Materials Management) during special periods? Ans: There is no posting which happens from MM in special periods. Special periods are only applicable for the FI module. They are required for making any additional posting such as closing entries, provisions. Which happen during quarter end or year end.

 Q.How many currencies can be configured for a company code? Ans: A company code can have 3 currencies in total. They are local currency (ie company code currency) and 2 parallel currencies. This gives the company the flexibility to report in the different currencies.

 Q.Do you require to configure additional ledger for parallel currencies? Ans: Where only 2 currencies are configured (Company code currency and a parallel currency) there is no need for an additional ledger. In case the third parallel currency is also configured and if it is different

than the second currency type, you would then need to configure additional ledger.

 Q.If there are two company codes with different chart of accounts how can you consolidate their activities? Ans. In this case you either need to write an ABAP program or you need to implement the Special Consolidation Module of SAP. If both the company codes use the same chart of accounts then standard SAP reports give you the consolidated figure.

Finance  economy  finance & insurance money derivatives wall street young money  got money cash money  get money