| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | GUID of Buffered Version | nvarchar | 32 | 0 | CHAR | (N' ') | No | | FOPC_RBF_GUID | Allow NULL? |
| 3 | ORGUNIT | Organizational Unit ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | FOPC_REP_ORGUNIT_ID | Allow NULL? |
| 4 | PRGROUP | Process Group ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | FOPC_REP_PRGROUP_ID | Allow NULL? |
| 5 | PROCESS | MIC Reporting: Process ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | FOPC_REP_PROCESS_ID | Allow NULL? |
| 6 | MCONTROL | MIC Reporting: Management Control ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | FOPC_REP_MCONTROL_ID | Allow NULL? |
| 7 | CONTROL | MIC Reporting: Control ID | nvarchar | 9 | 0 | CHAR | (N' ') | No | | FOPC_REP_CONTROL_ID | Allow NULL? |
| 8 | CASEGUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | CHAR | (N' ') | No | | SCMG_CASE_GUID | Allow NULL? |
| 9 | PARENT | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SCMG_CASE_GUID | Allow NULL? |
| 10 | RESPONSIBLE | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUBNAME | Allow NULL? |
| 11 | PROCESSOR | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUBNAME | Allow NULL? |
| 12 | CATEGORY | Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SCMG_CATEGORY | Allow NULL? |
| 13 | STATUS | Object Status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CRM_J_STATUS | Allow NULL? |
| 14 | PRIORITY | Issue Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | FOPC_ISSUE_PRIORITY | Allow NULL? |
| 15 | DURATION | Duration for Issue/Remediation Plan | int | 10 | 0 | INT4 | ((0)) | Yes | | FOPC_REP_DURATION | Allow NULL? |
| 16 | CMP_CONTROL | Name | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | FOPC_TEXT | Allow NULL? |
| 17 | CF_STATUS | Carryforward Status | char | 1 | 0 | CHAR | (N' ') | Yes | | FOPC_CF_STATUS | Allow NULL? |
| 18 | CREATION | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 19 | CHANGING | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 20 | CLOSING | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 21 | CF_TFRAME | Timeframe | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FOPC_TIMEFRAME | Allow NULL? |
| 22 | CF_YEAR | Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FOPC_YEAR | Allow NULL? |
