DB20 SAP tcode for – Update DB Statistics

Here we would like to draw your attention to DB20 transaction code in SAP. As we know it is being used in the SAP BC-DB (Database Interface, Database Platforms in Basis) component which is coming under BC module (BASIS).DB20 is a transaction code used for Update DB Statistics in SAP.

SAP DB20 transaction code

It comes under the package SDBA.When we execute this transaction code, SAPMSTRD is the normal standard SAP program that is being executed in background.

SAP DB20 menu path

See the possible menu paths to access the same report by avoiding entering the transaction code.
Path 1
Tools → CCMS → DB Administration → Cost-Based Optimizer → Create Statistics


Transaction DB20 technical data table

TcodeDB20
PurposeUpdate DB Statistics
ModuleBC
ComponentBC-DB
SAP PackageSDBA
Program runningSAPMSTRD
ObjectS_ADMI_FCD
Screen No1100
TypeT

Some Basic Questions & Answers

Which SAP Program will run when we enter tcode DB20?
Program named SAPMSTRD will run when we enter transaction code DB20.
What is the transaction code type of DB20?
DB20 is a Dialog Transaction code type which is shortly represented as T.