SAP Interview Questions And Answers
What
is SAP?
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.
SAP Basics feature
* Configuration of the SAP modules
o Transaction SPRO - this is the main tree for all the configuration.
* Function Key
o F1 - Help
o F4 - Possible entries or matchcode for the field you are accessing
o F5 - Selection screen
o F7 - Previous screen
o F8 - Next screen
o F9 - Technical info
o CTRL+X - Cut
o CTRL+C - Copy
o CTRL+V - Paste
* Navigation
o /n Skip to the next record if you are processing one batch input session
o /bend Cancel a batch input foreground process
o /nend Close all R/3 sessions and logoff
o /nxxx x Call the transaction xxxx in the same session
o /o Generate a session list
o /oxxx x Call the transaction xxxx in an additional session
o /i Delete the current session
o /h Turn the debug mode on
o /$tab Reset all buffers (for System Administrators)
o /$syn c Synchronize instances buffers (for System Administrators)
In 4.x, you can have long SAP transaction code up to a maximum of 20 character
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.
SAP Basics feature
* Configuration of the SAP modules
o Transaction SPRO - this is the main tree for all the configuration.
* Function Key
o F1 - Help
o F4 - Possible entries or matchcode for the field you are accessing
o F5 - Selection screen
o F7 - Previous screen
o F8 - Next screen
o F9 - Technical info
o CTRL+X - Cut
o CTRL+C - Copy
o CTRL+V - Paste
* Navigation
o /n Skip to the next record if you are processing one batch input session
o /bend Cancel a batch input foreground process
o /nend Close all R/3 sessions and logoff
o /nxxx x Call the transaction xxxx in the same session
o /o Generate a session list
o /oxxx x Call the transaction xxxx in an additional session
o /i Delete the current session
o /h Turn the debug mode on
o /$tab Reset all buffers (for System Administrators)
o /$syn c Synchronize instances buffers (for System Administrators)
In 4.x, you can have long SAP transaction code up to a maximum of 20 character
Different types of ERP ?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
What is ERP?
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
Explain the concept of “Business Content” in SAP Business
Information `Warehouse?
Business Content is a pre-configured set of role and
task-relevant information models based on consistent Metadata in the SAP
Business Information Warehouse. Business Content provides selected roles within
a company with the information they need to carry out their tasks. These
information models essentially contain roles, workbooks, queries, InfoSources,
InfoCubes, key figures, characteristics, update rules and extractors for SAP
R/3, mySAP.com Business Applications and other selected applications.
Why do you usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
Can BW run without a SAP R/3 implementation?
Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
International Demonstration and Education System. A sample application provided for faster learning and implementation.
What is WF and its importance?
Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, and the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.
Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, and the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.
What is SAP R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
What
are presentation, application and database servers in SAP R/3?
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.
What
should be the approach for writing a BDC program?
Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction (Write the program explicitly) or create sessions (sessions are created and processed, if success data will transfer).
Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction (Write the program explicitly) or create sessions (sessions are created and processed, if success data will transfer).
Explain open SQL vs native SQL?
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
What are datasets?
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
What are internal tables check table, value table, and transparent
table?
Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
What are the major benefits of reporting with BW over R/3? Would it
be sufficient just to Web-enable R/3 Reports?
Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
How can an ERP such as SAP help a business owner learn more about
how business operates?
|
Security Issue
Get Norton Security Scan
and Spyware Doctor free for your Computer from
Google.
The Pack contains nearly 14 plus
software . Pick the one which is suited for you
Make
your PC more useful. Get the free Google Pack.
|
In order to use an ERP system, a business person must
understand the business processes and how they work together from one
functional area to the other. This knowledge gives the student a much deeper
understanding of how a business operates. Using SAP as a tool to learn about
ERP systems will require that the people understand the business processes and
how they integrate.
What is the difference between OLAP and Data Mining?
OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.
OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.
What is “Extended Star Schema” and how did it emerge?
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.
Define Meta data, Master data and
Transaction data ?
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.
Name
some drawbacks of SAP ?
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
What is Bex?
Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.
Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.
What are variables?
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.
What is AWB?. What is its purpose?
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.
What is the significance of ODS in BIW?
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
What are the different types of source system?
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
What
is Extractor?
Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.
Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.
Describe how SAP handles Memory Management?
ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.
ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.
Describe where they would look at the buffer statistics, and what
steps they would use to adjust them?
ST02, RZ10 ...
ST02, RZ10 ...
Describe
how to setup a printer in SAP or where they would look to research why a
user/users can not print?
SPAD, SP01, SM50, SU01 ...
SPAD, SP01, SM50, SU01 ...
Can you create a table with fields not referring to data elements?
YES. eg:- ITAB LIKE SPFLI.here we are referring to a data object(SPFLI) not data element.
What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.
YES. eg:- ITAB LIKE SPFLI.here we are referring to a data object(SPFLI) not data element.
What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.
What should be the approach for writing a BDC program?
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATA TRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed.if success data will transfer).
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATA TRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed.if success data will transfer).
What
are the problems in processing batch input sessions and How is batch input process
different from processing online?
PROBLEMS: i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.
ii)if session processing fails data will not be transferred to SAP database table.
PROBLEMS: i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.
ii)if session processing fails data will not be transferred to SAP database table.
What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT. When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER. When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT. When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER. When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.
Can a transparent table exist in data dictionary but not in the
data base physically?
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. 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.
What is the step by step process to create a table in data
dictionary?
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table field).
step 3: creating tables(SE11).
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table field).
step 3: creating tables(SE11).
A
table is buffered. By select statement I don't want to get the data from table
buffer. I want to get the data from database. How?
If buffering is allowed for a table in the ABAP Dictionary, the SELECT statement always reads the data from the buffer in the database interface of the current application server. To read data directly from the database table instead of from the buffer, use the following:
SELECT... FROM *lt;tables> BYPASSING BUFFER. ..
This addition guarantees that the data you read is the most up to date. However, as a rule, only data that does not change frequently should be buffered, and using the buffer where appropriate improves performance. You should therefore only use this option where really necessary.
If buffering is allowed for a table in the ABAP Dictionary, the SELECT statement always reads the data from the buffer in the database interface of the current application server. To read data directly from the database table instead of from the buffer, use the following:
SELECT... FROM *lt;tables> BYPASSING BUFFER. ..
This addition guarantees that the data you read is the most up to date. However, as a rule, only data that does not change frequently should be buffered, and using the buffer where appropriate improves performance. You should therefore only use this option where really necessary.
What are user exits? What are customer exits?
User exits and customer exits are the same thing.
Both are used to give the customer the chance to influence the outcome of a process(-step) in some way, without having to change the standard SAP software. For example: if an order is entered in the system, availability checks, credit checks etc. could be performed by the system but just before writing the order to the database, the program runs a user exit. In this user exit, your code could change some fields in the order or write an entry in a table that you created for some reason.
User exits and customer exits are the same thing.
Both are used to give the customer the chance to influence the outcome of a process(-step) in some way, without having to change the standard SAP software. For example: if an order is entered in the system, availability checks, credit checks etc. could be performed by the system but just before writing the order to the database, the program runs a user exit. In this user exit, your code could change some fields in the order or write an entry in a table that you created for some reason.
What is the difference between start_form and open_form in scripts?
Why is it necessary to close a form always once it is opened?
Answer1:
strat_form using this we can open many layoutses
open_form using this we can open the layout
performance will be high
Answer2:
Open_form -- is used to initialize the spool request.
Start_form-- is used to initialize the layout.
Answer1:
strat_form using this we can open many layoutses
open_form using this we can open the layout
performance will be high
Answer2:
Open_form -- is used to initialize the spool request.
Start_form-- is used to initialize the layout.
What is difference between ON Change of and At New Field ?
Select Single * from and select Upto 1 rows
At new - on change of difference: In case if you want calculate sub totals for same values in a field you can use the atnew statement.ie:
For example in a table sflight, there are 2 fields carrid ( airline id) and seatsmax( seat available). In case if you want calculate the total number of seats available for each carrrid you can sort the table first and using the at new and sum you can claculate the total seats for each carrid. Atnew will be triggered whenever there is a change in the carrid and the total seats will be returned for each carrid.
In the same scenario if you use onchange of it will not return the total seats for each carrid, instead it will return the total seat count for the entire table( ie: for all the carrids in the table. Another diffrence is atnew can be used only between loop and end loop whereas on change of can also be used in select- endselect , do -enddo. Another diffrence is while using atnew in case if you code any write statements between atnew and end at the value for the numeric fields will be returned as 0 and that of no numeric fields will be returned as *(asteriks). But in on change of the orginal values will be returned. Select single * and select upto 1 row diffrence.
The select single * from stmt selects only one row form the database table and puts it in to the work area(internal table). The select upto n(where n stands for a integer number) rows stmt selects all the rows from the database table but writes only the specified number of rows specified by the n into the internal table. If its given as upto 1 rows only 1 row is written in to the internal table.
Select Single * from and select Upto 1 rows
At new - on change of difference: In case if you want calculate sub totals for same values in a field you can use the atnew statement.ie:
For example in a table sflight, there are 2 fields carrid ( airline id) and seatsmax( seat available). In case if you want calculate the total number of seats available for each carrrid you can sort the table first and using the at new and sum you can claculate the total seats for each carrid. Atnew will be triggered whenever there is a change in the carrid and the total seats will be returned for each carrid.
In the same scenario if you use onchange of it will not return the total seats for each carrid, instead it will return the total seat count for the entire table( ie: for all the carrids in the table. Another diffrence is atnew can be used only between loop and end loop whereas on change of can also be used in select- endselect , do -enddo. Another diffrence is while using atnew in case if you code any write statements between atnew and end at the value for the numeric fields will be returned as 0 and that of no numeric fields will be returned as *(asteriks). But in on change of the orginal values will be returned. Select single * and select upto 1 row diffrence.
The select single * from stmt selects only one row form the database table and puts it in to the work area(internal table). The select upto n(where n stands for a integer number) rows stmt selects all the rows from the database table but writes only the specified number of rows specified by the n into the internal table. If its given as upto 1 rows only 1 row is written in to the internal table.
When you create sales report, What you can see in that report ?
What are those field names or data element names?
vbak-auart, "ORDER TYPE
vbak-audat, "DOCUMENT DATE
vbak-kunnr, "CUSTOMER
vbak-bstnk, "PURCHASEORDERNO
vbak-submi, "collective no
vbrp-posnr, "ITEM
vbrp-matnr, "MATERIAL NUMBER
vbrp-arktx, "DESCRIPTION
vbrp-fkimg, "ORDER QTY
vbrp-vkbur, "SALESOFFICE
vbrp-aubel, "SALES DOCUMENT
vbrk-netwr, "NETPRICE
vbrk-vbeln, "BILLINGDOCNO
vbrk-knumv, "DOC.CONDITION
kna1-name1, "CUSTOMERNAME
vbrp-werks, "PLANT
vbrk-kunrg, "PAYER
kna1-name1, "PAYER NAME
vbpa-kunnr, "EMPLOYEENO
vbrk-netwr, "DISCOUNT
vbrk-netwr,"NETAMT
vbrk-netwr,"INVAMT
vbrk-fkart, "billing type
vbrk-netwr, "CST
konv-kbetr, "CST PER
vbrk-netwr, "LST
konv-kbetr, "LST PER
vbrk-netwr, "ED
konv-kbetr, "ED PER
vbrk-netwr, "Ecs
konv-kbetr, "Ecs PER
vbrk-netwr, "SURCHARGE
vbrk-fkdat, "BILLINGDATE
kna1-name1, "EMPLOYEENAME
vbak-bstdk, "PODATE
likp-bolnr, "Bill Of Lading
likp-traty, "Means of Transport Type
likp-traid, "Means of Transport ID
vbpa-kunnr, "Bill To Party
kna1-name1, "Bill To Party Name
vbrk-netwr, "Net Amount Basic Amount - Discount
vbak-audat, "DOCUMENT DATE
vbak-kunnr, "CUSTOMER
vbak-bstnk, "PURCHASEORDERNO
vbak-submi, "collective no
vbrp-posnr, "ITEM
vbrp-matnr, "MATERIAL NUMBER
vbrp-arktx, "DESCRIPTION
vbrp-fkimg, "ORDER QTY
vbrp-vkbur, "SALESOFFICE
vbrp-aubel, "SALES DOCUMENT
vbrk-netwr, "NETPRICE
vbrk-vbeln, "BILLINGDOCNO
vbrk-knumv, "DOC.CONDITION
kna1-name1, "CUSTOMERNAME
vbrp-werks, "PLANT
vbrk-kunrg, "PAYER
kna1-name1, "PAYER NAME
vbpa-kunnr, "EMPLOYEENO
vbrk-netwr, "DISCOUNT
vbrk-netwr,"NETAMT
vbrk-netwr,"INVAMT
vbrk-fkart, "billing type
vbrk-netwr, "CST
konv-kbetr, "CST PER
vbrk-netwr, "LST
konv-kbetr, "LST PER
vbrk-netwr, "ED
konv-kbetr, "ED PER
vbrk-netwr, "Ecs
konv-kbetr, "Ecs PER
vbrk-netwr, "SURCHARGE
vbrk-fkdat, "BILLINGDATE
kna1-name1, "EMPLOYEENAME
vbak-bstdk, "PODATE
likp-bolnr, "Bill Of Lading
likp-traty, "Means of Transport Type
likp-traid, "Means of Transport ID
vbpa-kunnr, "Bill To Party
kna1-name1, "Bill To Party Name
vbrk-netwr, "Net Amount Basic Amount - Discount
How to assign multiple transaction codes in a session method to
BDC_Insert function module?
Call function ' BDC_Insert'
exporting
tr. code = ' enter tr.code1 here'
table = 'give an internal table related totr.code1 here'
call function 'BDC_INSERT'
exporting
tr.code = ' enter 2nd tr code'
tables = ' 2nd internal table'
Call function ' BDC_Insert'
exporting
tr. code = ' enter tr.code1 here'
table = 'give an internal table related totr.code1 here'
call function 'BDC_INSERT'
exporting
tr.code = ' enter 2nd tr code'
tables = ' 2nd internal table'
“Check”
and “Continue”. What is the difference?
Check statement, checks the condition with in a loop and if it satisfies the condition, the control moves to next statement in the loop. Otherwise, it terminates the loop.
Continue statement, acts like goto statement. If the condition is true, it processes the remaining statements and if the condition is false, then the control moves to the top of loop.
At-Line selection, At user-command etc..,
In at line-selection system defined fcode will be generated In at user-command we need to define the fcode and fkey manually then only it will triggers.
Check statement, checks the condition with in a loop and if it satisfies the condition, the control moves to next statement in the loop. Otherwise, it terminates the loop.
Continue statement, acts like goto statement. If the condition is true, it processes the remaining statements and if the condition is false, then the control moves to the top of loop.
At-Line selection, At user-command etc..,
In at line-selection system defined fcode will be generated In at user-command we need to define the fcode and fkey manually then only it will triggers.
“Exit” and “Stop”. What is the difference?
exit statments is exit the current loop. and moving to next loop but stop statement move to end of selection. it's not check all other loops.
exit statments is exit the current loop. and moving to next loop but stop statement move to end of selection. it's not check all other loops.
What is the reserve command?
Answer1:
Reverse Command :Reverse N Lines : if there is not enough space left on the current page for atleast n lines it starts a new page
Answer2:
RESERVE
If insufficient space is there for listing output reserve statement encounters NEW-PAGE.But before going to new page it processes END-OF-PAGE.
Answer1:
Reverse Command :Reverse N Lines : if there is not enough space left on the current page for atleast n lines it starts a new page
Answer2:
RESERVE
If insufficient space is there for listing output reserve statement encounters NEW-PAGE.But before going to new page it processes END-OF-PAGE.
What
are even`qt keywords in reports?
Answer1:
Events keywords in Reports are
For Classical Reports,
1.Initialization
2. At line-selection
3. Start-of-selection
4.Top-of-page
5. At user-command
6.End-of-selection
7. End-of-page
8.At Pfn
For Interactive Reports,
9.At line-selection 10. Top-of-page during line selection
For LDB (Logical DataBase) Reports,
10. get 11.put 12. get table
Answer2:
1. Initialization
2. At line-selection
3. Start-of-selection
4.Top-of-page
5. Top-of -page during at line-selection
6. At PF
7. At user-command
8.End-of-selection
9. End-of-page
Answer1:
Events keywords in Reports are
For Classical Reports,
1.Initialization
2. At line-selection
3. Start-of-selection
4.Top-of-page
5. At user-command
6.End-of-selection
7. End-of-page
8.At Pfn
For Interactive Reports,
9.At line-selection 10. Top-of-page during line selection
For LDB (Logical DataBase) Reports,
10. get 11.put 12. get table
Answer2:
1. Initialization
2. At line-selection
3. Start-of-selection
4.Top-of-page
5. Top-of -page during at line-selection
6. At PF
7. At user-command
8.End-of-selection
9. End-of-page
How
can validate input values in selection screen and which event was fired?
Answer1:
We can Validate Selection Screen With the Help of the Following Events, the Event Follows the Same hierachy.
AT SELECTION-SCREEN ON
AT SELECTION-SCREEN ON BLOCK
AT SELECTION-SCREEN OUTPUT
AT SELECTION-SCREEN.
Answer2:
At selection-screen on
select stmt ------------------ where = .
if sy-subrc = 0.
validation success for LOw value in selection screen
At selection-screen on
select stmt-------------------- where =
if sy-subrc <> 0.
validation failure on high value in the selection field.
else
success.
endif
Answer1:
We can Validate Selection Screen With the Help of the Following Events, the Event Follows the Same hierachy.
AT SELECTION-SCREEN ON
AT SELECTION-SCREEN ON BLOCK
AT SELECTION-SCREEN OUTPUT
AT SELECTION-SCREEN.
Answer2:
At selection-screen on
select stmt ------------------ where = .
if sy-subrc = 0.
validation success for LOw value in selection screen
At selection-screen on
select stmt-------------------- where =
if sy-subrc <> 0.
validation failure on high value in the selection field.
else
success.
endif
BDC Transaction code?
Transaction code for bdc :SHDB
Transaction code for bdc :SHDB
How to navigate basic list to secondary list?
We can Navigate from basic list to secondary list with the help the event called AT LINE-SELECTION. for every Secondary List the System Field SY-LSIND increases by 1. So there will be Totally 21 list possible in SAP.
One Basic List 20 Secondary List.
We can Navigate from basic list to secondary list with the help the event called AT LINE-SELECTION. for every Secondary List the System Field SY-LSIND increases by 1. So there will be Totally 21 list possible in SAP.
One Basic List 20 Secondary List.
Which
is the First character of creating LockObject?
LockObjects always starts with character 'E'.
LockObjects always starts with character 'E'.
What is the Difference between Data Element and Domain?
Answer1:
Domain: Defines the attributes such as length,type and possible value range.
Data element; An intermediate object between domain and table type
Answer2:
Domain : technical attributes of dataelement is called domain.
Dataelement : Symantic attributes are called dataelement.
Answer1:
Domain: Defines the attributes such as length,type and possible value range.
Data element; An intermediate object between domain and table type
Answer2:
Domain : technical attributes of dataelement is called domain.
Dataelement : Symantic attributes are called dataelement.
How many types of standard SAP Internal Tables?
|
Security Issue
Get Norton Security Scan
and Spyware Doctor free for your Computer from
Google.
The Pack contains nearly 14 plus
software . Pick the one which is suited for you
Make
your PC more useful. Get the free Google Pack.
|
1)standered table
2)index table
3)hashed table
4)sorted table
2)index table
3)hashed table
4)sorted table
What is the Difference Between Tablecontrols and Step Loops?
Table controls have both horizontal and vertical scrollers and cursor control logic is designed implicitly.
Step loops have only horizontal scrollers and cursor control logic is to be designed by the user explicitly.
Table controls have both horizontal and vertical scrollers and cursor control logic is designed implicitly.
Step loops have only horizontal scrollers and cursor control logic is to be designed by the user explicitly.
What are the Events in Dialog Programs?
Events in Dialog Programming are:
Events in Dialog Programming are:
PBO-Process Before Output
PAI-Process After Input
POH-Process on Help Request
POV-Process on Value Request
How
many ways you can create Table?
User can create a Database table in two ways.
1. Top-to-bottom approach: In this approach, first fields are defined and later domain and data element are defined.
2.Bottom-to-top approach: In this approach, first domain and data element are defined and later fields are defined.
User can create a Database table in two ways.
1. Top-to-bottom approach: In this approach, first fields are defined and later domain and data element are defined.
2.Bottom-to-top approach: In this approach, first domain and data element are defined and later fields are defined.
What are the Cluster Tables?
Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.
Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.
What are function modules in LDB?
Function modules in LDB's are
get
put
get late
Function modules in LDB's are
get
put
get late
What
are Difference Between Classical Batch Input and Call Transaction?
Answer1:
In Batch input many transactions can be executed, where as in Call transcation only one transactioin can be executed.
BI is a background process, Ct can be either background or foreground .
BI is Synchronous process, Ct is both Asynchronous & Synchronous.
BI Sessions cannot be runed parallel.
Log file is generated automaticly in BI, errors can be found through BDCMSGCOLL.
Answer2:
1.batch input works for multiple applications where as call transactions doen't work
2.batch input has an implicit log file with it. where as call transaction doesn't have
3.batch input has sy-subrc check with the database where as call transaction doesn't have so call transaction is fast.
Answer1:
In Batch input many transactions can be executed, where as in Call transcation only one transactioin can be executed.
BI is a background process, Ct can be either background or foreground .
BI is Synchronous process, Ct is both Asynchronous & Synchronous.
BI Sessions cannot be runed parallel.
Log file is generated automaticly in BI, errors can be found through BDCMSGCOLL.
Answer2:
1.batch input works for multiple applications where as call transactions doen't work
2.batch input has an implicit log file with it. where as call transaction doesn't have
3.batch input has sy-subrc check with the database where as call transaction doesn't have so call transaction is fast.
How can you call the Sessions?
using transaction code SM35
using transaction code SM35
Can you call Report in SAP Script?
Yes, we can.
Just write in Line editor:
/:perform f_display_report
--------------
----------
----------
/:endperform
THIS PERFORM WOULD BE DECLARED IN THE PRINT PROGRAMME IN WHICH YOU CAN ALWAYS WRITE STATEMENT
SUBMIT REPORT...
Yes, we can.
Just write in Line editor:
/:perform f_display_report
--------------
----------
----------
/:endperform
THIS PERFORM WOULD BE DECLARED IN THE PRINT PROGRAMME IN WHICH YOU CAN ALWAYS WRITE STATEMENT
SUBMIT REPORT...
How to Upload Logo to Layout Set and what is Program Name?
You can also upload a Logo in BMP format - it has to be saved as "%^ Colours if it is a colour Bitmap.
If you don't save a colour Bitmap as 256 Colours then it will be uploaded in Black.
This can be done in Smart Forms, SAPScript or Transaction SE78
You can also upload a Logo in BMP format - it has to be saved as "%^ Colours if it is a colour Bitmap.
If you don't save a colour Bitmap as 256 Colours then it will be uploaded in Black.
This can be done in Smart Forms, SAPScript or Transaction SE78
What
are the SET Parameter and GET Parameter?
To use parameter IDs, you need to “set” (store) values in the global memory area and then “get” (retrieve) values from this parameter ID memory area. §IIn the case of an online program, you will “set” values from screen fields and you will “get” these values for screen fields. §YYou can perform this “set/get” function two ways: § Use the ABAP statements “SET PARAMETER ID” and “GET PARAMETER ID”. § Use the field attributes “SPA” and “GPA” . §RRemember that parameter IDs can only be used with ABAP Dictionary fields because parameter IDs are linked to data elements. The appropriate data elements must have a parameter IDs for this “set/get” function to work.
To use parameter IDs, you need to “set” (store) values in the global memory area and then “get” (retrieve) values from this parameter ID memory area. §IIn the case of an online program, you will “set” values from screen fields and you will “get” these values for screen fields. §YYou can perform this “set/get” function two ways: § Use the ABAP statements “SET PARAMETER ID” and “GET PARAMETER ID”. § Use the field attributes “SPA” and “GPA” . §RRemember that parameter IDs can only be used with ABAP Dictionary fields because parameter IDs are linked to data elements. The appropriate data elements must have a parameter IDs for this “set/get” function to work.
What
are Text Elements?
Text elements makes program easier to maintain program texts in different languages.
These are used for maintainig list headers,selectiontexts in programs
Text elements makes program easier to maintain program texts in different languages.
These are used for maintainig list headers,selectiontexts in programs
What is an Interactive Report?
An Interactive report allows the user to participate in retrieving and present data at each level.while classical report doesn't have access to interact
An Interactive report allows the user to participate in retrieving and present data at each level.while classical report doesn't have access to interact
What are Layout set Elements?
layout set elements are
1.header 2.peragraph formats 3. character formats 4. windows 5. pages 6.page windows
layout set elements are
1.header 2.peragraph formats 3. character formats 4. windows 5. pages 6.page windows
Distinguish between setscreen and call screen?
In the case of setscreen the entire processing of the current screen takes place and then the system branches out to next screen.if u want to branch out to the next screen without processing the current screen then LEAVE SCREEN should be used along with SET SCREEN.
CALL SCREEN is usually used for pop up screens.
In the case of setscreen the entire processing of the current screen takes place and then the system branches out to next screen.if u want to branch out to the next screen without processing the current screen then LEAVE SCREEN should be used along with SET SCREEN.
CALL SCREEN is usually used for pop up screens.
What is ABAP Memory and SAP Memory?
Answer1;
SAP memory is a memory area to which all main sessions within a SAPgui have access. You can use SAP memory either to pass data from one program to another within a session, or to pass data from one session to another. Application programs that use SAP memory must do so using SPA/GPA parameters .
ABAP memory is a memory area that all ABAP programs within the same internal session can access using the EXPORT and IMPORT statements. Data within this area remains intact during a whole sequence of program calls. To pass data to a program which you are calling, the data needs to be placed in ABAP memory before the call is made. The internal session of the called program then replaces that of the calling program. The program called can then read from the ABAP memory.
Answer2;
1. SAP memory is for cross-transaction Applications and ABAP/4 memory is transaction-specific.
2. The SAP memory, otherwise known as the global memory, is available to a user during the entire duration of a terminal session. Its contents are retained across transaction boundaries as well as external and internal sessions. The contents of the ABAP/4 memory are retained only during the lifetime of an external session. You can retain or pass data across internal sessions.
3. The SET PARAMETER and GET PARAMETER statements allow you to write to, or read from, the SAP memory. The EXPORT TO MEMORY and IMPORT FROM MEMORY statements allow you to write data to, or read data from, the ABAP memory.
Answer1;
SAP memory is a memory area to which all main sessions within a SAPgui have access. You can use SAP memory either to pass data from one program to another within a session, or to pass data from one session to another. Application programs that use SAP memory must do so using SPA/GPA parameters .
ABAP memory is a memory area that all ABAP programs within the same internal session can access using the EXPORT and IMPORT statements. Data within this area remains intact during a whole sequence of program calls. To pass data to a program which you are calling, the data needs to be placed in ABAP memory before the call is made. The internal session of the called program then replaces that of the calling program. The program called can then read from the ABAP memory.
Answer2;
1. SAP memory is for cross-transaction Applications and ABAP/4 memory is transaction-specific.
2. The SAP memory, otherwise known as the global memory, is available to a user during the entire duration of a terminal session. Its contents are retained across transaction boundaries as well as external and internal sessions. The contents of the ABAP/4 memory are retained only during the lifetime of an external session. You can retain or pass data across internal sessions.
3. The SET PARAMETER and GET PARAMETER statements allow you to write to, or read from, the SAP memory. The EXPORT TO MEMORY and IMPORT FROM MEMORY statements allow you to write data to, or read data from, the ABAP memory.
Explain Check Table and Value Table ?
check tabke works at table level and value table works at domain level.
check table is nothing but master table that u will create with valid set of values.
value table it provides the list of values and it will automatically proposed as a check table while creating foreing key relationship
check tabke works at table level and value table works at domain level.
check table is nothing but master table that u will create with valid set of values.
value table it provides the list of values and it will automatically proposed as a check table while creating foreing key relationship
How
many types of Standard Internal Tables?
- STANDARD TABLE:
The key is, by default, set to NON-UNIQUE. You may not use
the UNIQUE addition.
- SORTED TABLE:
Unlike stadard tables, sorted table have no default setting
for the uniqueness attribute. If you do not specify either
UNIQUE or NON-UNIQUE, the system defines a generic table
type, where uniqueness is irrelevant. You can use generic
types to specify the type of generic subroutine parameters.
- HASHED TABLE:
Hashed tables have no default setting. You must use the
UNIQUE addition with hashed tables. You may not use
NON-UNIQUE.
- STANDARD TABLE:
The key is, by default, set to NON-UNIQUE. You may not use
the UNIQUE addition.
- SORTED TABLE:
Unlike stadard tables, sorted table have no default setting
for the uniqueness attribute. If you do not specify either
UNIQUE or NON-UNIQUE, the system defines a generic table
type, where uniqueness is irrelevant. You can use generic
types to specify the type of generic subroutine parameters.
- HASHED TABLE:
Hashed tables have no default setting. You must use the
UNIQUE addition with hashed tables. You may not use
NON-UNIQUE.
What is Refresh in Internal Table?
'Refresh' is the keyworld which clears the contents of an internal table body.
'Refresh' is the keyworld which clears the contents of an internal table body.
What
is the Difference Between Collect and Sum?
COLLECT allows you to create unique or summarized datasets. The system first tries to find a table entry corresponding to the table key. The key values are taken either from the header line of the internal table itab, or from the explicitly-specified work area.
If the system finds an entry, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, the system creates a new entry instead.
The way in which the system finds the entries depends on the type of the internal table:
- STANDARD TABLE:
The system creates a temporary hash administration for the table to find the entries. This means that the runtime required to find them does not depend on the number of table entries. The administration is temporary, since it is invalidated by operations like DELETE, INSERT, MODIFY, SORT, ...). A subsequent COLLECT is then no longer independent of the table size, because the system has to use a linear search to find entries. For this reason, you should only use COLLECT to fill standard tables.
- SORTED TABLE:
The system uses a binary search to find the entries. There is a logarithmic relationship between the number of table entries and the search time.
COLLECT allows you to create unique or summarized datasets. The system first tries to find a table entry corresponding to the table key. The key values are taken either from the header line of the internal table itab, or from the explicitly-specified work area.
If the system finds an entry, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, the system creates a new entry instead.
The way in which the system finds the entries depends on the type of the internal table:
- STANDARD TABLE:
The system creates a temporary hash administration for the table to find the entries. This means that the runtime required to find them does not depend on the number of table entries. The administration is temporary, since it is invalidated by operations like DELETE, INSERT, MODIFY, SORT, ...). A subsequent COLLECT is then no longer independent of the table size, because the system has to use a linear search to find entries. For this reason, you should only use COLLECT to fill standard tables.
- SORTED TABLE:
The system uses a binary search to find the entries. There is a logarithmic relationship between the number of table entries and the search time.
What are the ways of creating Tables?
There are two ways to create table
1) top-down approach
2) bottom-up approach
There are two ways to create table
1) top-down approach
2) bottom-up approach
What
are Function Modules?
Answer1:
Function modules is a extranal subroutine.we can call it to outside the program.its a mini program. its used for redues the coding,easy to find error.
Answer2:
Function modules is like a small program (is not a suboutine because sub-routines are not standalone objects-i.e we cannot execute them alone) which are similar to 'functions' in C.
We can pass the varible and get the return values even with out knowing what is happening in its code.
They are standalone programs-i.e.we can debug and execute them alone unlike subroutines and macros and includes.
Answer1:
Function modules is a extranal subroutine.we can call it to outside the program.its a mini program. its used for redues the coding,easy to find error.
Answer2:
Function modules is like a small program (is not a suboutine because sub-routines are not standalone objects-i.e we cannot execute them alone) which are similar to 'functions' in C.
We can pass the varible and get the return values even with out knowing what is happening in its code.
They are standalone programs-i.e.we can debug and execute them alone unlike subroutines and macros and includes.
What is CAT?
"CAT" Computer Aided Test Tool. Used to create test cases for application testing purposes.
"CAT" Computer Aided Test Tool. Used to create test cases for application testing purposes.
What
is LDB?
Logical Database is an ABAP program which retrieves data from various tables
Which are interrelated and provides a read only view of the data.
Logical Database is an ABAP program which retrieves data from various tables
Which are interrelated and provides a read only view of the data.
What
are the EVENTS in Report Program? What are EVENTS In Interactive Report and
Explain?
Classical Report Events are
LOAD OF PROGRAM.INITIALIZATION.
AT SELECTION-SCREEN.START-OF-SELECTION.
TOP-OF-PAGE.END-OF-PAGE.
END-OF-SELECTION.
Interactive events are
AT LINE-SELECTION.
AT USER-COMMAND.
TOP-OF-PAGE DURING LINE-SELECTION.
AT LINE-SELECTION:Allows the user to interact with the lists.
AT USER-COMMAND:USed for handling Push buttons.
SET PF-STATUS:Provides User Interface.
Classical Report Events are
LOAD OF PROGRAM.INITIALIZATION.
AT SELECTION-SCREEN.START-OF-SELECTION.
TOP-OF-PAGE.END-OF-PAGE.
END-OF-SELECTION.
Interactive events are
AT LINE-SELECTION.
AT USER-COMMAND.
TOP-OF-PAGE DURING LINE-SELECTION.
AT LINE-SELECTION:Allows the user to interact with the lists.
AT USER-COMMAND:USed for handling Push buttons.
SET PF-STATUS:Provides User Interface.
What are the various techniques of BDC?
call transaction
session method
direct input method
call transaction
session method
direct input method
What
is SQL Trace?
SQL Tracer is a tool used to measure the performance of ABAP program.
T.code :st05
SQL Tracer is a tool used to measure the performance of ABAP program.
T.code :st05
What is LUW?
It is a span of time during which database records are updated either
commit or rollback.
It is a span of time during which database records are updated either
commit or rollback.
Have
you worked with reading and writing data on to files?
YES, open dataset <filename> for output. read dataset <filename> from itab. close dataset <filename>.
YES, open dataset <filename> for output. read dataset <filename> from itab. close dataset <filename>.
Have
you created tables in SAP? What are client dependent and independent tables?
How do you create independent tables?
Tables which are having MANDT field is called as client dependent tables. Tables which are not having MANDT field is called as client dependent tables.
Tables which are having MANDT field is called as client dependent tables. Tables which are not having MANDT field is called as client dependent tables.
Have you used SM30 and SM31 transactions?
sm30 is used to view the ' Call Up View Maintenance ' and SM31 is to view the ' Table maintenance ' with
sm30 is used to view the ' Call Up View Maintenance ' and SM31 is to view the ' Table maintenance ' with
How many dictionary objects are there and list all
Available Dictionary Objects are Domains, Viwes, Match Codes, Lock Objects, Structures, Data Elements, Intenal Types.
Available Dictionary Objects are Domains, Viwes, Match Codes, Lock Objects, Structures, Data Elements, Intenal Types.
What
is the difference between transparent and non transparent database tables?
Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality.
Transparent table can access with using OPen & NAtive SQL stmts where as Nontransparent only OPen Sql.
Transparent trables can store Table relevent data and non transparent tables can store system data/ application data based on the transparent tables
Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality.
Transparent table can access with using OPen & NAtive SQL stmts where as Nontransparent only OPen Sql.
Transparent trables can store Table relevent data and non transparent tables can store system data/ application data based on the transparent tables
What
is meant by BDC. How many methods of BDC are there?
BDC -> BATCH DATA COMMUNICATION.
METHODS OF BDC-> Direct Input method, Batch Input Session method, Call transaction method.
BDC -> BATCH DATA COMMUNICATION.
METHODS OF BDC-> Direct Input method, Batch Input Session method, Call transaction method.
What are the difference between table controls and step loops in
dialog programming?
1. Function modules use a special screen to define the parameters where as subroutines use the same ABAP/4 editor to define its parameters.
2. Tables work area can be commonly shared by calling program and subroutine where as function modules do not share commonly.
3. Calling a function module syntax (Call function.) is different from calling a subroutine syntax (perform….).
4. With raise statement user can exit from a function module where as exit is used in subroutines.
1. Function modules use a special screen to define the parameters where as subroutines use the same ABAP/4 editor to define its parameters.
2. Tables work area can be commonly shared by calling program and subroutine where as function modules do not share commonly.
3. Calling a function module syntax (Call function.) is different from calling a subroutine syntax (perform….).
4. With raise statement user can exit from a function module where as exit is used in subroutines.
What is ALE, IDOC , EDI , RFC. Explain briefly.
ALE: application linking enabling
IDOC: intermediatary documents
EDI: electronic data interchange
RFC: remote function call
ALE: application linking enabling
IDOC: intermediatary documents
EDI: electronic data interchange
RFC: remote function call
What is a binary search?
Binary Search is used in internal table for searching the records. its means record searched one by one from top & bottom both side.so its a easy nd fast way to find the record.bt pointer searching is better.
Binary Search is used in internal table for searching the records. its means record searched one by one from top & bottom both side.so its a easy nd fast way to find the record.bt pointer searching is better.
Types of User Exits, what kind of work is done on these exits?
File Exit, Menu Exit, Function Exit.
File Exit, Menu Exit, Function Exit.
How will you find out where the user exits are available?
CMOD : This transaction allows you to create a PROJECT by identifying its ENHANCEMENT(S). After determining all of the ENHANCEMENTS that are part of the PROJECT, you will have to activate the PROJECT. You will still need to code your user-exit; therefore, you may want to wait until this step is completed before activating the PROJECT.
§SMOD : This transaction allows you to create an ENHANCEMENT, which you will include in a PROJECT, by identifying its COMPONENT(S). In the case where SAP has already created an ENHANCEMENT for its pre-defined user-exits, you will not need to use transaction SMOD; instead, you should just use transaction CMOD.
CMOD : This transaction allows you to create a PROJECT by identifying its ENHANCEMENT(S). After determining all of the ENHANCEMENTS that are part of the PROJECT, you will have to activate the PROJECT. You will still need to code your user-exit; therefore, you may want to wait until this step is completed before activating the PROJECT.
§SMOD : This transaction allows you to create an ENHANCEMENT, which you will include in a PROJECT, by identifying its COMPONENT(S). In the case where SAP has already created an ENHANCEMENT for its pre-defined user-exits, you will not need to use transaction SMOD; instead, you should just use transaction CMOD.
Have you created any transactions?
Yes,
We can use TC SE93 for creating our own transaction code.
Yes,
We can use TC SE93 for creating our own transaction code.
Difference between Table-Controls and Step-loops?
Table controls are modified / mproved versions of step loops.
in controls we can do,
horizontal scrolling,
vertical scrolling,
scrolling in a perticular field,
resize the table,
can save the settings for future use,
can make selective columns editable,....etc
these things are not possible with step loops.
step loops are controlled by loop-endloop statements.
Table controls are modified / mproved versions of step loops.
in controls we can do,
horizontal scrolling,
vertical scrolling,
scrolling in a perticular field,
resize the table,
can save the settings for future use,
can make selective columns editable,....etc
these things are not possible with step loops.
step loops are controlled by loop-endloop statements.
Import and Export
ABAP memory is a memory area that all ABAP programs within the same internal session can access using the EXPORT and IMPORT statements. Data within this area remains intact during a whole sequence of program calls. To pass data to a program which you are calling, the data needs to be placed in ABAP memory before the call is made. The internal session of the called program then replaces that of the calling program. The program called can then read from the ABAP memory. If control is then returned to the program which made the initial call, the same process operates in reverse.
ABAP memory is a memory area that all ABAP programs within the same internal session can access using the EXPORT and IMPORT statements. Data within this area remains intact during a whole sequence of program calls. To pass data to a program which you are calling, the data needs to be placed in ABAP memory before the call is made. The internal session of the called program then replaces that of the calling program. The program called can then read from the ABAP memory. If control is then returned to the program which made the initial call, the same process operates in reverse.
How many interactive reports did you write?
In an Interactive Report, user can define maximum 20 secondary lists.
In an Interactive Report, user can define maximum 20 secondary lists.
What is an “Unpack command”
UNPACK field1TO field2 .Unpacks the packed field field1 and places it in the field field2 with leading zeros. If field2 is too short, it is truncated on the left.
UNPACK field1TO field2 .Unpacks the packed field field1 and places it in the field field2 with leading zeros. If field2 is too short, it is truncated on the left.
SAP Modules Interview Questions And Answers
What
is the difference between updated project and end to end project. explain
Answer1:
Some organisations select to implement SAP module by module, thus gets updated as per their convenience / schedule. This is called as updated project.
Some organisations simply plan all integrated functional modules and decide to go-live with all functional modules and take their entire operations on SAP. This is called as End to End SAP implementation project.
Answer2:
Upgrade Project is a project where in SAP is already in place and it is the version upgrade from a lower end to a higher version.
End to End project is a project where SAP is implemented for the first time.
Answer1:
Some organisations select to implement SAP module by module, thus gets updated as per their convenience / schedule. This is called as updated project.
Some organisations simply plan all integrated functional modules and decide to go-live with all functional modules and take their entire operations on SAP. This is called as End to End SAP implementation project.
Answer2:
Upgrade Project is a project where in SAP is already in place and it is the version upgrade from a lower end to a higher version.
End to End project is a project where SAP is implemented for the first time.
What is Ranking order in automatic payment program ?
Its the priority assigned to each house bank which helps Automatic Payment program choose the house bank for payment in case there are more than one bank satisfying the payment program.
If a payment program ends up selecting more than one(say 4) bank for payment, the ranking of the banks helps it select one bank from the list of (say 4) selected banks.
Its the priority assigned to each house bank which helps Automatic Payment program choose the house bank for payment in case there are more than one bank satisfying the payment program.
If a payment program ends up selecting more than one(say 4) bank for payment, the ranking of the banks helps it select one bank from the list of (say 4) selected banks.
What is SAP APO?
Answer1:
SAP APO stands for Advanced Planner and Optimizer, which is one area of SCM and application component of MySAP product. Its is designed to provide solutions for companies in Demand planning, network design, supply network planning, production planning and global available to promise, transportation and scheduling.
Answer2:
Prior to SCM4.0 (-APO3.1) APO was a system, now from SCM4.0 APO is a function of SCM not a system as SCM now includes ECH and CM
Answer1:
SAP APO stands for Advanced Planner and Optimizer, which is one area of SCM and application component of MySAP product. Its is designed to provide solutions for companies in Demand planning, network design, supply network planning, production planning and global available to promise, transportation and scheduling.
Answer2:
Prior to SCM4.0 (-APO3.1) APO was a system, now from SCM4.0 APO is a function of SCM not a system as SCM now includes ECH and CM
What are the support tickets given in SAP fico module? please give
some examples.
Support tickets are basically the problems that arise in day to day usage of SAP.
So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets.
Support tickets are basically the problems that arise in day to day usage of SAP.
So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets.
How is bank reconciliation handled in SAP?
The following are the steps for BRS:
1. Create Bank Master Data - This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account
2. Define House Bank
3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.
a. setup all co codes for payment transaction - Customer and vendors
b.setup paying co codes for payment transactions
c.setup payment method per country
d.setup payment method per co code for payment transaction
e.setup bank determination for payment transaction
Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement) . Don't forget to keep the opening Balance as zero. Use FBEA for post process.
All the steps together will lead to (FF67) Bank reconciliation statement.
The following are the steps for BRS:
1. Create Bank Master Data - This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account
2. Define House Bank
3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.
a. setup all co codes for payment transaction - Customer and vendors
b.setup paying co codes for payment transactions
c.setup payment method per country
d.setup payment method per co code for payment transaction
e.setup bank determination for payment transaction
Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement) . Don't forget to keep the opening Balance as zero. Use FBEA for post process.
All the steps together will lead to (FF67) Bank reconciliation statement.
How do you configure electronic bank statement?
|
Security
Tip
Use
Firefox instead of Internet Explorer and PREVENT
Spyware !
Firefox is
free and is considered the best free, safe web browser
available today
Get Firefox with Google Toolbar for better browsing |
Answer1:
Following is the sequence of configuration to be done for Electronis Bank Statment(EBS):
1. create Tranaction types( which helps you group all the house baks with same External transaction code).
2. assign them to house banks.
3 create and define posting rule keys .
4 assign them to external transaction codes.
external transaction codes are bank specific codes for buisness tranactions( which it issues in each EBS) each one for each type of payment. eg. transfer order, foreign transfer,bill of exchange etc.
5 define posting specification for G/L posting as well as subledger posting
6. define account symbols(which determines the G/L account to be posted to) and assign them to posting keys.
Answer2:
1. Create account symbols
2. Create gl accounts ans assign t account symbols
3. Create posting keys:
4. Posting rules
5. Assing external transactions
Following is the sequence of configuration to be done for Electronis Bank Statment(EBS):
1. create Tranaction types( which helps you group all the house baks with same External transaction code).
2. assign them to house banks.
3 create and define posting rule keys .
4 assign them to external transaction codes.
external transaction codes are bank specific codes for buisness tranactions( which it issues in each EBS) each one for each type of payment. eg. transfer order, foreign transfer,bill of exchange etc.
5 define posting specification for G/L posting as well as subledger posting
6. define account symbols(which determines the G/L account to be posted to) and assign them to posting keys.
Answer2:
1. Create account symbols
2. Create gl accounts ans assign t account symbols
3. Create posting keys:
4. Posting rules
5. Assing external transactions
How do you configure manual bank statement?
configuration is required during electronic bank statment not in mannual bank stament.
In mannual bank statment you just have to enter the data on screen and save it.
configuration is required during electronic bank statment not in mannual bank stament.
In mannual bank statment you just have to enter the data on screen and save it.
What is dunning?
Dunning is actually the process by which you “bill” or “invoice” a customer for past due items.
With regards bad Checks for example dunning procedure could follow these steps:
• Step 1: Phone call to customer on receipt of bad check – at this stage, perform the journal posting outlined in section on Returned Checks
• Step 2: Letter to customer (+10 days)
• Step 3: Letter to CO (+7 days)
• Step 4: Legal letter to customer (? DD139) (+13 days)
• Step 5: Issue DD139 (+10 days)
• Step 6: Follow-up on DD139 (dispersing officer) (+45 days)
• Step 7: Write-off (after 6 months)
Steps 2-6 above will be handled by dunning levels in SAP.
Configuration before dunning can be carried out
1. Defining Dunning Area
2. Define Dunning Keys
3. Define Dunning Block Reasons
4. Dunning Procedure
• Define Dunning Procedure (T. Code – FBMP), To set up a Dunning Procedure, the following must be specified: number of Dunning Levels (1-9) Dunning Texts, Standard Text can also be included in the Dunning Texts. Dunning Procedure major parameters: Dunning Interval, Number of Dunning Levels, Grace Period
5. Assign Dunning Procedure to Customer / Vendors Accounts (T. Code – XD02)
6. Define Correspondence Types (T. Code – OB77)
7. Assign Company Codes to Correspondence company Codes
8. Assign Programs for Correspondence Types (OB78)
9. Dunning Run: Transaction Code: F150
Menu Path: accounting > financial accounting > accounts receivable > periodic processing > dunning.
Note: Whenever you schedule more than one dunning run a day, the "Identification" number must change. You may run several dunning runs on the same date but the "Identification" name must be different as well as certain parameters such as the “Dunning Date” and “Documents Posted up to” date.
Dunning is actually the process by which you “bill” or “invoice” a customer for past due items.
With regards bad Checks for example dunning procedure could follow these steps:
• Step 1: Phone call to customer on receipt of bad check – at this stage, perform the journal posting outlined in section on Returned Checks
• Step 2: Letter to customer (+10 days)
• Step 3: Letter to CO (+7 days)
• Step 4: Legal letter to customer (? DD139) (+13 days)
• Step 5: Issue DD139 (+10 days)
• Step 6: Follow-up on DD139 (dispersing officer) (+45 days)
• Step 7: Write-off (after 6 months)
Steps 2-6 above will be handled by dunning levels in SAP.
Configuration before dunning can be carried out
1. Defining Dunning Area
2. Define Dunning Keys
3. Define Dunning Block Reasons
4. Dunning Procedure
• Define Dunning Procedure (T. Code – FBMP), To set up a Dunning Procedure, the following must be specified: number of Dunning Levels (1-9) Dunning Texts, Standard Text can also be included in the Dunning Texts. Dunning Procedure major parameters: Dunning Interval, Number of Dunning Levels, Grace Period
5. Assign Dunning Procedure to Customer / Vendors Accounts (T. Code – XD02)
6. Define Correspondence Types (T. Code – OB77)
7. Assign Company Codes to Correspondence company Codes
8. Assign Programs for Correspondence Types (OB78)
9. Dunning Run: Transaction Code: F150
Menu Path: accounting > financial accounting > accounts receivable > periodic processing > dunning.
Note: Whenever you schedule more than one dunning run a day, the "Identification" number must change. You may run several dunning runs on the same date but the "Identification" name must be different as well as certain parameters such as the “Dunning Date” and “Documents Posted up to” date.
What is the difference between profit center accounting and
Profitability analysis ?
profit center accounting is basicaly done for internal controlling purposes. It lets you determine the profit and loss using the cost of sale approach or period accounting approach. Here you can find the profit from an "area of reponsibility or pserson" point of view.this is accound based costing
Whereas in Profitability analysis, market segments based on product , cutomer,order aor any comobination of these are studied to find wots the profit. PA provides information to the marketing,sales and planning department so that they can make decisions. PA has two forms account based and CO based.
both these are tools for profit management, and both are alternative. They are not same.
profit center accounting is basicaly done for internal controlling purposes. It lets you determine the profit and loss using the cost of sale approach or period accounting approach. Here you can find the profit from an "area of reponsibility or pserson" point of view.this is accound based costing
Whereas in Profitability analysis, market segments based on product , cutomer,order aor any comobination of these are studied to find wots the profit. PA provides information to the marketing,sales and planning department so that they can make decisions. PA has two forms account based and CO based.
both these are tools for profit management, and both are alternative. They are not same.
What are the manufacturing cost of a producting ?
Materail cost + Productions cost = Manufacturing cost
Materail cost + Productions cost = Manufacturing cost
What is the difference between stock transfer between two plants
belongs to same company code and to that of different company code?
In 1st case it is called as intra company stock transfer and the 2nd case is inter company stock transfer
Stock Transfer between plants of same company code only includes inventory movement without any pricing and so called Stock Transfer Order where Stock Transfer between plants of different company code is same as a purchase order as along with the inventory there is also accounts transfer (pricing) involved.
In 1st case it is called as intra company stock transfer and the 2nd case is inter company stock transfer
Stock Transfer between plants of same company code only includes inventory movement without any pricing and so called Stock Transfer Order where Stock Transfer between plants of different company code is same as a purchase order as along with the inventory there is also accounts transfer (pricing) involved.
In
real time, How listing and exclusion is used ?
Listing and exclusion is used in chemical and pharma industries for ex:-Particular customer is not having a valid license of selling some chemical/Medicines and he is ordering the same. in this case listing and exclusion is useful
Listing and exclusion is used in chemical and pharma industries for ex:-Particular customer is not having a valid license of selling some chemical/Medicines and he is ordering the same. in this case listing and exclusion is useful
What is the schema you use in Time Management?
Schema : TC00
Schema : TC00
What
is the work relation between SAP-MM,
SD and fi/co modules?
SAP is the integration of all the modules and the topics are very relavent to each other because basically its management skillsetgroup. From manufacturing the product/goods/services to reaching the customer. All the transaction process is depending on sales area, sales doc, item proposals, shipping, delivery and billing.
SAP is the integration of all the modules and the topics are very relavent to each other because basically its management skillsetgroup. From manufacturing the product/goods/services to reaching the customer. All the transaction process is depending on sales area, sales doc, item proposals, shipping, delivery and billing.
In SAP-HR, What is the landscape of your project?
Landscape in SAP consists the following: 1. IDES = Training Server
2. Development Server
* Configuration (200 client)
* Sandbox (210 client)
* Data Change (220 client)
3. Quality Server
* Standby (300 client)
* Testing (310 client)
4. Production Server
* Pre-Production (400 client)
* Real Production (500 client)
Landscape in SAP consists the following: 1. IDES = Training Server
2. Development Server
* Configuration (200 client)
* Sandbox (210 client)
* Data Change (220 client)
3. Quality Server
* Standby (300 client)
* Testing (310 client)
4. Production Server
* Pre-Production (400 client)
* Real Production (500 client)
What
is the role of abapers? What is the Work Bench?
Abaper is a application programmer who retrives the data from the database and show it to the end-user with the help of report..out of three layers of SAP the abaper position is on Application Layer in which SAP programs are develop and then transported to the Production server...
Workbench... The ABAP Workbench contains several tools that allow you to edit specific repository objects. like ABAP Editor , Menu PAinter etc...
Abaper is a application programmer who retrives the data from the database and show it to the end-user with the help of report..out of three layers of SAP the abaper position is on Application Layer in which SAP programs are develop and then transported to the Production server...
Workbench... The ABAP Workbench contains several tools that allow you to edit specific repository objects. like ABAP Editor , Menu PAinter etc...
How to integrate MM With Fico?
Answer1
By using transaction code OBYC we can get the details of MM, Fico integration.
Answer2
Go to IMG settings in Financial accounting and do the configuration for MM-FI settings
Answer3
Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, Accounting, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. Helps to determine, the GL accounts updated when there is a movement of goods.
Answer1
By using transaction code OBYC we can get the details of MM, Fico integration.
Answer2
Go to IMG settings in Financial accounting and do the configuration for MM-FI settings
Answer3
Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, Accounting, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. Helps to determine, the GL accounts updated when there is a movement of goods.
What is difference between business area or cost centre?
|
Security Issue
Get Norton Security Scan
and Spyware Doctor free for your Computer from
Google.
The Pack contains nearly 14 plus
software . Pick the one which is suited for you
Make
your PC more useful. Get the free Google Pack.
|
Business area is a place where the product or the produced
components are valued in group or for the total transactions carried out, Right
from procurement, production and sales of goods.
Wheras Cost centre is a particular area where the production or the project is taken up and expenditure is identified separately with a separate GL account
Wheras Cost centre is a particular area where the production or the project is taken up and expenditure is identified separately with a separate GL account
How to create Tax Calculation Procedure?
Answer1:
Tax calculation procedures based on the countries depended. one country is using deferent of tax procedures. We are creating new country also and at what type calculation procedures present is running on the country and it is assigned which country used.
Answer2:
Tax calculation procedures based on the country wise using . and which country is used at what percent and it is used on the country. We are creating new country also at what percent it is used and it is assigned to using of this country.
Answer1:
Tax calculation procedures based on the countries depended. one country is using deferent of tax procedures. We are creating new country also and at what type calculation procedures present is running on the country and it is assigned which country used.
Answer2:
Tax calculation procedures based on the country wise using . and which country is used at what percent and it is used on the country. We are creating new country also at what percent it is used and it is assigned to using of this country.
What is the difference between business area and profit center?
Answer1:
Business area is where the total business is valuated as a whole
Whereas Profit centre is an area where the company/work place allows the outside agency to use its machinery for external profits (eq: A CNC machine which can run 24 hrs a day is utilized in our company for 15 hrs and the balance 9 hrs is let out for addition to the company's profit) is known as Profit Centre.
Answer2:
Business area is related term to FI module and Profit centre is related to CO module. One business area can have one or more profit centers.
Answer3:
Business area is gared on external accounting where as profit centers are used for internal accounting purposes
Answer1:
Business area is where the total business is valuated as a whole
Whereas Profit centre is an area where the company/work place allows the outside agency to use its machinery for external profits (eq: A CNC machine which can run 24 hrs a day is utilized in our company for 15 hrs and the balance 9 hrs is let out for addition to the company's profit) is known as Profit Centre.
Answer2:
Business area is related term to FI module and Profit centre is related to CO module. One business area can have one or more profit centers.
Answer3:
Business area is gared on external accounting where as profit centers are used for internal accounting purposes
What is Legaccy System Migration Workbench? How it can be carried
out in SAP SD?
Answer1:
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.
Answer2:
LSMW is used for migrating data from a legacy system to SAP system, or from one SAP system to another.
Apart from standard batch/direct input and recordings, BAPI and IDocs are available as additional import methods for processing the legacy data.
The LSMW comprises the following main steps:
* Read data (legacy data in spreadsheet tables and/or sequential files).
* Convert data (from the source into the target format).
* Import data (to the database used by the R/3 application.
But, before these steps, you need to perform following steps :
* Define source structure : structure of data in the source file.
* Define target structure : structure of SAP that receives data.
* Field mapping: Mapping between the source and target structure with conversions, if any.
* Specify file: location of the source file
Answer1:
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.
Answer2:
LSMW is used for migrating data from a legacy system to SAP system, or from one SAP system to another.
Apart from standard batch/direct input and recordings, BAPI and IDocs are available as additional import methods for processing the legacy data.
The LSMW comprises the following main steps:
* Read data (legacy data in spreadsheet tables and/or sequential files).
* Convert data (from the source into the target format).
* Import data (to the database used by the R/3 application.
But, before these steps, you need to perform following steps :
* Define source structure : structure of data in the source file.
* Define target structure : structure of SAP that receives data.
* Field mapping: Mapping between the source and target structure with conversions, if any.
* Specify file: location of the source file
Of all the methods used for data migration like BDC, LSMW , Call
Transaction which one is used most of the time? How is the decision made which
method should be followed? What is the procedure followed for this analysis?
All the 3 methods are used to migrate data. Selection of these methods depends on the scenario, amount of data need to transfer. LSMW is a ready tool provided by SAP and you have to follow some 17 steps to migrate master data. While in BDCs Session method is the better choice because of some advantages over call transaction. But call transaction is also very useful to do immediate updation of small amout of data. (In call transaction developer has to handle errors).
Bottom line is make choice of these methods based of real time requirements.
These methods are chosen completely based on situation you are in. Direct input method is not available for all scenarios; else, they are the simplest ones. In batch input method, you need to do recording for the transaction concerned. Similarly, IDoc, and BAPI are there, and use of these need to be decided based on the requirement.
Try to go through the some material on these four methods, and implement them. You will then have a fair idea about when to use which.
All the 3 methods are used to migrate data. Selection of these methods depends on the scenario, amount of data need to transfer. LSMW is a ready tool provided by SAP and you have to follow some 17 steps to migrate master data. While in BDCs Session method is the better choice because of some advantages over call transaction. But call transaction is also very useful to do immediate updation of small amout of data. (In call transaction developer has to handle errors).
Bottom line is make choice of these methods based of real time requirements.
These methods are chosen completely based on situation you are in. Direct input method is not available for all scenarios; else, they are the simplest ones. In batch input method, you need to do recording for the transaction concerned. Similarly, IDoc, and BAPI are there, and use of these need to be decided based on the requirement.
Try to go through the some material on these four methods, and implement them. You will then have a fair idea about when to use which.
What
is the difference between the stock transfer between two plants belonging to
same company code and those belonging to different company code?
Answer1:
A stock transfer from plant to plant generally takes place within a company code. It can, however, also take place between two company codes, if the plants are assigned to different valuation areas, which belong to different company codes.
Unlike a stock transfer from storage location to storage location, a stock transfer from plant to plant affects both accounting and Materials Planning, as follows:
* Accounting
Accounting is affected if both plants are assigned to different valuation areas. This means that a stock transfer leads not only to a quantity update but also to a value update (stock value, G/L accounts). Thus, parallel to the material document for stock transfer, an accounting document is created.
* Materials Planning
Materials Planning is affected because a change of plant stock is taken into account by Materials Planning.
Answer2:
The stock transfer from one plant to another belonging to same company code is same as that of belonging to different company code functionally.
In both the types of transfers, there will be a material document generated which will update the QTY in both the plants in the respective storage location.
Accounting document generation will depend on the valuation level of the material. If the materials are being valuated at company level and it is being transferred from one plant to another belonging to the same company code, no accounting entry is generated. However, if the valuation is being done at plant level, the accounting document will be generated in both the cases.
Answer1:
A stock transfer from plant to plant generally takes place within a company code. It can, however, also take place between two company codes, if the plants are assigned to different valuation areas, which belong to different company codes.
Unlike a stock transfer from storage location to storage location, a stock transfer from plant to plant affects both accounting and Materials Planning, as follows:
* Accounting
Accounting is affected if both plants are assigned to different valuation areas. This means that a stock transfer leads not only to a quantity update but also to a value update (stock value, G/L accounts). Thus, parallel to the material document for stock transfer, an accounting document is created.
* Materials Planning
Materials Planning is affected because a change of plant stock is taken into account by Materials Planning.
Answer2:
The stock transfer from one plant to another belonging to same company code is same as that of belonging to different company code functionally.
In both the types of transfers, there will be a material document generated which will update the QTY in both the plants in the respective storage location.
Accounting document generation will depend on the valuation level of the material. If the materials are being valuated at company level and it is being transferred from one plant to another belonging to the same company code, no accounting entry is generated. However, if the valuation is being done at plant level, the accounting document will be generated in both the cases.
What are the fields in purchasing view?
- RFQ/Quotation
- Purchase requisition
- Purchase order
- Master data (Info record, Source list, Conditions, Vendors etc.)v - Outline agreements
- RFQ/Quotation
- Purchase requisition
- Purchase order
- Master data (Info record, Source list, Conditions, Vendors etc.)v - Outline agreements
How do you create movement types? What are the steps involved? When
will you recommend a new movement type?
A movement type can be created using T code OMJJ. Copying an existing movement type and modifying the field contents can create a new movement type.
The SAP system is delivered with some pre-defined movement types from 100 to 899. 900 onwards can be used for customized movement types.
A movement type can be created using T code OMJJ. Copying an existing movement type and modifying the field contents can create a new movement type.
The SAP system is delivered with some pre-defined movement types from 100 to 899. 900 onwards can be used for customized movement types.
What is meant by access sequence? When it is used?
Condition type has an access sequence assigned to it which determines which tables to access for data and in what sequence. This has a sequence of table based on the most specific to most generic.
It can be used for any new condition type creation.
Condition type has an access sequence assigned to it which determines which tables to access for data and in what sequence. This has a sequence of table based on the most specific to most generic.
It can be used for any new condition type creation.
How does the PO pick up the
pricing schema?
The pricing procedure assigned to a vendor has a calculation schema attached to it. This schema defines the various conditions’ pre-requisite, calculation & sequence in the PO. Generally, only one type of pricing procedure is followed for all the vendors.
The pricing procedure assigned to a vendor has a calculation schema attached to it. This schema defines the various conditions’ pre-requisite, calculation & sequence in the PO. Generally, only one type of pricing procedure is followed for all the vendors.
What are the types of special stocks available?
- Consignment stock - vendor
- Components provided to vendor
- Project stock
- Consignment stock – customer
- Pipeline material
- Orders on hand
- Consignment stock - vendor
- Components provided to vendor
- Project stock
- Consignment stock – customer
- Pipeline material
- Orders on hand
What are the types of inforecords?
- Standard
- Pipeline
- Consignment
- Subcontracting
- Standard
- Pipeline
- Consignment
- Subcontracting
What is meant by consignment stock?
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.
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.
What are the steps involved in consignment cycle?
Consignment cycle is similar to a standard purchase cycle. The difference it that no accounting document is created at the time of goods receipts only QTY is updated.
It is settled once the same is utilized.
Consignment cycle is similar to a standard purchase cycle. The difference it that no accounting document is created at the time of goods receipts only QTY is updated.
It is settled once the same is utilized.
Tell me about the subcontracting cycle.
When the material is sent for subcontracting i.e. some value addition, it is converted into a different material. It needs a BOM to define the components of the finished item being received.
When the material is sent for subcontracting i.e. some value addition, it is converted into a different material. It needs a BOM to define the components of the finished item being received.
How is scrap accounted in subcontracting?
The scrap or the process loss can be adjusted while doing a quality inspection of the material received after subcontracting.
The scrap or the process loss can be adjusted while doing a quality inspection of the material received after subcontracting.
How are the byproducts taken care of in subcontracting?
Byproducts can be taken care of by defining them in the BOM
Byproducts can be taken care of by defining them in the BOM
Tell
me about the various movement types and usage.
101 – GR in unrest. use
103 – GR in Blocked stock
105 – Release from Block to Unrest. use stock.
122 – Return to vendor from unrest. use stock.
124 – Return to vendor from blocked stock
301 - Plant to Plant tfr.
309 – Material to Material tfr.
311 – Tfr. from stg loc to stg loc
261 – Issue for consumption.
411 – Taking consignment stock into own stock.
551 – Withdrawal for scrapping.
Etc.
101 – GR in unrest. use
103 – GR in Blocked stock
105 – Release from Block to Unrest. use stock.
122 – Return to vendor from unrest. use stock.
124 – Return to vendor from blocked stock
301 - Plant to Plant tfr.
309 – Material to Material tfr.
311 – Tfr. from stg loc to stg loc
261 – Issue for consumption.
411 – Taking consignment stock into own stock.
551 – Withdrawal for scrapping.
Etc.
What
is the difference between a contract and a scheduling agreement?
A scheduling agreement can be made for Consignment, Subcontracting and stock transfer. A contract, also known as a blanket PO, can be made for standard items and can be restricted to a Value or QTY.
A scheduling agreement can be made for Consignment, Subcontracting and stock transfer. A contract, also known as a blanket PO, can be made for standard items and can be restricted to a Value or QTY.
How does the system calculate taxes?
Based on the calculation schema of that condition and based on access sequence assigned to it.
Based on the calculation schema of that condition and based on access sequence assigned to it.
What are the cutover activities performed infinal preparartion
phase ?
This activity involves- Master data upload for objects like customer masters including partner function assignment, customer material info, pricing, outputs and credit masters.
This activity involves- Master data upload for objects like customer masters including partner function assignment, customer material info, pricing, outputs and credit masters.
How to create a Purchase Order to a vendor who got best rating in
Price comparision session (me49). I wish to create PO
from this session directly, explain how can it be created?
Answer1:
Vendor rating has to be done for new purchase order everytime. PO can be generated by using transaction ME21N. This PO has to be released after creation
The other way is to assign that item to the vendor and maintain info records and update it by using ME11. This can also be done manualy.
Answer2:
This is not possible. Price comaprison session only gives you the idea which supplier has given the best price for a particular material.you have to raise the po ME21N transaction only.
Answer3:
The vendor who has got best price will have a unique quotation number. USe ME21N transaction and create PO with respect RFQ from Overview tab .
Answer1:
Vendor rating has to be done for new purchase order everytime. PO can be generated by using transaction ME21N. This PO has to be released after creation
The other way is to assign that item to the vendor and maintain info records and update it by using ME11. This can also be done manualy.
Answer2:
This is not possible. Price comaprison session only gives you the idea which supplier has given the best price for a particular material.you have to raise the po ME21N transaction only.
Answer3:
The vendor who has got best price will have a unique quotation number. USe ME21N transaction and create PO with respect RFQ from Overview tab .
What is the complete flow of the profit center accounting,and
Internal orders in controlling
Profit Centre Accounting:The following data can be passed on in Profit Center Accounting
* Costs (assessment and/or distribution)
* Revenue and sales deductions (assessment and/or distribution)
* Balance sheet items (distribution)
For this purpose, it is necessary to define cycles containing rules for finding sender-receiver relationships.
Related Activities in Controlling
* Definition of actual assessment cycles
* Definition of plan assessment cycles
* Definition of actual distribution cycles
* Definition of plan distribution cycles
Internal Orders
Internal orders are normally used to plan, collect, and settle the costs of internal jobs and tasks. The SAP system enables you to monitor your internal orders throughout their entire life-cycle; from initial creation, through the planning and posting of all the actual costs, to the final settlement and archiving:
Features
* You can use master data to assign certain characteristics to your internal orders, which enables you to control which business transactions can be used with the internal order.
* Internal order planning enables you to roughly estimate the costs of a job before the order starts and to make an exact calculation at a later date. You can choose between various planning approaches to compare the effectiveness of different methods. * You can assign and manage budgets for internal orders.
* You apply the actual costs incurred by a job to your internal orders using actual postings. In Financial Accounting, you can assign primary cost postings (such as the procurement of external activities and external deliveries) directly to internal orders.
* In period-end closing you can use various different allocation methods (for example, overhead costing) to allocate costs between different areas of Cost Accounting.
Order settlement enables you to transfer the costs incurred by an order to the appropriate receivers.
* The information system for internal orders enables you to track planned and assigned costs on your orders in each stage of the order life-cycle.
* You can archive internal orders that you no longer require.
Profit Centre Accounting:The following data can be passed on in Profit Center Accounting
* Costs (assessment and/or distribution)
* Revenue and sales deductions (assessment and/or distribution)
* Balance sheet items (distribution)
For this purpose, it is necessary to define cycles containing rules for finding sender-receiver relationships.
Related Activities in Controlling
* Definition of actual assessment cycles
* Definition of plan assessment cycles
* Definition of actual distribution cycles
* Definition of plan distribution cycles
Internal Orders
Internal orders are normally used to plan, collect, and settle the costs of internal jobs and tasks. The SAP system enables you to monitor your internal orders throughout their entire life-cycle; from initial creation, through the planning and posting of all the actual costs, to the final settlement and archiving:
Features
* You can use master data to assign certain characteristics to your internal orders, which enables you to control which business transactions can be used with the internal order.
* Internal order planning enables you to roughly estimate the costs of a job before the order starts and to make an exact calculation at a later date. You can choose between various planning approaches to compare the effectiveness of different methods. * You can assign and manage budgets for internal orders.
* You apply the actual costs incurred by a job to your internal orders using actual postings. In Financial Accounting, you can assign primary cost postings (such as the procurement of external activities and external deliveries) directly to internal orders.
* In period-end closing you can use various different allocation methods (for example, overhead costing) to allocate costs between different areas of Cost Accounting.
Order settlement enables you to transfer the costs incurred by an order to the appropriate receivers.
* The information system for internal orders enables you to track planned and assigned costs on your orders in each stage of the order life-cycle.
* You can archive internal orders that you no longer require.
What
is the one full implementation of life cycle in SAP-BW ?
Full life cycle implementation means implementing the project start from requirement gathering, analysis, solution desion, mapping, implementing according to ASAP methodology.
Full life cycle implementation means implementing the project start from requirement gathering, analysis, solution desion, mapping, implementing according to ASAP methodology.
How the Price determination process works in SAP-MM?
Price determination process:
Create a Price schema
Add a condition type if required
Asssign Access sequence to the condition type.
Create a condition table and specify flds required.
Create a cond. rec. The price schema for the particular mat. has a cond type. This pricing will trigger the Price determination process. Basically the access sequence assigned to the cond type will search the cond table to find the particular cond. rec. and determin the price.
Price determination process:
Create a Price schema
Add a condition type if required
Asssign Access sequence to the condition type.
Create a condition table and specify flds required.
Create a cond. rec. The price schema for the particular mat. has a cond type. This pricing will trigger the Price determination process. Basically the access sequence assigned to the cond type will search the cond table to find the particular cond. rec. and determin the price.
What are the activities we will do in SAP MM module implementation?
Various activities in SAP MM are : Inventory, Warehouse, Purchasing, Vendor evolution, Invoice varification, etc.
Various activities in SAP MM are : Inventory, Warehouse, Purchasing, Vendor evolution, Invoice varification, etc.
Explain what are the steps in the SD process at least up to the
invoicing stage
Answer1:
1) pre-sales activity -inquiry,quotation
2) sales-order,
3) inventory sourcing,
4) delivery,
5) pgi,
6) invoicing
Answet2:
SD Inquiry-- Quotation---Sales Order---Delivery---Transfer Order----Post Good Issue----Billing---Invoicing.
Condition technique
condition technique means, the combination of
- condition table
- access sequence
- conditon type
- procedure
- determination
Answer1:
1) pre-sales activity -inquiry,quotation
2) sales-order,
3) inventory sourcing,
4) delivery,
5) pgi,
6) invoicing
Answet2:
SD Inquiry-- Quotation---Sales Order---Delivery---Transfer Order----Post Good Issue----Billing---Invoicing.
Condition technique
condition technique means, the combination of
- condition table
- access sequence
- conditon type
- procedure
- determination
What is the work you have done in the MM module and what programs
did you use for creating views in MM?
In MM
1.Stock overview for a period can be done by Tcode-MB5B -further giving details like storage location, Plant, Material code, Date..
2. Stock as on date can be viewed by using Tcode-MMBE-further giving details like storage location, Plant, Material code. Mail
In MM
1.Stock overview for a period can be done by Tcode-MB5B -further giving details like storage location, Plant, Material code, Date..
2. Stock as on date can be viewed by using Tcode-MMBE-further giving details like storage location, Plant, Material code. Mail
How do you get the Sales Order (S.O) No. from the Delivery Order?
There are 2 ways through which you can see the reference of the documents.
1) Through Document Flow
2)Enter the delivery-> Go at the item level and select TAB PREDECESSOR DATA tab and you can see the reference order number.
There are 2 ways through which you can see the reference of the documents.
1) Through Document Flow
2)Enter the delivery-> Go at the item level and select TAB PREDECESSOR DATA tab and you can see the reference order number.
What is an Open Item in SAP? How will you find an Open Item in SAP?
you can generate a list of open items from the information systems menu option:
* General Ledger: Information system ® General ledger reports ® Line items ® General ledger line items ® G/L line items, list for printing.
* Accounts Receivable: Information system
* ® Reports for accounts receivable ® Customer items ® List of customer open items for printing. Accounts Payable: Information system ® Reports for accounts payable ® Vendor items ® List of vendor open items for printing
you can generate a list of open items from the information systems menu option:
* General Ledger: Information system ® General ledger reports ® Line items ® General ledger line items ® G/L line items, list for printing.
* Accounts Receivable: Information system
* ® Reports for accounts receivable ® Customer items ® List of customer open items for printing. Accounts Payable: Information system ® Reports for accounts payable ® Vendor items ® List of vendor open items for printing
SAP ABAP Interview Questions And Answers
What is the difference between internal table and structure?There are there types of structure:-
1. Flat structure ( elementary fields)
2. Nested structure ( type reference to other structure)
3. deep structure ( type reference to database tables)
Explain row type and line type concept
line type refers to the structure of an internal table,whereas row type is the actual part that contains the data and it refers to the table body.creating internal table using line type and row type concept is for reusability purpose.Line type and Row type are defined at DDIC LEVEL.
Can any one give me brief explanation about internal tables, and work area ?
*An internal table is a run time instance. It get created when program starts execution.
*It get destroyed when program terminates. It has two different parts: HeaderLine(optional) and Body(Compulsory).
*Any value that comes to or goes from interanal table, that travels through headerline.
How to eliminate duplicate entries in internal tables?
Answer1:
SORT itab. DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.
Answer2:
The following syntax:
SORT itab <fieldname>.
delete adjcent duplicates from itab comparing .
Size of the internal tables?
The size of the internal tables are set using the 'occurs n' clause. Here n refers to a integer number that specifies the size. Usually its given as 'occurs 0' which creates an itab with the memmory space of 8kb.
What is the basic difference internal tables and database tables? How can we differentiate by looking at the tables? Handling of internal tables
The basic difference is database tables are stored in DB server
and the internal tables are virtual tables these are created run time only
Internal tables are created dynamically, the memory of internal tables is not
permant memory, for internal tables the memory will be created in the application server and it is external memory and terminates after the program termination
SAP BDC Interview Questions And Answers
/BEND terminates the batch input processing and sets the session to be failed.
/N terminates the current batch input transaction.
SM35 transaction . How to automate BDC ?
After execution of batch input program , the session created is placed in the session queue which can be viewed using SM35 transaction executing / Releasing the session will start the transfer of the data from the session into the database tables./
Update types in Call transaction method. What is the difference ?
At present with SAP we have only modes of updation
1.Synchronus Update.
2.Asynchronous Update.
There is no more Local Update.
What are the table controls in BDC ? What is the difference between bdc and lsmw ? What is the difference between bdc and rfc ?
BDC - Batch data communication in which there are 2 processes
1. in bound
2. outbound
RFC - remote fucntion call(or) calling
Data conversion experience?
DATA CONVERSIONS:
SAP HAS PROVIDED A TOOL NAMED LSMW WHICH CONVERTS THE LEGACY DATA INTO THE REQUIRED SAP FORMAT AND UPDATES THE DATABASE.
Open datasets, Read datasets ( Reading and writing data to files)?
Date Sets are nothing but files on Application Server,they can even be called as Sequential files.
Open Dataset
Is used to open required file on the application Server.
Read Dataset.
Is used to read the contents required file on the application Server.
How to do back ground processing in BDC Session method ?
select the option background process
Call transaction method, how to capture the errors ?
IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.
FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.
THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.
THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"
AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING.
How to load data from MS Excel sheet to SAP by using BDC method ?
KCD_EXCEL_OLE_TO_INT_CONVERT even takes care of blank cells and is available in older versions of SAP
* Add values to internal table
SORT t_cells BY row col.
LOOP AT t_cells INTO wa_cells.
MOVE: wa_cells-col TO l_index.
ASSIGN COMPONENT l_index OF STRUCTURE itab TO <f_value>.
MOVE: wa_cells-value TO <f_value>.
AT END OF row.
APPEND itab
CLEAR itab.
ENDAT.
ENDLOOP.
What is the difference between call transaction and session method?
Session method: The records are not added to the database until the session is processed. sy-subrc is not returned. Error logs are created for error records. Updation in database table is always Synchronous.
Call Transaction method: The records are immediately added to the database table. sy-subrc is returned to 0 if successful. Error logs are not created and hence the errors need to be handled explicitly. Updation in database table is either Synchronous or Asynchronous.
SM35 transaction . How to automate BDC ?
sm35 is used to play girls for better nightfall’s.
What is the difference between Upload and WS_Upload ?
The difference between WS_Upload and Upload is when you use function Upload it prompts for a dialog box where in you need to key in the file location. Where as in case of WS_Upload you specify the file location in the function input parameters itself
If I want to execute a program only in background not in foreground is there any option for this?
The sm37 transaction can be used for running a program in the background. Also in the session method while processing the session you can specify the processing type as background or foreground.
What kind of BDC programs are written ?
|
Security Issue
Get Norton Security Scan
and Spyware Doctor free for your Computer from
Google.
The Pack contains nearly 14 plus
software . Pick the one which is suited for you
Make
your PC more useful. Get the free Google Pack.
|
There are five types of BDC methods available. They are
1.Batch input session 2.Call Transaction 3.Recording 4.Direct Input and 5.LSMW
How to read files and process BDCs automatically? To read file from Presentation server use Upload or GUI Upload or WS upload and to read file from Application server use Opened Dataset, Read dataset and Close dataset
In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?
While to transfer the data from the through if any errors occurs until the errors are the complete the data is not transfer to the SAP system.
The system compulsory shows the errors. Those errors are stored into the error logs (Transaction is SM35).
So the session method should not return any value.
In call transaction method data is directly pass to the SAP system.
So its compulsory return the value.
Because of the call transaction is the function.
A function should return the value mandatory.
Recording Function
With recording, user can avoid manual search for fields and tables required in a program including screen numbers. SHDB is the transaction code.
BDC vs Direct Loads( have you used direct loads on SAP tables )
Direct loads is 5 times faster than uploading by normal BDC method. but some times while updating the database referential integrity is violated.
Have you set up a back ground job ? How to create a background job without a variant ?
Yes, user can create background job scheduling in two ways.
1. By calling the executable program RSBDCSUB
2. Transaction Code SM37
SAP R-3 Interview Questions And Answers
What
is SAP R/3 ?
The name SAP a German company is an acronym for "Systeme, Anwendungen, Produkte in der Datenverarbeitung." This is translated in English as "Systems, Applications, and Products in Data Processing."
The name SAP a German company is an acronym for "Systeme, Anwendungen, Produkte in der Datenverarbeitung." This is translated in English as "Systems, Applications, and Products in Data Processing."
Can you create a table with fields not referring to data elements ?
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element.
What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element.
What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.
What should be the approach for writing a BDC program ?
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATA TRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed. If success data will transfer).
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATA TRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed. If success data will transfer).
What are the problems in processing batch input sessions and How is
batch input process different from processing online ?
PROBLEMS:
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.
ii)if session processing fails data will not be transferred to SAP database table.
PROBLEMS:
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.
ii)if session processing fails data will not be transferred to SAP database table.
|
Security
Tip
Use
Firefox instead of Internet Explorer and PREVENT
Spyware !
Firefox is
free and is considered the best free, safe web browser
available today
Get Firefox with Google Toolbar for better browsing |
What
does an extract statement do in the ABAP program ?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT. When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER. When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT. When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER. When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.
Can a transparent table exist in data dictionary but not in the
data base physically ?
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. 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.
What is the step by step process to create a table in data
dictionary ?
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table field).
step 3: creating tables(SE11).
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table field).
step 3: creating tables(SE11).
What is the typical structure of an ABAP/4 program?
HEADER ,BODY,FOOTER.
HEADER ,BODY,FOOTER.
A situation: An ABAP program creates a batch input session. We need
to submit the program and the batch session in back ground. How to do it ?
go to SM36 and create background job by giving job name, job class and job steps (JOB SCHEDULING)
go to SM36 and create background job by giving job name, job class and job steps (JOB SCHEDULING)
What are the domains and data elements ?
DOMAINS : FORMAL DEFINITION OF THE DATA TYPES.THEY SET ATTRIBUTES SUCH AS DATA TYPE,LENGTH,RANGE. DATA ELEMENT : A FIELD IN R/3 SYSTEM IS A DATA ELEMENT.
DOMAINS : FORMAL DEFINITION OF THE DATA TYPES.THEY SET ATTRIBUTES SUCH AS DATA TYPE,LENGTH,RANGE. DATA ELEMENT : A FIELD IN R/3 SYSTEM IS A DATA ELEMENT.
What is the alternative to batch input session?
Call transaction.
Call transaction.
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.
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.
What is the advantage of structures? How do you use them in the
ABAP programs?
Adv:- GLOBAL EXISTANCE(these could be used by any other program without creating it again).
Adv:- GLOBAL EXISTANCE(these could be used by any other program without creating it again).
How many types of tables exists and what are they in data
dictionary?
4 types of tables
i)Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used. ii)Pool tables &
iii)Cluster tables - These are logical tables that are arranged as records of transparent tables. one cannot use native sql on these tables (only open sql).They are not managable directly using database system tools.
iv)Internal tables - .?
4 types of tables
i)Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used. ii)Pool tables &
iii)Cluster tables - These are logical tables that are arranged as records of transparent tables. one cannot use native sql on these tables (only open sql).They are not managable directly using database system tools.
iv)Internal tables - .?
SAP SD Interview Questions And Answers
Answer1:
Text determination: For transferring information from material or customer to order/delivery or invoice (and anything in between)
Account determination: For transferring financial and costing information to proper financial docs
Partner determination: For determining who is is legally responsible for A/r, who the goods are going to and whatever else you waana drive through this functionality.
Output determination: What kinda output does a sales/delivery/billing document create and who gets it, where?. For example A partner might get an EDI notification for a sales order just confirmed, whereas a financial/leasing company gets the invoice!
Answer2:
(a) Text Determination: Any Texts in Masterial Master/Material Determination/Order/Delivery , etc is meant to convey messages to the subsequent documents for compliance. e.g. "Give Top Priority" message mentioned in Order is meant for Production Dept. (b) Account Determination:is integration between Finance and SD. The A/P along with Account Keys need to be allocated accordingly with combination of Account Determination Group for Customer and Material if required. (c) Partner Determination: To identify which type of Partner it is so that if required for same Customer different Partner Functions may be required e.g Only One Sold To Party per Customer. More than One Ship to Party/ Bill to Party/ Payer possible. Accordingly different Masters will have to be created. Useful for dispatch of Material in casae of Ship to Party, sending Bill in case of Bill to Party and payment followup/Dunning in case of Payer. (d) Output Determination: What type of Output (Fax/Mail, etc) is required, where and in what Format(ABAP Customisation may be required in some cases especially Invoices). (e) Storage Location Determination: depends on Plant, Shipping Point and Storage Conditions
What are the five imp fields to be maintained in account determination
Account Determination: Sales View, Sales Organization, Distribution Chanel, Chart of Accounts, Account Assignment Group for Customer and Material and Account Keys.
What is meant by transfer of data from legacy code to sap Legacy Code ?
Answer1:
It should be legacy data to SAP. What it means is you want to transfer all the customer and materials and all other information from Older (legacy system) to new SAP system. You can do it using many tools, most noticeably MDMs.
Answer2:
Before installation of SAP, Data maintained by Company is called Legacy Data. At the time of installation, it is required to transfer Data from Legacy to SAP like Masters (Material/Customer, etc). It can be done in various ways like BDC, LSMW, etc.
What do you do really in pricing determination, and what are the main deifferences between pricing procedures?
|
Security Issue
Get Norton Security Scan
and Spyware Doctor free for your Computer from
Google.
The Pack contains nearly 14 plus
software . Pick the one which is suited for you
Make
your PC more useful. Get the free Google Pack.
|
Pricing is determined by combination of Sales Organization, Distribution Channel, Division, Customer Pricing Procedure and Document Pricing Procedure.
Answer2:
We determine how the prices are calculated, taking into account sales area(sales org, distribution channel, division), document type and customer(generally sold-to-party).
The main differences between pricing procedures would be the differences as we mentioned above, from the point of view of field entries. Coming to the output and the procedure, Suppose the condition types used will be different and hence the following whole procedure. One pricing procedure determination to the others, which data control these differences
What type of reports generally a support consultant maintain and report
Depends on Customer requirements.
What is the purpose of shipping point determination not menu path
So that Shipping Point is determined automatically once the settings for the same are done.
What and where types of copy controls we change
Copy Control: is basically meant so that Data is copied from preceding Document to subsequent one. What subsequent Document is required is to some extent determined by Customer Requirements as well as Document Types. e.g. In general case of Standard Order, it will be Copy Control (Order to Delivery) from OR to LF .
How to and where to maintain copy controls
Check for yourself in IMG (Sales Document types and Delivery Document Types)
What is purpose of maintaining common distribution channels and common divisions
Common Distribution Channel and Common Division are maintained so that if any master data like customer or material maintained with respect to one distribution channel can be used in other DCh. It prevents the multiplication of master records.
Eg: A customer is created for say sales area 1000/20/00 then the same customer can be used in sales area 1000/30/00 if we maintain 20 as common distribution channel. Hence no need for extending the customers...the same for materials also.
What is the difference between the Availability check 01 (Daily requirement) and 02 (Individual Requirement) in material master?
01 and 02 are the checking group. Availability check is carried out with the help of these checking group and checking rule. Checking group 01 and 02 are maintained on the material master.
01 - Individual requirement -For this system generates transfers the requirement for each order to the MRP .So that MM can either produce or procure.
02- Collective requirement.-In this all the requirements in a day or in a week are processed at a time. System stores all request and passes on to the MRP in MRP run. In this system performance is high however you can not do the backorder processing whereas in other you can do. orm
|
|
SAP DB Interview Questions And Answers
What are the tools used in SAP Implementation? How do you create Alert Messages?One of the Tools being used for SAP Implemention is QuickSizer, which is used to size the SAP Server based on number of users using various modules in SAP.
Alert Message is created in the CCMS monitor using TCodes RZ20 and RZ21. The values for Alert AutoReaction Methods are defined using the TCode RZ21, while this particular method is assigned to the Monitoring Tree Element (MTE) in the TCode RZ20.
One as well can have an Alert Management System, where alerts from the Entire Landscape can be configured in a Central Monitoring System from where it can trigger a alert mail or SMS to the concerned Administrator
When spool buffer is full and new spool request is raised what happens to the request ? where does the request stored?
The new spool request will be in the queue. If it is urgent request then the current request will be be stoped and newrequest will be send.
What is the difference between R3trans and Tp in SAP-DBA?
R/3trans is the R/3 system transport program which can be used for transporting data between different SAP systems ,even when they dont belong to the same group. R3trans normally is not used directorly but called from the Tp controle program or by the R/3 upgrade. Tp is the basic tool for the transporting the request.
What is “Group by” in Select statement?
Answer1:
Group by is used to fetch a unique data from a column.
Answer2:
A "group by" is used to group selected rows in a table to perform arg functions on them. Rows not included in the "group by" clouse and not part of ARG functions cannot be used ...(logical grouping of data) or orerations performed (on groups of data) can be used with the "HAVING" clause to further refine the output.
ex of some ARG functions : SUM() , MIN(),MAX(), AVG()
Select statement to read data into internal tables. Types of Select statements
|
Security
Tip
Use
Firefox instead of Internet Explorer and PREVENT
Spyware !
Firefox is
free and is considered the best free, safe web browser
available today
Get Firefox with Google Toolbar for better browsing |
select * from
database table into (internal table name)
the above statement collects data into the header area of the internal table.
and
select * from database table into table (internal table name)
the above statement collects the data into the body area directly .
Explain “Commit” and “Roll back” the above statement collects data into the header area of the internal table.
and
select * from database table into table (internal table name)
the above statement collects the data into the body area directly .
The Oracle RDBMS provides a transaction model based on a unit of work. The PL/SQL language supports most, but not all, of the database model for transactions (you cannot, for example, ROLLBACK FORCE). Transactions begin with the first change to data and end with either a COMMIT or ROLLBACK.
COMMIT makes the database changes permanent and visible to other database sessions.
ROLLBACK undoes the changes made in the current transaction either to the beginning of the transaction or to a savepoint. A savepoint is a named processing point in a transaction, created with the SAVEPOINT statement. Rolling back to a savepoint is a partial rollback of a transaction, wiping out all changes (and savepoints) that occurred later than the named savepoint.
What happens “Update” command is used without where clause ?
Answer1:
It will update all the records with same name in the particular field of the table.
Answer2:
If we dont mention "WHERE" clause in the UPDATE statement, it will update all records satisfying the given condition (if given any ) in the table !
Answer3:
Based on query condition. it will update all the fields which are mentioned in the query.
ex: update employee set firstname= @firstname,lastname=@lastname where employee_id =@employee_id.
so in the above case nothing wil be happen if you used where clause or not.
if you have many statements in the query you need to use the where clause.
What are logical databases?
Answer1:
insert' will add a new record or a new row into the database table.
'Update' will modify a record in the DB table.
'Modify' it is a combination of both insert and update...
Difference between “Insert”, “Update” and “Modify”
INSERT - Add a new record into the database table.
UPDATE - If record is available it modifies otherwise it wont modify.
MODIFY - If record is available its update the record otherwise it creates a new record.
“Catch” Command
Trying to catch any runtime errors programmatically or manually we use this statement catch.
