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.
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
Tcode | DB20 |
Purpose | Update DB Statistics |
Module | BC |
Component | BC-DB |
SAP Package | SDBA |
Program running | SAPMSTRD |
Object | S_ADMI_FCD |
Screen No | 1100 |
Type | T |
Some Basic Questions & Answers
Program named SAPMSTRD will run when we enter transaction code DB20.
DB20 is a Dialog Transaction code type which is shortly represented as T.