| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FIKRS | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | FIPEX | Commitment Item | nvarchar | 24 | 0 | | | | Allow NULL? |
| 5 | KATEG | Attribute: Can be Posted To | char | 1 | 0 | | | | Allow NULL? |
| 6 | FIVOR | Financial transaction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | POTYP | Commitment Item Category | char | 1 | 0 | | | | Allow NULL? |
| 8 | KRTYP | Commitment item criterion category | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | FPART | Commitment Item Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | FIPUP | Superior Commitment Item | nvarchar | 24 | 0 | | | | Allow NULL? |
| 11 | POSIT | Item (Internal Commitment Item Number) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FICTR | Funds Center (Default Value in a Commitment Item) | nvarchar | 16 | 0 | | | | Allow NULL? |
| 13 | VPTYP | Carryforward item category for commitment item | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | SNTYP | Collective budget adminstration category | char | 1 | 0 | | | | Allow NULL? |
| 15 | SNROL | Use type in collective budget administration | char | 1 | 0 | | | | Allow NULL? |
| 16 | KRGRP | Criterion category group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | STATS | Statistical commitment item | char | 1 | 0 | | | | Allow NULL? |
| 18 | NCBUD | No Budget for Future Years | char | 1 | 0 | | | | Allow NULL? |
| 19 | AUGRP | Authorization Groups of the Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | STVAR | Standard variant | char | 1 | 0 | | | | Allow NULL? |
| 21 | HSART | Commitment Item Type | char | 1 | 0 | | | | Allow NULL? |
| 22 | GKFLG | Relevant to total costs | char | 1 | 0 | | | | Allow NULL? |
| 23 | DRUCK | Not relevant for budget print | char | 1 | 0 | | | | Allow NULL? |
| 24 | CFFLG | Able to carry forward at fiscal year change | char | 1 | 0 | | | | Allow NULL? |
| 25 | CVFLG | (Negative) clearing item | char | 1 | 0 | | | | Allow NULL? |
| 26 | NEGBUD | Negative Budget Permitted | char | 1 | 0 | | | | Allow NULL? |
| 27 | BEZIRK | District | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | BSAMT | Managed position / clearing lower section | nvarchar | 16 | 0 | | | | Allow NULL? |
| 29 | UBFLG | Local authorities: Budget execution account | char | 1 | 0 | | | | Allow NULL? |
| 30 | HSFLG | Budget balancing concept | char | 1 | 0 | | | | Allow NULL? |
| 31 | NDAKZ | Indicator: NDA Budget | char | 1 | 0 | | | | Allow NULL? |
| 32 | AZPKZ | Indicator: Accrued Budget | char | 1 | 0 | | | | Allow NULL? |
| 33 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | | | Allow NULL? |
| 35 | BUTYP | Budget structure element type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | DATAB | FM: Valid from date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | DATBIS | FM: Valid to date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | DATE_EXP | Expiration Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | DUMMY_FMCIEXT | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 40 | DUMMY_FSTR | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 41 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | CISUB1 | Substring 1 of Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | CISUB2 | Substring 2 of Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | CISUB3 | Substring 3 of Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | CISUB4 | Substring 4 of Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | CISUB5 | Substring 5 of Commitment Item | nvarchar | 10 | 0 | | | | Allow NULL? |
