Tuesday, August 7, 2018

Q. What are the variables?
Ans. Variables are parameters of a query that are arranged in the parameter query definition and are not filled with values until the queries are entered into the workbooks.

Q. Mention what are various kinds of variables?
Ans. Variables are used in many application
  • Characteristics variable
  • Hierarchy Nodes
  • Hierarchies
  • Text
  • Processing Types
  • Formulas
  • User entry/default type
  • Replacement Path
Q. Mention some of the set-backs of SAP?
Ans.
  • It is expensive
  • Lengthy implementation time
  • Demands highly trained staff
  • Does not determine where master data resides
  • Interfaces are a little bit complex
Q. Mention where are the t-code name and program values stored? Describe how can you get a list of all t-codes in the SAP system?
Ans. To see transaction table TSTC you can use transaction code st11, and you can determine a new t-code using transaction se93.

Q. Mention what is the difference between OLAP and Data Mining?
Ans. OLAP stands for Online Analytical Processing it is a reporting tool configured to know your database schema, dimensions, and configuration facts.
Data Mining: It is an analytic method to explore data in search of consistent patterns or systematic relationship between variables.

Q. what are the three stages of data-mining?
Ans. Three stages of data-mining include
Initial Exploration
Model building
Deployment

Q. what are the various layers in an R/3 system?
Ans. Various layers in an R/3 system includes
Presentation Layer
Database layer
Application layer

Q. what is the process to create a table in the data dictionary?
Ans. To create a table in the data dictionary, you have to follow this steps
Creating domains (data type, field length, range)
Creating data elements (Properties and type for a table field)
Creating tables (SE 11)

Q. What is AWB?
Ans. AWB stands for Administrator Workbench. It is a tool for monitoring, controlling and managing all the processes connected with data staging and processing in the business data warehousing.

Q. Explain what is Bex?
Ans. Bex means Business Explorer. It enables an end user to locate reports, analyze information, view reports and can execute queries. The queries in the workbook can be saved to their similar roles in the Bex browser. It has following components Bex analyzer, Bex Map and Bex web.

Q. what is mean by ODS in BIW?
Ans. An ODS object helps to put debugged and consolidated transaction data on a document level. It describes a consolidated dataset from one or more info-sources. This data-set can be evaluated with a Bex query or Infoset query. The data of an ODS object can be updated with a delta update into InfoCubes or another ODS object in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS object is stored in transparent, flat database tables.

Q. What is the distinction between Domain and Data Element?
Ans. Data Element: It is an intermediate object between domain and table type
Domain: It describes the attributes such as length, type, and possible value range

Q. What are SET parameters and GET parameters?
Ans. To use parameter IDs, you need to "set" values in the global memory area and then "get" values from this parameter ID memory area. In the case of the online program, you have to "Set" values from screen fields, and you will "get" these values for screen fields.

Q. What is ALE, IDOC, EDI, RFC and describe shortly?
Ans.
ALE: Application Linking enabling
EDI: Electronic data interchange
RFC: Remote function call
IDOC: Intermediary documents

Q. What is LUW (Logical Unit Of Work)?
Ans. LUW: LUW is a span of time while which database records are updated either commit or rollback.

Q. What is BDC stand for? How are several methods of BDC there?
Ans. BDC stands for Batch Data Communication. The methods of BDC are
Call Transaction Method
Batch Input Session Method
Direct Input Method

Q. What is "baseline data" in SAP AR and AP?
Ans. The baseline date is the date from which the payment terms apply. Normally, it is the report date on the invoice but can also be the date of entry or posting date from the ledger.

Q. what do you mean by one-time vendors?
Ans. In particular industries, it is not possible to create new master records for each vendor trading partner. The one-time vendor gives for a dummy vendor code to be used on invoice listing and the data that is usually put in the vendor master is keyed on the invoice itself.

Q. what are the standard stages of the SAP Payment Run?
Ans. While executing the SAP Payment Run the standard stages of SAP includes
Entering of parameters: It includes entering company codes, vendor accounts, payment methods, etc.
Proposal Scheduling: The system proposes a list of invoices to be paid
Payment booking: Booking of the actual payments into the ledger
Printing of Payment forms: Printing of payment forms

Q. what is the difference between the "residual payment" and "partial payment" methods of allocating cash in account receivable?
Ans. The difference between the residual and partial payment includes
Partial payment: let say invoice A456 exits for $100 and customer pay $70. With the partial payment, it offsets the invoice leaving a remaining balance $30
Residual Payment: While in residual payment, invoice A456 is cleared for the full value $100 and a new invoice line item is produced for the remaining balance of $30.

Q. what are internal tables, check tables, value tables, and transparent table?
Ans. It is the standard data type object; it exists only during the run time of the program.
Check the table will be at field level checking
Value table will be at domain level checking
The transparent table will exist with the same structure both in the dictionary as well as in the database exactly with the same data and fields

Q. what is an application, presentation and database servers in SAP R/3?
Ans. The application layer of an R/3 system is made up of the application server and the message server. Application programs in an R/3 system run on application servers. Using the message server, the application servers communicate with presentation components, the database and also with each other. All the data are stored on a centralized server, which is known as a database server.


No comments:

Post a Comment