| 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 | POSNR | Internal number for appropriation request | nvarchar | 12 | 0 | CHAR | (N' ') | No | | IMA_POSNR | Allow NULL? |
| 3 | IVART | Appropriation request type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TAIF1 | IMA_IVART | Allow NULL? |
| 4 | POSID | Appropriation Request Number (Formatted for Coding Mask) | nvarchar | 24 | 0 | CHAR | (N' ') | No | | IMA_POSID | Allow NULL? |
| 5 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 6 | WAERS | Object currency of the appropriation request | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | IMA_WAERS | Allow NULL? |
| 7 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 8 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 9 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 10 | AEDAT | Date on which object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | UPDAT | Allow NULL? |
| 11 | VKOKRS | Responsible controlling area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | IMA_VKOKRS | Allow NULL? |
| 12 | ABUKRS | Requesting company code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | IMA_ABUKRS | Allow NULL? |
| 13 | VBUKRS | Responsible company code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | IMA_VBUKRS | Allow NULL? |
| 14 | ARCOMP | Requesting company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | IMA_ARCOMP | Allow NULL? |
| 15 | VRCOMP | Responsible company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | IMA_VRCOMP | Allow NULL? |
| 16 | FKBER | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | No | TFKB | FKBER | Allow NULL? |
| 17 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | No | IFLOT | TPLNR | Allow NULL? |
| 18 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 19 | SIZECL | Scale of investment objects | nvarchar | 2 | 0 | CHAR | (N' ') | No | TAIF5 | IM_SIZECL | Allow NULL? |
| 20 | WDATU | Desired date for start of implementation | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | IMA_WDATU | Allow NULL? |
| 21 | PRIORI | Priority of the appropriation request | char | 1 | 0 | CHAR | (N' ') | No | TCN07 | IMA_PRIOR | Allow NULL? |
| 22 | VKOSTL | Responsible cost center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CSKS | IMA_VKOSTL | Allow NULL? |
| 23 | VPRCTR | Responsible profit center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CEPC | IMA_VPRCTR | Allow NULL? |
| 24 | VGSBER | Responsible business area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | IMA_VGSBER | Allow NULL? |
| 25 | XEXTRN | Required by external authorities | char | 1 | 0 | CHAR | (N' ') | No | | IMA_XEXTRN | Allow NULL? |
| 26 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | AUFART | Allow NULL? |
| 27 | PROFIDPROJ | Project Profile | nvarchar | 7 | 0 | CHAR | (N' ') | No | TCJ41 | PROFIDPROJ | Allow NULL? |
| 28 | XEINZL | Flag for individual app. request belonging to coll.app.reqst | char | 1 | 0 | CHAR | (N' ') | No | | IMA_XEINZL | Allow NULL? |
| 29 | VBUND | Trading partner number for app.requests within group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | IMA_VBUND | Allow NULL? |
| 30 | PSPNR | Internal sequence number of project for approp. request | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PROJ | IMA_PSPNR | Allow NULL? |
| 31 | GDATU | Planned approval date for appropriation request | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IMA_GDATU | Allow NULL? |
| 32 | GJAHR | Approval year for appropriation request | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | IMA_GJAHR | Allow NULL? |
| 33 | STORT | Planned location of appropriation request | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T499S | IMA_STORT | Allow NULL? |
| 34 | PRART | Program type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TAI05 | IM_PRART | Allow NULL? |
| 35 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | LOGSYSTEM | Allow NULL? |
| 36 | LAND1 | Country for Which Approp. Request Is Planned | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | IMA_LAND1 | Allow NULL? |
| 37 | XWFLOW | Indicator: Workflow was started | char | 1 | 0 | CHAR | (N' ') | Yes | | IMA_XWFLOW | Allow NULL? |
| 38 | SCOPE | Object Class | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SCOPE_CV | Allow NULL? |
| 39 | USR00 | User field 1 (20 characters) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | IMA_USR00 | Allow NULL? |
| 40 | USR01 | User field 2 (20 characters) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | IMA_USR01 | Allow NULL? |
| 41 | USR02 | User field 3 (10 characters) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TAIF9 | IMA_USR02 | Allow NULL? |
| 42 | USR03 | User field 4 (10 characters) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TAIF9 | IMA_USR03 | Allow NULL? |
| 43 | USR04 | User field 5 for quantity - IM | decimal | 13 | 3 | QUAN | ((0)) | Yes | | IMA_USR04 | |
| 44 | USE04 | User field 5 for unit for quantity field 5 - IM | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | IMA_USE04 | Allow NULL? |
| 45 | USR05 | User field 6 for quantity - IM | decimal | 13 | 3 | QUAN | ((0)) | Yes | | IMA_USR05 | |
| 46 | USE05 | User field 6 for unit of quantity field 6 -IM- | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | IMA_USE05 | Allow NULL? |
| 47 | USR06 | User field 7 for values - IM | decimal | 13 | 3 | CURR | ((0)) | Yes | | IMA_USR06 | |
| 48 | USE06 | User field 7 for currency for user field 7 | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | IMA_USE06 | Allow NULL? |
| 49 | USR07 | User field 8 for values - IM | decimal | 13 | 3 | CURR | ((0)) | Yes | | IMA_USR07 | |
| 50 | USE07 | User field 8 for currency for user field 8 | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | IMA_USE07 | Allow NULL? |
| 51 | USR08 | User field 9 as date for IM | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IMA_USR08 | Allow NULL? |
| 52 | USR09 | User field 10 as date for IM | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IMA_USR09 | Allow NULL? |
| 53 | USR10 | User field 11 as indicator for IM reports | char | 1 | 0 | CHAR | (N' ') | Yes | | IMA_USR10 | Allow NULL? |
| 54 | USR11 | User field 12 as indicator for IM reports | char | 1 | 0 | CHAR | (N' ') | Yes | | IMA_USR11 | Allow NULL? |
| 55 | USR12 | User field 13 for period and fiscal year | nvarchar | 6 | 0 | ACCP | (N' ') | Yes | | IMA_USR12 | Allow NULL? |
| 56 | USR13 | User field 14 for period and fiscal year | nvarchar | 6 | 0 | ACCP | (N' ') | Yes | | IMA_USR13 | Allow NULL? |
| 57 | STRATFLG | Strategic Appropriation Request | char | 1 | 0 | CHAR | (N' ') | Yes | | IM_STRATFLG | Allow NULL? |
