| 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 | KF_ADM_VAR | Technical Name of Key Figure Administrator | nvarchar | 30 | 0 | CHAR | (N' ') | No | | KFM_ADM_VAR | Allow NULL? |
| 3 | KF_TIMESTAMP | Time Stamp | decimal | 15 | 0 | DEC | ((0)) | No | | KFM_TIMESTAMP | |
| 4 | KF_SRC_TYPE | Source System Type of Key Figure | char | 1 | 0 | CHAR | (N' ') | Yes | | KFM_KF_SOURCE_TYPE | Allow NULL? |
| 5 | KF_SRC_SYSTEM | Source System of Key Figure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KFM_KF_SOURCE | Allow NULL? |
| 6 | KF_DECIMALS | Number of Decimal Places for Key Figure Display | char | 1 | 0 | CHAR | (N' ') | Yes | | KFM_KF_DECIMALS | Allow NULL? |
| 7 | KF_PROGRAM | Report for Generating Key Figure Value | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | KFM_PROGRAM | Allow NULL? |
| 8 | KF_VARIANT | Variant of Report for Generating Key Figure | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | KFM_VARIANT | Allow NULL? |
| 9 | KF_EXE_USER | User for Generating Key Figures | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KFM_KF_EXE_USER | Allow NULL? |
| 10 | BW_WEBTEMPLATE | Business Information Warehouse Web Template | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KFM_BW_WEBTEMPLATE | Allow NULL? |
| 11 | KF_EXT_SYS_URL | URL Link to External System | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | KFM_EXT_SYS_URL | Allow NULL? |
| 12 | KF_MIN_VALUE | Minimum Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_MIN_VALUE | |
| 13 | KF_MAX_VALUE | Maximum Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_MAX_VALUE | |
| 14 | KF_TARGET | Target Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_KF_TARGET | |
| 15 | KF_R2YGATE | Red->Yellow Threshold Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_R2YGATE_VAL | |
| 16 | KF_Y2GGATE | Yellow->green threshold value of key figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_Y2GGATE_VAL | |
| 17 | KF_G2YGATE | Green->Yellow Threshold Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_G2YGATE_VAL | |
| 18 | KF_Y2RGATE | Yellow->Red Threshold Value of Key Figure | decimal | 20 | 5 | DEC | ((0)) | Yes | | KFM_Y2RGATE_VAL | |
| 19 | KF_PERIOD | Period Type for Key Figure | char | 1 | 0 | CHAR | (N' ') | Yes | | KFM_PERIOD | Allow NULL? |
| 20 | KF_NUM_PERIODS | Number of Periods (Validity of Key Figures) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KFM_NUM_PERIODS | Allow NULL? |
| 21 | KF_CMT_SETTING | Settings for Comments | char | 1 | 0 | CHAR | (N' ') | Yes | | KFM_KF_COMMENT_SETTING | Allow NULL? |
| 22 | KF_INTERVAL | Interval for Value Determination of Key Figures | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | KFM_INTERVAL | KFM_KF_INTERVAL | Allow NULL? |
| 23 | KF_CATEGORY | Key Figure Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | KFM_CATEGORY | KFM_KF_CATEGORY | Allow NULL? |
