| 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 | T000 | MANDT | Allow NULL? |
| 2 | COMPR_VRSN | Summarization version in Info system for inv. programs | nvarchar | 3 | 0 | CHAR | (N' ') | No | IMCH | IMC_CVERS | Allow NULL? |
| 3 | INV_PROG | Investment program name | nvarchar | 8 | 0 | CHAR | (N' ') | No | IMCH | IM_PRNAM | Allow NULL? |
| 4 | APPR_YEAR | Approval year of the investment program | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | IM_GNJHR | Allow NULL? |
| 5 | PROG_POS | Identification for an investment program position | nvarchar | 24 | 0 | CHAR | (N' ') | No | IMCHIE | IM_POSID | Allow NULL? |
| 6 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | No | IMCH | LOGSYSTEM | Allow NULL? |
| 7 | RECNO | Record number for summarization of investment programs | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | IMC_RECNO | Allow NULL? |
| 8 | REQUEST | Appropriation request: Identification for internal use | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | IMCER | IMC_RPOSID | Allow NULL? |
| 9 | MEASURE | Measure: Identification for internal use | nvarchar | 26 | 0 | CHAR | (N' ') | Yes | IMCEM | IMC_MEASR | Allow NULL? |
| 10 | COMPANY | Company | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | RCOMP_D | Allow NULL? |
| 11 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 12 | BUS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 13 | CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 14 | PROFIT_CTR | IM Summarization: Profit centers | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | IMCEPC | IMC_PRCTR | Allow NULL? |
| 15 | COSTCENTER | IM Summarization: Requesting cost center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | IMCECC | IMC_KOSTL | Allow NULL? |
| 16 | PLANT | IM Summarization: Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | IMCEP | IMC_WERKS | Allow NULL? |
| 17 | FUNCTLOC | IM Summarization: Functional location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | IMCEFL | IMC_TPLNR | Allow NULL? |
| 18 | FUNC_AREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TFKB | FKBER | Allow NULL? |
| 19 | INV_CNTRY | Country for Which Approp. Request Is Planned | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | IMA_LAND1 | Allow NULL? |
| 20 | RESPNO_POS | Person responsible | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | TCJ04 | IM_VERNR | Allow NULL? |
| 21 | PARTN_NAME | Partner Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | PARTN_NAME | Allow NULL? |
| 22 | RESP_MEAS | Name of person responsible for measure | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | IMC_VERNM | Allow NULL? |
| 23 | NEW_OLD | Ind: Assignment new in approv. year/or copied from prev.year | char | 1 | 0 | CHAR | (N' ') | Yes | | IM_XGNJ | Allow NULL? |
| 24 | BLITM | IM: Balance sheet item (credit) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | IM_ERGSO | Allow NULL? |
| 25 | INV_REASON | Reason for investment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T087I | IZWEK | Allow NULL? |
| 26 | ENVIR_INV | Reason for environmental investment | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T087K | IMA_UMWKZ | Allow NULL? |
| 27 | PRIORITY | Priority | char | 1 | 0 | CHAR | (N' ') | Yes | * | IM_PRIOR | Allow NULL? |
| 28 | ISTAT_REQ | Main system status of an appropriation request | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | IMA_STATUS | Allow NULL? |
| 29 | ISTAT_MEAS | Main system status of measure | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | IM_STATUS | Allow NULL? |
| 30 | OBJECTTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_OBART_LD | Allow NULL? |
| 31 | SCALE | Scale of investment objects | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TAIF5 | IM_SIZECL | Allow NULL? |
| 32 | IM_UFLD00 | User field 1 (20 characters) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | IMA_USR00 | Allow NULL? |
| 33 | IM_UFLD01 | User field 2 (20 characters) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | IMA_USR01 | Allow NULL? |
| 34 | IM_UFLD02 | User field 3 (10 characters) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TAIF9 | IMA_USR02 | Allow NULL? |
| 35 | IM_UFLD03 | User field 4 (10 characters) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TAIF9 | IMA_USR03 | Allow NULL? |
| 36 | IM_UFLD10 | User field 11 as indicator for IM reports | char | 1 | 0 | CHAR | (N' ') | Yes | | IMA_USR10 | Allow NULL? |
| 37 | IM_UFLD11 | User field 12 as indicator for IM reports | char | 1 | 0 | CHAR | (N' ') | Yes | | IMA_USR11 | Allow NULL? |
| 38 | OWNSYS_FLG | IM Summarization: Indicator: Own logical system | char | 1 | 0 | CHAR | (N' ') | Yes | | IMC_XOWN | Allow NULL? |
| 39 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 40 | CREATED_ON | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 41 | DIVISION | Requesting Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | IMA_ASPART | Allow NULL? |
| 42 | ORIG_APPR_YEAR | Approval year for appropriation request | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | IMA_GJAHR | Allow NULL? |
| 43 | REQ_CHARACTER | Assignment of measures to appropriation request | char | 1 | 0 | NUMC | (N'0') | Yes | | IMA_REQ_CH | Allow NULL? |
| 44 | MEAS_REQ_REL | Assignment of measure to an appropriation request | char | 1 | 0 | NUMC | (N'0') | Yes | | IM_MEAS_AS | Allow NULL? |
| 45 | IM_UFLD12 | User field 13 for period and fiscal year | nvarchar | 6 | 0 | ACCP | (N' ') | Yes | | IMA_USR12 | Allow NULL? |
| 46 | IM_UFLD13 | User field 14 for period and fiscal year | nvarchar | 6 | 0 | ACCP | (N' ') | Yes | | IMA_USR13 | Allow NULL? |
| 47 | RESP_COSTCENTER | Responsible cost center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | IMA_VKOSTL | Allow NULL? |
