| 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 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | CHAR | (N' ') | No | T096 | AFAPL | Allow NULL? |
| 3 | INVSL | Investment support key | nvarchar | 2 | 0 | CHAR | (N' ') | No | | INVSL | Allow NULL? |
| 4 | ADATU | Date for beginning of validity | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ADATU | Allow NULL? |
| 5 | BDATU | Date validity ends | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BDATU | Allow NULL? |
| 6 | FRIBEG | Indicator: Period calculation start date | char | 1 | 0 | CHAR | (N' ') | No | | FRIBEG | Allow NULL? |
| 7 | BFRJAR | Retention period in years | nvarchar | 2 | 0 | NUMC | (N'00') | No | | BFRJAR | Allow NULL? |
| 8 | BFRMON | Retention period in months | nvarchar | 2 | 0 | NUMC | (N'00') | No | | BFRMON | Allow NULL? |
| 9 | INVEINZ | Indicator: Line item proof for investment support | char | 1 | 0 | CHAR | (N' ') | No | | INVEINZ | Allow NULL? |
| 10 | MXPROZ | APC investment support: Maximum percentage | decimal | 7 | 4 | DEC | ((0)) | No | | MXPROZ | |
| 11 | MXBTRG | Investment support measure: Maximum amount | decimal | 13 | 2 | CURR | ((0)) | No | | MXBTRG | |
| 12 | IBWASL | Transaction type for posting investment support | nvarchar | 3 | 0 | CHAR | (N' ') | No | TABW | IBWASL | Allow NULL? |
| 13 | IAFABE | Depreciation area for determining investment support amount | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | IAFABE | Allow NULL? |
| 14 | EAFABE | Investment support: Separate area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | EAFABE | Allow NULL? |
| 15 | XPROB | Checking an investment support measure | char | 1 | 0 | CHAR | (N' ') | No | | XPROB | Allow NULL? |
| 16 | XIFBGJ | Not used: Investment support by acquisition years | char | 1 | 0 | CHAR | (N' ') | No | | XIFBGJ | Allow NULL? |
| 17 | XINACH | Indicator: Investment support catch-up | char | 1 | 0 | CHAR | (N' ') | No | | XINACH | Allow NULL? |
| 18 | XMAFA | Indicator: Allowance for transfer of reserves | char | 1 | 0 | CHAR | (N' ') | No | | XINVMAFA | Allow NULL? |
| 19 | RUECKZ | How should investment support be repaid? | char | 1 | 0 | CHAR | (N' ') | No | | RUECKZ | Allow NULL? |
| 20 | IFDART | Which date is used for calculating investment support? | char | 1 | 0 | CHAR | (N' ') | No | | AA_IFDART | Allow NULL? |