SAP DB Interview Questions and Answers
Question - 51 : - Mention what are reason codes used in Account Receivable?
Answer - 51 : -
“Reason Codes” are tags that can be allocated to describe under/overpayments during the allocation of incoming customer payments. They should not be mixed up with “void reason codes” used when outgoing cheques are produced.
Question - 52 : - Mention what is the protocol does SAP Gateway process use?
Answer - 52 : -
The SAP gateway process uses TCP/IP protocol to communicate with the clients.
Question - 53 : - Mention what is pooled tables?
Answer - 53 : -
“Reason Codes” are tags that can be allocated to describe under/overpayments during the allocation of incoming customer payments. They should not be mixed up with “void reason codes” used when outgoing cheques are produced.
Question - 54 : - Explain what is an update type with reference to a match code ID?
Answer - 54 : -
If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the match-code has to be updated and how it has to be done. The update type also defines which method is to be used for building match-codes.
Question - 55 : - Explain what the .sca files and mention their importance?
Answer - 55 : -
. sca stands for SAP component Archive. It is used to deploy the Java components, patches, and other java developments in the form of. sca,. sda,.war and .jar.
Question - 56 : - Explain what is meant by “Business Content” in SAP?
Answer - 56 : -
Business Content in SAP is a pre-configured and pre-defined model of information contained in the SAP warehouse, which can be used directly or with desired modification in different industries.
Question - 57 : - Explain what is dispatcher?
Answer - 57 : -
A dispatcher is a component that takes the request for client systems and stores the request in the queue.
Question - 58 : - Mention what are the common transport errors?
Answer - 58 : -
The common transport errors include
- Return code 4: Imported with warnings, generation of program, columns or row missing
- Return code 8: Imported with a syntax error, program generation error, dictionary activation error, etc.
- Return code 12: Indicates import cancelled due to object missing, object not active, etc.
- Return code 18: Indicates import cancelled due to system down while import, user expired during import, and insufficient roles or authorization.
These Interview Questions are useful for Freshers as well as Experienced SAP Candidates.
Question - 59 : - Is There Any Specific Size Limit For A Sap Maxdb Database?
Answer - 59 : -
One can configure a maximum of 255 data volumes in the SAP MaxDB standard layout (parameter: VOLUMENO_BIT_COUNT or ConverterVolumeIDLayout= 8). The maximum size of a data volume can be 128 GB. However the maximum total size of the data volumes can be 32 TB. The log area can also use a maximum of 32 TB.
Question - 60 : - What Are The Tasks Of A Maxdb Database Administrator?
Answer - 60 : -
The MaxDB administrator is responsible for monitoring the active database and also for the following activities:
- Backing up the dataset and the log area
- Executing consistency checks on the dataset to eliminate inconsistencies in the database that are caused by hardware defects.
- Updating the optimizer statistics (Update Statistics).
- Executing performance analyses.
- Monitoring the free memory.