SAP table IMAK (Appropriation requests - general data)

SAP table IMAK has 2 primary key fields being MANDT,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
POSNR Internal number for appropriation request CHAR 12 0 IMA_POSNR
IVART Appropriation request type CHAR 2 0 TAIF1 IMA_IVART
POSID Appropriation Request Number (Formatted for Coding Mask) CHAR 24 0 IMA_POSID
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
WAERS Object currency of the appropriation request CUKY 5 0 TCURC IMA_WAERS
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Date on which object was last changed DATS 8 0 UPDAT
VKOKRS Responsible controlling area CHAR 4 0 TKA01 IMA_VKOKRS
ABUKRS Requesting company code CHAR 4 0 T001 IMA_ABUKRS
VBUKRS Responsible company code CHAR 4 0 T001 IMA_VBUKRS
ARCOMP Requesting company CHAR 6 0 T880 IMA_ARCOMP
VRCOMP Responsible company CHAR 6 0 T880 IMA_VRCOMP
FKBER Functional Area CHAR 16 0 TFKB FKBER
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
WERKS Plant CHAR 4 0 T001W WERKS_D
SIZECL Scale of investment objects CHAR 2 0 TAIF5 IM_SIZECL
WDATU Desired date for start of implementation DATS 8 0 IMA_WDATU
PRIORI Priority of the appropriation request CHAR 1 0 TCN07 IMA_PRIOR
VKOSTL Responsible cost center CHAR 10 0 CSKS IMA_VKOSTL
VPRCTR Responsible profit center CHAR 10 0 CEPC IMA_VPRCTR
VGSBER Responsible business area CHAR 4 0 TGSB IMA_VGSBER
XEXTRN Required by external authorities CHAR 1 0 IMA_XEXTRN
AUART Order Type CHAR 4 0 T003O AUFART
PROFIDPROJ Project Profile CHAR 7 0 TCJ41 PROFIDPROJ
XEINZL Flag for individual app. request belonging to coll.app.reqst CHAR 1 0 IMA_XEINZL
VBUND Trading partner number for app.requests within group CHAR 6 0 T880 IMA_VBUND
PSPNR Internal sequence number of project for approp. request NUMC 8 0 PROJ IMA_PSPNR
GDATU Planned approval date for appropriation request DATS 8 0 IMA_GDATU
GJAHR Approval year for appropriation request NUMC 4 0 IMA_GJAHR
STORT Planned location of appropriation request CHAR 10 0 T499S IMA_STORT
PRART Program type CHAR 4 0 TAI05 IM_PRART
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
LAND1 Country/Region for Planned Request CHAR 3 0 T005 IMA_LAND1
XWFLOW Indicator: Workflow was started CHAR 1 0 IMA_XWFLOW
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
USR00 User field 1 (20 characters) CHAR 20 0 IMA_USR00
USR01 User field 2 (20 characters) CHAR 20 0 IMA_USR01
USR02 User field 3 (10 characters) CHAR 10 0 TAIF9 IMA_USR02
USR03 User field 4 (10 characters) CHAR 10 0 TAIF9 IMA_USR03
USR04 User field 5 for quantity - IM QUAN 13 3 IMA_USR04
USE04 User field 5 for unit for quantity field 5 - IM UNIT 3 0 T006 IMA_USE04
USR05 User field 6 for quantity - IM QUAN 13 3 IMA_USR05
USE05 User field 6 for unit of quantity field 6 -IM- UNIT 3 0 T006 IMA_USE05
USR06 User field 7 for values - IM CURR 13 3 IMA_USR06
USE06 User field 7 for currency for user field 7 CUKY 5 0 TCURC IMA_USE06
USR07 User field 8 for values - IM CURR 13 3 IMA_USR07
USE07 User field 8 for currency for user field 8 CUKY 5 0 TCURC IMA_USE07
USR08 User field 9 as date for IM DATS 8 0 IMA_USR08
USR09 User field 10 as date for IM DATS 8 0 IMA_USR09
USR10 User field 11 as indicator for IM reports CHAR 1 0 IMA_USR10
USR11 User field 12 as indicator for IM reports CHAR 1 0 IMA_USR11
USR12 User field 13 for period and fiscal year ACCP 6 0 IMA_USR12
USR13 User field 14 for period and fiscal year ACCP 6 0 IMA_USR13
STRATFLG Strategic Appropriation Request CHAR 1 0 IM_STRATFLG

