SAP DB Interview Questions and Answers
Question - 31 : - Mention what is the importance of ODS in BIW?
Answer - 31 : -
An ODS object serves to store debugged and consolidated transaction data on a document level. It defines a consolidated dataset from one or more info-sources. This dataset can be evaluated with a Bex query or an Infoset query. The data of an ODS object can be updated with a delta update into InfoCubes or other ODS objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in the ODS object is stored in transparent, flat database tables.
Question - 32 : - Mention what is the difference between Domain and Data Element?
Answer - 32 : -
Data Element: It is an intermediate object between domain and table type
Domain: It defines attributes such as length, type, and possible value range
Question - 33 : - Mention what are SET parameters and GET parameters?
Answer - 33 : -
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.
Question - 34 : - Mention what is ALE, IDOC, EDI, RFC, and explain briefly?
Answer - 34 : -
- ALE: Application Linking enabling
- IDOC: Intermediary documents
- EDI: Electronic data interchange
- RFC: Remote function call
Question - 35 : - Mention what is LUW (Logical Unit of Work)?
Answer - 35 : -
LUW is a span of time during which database records are updated, either commit or rollback.
Question - 36 : - Mention what is BDC stands for? How many methods of BDC are there?
Answer - 36 : -
BDC stands for Batch Data Communication. The methods of BDC are
Question - 37 : - Direct Input Method
Answer - 37 : -
Batch Input Session Method
Call transaction Method
Mention what is meant by a “baseline data” in SAP AR and AP?
The baseline date is the date from which the payment terms apply. Usually, it is the document date on the invoice but can also be the date of entry or posting date from the ledger.
Question - 38 : - Mention what do you mean by one-time vendors?
Answer - 38 : -
In specific industries, it is not possible to create new master records for every vendor trading partner. One-time vendor enables a dummy vendor code to be used on invoice entry, and the information that is normally stored in the vendor master is keyed on the invoice itself.
Question - 39 : - Mention what are the standard stages of the SAP Payment Run?
Answer - 39 : -
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
Question - 40 : - Mention what is the difference between the “residual payment” and “partial payment” methods of allocating cash in account receivable?
Answer - 40 : -
The difference between the residual and partial payment includes
Partial payment: For example, 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 of $100, and a new invoice line item is produced for the remaining balance of $30.