Question 1

What is a batch input session?

Accepted Answer

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

Question 2

What is an ABAP?

Accepted Answer

ABAP (Advanced Business Application Programming) is a high level programming language created by the German software company SAP It is currently positioned as the language for programming SAP's Web Application Server, part of its NetWeaver platform for building business applications Its syntax is somewhat similar to COBOL

Question 3

What is an ABAP/4 Query?

Accepted Answer

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

Question 4

What is BDC programming?

Accepted Answer

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”

Question 5

What are the components of SAP scripts?

Accepted Answer

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

Question 6

What are different ABAP/4 editors? What are the differences?

Accepted Answer

The 2 editors are se38 and se80 both have the abap editor in place In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications

Question 7

What are event keywords in reports?

Accepted Answer

Events keywords in Reports are: For Classical Reports, 1Initialization 2 At line-selection 3 Start-of-selection 4Top-of-page 5 At user-command 6End-of-selection 7 End-of-page 8At Pfn For Interactive Reports, 9At line-selection 10 Top-of-page during line selection For LDB (Logical DataBase) Reports, 10 get 11put 12 get table

Question 8

what are the types of standard SAP Internal Tables?

Accepted Answer

1)standered table 2)index table 3)hashed table 4)sorted table

Question 9

What is an Interactive Report?

Accepted Answer

An Interactive report allows the user to participate in retrieving and present data at each levelwhile classical report doesn't have access to interact

Question 10

What is meant by BDC. How many methods of BDC are there?

Accepted Answer

BDC ----> Batch Data Communication Methods of BDC-----> Direct Input method, Batch Input Session method, Call transaction method

Question 11

How many interactive reports did you write?

Accepted Answer

In an Interactive Report, user can define maximum 20 secondary lists

Question 12

What is Legaccy System Migration Workbench? How it can be carried out in SAP SD?

Accepted Answer

LSMW is widely used by EDI programmers EDI Programmers connect the SAP system to Non SAP system During this Data migration is a necessity When data migrates from source to destination the destination code is differrent from the source code So what LSMW does is * Converts the data in to batch files * Then converts the batch files in to source code batch files * And then mirgates data Standard Interfaces like BAPI or Idoc are used in this process

Question 13

What is meant by consignment stock?

Accepted Answer

Consignment stock is the material which is lying in the premises but is not owned by the company It has no value assigned to it until it is taken into own stock Once it is used in production or to be sold, it is taken into own stock

Question 14

What is Data warehousing?

Accepted Answer

Data warehousing is a process of repository of electronic data of an organization For the purpose of reporting and analysis, data warehousing is used The essence concept of data warehousing is to provide data flow of architectural model from operational system to decision support environments

Question 15

Explain the difference between data mining and data warehousing.

Accepted Answer

Data mining is a method for comparing large amounts of data for the purpose of finding patterns Data mining is normally used for models and forecasting Data mining is the process of correlations, patterns by shifting through large data repositories using pattern recognition techniques Data warehousing is the central repository for the data of several business systems in an enterprise Data from various resources extracted and organized in the data warehouse selectively for analysis and accessibility

Question 16

What are fact tables and dimension tables?

Accepted Answer

Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables

Question 17

What is an OLTP system and OLAP system?

Accepted Answer

OLTP stands for OnLine Transaction Processing Applications that supports and manges transactions which involve high volumes of data are supported by OLTP system OLTP is based on client-server architecture and supports transactions across networks OLAP stands for OnLine Analytical Processing Business data analysis and complex calculations on low volumes of data are performed by OLAP An insight of data coming from various resources can be gained by a user with the support of OLAP

Question 18

What is Dimensional Modeling?

Accepted Answer

Dimensional modeling is often used in Data warehousing In simpler words it is a rational or consistent design technique used to build a data warehouse DM uses facts and dimensions of a warehouse for its design A snow and star flake schema represent data modeling

Question 19

Explain the difference between star and snowflake schemas.

Accepted Answer

Star schema: A highly de-normalized technique A star schema has one fact table and is associated with numerous dimensions table and depicts a star Snow flake schema: The normalized principles applied star schema is known as Snow flake schema Every dimension table is associated with sub dimension table Differences: - A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables - The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema The drilling down data from top most hierarchies to the lowermost hierarchies can be done

Question 20

What is the difference between view and materialized view?

Accepted Answer

View: - Tail raid data representation is provided by a view to access data from its table - It has logical structure can not occupy space - Changes get affected in corresponding tables Materialized view - Pre calculated data persists in materialized view - It has physical data space occupation - Changes will not get affected in corresponding tables

Technology Questions