SAP table IMAV (Appropriation request variant)
SAP table IMAV has 3 primary key fields being MANDT,POSNR,VARNT.
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 | IMAK | IMA_POSNR | |
| VARNT | Variant of Appropriation Request | CHAR | 4 | 0 | IMA_VARNT | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Date on which object was last changed | DATS | 8 | 0 | UPDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |
| XGENEH | Approval by governmental authorities is required | CHAR | 1 | 0 | IMA_XGENEH | ||
| BWERT | Assessment criteria for appropriation request variants | CHAR | 4 | 0 | TAIF6 | IMA_BWERT | |
| FDATU | Desired completion date | DATS | 8 | 0 | IMA_FDATU | ||
| IDATU | Start-up date (relative to/independent of implement. start) | DATS | 8 | 0 | IMA_IDATU | ||
| IZFUS | Internal rate of return from preinvestment analysis | DEC | 5 | 2 | IMA_IZFUS | ||
| KAPWRT | Net present value of app. request variant in CO area curr. | CURR | 15 | 2 | IMA_KAPWRT | ||
| KAPWRO | Net present value of approp.req. variant - obj. currency | CURR | 15 | 2 | IMA_KAPWRO | ||
| KAPRAT | Disc. cash flow rate f. app.req.variant in COarea currcy | DEC | 7 | 3 | IMA_KAPRAT | ||
| AMORT | Payback period for appropriation requests | DEC | 7 | 3 | IMA_AMORT | ||
| WIDAT | Reference date for the preinvestment analysis | DATS | 8 | 0 | IMA_WIDAT | ||
| MPLAN | Indicator: Planning on measure | CHAR | 1 | 0 | IM_MPLAN | ||
| MVERS | Planning version in assigned measure | CHAR | 3 | 0 | * | IM_MVERS | |
| VARGN | Variant that was approved after this variant | CHAR | 4 | 0 | IMA_VARGN | ||
| KVARNT | Copied appropriation request variant | CHAR | 4 | 0 | IMA_KVARNT | ||
| DWIRE | Date on which preinvestment analysis was manually changed | DATS | 8 | 0 | IMA_DWIRE | ||
| KLVAR | Costing Variant | CHAR | 4 | 0 | * | CK_KLVAR | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | NUMC | 12 | 0 | * | CK_KALNR | |
| IVPRZ | Investment Portion as Percent | DEC | 3 | 0 | IMA_IVPRZ | ||
| COPRZ | Part of Plan Values Transferred to Measures | DEC | 3 | 0 | IMA_COPRZ |
IMAV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 IMAV | BWERT | TAIF6 | Scores for variants | MANDT |
| 0 IMAV | BWERT | TAIF6 | Scores for variants | BWERT |
| 1 IMAV | OBJNR | ONR00 | General Object Number | MANDT |
| 0 IMAV | POSNR | IMAK | Appropriation requests - general data | MANDT |
| 0 IMAV | POSNR | IMAK | Appropriation requests - general data | POSNR |