SAP table SCEKB (Runtime Version of SCE Knowledge Base)
SAP table SCEKB has 4 primary key fields being MANDT,KBID,KBOBJNAME,VERSION.
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 | |
| KBID | Internal Number of SCE Knowledge Base | NUMC | 6 | 0 | KBID | ||
| KBOBJNAME | Knowledge-Base Object | CHAR | 30 | 0 | SCEKBOBJ | KBOBJNAME | |
| VERSION | Runtime Version of SCE Knowledge Base | CHAR | 30 | 0 | RTVERSION | ||
| BUILD | Build number of runtime version | NUMC | 4 | 0 | RTBUILD | ||
| FROMDATE | Valid-from date | DATS | 8 | 0 | SCEDATUM | ||
| STATUS | Status of version of SCE knowledge base | CHAR | 1 | 0 | TCUX | SCESTATUS | |
| AUTHORIZE | Authorization to create/change/download a knowledge base | CHAR | 3 | 0 | TCUB | SCEAUTHORI | |
| CREATOR | User that created a knowledge base version | CHAR | 12 | 0 | SCECREATOR | ||
| CREADATE | Creation date | DATS | 8 | 0 | SCECREADAT | ||
| CHANGER | User that last changed a knowledge base version | CHAR | 12 | 0 | SCECHANGER | ||
| CHANGEDATE | Changed On | DATS | 8 | 0 | SCECHANDAT | ||
| LANG_DOWN | Language key | LANG | 1 | 0 | T002 | SCELANGU | |
| PLANT | Plant | CHAR | 4 | 0 | T001W | SCEPLANT | |
| BOM_APPL | BOM application | CHAR | 4 | 0 | TC04 | SCEBOMAPPL | |
| KLART_DOWN | Class type | CHAR | 3 | 0 | TCLA | SCECLTYPE | |
| CLASSICDEP | Boolean (T = true, F = false, blank = unknown) | CHAR | 1 | 0 | SCEBOOLEAN | ||
| ACTIONFLAG | Boolean (T = true, F = false, blank = unknown) | CHAR | 1 | 0 | SCEBOOLEAN | ||
| KBSCHEMA | 2-byte integer | INT2 | 5 | 0 | SCEINT2 |
SCEKB foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SCEKB | AUTHORIZE | TCUB | Authorization Groups for Object Dependencies | MANDT |
| 1 SCEKB | BOM_APPL | TC04 | Applic-Specific Criteria for Alternative Determination | MANDT |
| 1 SCEKB | BOM_APPL | TC04 | Applic-Specific Criteria for Alternative Determination | CAPID |
| 0 SCEKB | KBOBJNAME | SCEKBOBJ | Knowledge-Base Object (SCE) | MANDT |
| 0 SCEKB | KBOBJNAME | SCEKBOBJ | Knowledge-Base Object (SCE) | CUCOUNT |
| 1 SCEKB | KLART_DOWN | TCLA | Class Types | MANDT |
| 0 SCEKB | LANG_DOWN | T002 | Language Keys (Component BC-I18) | SPRAS |
| 1 SCEKB | PLANT | T001W | Plants/Branches | MANDT |
| 1 SCEKB | PLANT | T001W | Plants/Branches | WERKS |
| 0 SCEKB | STATUS | TCUX | Dependency Maintenance - Statuses | MANDT |