| 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 | T000 | MANDT | Allow NULL? |
| 2 | PRART | Program type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | IM_PRART | Allow NULL? |
| 3 | PROFIL | Budget Profile | nvarchar | 6 | 0 | CHAR | (N' ') | No | TBP1C | BP_BPROFIL | Allow NULL? |
| 4 | XALLP | Ind. "Operative objects at all positions" | char | 1 | 0 | CHAR | (N' ') | No | | IM_XALLP | Allow NULL? |
| 5 | DARST | Represent. of cap. inv. prog. position in graphic hierarchy | char | 1 | 0 | CHAR | (N' ') | No | | IM_DARST | Allow NULL? |
| 6 | SCOPE | Object Class | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SCOPE_CV | Allow NULL? |
| 7 | VJAWE | Handling of unused budgets at fiscal year change | char | 1 | 0 | CHAR | (N' ') | No | | IM_VJAWE | Allow NULL? |
| 8 | XJBDG | Ind. "Annual budget" | char | 1 | 0 | CHAR | (N' ') | No | | IM_XJBDG | Allow NULL? |
| 9 | PRAUT | Ind. automatic assignment of program position | char | 1 | 0 | CHAR | (N' ') | No | | IM_PRAUT | Allow NULL? |
| 10 | STSMA | Status Profile | nvarchar | 8 | 0 | CHAR | (N' ') | No | TJ20 | J_STSMA | Allow NULL? |
| 11 | XAKTB | Budget distrib. of overall values only from prog.position | char | 1 | 0 | CHAR | (N' ') | No | | IM_XAKTB | Allow NULL? |
| 12 | XORGV | Ind: Data transfer of org. units to lower hierarchy levels | char | 1 | 0 | CHAR | (N' ') | No | | IM_XORGV | Allow NULL? |
| 13 | XORGC | Indicator: Check org. units of assigned measures | char | 1 | 0 | CHAR | (N' ') | No | | IM_XORGC | Allow NULL? |
| 14 | XAFAV | Indicator: Depreciation forecast incl. distributed values | char | 1 | 0 | CHAR | (N' ') | No | | IM_XAFAV | Allow NULL? |
| 15 | KURST | Exch. Rate Type for Currency Translation in IM InfoSystem | nvarchar | 4 | 0 | CHAR | (N' ') | No | TCURV | IM_KURST | Allow NULL? |
| 16 | CAFWD | Ind: Take over old assignements of measures | char | 1 | 0 | CHAR | (N' ') | No | | IM_CAFWD | Allow NULL? |
| 17 | PPROFIL | Planning profile | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TBP1C | BP_PPROFIL | Allow NULL? |
| 18 | YDIST | Budget distribution of annual values from program position | char | 1 | 0 | CHAR | (N' ') | Yes | | IM_YDIST | Allow NULL? |
| 19 | DIMEN | Dimension in Consolidation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TF150 | IM_DIMEN | Allow NULL? |
| 20 | X1ASS | Indicator: Only single assignment allowed | char | 1 | 0 | CHAR | (N' ') | No | | IM_SINGLE_ASSIGN | Allow NULL? |
| 21 | IVPRO | Investment measure profile | nvarchar | 6 | 0 | CHAR | (N' ') | No | TAPRF | IM_PROFIL | Allow NULL? |
