SAP table TABW (Asset transaction types)
SAP table TABW (Asset Transaction Types) stores the various transaction types used in Asset Accounting (FI-AA). These transaction types categorize and manage asset movements, such as acquisitions, retirements, transfers, revaluations, and depreciation postings. Each transaction type is assigned specific attributes and rules, which control how the transactions affect the general ledger and asset values. TABW is essential for ensuring accurate and compliant asset tracking and financial reporting in SAP.
The descriptions of Asset Transaction Types can be found in SAP table TABWT (Asset transaction types texts).
SAP table TABW has 2 primary key fields being MANDT,BWASL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BWASL | Asset Transaction Type | CHAR | 3 | 0 | BWASL | ||
| BWAGRP | Transaction Type Group | CHAR | 2 | 0 | TABWG | BWAGRP | |
| XVERGA | Indicator: Original Transaction in Past | CHAR | 1 | 0 | XVERGA | ||
| XAKTIV | Indicator: Capitalize Fixed Asset | CHAR | 1 | 0 | XAKTIV | ||
| XDEAKT | Deactivate Asset Once Acquisition Value Equals Zero | CHAR | 1 | 0 | XDEAKT | ||
| XABGMM | Ind: Post Gain/Loss from Asset Retirement Automatically | CHAR | 1 | 0 | XABGMM | ||
| XERLOS | Specify Revenue with Asset Retirement | CHAR | 1 | 0 | XERLOS | ||
| XAVERB | Asset Transfer Between Affiliated Companies (Gross) | CHAR | 1 | 0 | XAVERB | ||
| XABUCH | Indicator: Transaction Type Cannot Be Used Manually | CHAR | 1 | 0 | XABUCH | ||
| BWAKON | Consolidation Transaction Type | CHAR | 3 | 0 | T856 | AM_RMVCT | |
| XPRJKT | Indicator: Account Assignment to Project Desired | CHAR | 1 | 0 | XPRJKT | ||
| ANSHKZ | Default Posting Indicator | CHAR | 1 | 0 | ANSHKZ | ||
| BWASLG | Trans. Type Offsetting Entry for Transfer | CHAR | 3 | 0 | TABW | BWASLG | |
| BLART | Default Document Type for Transaction Type | CHAR | 2 | 0 | T003 | BLGART | |
| XABINV | Repayment of Invest. Support in Required Period of Retention | CHAR | 1 | 0 | XABINV | ||
| BWASLN | Trans.Type Retirement/Transfer Curr-Yr Acquis. in Same Year | CHAR | 3 | 0 | TABW | BWASLN | |
| GITTGR | Summariz. of Trans. Types for Asset History Sheet | CHAR | 2 | 0 | TABWQ | GITTGR | |
| XABGWG | Indicator Simulation of LVA Ret. in Asset Hist Sheet | CHAR | 1 | 0 | XABGWG | ||
| XABIMM | Ind. Simulate Ret. of Intangible Asset in Asset Hist Sheet | CHAR | 1 | 0 | XABIMM | ||
| XUSBWA | Indicator: Call up a user-exit for this transaction type? | CHAR | 1 | 0 | XUSBWA | ||
| XUMBHI | Adopt Historical Depreciation Start Date for Transfer | CHAR | 1 | 0 | XUMBHI | ||
| XIFREL | Indicator: Post gain/loss to asset | CHAR | 1 | 0 | XIFREL | ||
| XCOOBJ | Budget-Relevant | CHAR | 1 | 0 | FM_XSAUF | ||
| XCOPSP | not used (any longer) | CHAR | 1 | 0 | IM_XSPSP | ||
| XAVERBN | Post with affiliated company indicator (net!) | CHAR | 1 | 0 | XAVERBN | ||
| XZUGBR | Post Acquisition Gross (Including Depreciation) | CHAR | 1 | 0 | XZUGBRUTTO | ||
| XUMJA | Set the changeover year in the asset | CHAR | 1 | 0 | XUMJA | ||
| RSN_CODE | Asset Transaction Category | CHAR | 1 | 0 | CHAR1_REASON_C | ||
| XOBS | Transaction Type is Obsolete | CHAR | 1 | 0 | FAA_TRANSACTION_TYPE_OBSOLETE |
TABW foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TABW | BLART | T003 | Document Types | MANDT |
| 1 TABW | BWAGRP | TABWG | Transaction type groups | MANDT |
| 1 TABW | BWAGRP | TABWG | Transaction type groups | BWAGRP |
| 0 TABW | BWAKON | T856 | Transaction Types | MANDT |
| 0 TABW | BWAKON | T856 | Transaction Types | TRTYP |
| 1 TABW | BWASLG | TABW | Asset transaction types | MANDT |
| 0 TABW | BWASLN | TABW | Asset transaction types | MANDT |
| 1 TABW | GITTGR | TABWQ | Asset hist. sheet group | MANDT |
| 1 TABW | GITTGR | TABWQ | Asset hist. sheet group | GITTGR |