SAP table CUKB (Administrative Information for Dependency Maintenance)

SAP table CUKB has 3 primary key fields being MANDT,KNNUM,ADZHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KNNUM Internal number of knowledge element NUMC 10 0 KNNUM
ADZHL Internal Counter for Archiving Objects by ECM NUMC 4 0 ADZHL
KNNAM Name of Dependency CHAR 30 0 KNNAM
KNART Dependency Type CHAR 4 0 KNART
1 Constraint
11 Constraint AVC
12 Precondition AVC
14 Rule AVC
15 Selection Condition AVC
16 Dependency Net AVC
17 Procedure AVC
2 Precondition
3 Action
4 Rule
5 Selection condition
6 Dependency net
7 Procedure
KNART2 Dependency type - supplement CHAR 1 0 KNART2
Standard
1 Event-driven
2 Monitoring
KNSOFT Indicator: Soft/Hard Inferred Values for Dependency CHAR 1 0 KNSOFT
KNVER Internal version number for object dependency NUMC 4 0 KNVER
KNVER2 Suffix for internal version assignment of dependency NUMC 4 0 KNVER2
KNSCE Indicator: Dependencies for SCE Format CHAR 1 0 KNSCE
KNSTA Dependency status CHAR 1 0 TCUX KNSTA
KNEDT Creation Date DATS 8 0 KNEDT
KNEUS Person Who Created Dependency CHAR 12 0 KNEUS
KNADT Date of Last Change DATS 8 0 KNADT
KNAUS Last Changed By CHAR 12 0 KNAUS
KNGRP Dependency Group CHAR 10 0 TCUG KNGRP
KNBEO Authorization Group for Object Dependencies CHAR 3 0 TCUB KNBEO
LKENZ Deletion Indicator CHAR 1 0 LKENZ
AENNR Change Number CHAR 12 0 AENNR
DATUV Valid-From Date DATS 8 0 DATUV
DATUB Valid-to date DATS 8 0 DATUB
CHTIM UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL

CUKB foreign key relationships

Table Field Check Table Check Field
0 CUKB KNBEO TCUB Authorization Groups for Object Dependencies MANDT
1 CUKB KNGRP TCUG Dependency Maintenance - Groups MANDT
1 CUKB KNGRP TCUG Dependency Maintenance - Groups KNGRP
0 CUKB KNSTA TCUX Dependency Maintenance - Statuses MANDT
1 CUKB MANDT T000 Clients MANDT