IMAK foreign key relationships

Table Field Check Table Check Field
0 IMAK ABUKRS T001 Company Codes BUKRS
1 IMAK ARCOMP T880 Global Company Data (for KONS Ledger) MANDT
1 IMAK ARCOMP T880 Global Company Data (for KONS Ledger) RCOMP
0 IMAK AUART T003O Order Types AUART
1 IMAK FKBER TFKB Functional areas FKBER
0 IMAK IVART TAIF1 Appropriation request types MANDT
0 IMAK IVART TAIF1 Appropriation request types IVART
1 IMAK LAND1 T005 Countries MANDT
1 IMAK LAND1 T005 Countries LAND1
0 IMAK LOGSYSTEM TBDLS Logical system LOGSYS
1 IMAK OBJNR ONR00 General Object Number MANDT
0 IMAK PRART TAI05 CI Program Types MANDT
0 IMAK PRART TAI05 CI Program Types PRART
1 IMAK PRIORI TCN07 Priority MANDT
1 IMAK PRIORI TCN07 Priority NPRIO
0 IMAK PROFIDPROJ TCJ41 Default Values for Work Breakdown Structure MANDT
1 IMAK PSPNR PROJ Project definition MANDT
1 IMAK PSPNR PROJ Project definition PSPNR
0 IMAK SIZECL TAIF5 Scale of investment objects MANDT
0 IMAK SIZECL TAIF5 Scale of investment objects SIZECL
1 IMAK STORT T499S Location MANDT
1 IMAK STORT T499S Location WERKS
0 IMAK USE04 T006 Units of Measurement MANDT
1 IMAK USE05 T006 Units of Measurement MANDT
0 IMAK USE06 TCURC Currency Codes MANDT
0 IMAK USE06 TCURC Currency Codes WAERS
1 IMAK USE07 TCURC Currency Codes MANDT
1 IMAK USE07 TCURC Currency Codes WAERS
0 IMAK USR02 TAIF9 Value table for user fields MANDT
0 IMAK USR02 TAIF9 Value table for user fields USRNR
1 IMAK USR03 TAIF9 Value table for user fields MANDT
1 IMAK USR03 TAIF9 Value table for user fields USRNR
0 IMAK VBUKRS T001 Company Codes BUKRS
1 IMAK VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 IMAK VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 IMAK VGSBER TGSB Business Areas MANDT
0 IMAK VGSBER TGSB Business Areas GSBER
1 IMAK VKOKRS TKA01 Controlling Areas MANDT
0 IMAK VKOSTL CSKS Cost Center Master Record MANDT
0 IMAK VKOSTL CSKS Cost Center Master Record KOKRS
0 IMAK VKOSTL CSKS Cost Center Master Record DATBI
1 IMAK VPRCTR CEPC Profit Center Master Data Table PRCTR
1 IMAK VPRCTR CEPC Profit Center Master Data Table DATBI
1 IMAK VPRCTR CEPC Profit Center Master Data Table KOKRS
0 IMAK VRCOMP T880 Global Company Data (for KONS Ledger) MANDT
0 IMAK VRCOMP T880 Global Company Data (for KONS Ledger) RCOMP
1 IMAK WAERS TCURC Currency Codes MANDT
1 IMAK WAERS TCURC Currency Codes WAERS
0 IMAK WERKS T001W Plants/Branches MANDT
0 IMAK WERKS T001W Plants/Branches WERKS