| 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 | * | MANDT | Allow NULL? |
| 2 | FINSRC | Financing Source | nvarchar | 31 | 0 | CHAR | (N' ') | No | | FMEUF_FNS | Allow NULL? |
| 3 | FINTYP | Financing Source Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FMEUFTYP | FMEUF_TYP | Allow NULL? |
| 4 | FUND_CAT | Funding Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FMEUFFCAT | FMEUF_FUNDCAT | Allow NULL? |
| 5 | INTERV | Intervention | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | FMEUFINT | FMEUF_INT | Allow NULL? |
| 6 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FMEUF_LEV1 | Allow NULL? |
| 7 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FMEUF_LEV2 | Allow NULL? |
| 8 | LEVEL3 | Level 3 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FMEUF_LEV3 | Allow NULL? |
| 9 | LEVEL4 | Level 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FMEUF_LEV4 | Allow NULL? |
| 10 | UTILZ | Usage of the Financing Source in Respect of Others | char | 1 | 0 | CHAR | (N' ') | Yes | | FMEUF_UTILZ | Allow NULL? |
| 11 | OVCRTRATE | Overexpenditure Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | FMEUF_OVCRTRATE | |
| 12 | CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 13 | DSTRDT | Validity Start Date (Document Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_DSTRDT | Allow NULL? |
| 14 | DENDDT | Validity End Date (Document Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_DENDDT | Allow NULL? |
| 15 | PSTRDT | Validity Start Date (Posting Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_PSTRDT | Allow NULL? |
| 16 | PENDDT | Validity End Date (Posting Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_PENDDT | Allow NULL? |
| 17 | PAYSTRDT | Validity Start Date (Payment Date ) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_PAYSTRDT | Allow NULL? |
| 18 | PAYENDDT | Validity End Date (Payment Date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FMEUF_PAYENDDT | Allow NULL? |
| 19 | FIKRS_R | Financial Management Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FM01 | FIKRS | Allow NULL? |
| 20 | FONDS_R | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FMFINCODE | FM_FUND | Allow NULL? |
| 21 | FICTR_R | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | FMFCTR | FM_FICTR | Allow NULL? |
| 22 | MEASUR_R | Funded Program | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | FMMEASURE | FM_MEASURE | Allow NULL? |
| 23 | FAREA_R | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TFKB | FM_FAREA | Allow NULL? |
| 24 | FIPEX_R | Commitment Item | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | FMCI | FM_FIPEX | Allow NULL? |
| 25 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | GMGR | GM_GRANT_NBR | Allow NULL? |
| 26 | EXT_REF | External Reference | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FMEUF_EXTREF | Allow NULL? |
| 27 | RESP_AUTH | Responsible Person | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FMEUF_RESP | Allow NULL? |
| 28 | COMPL | Completion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FMEUF_FS_COMPL | Allow NULL? |
| 29 | COMPL_NO_RESET | Completion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FMEUF_FS_COMPL | Allow NULL? |
| 30 | CRUSER | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | KBLERF | Allow NULL? |
| 31 | CRDATA | Entry date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KBLERDAT | Allow NULL? |
| 32 | CHUSER | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | KBLAEN | Allow NULL? |
| 33 | CHDATA | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KBLAEDAT | Allow NULL? |
| 34 | CHTIME | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 35 | DELFLAG | Logical Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FMEUF_DEL | Allow NULL? |
