| 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 | VARNT | Commitment Item Hierarchy Variant | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SFIPEX | Commitment Item | nvarchar | 24 | 0 | | | | Allow NULL? |
| 6 | SFICTR | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 7 | SFONDS | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | EFICTR | Balance Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | EFIPEX1 | Balance Cmmt Item | nvarchar | 24 | 0 | | | | Allow NULL? |
| 10 | PROZ1 | Balance percentage rate | decimal | 5 | 2 | | | | |
| 11 | EFIPEX2 | Balance commitment item plan year+1 | nvarchar | 24 | 0 | | | | Allow NULL? |
| 12 | PROZ2 | Balance percentage rate plan year+1 | decimal | 5 | 2 | | | | |
| 13 | EFIPEX3 | Balance commitment item plan year+2 | nvarchar | 24 | 0 | | | | Allow NULL? |
| 14 | PROZ3 | Balance percentage rate plan year+2 | decimal | 5 | 2 | | | | |
| 15 | EFIPEX4 | Balance commitment item plan year+3 | nvarchar | 24 | 0 | | | | Allow NULL? |
| 16 | PROZ4 | Balance percentage rate plan year+3 | decimal | 5 | 2 | | | | |
| 17 | EFIPEX5 | Balance commitment item plan year+4 | nvarchar | 24 | 0 | | | | Allow NULL? |
| 18 | PROZ5 | Balance percentage rate plan year+4 | decimal | 5 | 2 | | | | |