| 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 | METPER | Period Control Method | nvarchar | 3 | 0 | CHAR | (N' ') | No | | METPER | Allow NULL? |
| 4 | PERBZU | Period control: Acquisition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBZU | Allow NULL? |
| 5 | PERBNA | Period control: Acquisition in the following year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBNA | Allow NULL? |
| 6 | PERBAB | Period control: Retirement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBAB | Allow NULL? |
| 7 | PERBUM | Period control : Transfer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBUM | Allow NULL? |
| 8 | XBZDAT | Ind.: Calculate depreciation from the asset value date | char | 1 | 0 | CHAR | (N' ') | Yes | | XBZDAT | Allow NULL? |
| 9 | PERBAW | Period Control for Revaluation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBAW | Allow NULL? |
| 10 | PERBIF | Period Control for Investment Support | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBIF | Allow NULL? |
| 11 | PERBAA | Period Control for Unplanned Depreciation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBAA | Allow NULL? |
| 12 | PERBZR | Period Control for Write-Ups to Reserves | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBZR | Allow NULL? |
| 13 | PERBD1 | Period Control (Dummy Field for Enhancement) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERB_DUMMY | Allow NULL? |
| 14 | PERBD2 | Period Control (Dummy Field for Enhancement) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERB_DUMMY | Allow NULL? |