SAP Database

BDC Frequently Asked Questions (FAQs)

1. What is full form of BDC Session?
Batch Data Communication Session.

2. What are the steps in a BDC session?
The first step in a BDC session is to identify the screens of the transaction that the program will process. Next step is to write a program to build the BDC table that will be used to submit the data to SAP. The final step is to submit the BDC table to the system in the batch mode or as a single transaction by the CALL TRANSACTION command.

(more…)

Transaction Frequently Asked Questions (FAQs)

1. What is a transaction?
- A transaction is dialog program that change data objects in a consistant way.

2. What are the requirements a dialog program must fulfill?
A dialog program must fulfil the following requirements
- a user friendly user interface.
- Format and consistancey checks for the data entered by the user.
- Easy correction of input errors.
- Access to data by storing it in the data bases.
(more…)

Interactive Reporting Frequently Asked Questions (FAQs)

1. What is interactive reporting?
It helps you to create easy-to-read lists. You can display an overview list first that contains general information and provide the user with the possibility of choosing detailed information that you display on further lists.

2. What are the uses of interactive reporting?
The user can actively control data retrieval and display during the session. Instead of an extensive and detailed list, you create a basic list with condensed information from which the user can switch to detailed displays by positioning the cursor and entering commands. The detailed information appears in secondary lists.
(more…)

Reporting General Frequently Asked Questions (FAQs)

1. The system field, which indicates success or failure of a SQL operation, is SY-SUBRC.
2. What is the syntax for specifying database table name at runtime in SELECT statement.
NAME = ‘SPFL1’.
SELECT * FROM (NAME).
……………….
……………….
ENDSELECT.
3. How do you read selected lines of database table into an internal table in packages of predefined size.
SELECT * FROM INTO TABLE PACKAGE SIZE.
Where n is variable.
(more…)

Report Generation - Formatting Frequently Asked Questions FAQs

1. The alignment of a type ‘c’ field in a report is left Aligned.
2. In the statement Write:/15(10) Ofal-lifnr. what do the number 15 and 10 stand for
15 stand for the offset on the screen and 10 stands for the field length displayed.
3. Specify the default alignment for the following field types:
‘D’ – Left, ‘F’-Right, ‘N’-Left, ‘I’-Right, ‘T’-Left.
4. If s_time has the value ‘123456’ how would you get an output of 12:34:56 with a single ‘Write:’ statement.
Write:s_time using edit mask’–:–:–‘.
(more…)

Logical Database Frequently Asked Questions FAQs

1. Preparation of the data records by the L.D.B and reading of the data records in the actual report are accomplished with the command pair Put and Get.
2. The three main elements of LDB are Structure, Selections, and Database Program.
3. In LDB what determines hierarchy of the tables?
Structure.
4. In general what are the two ways in which one can retrieve data from tables?
Using Select statements, Database Program.
(more…)

Modularization Frequently Asked Questions FAQs

1. Does every ABAP/4 have a modular structure?
Yes.

2. What is Modularization and its benefits?
If the program contains the same or similar blocks of statements or it is required to process the same function several times, we can avoid redundancy by using modularization techniques. By modularizing the ABAP/4 programs we make them easy to read and improve their structure. Modularized programs are also easier to maintain and to update.
(more…)

Data Dictionary Frequently Asked Questions (FAQs)

1. What are the layers of data description in R/3?
• The external layer.
• The ABAP/4 layer.
• The database layer.

2. Define external layer?
The external layer is the plane at which the user sees and interacts with the data, that is, the data format in the user interface. This data format is independent of the database system used.

(more…)

SAP R/3 Architecture Frequently Asked Questions (FAQs)

1. What guarantees the integration of all application modules?
The R/3 basis system guarantees the integration of all application modules. The R/3 basis s/w provides the run time environment for the R/3 applications ensures optimal integration, defines a stable architectural frame for system enhancements, and contains the administration tools for the entire system.
One of the main tasks of the basis system is to guarantee the portability of the complete system.

2. What are the central interfaces of the R/3 system?
Presentation Interface.
Database Interface.
Operating system Interface.
(more…)

Knowledge Management How-to Guides on SAP Netweaver 2004

Download from Rapidshare or Mediafire.

Contains How to’s on :

• Configure - KM Performance Tuning, Anonymous Access, Commands, Predefined Properties, last 10 docs, Search user interface, Virus scan service & who is who in Iview.
• Create - XML Forms.
• Distribute Knowledge Management Contents.
• Extend User Details
• Implement a single folder
• Translate CM Properties