| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | CRM_OBJECT_GUID | Product, Category or Hierarchy GUID | varbinary | 16 | 0 | RAW | | No | | COMT_PME_CRM_GUID | |
| 3 | FROMDATE | Date for Determining the Relevant Knowledge Base | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | COMT_SCE_KB_DATE_MD | Allow NULL? |
| 4 | PR_ORG_TYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | COMT_PR_ORG_TYPE | Allow NULL? |
| 5 | PR_ORG_ID | Identification of an Organizational Unit | nvarchar | 32 | 0 | CHAR | (N' ') | No | | COMT_PR_ORG_ID | Allow NULL? |
| 6 | CRM_PARENT_GUID | Product, Category or Hierarchy GUID | varbinary | 16 | 0 | RAW | | No | | COMT_PME_CRM_GUID | |
| 7 | KBBUNDLEID | Internal Number of SCE Knowledge Base | int | 10 | 0 | INT4 | ((0)) | Yes | | COMT_SCED_KBID_MD | Allow NULL? |
| 8 | KBOBJNAME | Knowledge-Base Object | nvarchar | 72 | 0 | CHAR | (N' ') | Yes | | COMT_SCED_KBOBJNAME_MD | Allow NULL? |
| 9 | VERSION | Runtime Version of SCE Knowledge Base | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | COMT_SCED_VERSION_MD | Allow NULL? |
| 10 | KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | INT4 | ((0)) | Yes | | COMT_SCED_KBID_MD | Allow NULL? |
| 11 | TODATE | Date for Determining the Relevant Knowledge Base | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | COMT_SCE_KB_DATE_MD | Allow NULL? |
| 12 | CLASS_KEY | Knowledge-Base Object | nvarchar | 72 | 0 | CHAR | (N' ') | Yes | | COMT_SCED_KBOBJNAME_MD | Allow NULL? |
| 13 | ORGID | Organizational Unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | COMT_SCED_ORGID_MD | Allow NULL? |
| 14 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 15 | CAT_PARENT_KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | INT4 | ((0)) | Yes | | COMT_SCED_KBID_MD | Allow NULL? |
| 16 | ORG_PARENT_KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | INT4 | ((0)) | Yes | | COMT_SCED_KBID_MD | Allow NULL? |
| 17 | INACTIVE | Indicator: Inactive Product | char | 1 | 0 | CHAR | (N' ') | Yes | | COMT_SCED_INACTIVE_MD | Allow NULL? |