| 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 | ANLKL | Asset Class | nvarchar | 8 | 0 | CHAR | (N' ') | No | ANKA | ANLKL | Allow NULL? |
| 3 | AM_TDNAM01 | Asset Accounting: Template for gen. long text | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM01 | Allow NULL? |
| 4 | AM_TDNAM02 | Asset Accounting: Long text template net worth valuation | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM02 | Allow NULL? |
| 5 | AM_TDNAM03 | Asset Accounting: Long text template technical view | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM03 | Allow NULL? |
| 6 | AM_TDNAM04 | Asset Accounting: Long text template cost-acc. view | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM04 | Allow NULL? |
| 7 | AM_TDNAM05 | Asset Accounting: Long text template for supplier data | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM05 | Allow NULL? |
| 8 | AM_TDNAM06 | Asset Accounting: Long text template for insurance | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM06 | Allow NULL? |
| 9 | AM_TDNAM07 | Asset Accounting: Long text template for leasing | nvarchar | 32 | 0 | CHAR | (N' ') | No | | AM_TDNAM07 | Allow NULL? |
| 10 | ANLN1_ABG | Asset number for gain/loss account assgmt. for retirement | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | ANLN1_ABG | Allow NULL? |
| 11 | ANLN2_ABG | Asset subnumber for gain/loss account assignment retirement | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | ANLN2_ABG | Allow NULL? |
| 12 | EQTYP | Equipment category | char | 1 | 0 | CHAR | (N' ') | Yes | T370T | EQTYP | Allow NULL? |
| 13 | EQART | Type of Technical Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T370K | EQART | Allow NULL? |
| 14 | ACT_CREATE_AA | Create Equipment Record when Creating Asset | char | 1 | 0 | CHAR | (N' ') | No | | AAPM_ACT_CREATE_AA | Allow NULL? |
| 15 | ACT_CHANGE_AA | Change Equipment Master when Changing Asset | char | 1 | 0 | CHAR | (N' ') | No | | AAPM_ACT_CHANGE_AA | Allow NULL? |
| 16 | ACT_CREATE_PM | Create Asset when Creating Equipment | char | 1 | 0 | CHAR | (N' ') | No | | AAPM_ACT_CREATE_PM | Allow NULL? |
| 17 | ACT_CHANGE_PM | Change Asset Master Record from Equipment Master | char | 1 | 0 | CHAR | (N' ') | No | | AAPM_ACT_CHANGE_PM | Allow NULL? |
