| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | AFASL | Depreciation key | nvarchar | 4 | 0 | CHAR | (N' ') | No | T090NA | AFASL | Allow NULL? |
| 4 | BGJAHR | Valid to fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BGJAHR | Allow NULL? |
| 5 | PERBZU | Period control: Acquisition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBZU | Allow NULL? |
| 6 | PERBNA | Period control: Acquisition in the following year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBNA | Allow NULL? |
| 7 | PERBAB | Period control: Retirement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBAB | Allow NULL? |
| 8 | PERBUM | Period control : Transfer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T090R | PERBUM | 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? |