| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | DATUM | Local Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SYSTDATLO | Allow NULL? |
| 2 | TIME | Local Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | SYSTTIMLO | Allow NULL? |
| 3 | PROG_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 4 | TSTSET_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 5 | ID | ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | | /SAPAPO/OM_ID | Allow NULL? |
| 6 | COM_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 7 | LVC_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 8 | APPHW_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 9 | LVCHW_GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 10 | DURATION | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 11 | COUNTER | Counter | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/OM_TB_COUNTER | Allow NULL? |
| 12 | TEXT | Result | nvarchar | 120 | 0 | CHAR | (N' ') | No | | /SAPAPO/OM_TEXT120 | Allow NULL? |
| 13 | LVCFILLRATE | liveCache Fill Rate | int | 10 | 0 | INT4 | ((0)) | No | | /SAPAPO/OM_TB_FILLRATE | Allow NULL? |
| 14 | LVCHITRATIO | liveCache Hit Ratio | int | 10 | 0 | INT4 | ((0)) | No | | /SAPAPO/OM_TB_HITRATIO | Allow NULL? |
| 15 | LVCSIZE | liveCache Data Cache Size | int | 10 | 0 | INT4 | ((0)) | No | | /SAPAPO/OM_TB_SIZE | Allow NULL? |
| 16 | TEST_CONNECTION | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 17 | TEST_GLOBALS | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 18 | TEST_TABLE_READ | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 19 | TEST_TABLE_WRITE | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 20 | TEST_LOOP | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 21 | TEST_MEM | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 22 | TEST_KEYRANGE | Duration of the Call in Seconds (in Test Table Examples) | decimal | 14 | 4 | DEC | ((0)) | Yes | | /SAPAPO/OM_TB_DURATION | |
| 23 | SUM_RTIME | Total Runtime for All Calls (AvgRuntime * CallCnt) | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCSUMRTIME | |
| 24 | OMS_DEREF | Number of dereferencings (accesses to object instances) | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCOMSDEREF | |
| 25 | KEY_DEREF | Number of dereferencings with key | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCKEYDEREF | |
| 26 | MALLOCMAX | Maximum Number of Bytes Allocated Using omsMalloc | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCMALLOMAX | |
| 27 | METHODE1 | Name of database procedure called | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | LC_METHODE | Allow NULL? |
| 28 | SUM_RTIME1 | Total Runtime for All Calls (AvgRuntime * CallCnt) | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCSUMRTIME | |
| 29 | METHODE2 | Name of database procedure called | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | LC_METHODE | Allow NULL? |
| 30 | SUM_RTIME2 | Total Runtime for All Calls (AvgRuntime * CallCnt) | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCSUMRTIME | |
| 31 | METHODE3 | Name of database procedure called | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | LC_METHODE | Allow NULL? |
| 32 | SUM_RTIME3 | Total Runtime for All Calls (AvgRuntime * CallCnt) | decimal | 20 | 0 | DEC | ((0)) | Yes | | LCSUMRTIME | |
| 33 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 34 | FINAL | Boolean Value for liveCache COM Routines | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_BOOL | Allow NULL? |
| 35 | COMMENTARY | Result | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_TEXT120 | Allow NULL? |
| 36 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 37 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
