| 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 | BWAGRP | Transaction type group | nvarchar | 2 | 0 | CHAR | (N' ') | No | | BWAGRP | Allow NULL? |
| 3 | PERGRP | Period control group | char | 1 | 0 | CHAR | (N' ') | No | | PERGRP_D | Allow NULL? |
| 4 | VZJSAL | +/- Sign for year-to-date balance | char | 1 | 0 | CHAR | (N' ') | No | | VZJSAL | Allow NULL? |
| 5 | AWTFLD | Not used (any more), replaced by BWATYP | nvarchar | 3 | 0 | CHAR | (N' ') | No | | BZWRTF | Allow NULL? |
| 6 | XZUGNE | Indicator: Current-year acquisition transaction | char | 1 | 0 | CHAR | (N' ') | No | | XZUGNE | Allow NULL? |
| 7 | XZUGDA | Indicator: Set date of the first acquistion | char | 1 | 0 | CHAR | (N' ') | No | | XZUGDA | Allow NULL? |
| 8 | XANTEI | Ind: Post proportional values automatically | char | 1 | 0 | NUMC | (N'0') | No | | XANTEI | Allow NULL? |
| 9 | GITCOL | Classification of transaction type group | char | 1 | 0 | CHAR | (N' ') | No | | GITCOL | Allow NULL? |
| 10 | FLDNM | Not used | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CHAR10U | Allow NULL? |
| 11 | XACLAS | Indicator: Check asset classes | char | 1 | 0 | CHAR | (N' ') | No | | XACLAS | Allow NULL? |
| 12 | BWATYP | Transaction type category | char | 1 | 0 | CHAR | (N' ') | No | | BWATYP | Allow NULL? |
| 13 | XBNAFA | Indicator: Plan/write-up ordinary depreciation | char | 1 | 0 | CHAR | (N' ') | No | | XBNAFA | Allow NULL? |
| 14 | XBSAFA | Indicator: Plan/write-up special depreciation | char | 1 | 0 | CHAR | (N' ') | No | | XBSAFA | Allow NULL? |
| 15 | XBAAFA | Indicator: Plan/write-up unplanned depreciation | char | 1 | 0 | CHAR | (N' ') | No | | XBAAFA | Allow NULL? |
| 16 | XBMAFA | Indicator: Plan/write-up reserve transfer | char | 1 | 0 | CHAR | (N' ') | No | | XBMAFA | Allow NULL? |
| 17 | VALID | Validation | nvarchar | 7 | 0 | CHAR | (N' ') | No | GB93 | VALID | Allow NULL? |
| 18 | V_ACTIV | Activation level for validation/substitution callup points | char | 1 | 0 | NUMC | (N'0') | No | | GVSACTIV | Allow NULL? |
| 19 | SUBSTID | Substitution name | nvarchar | 7 | 0 | CHAR | (N' ') | No | GB92 | SUBST_ID | Allow NULL? |
| 20 | S_ACTIV | Activation level for validation/substitution callup points | char | 1 | 0 | NUMC | (N'0') | No | | GVSACTIV | Allow NULL? |
| 21 | JVMAN | Manual use of Transaction Type Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_ABWMAN | Allow NULL? |
