SAP Table DBDIFF

Definition of (Intended) Differences Between DD and DB

DBDIFF (Definition of (Intended) Differences Between DD and DB) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DBDIFF to other SAP tables.

DBDIFF table fields

Field

Data element

Checktable

Datatype

Length

Decimals

OBJNAME

Name of the database object (table, index, view ...)

DBDIFFOBJ

CHAR

DBSYS

Database system name

DBDIFFSYS

CHAR

Possible values

SAP DB	SAP DB
DB6	DB2 UDB
INFORMIX	INFORMIX
ORACLE	Oracle
DB2	DB2/CS
DB400	DB2/400
MSSQL	Microsoft SQL Server
HDB	SAP In-Memory Computing Engine
SYBASE	Sybase ASE

OBJTYPE

Object type of a database object (in DBDIFF)

DIFFOBJTYP

CHAR

Possible values

TABL	Table
VIEW	View
INDX	Index
KEY	(Primary) key
SPRO	Stored procedure
TRIG	Trigger

DIFFKIND

DD: Type of inconsistency between DD and DB, DB exceptions

DBDIFFKIND

NUMC

Possible values

01	Mandatory in DB, but not in DD
02	Mandatory in the DD but not on the DB (e.g. index)
04	Type in DD different to type in DB
08	Other definition in DD (fields, sequence, ...)
50	DB-system-dependent objects (mandatory in DD and DB)
60	Secondary index must be created before primary index
61	Table without indexes
70	Field name in reserved name range of DB system
95	Temporarily mandatory on the DB (is not checked)
99	Optional object (should not be checked)

SOURCE

ABAP program used to create a DB object

DBDIFFREP

CHAR