SAP table V_TABWT_01 (Generated Table for View)

SAP table V_TABWT_01 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
BLART Default Document Type for Transaction Type CHAR 2 0 T003 BLGART
BWATXT Asset Transaction Type Name CHAR 50 0 BWATXT
BWGTXT Name for the Asset Transaction Type Group CHAR 40 0 BWGTXT
XAKTIV Indicator: Capitalize Fixed Asset CHAR 1 0 XAKTIV
XDEAKT Deactivate Asset Once Acquisition Value Equals Zero CHAR 1 0 XDEAKT
XCOOBJ Budget-Relevant CHAR 1 0 FM_XSAUF
LTEXT Document Type Description CHAR 20 0 LTEXT_003T
XABINV Repayment of Invest. Support in Required Period of Retention CHAR 1 0 XABINV
XUMBHI Adopt Historical Depreciation Start Date for Transfer CHAR 1 0 XUMBHI
BWASLG Trans. Type Offsetting Entry for Transfer CHAR 3 0 TABW BWASLG
BWASLN Trans.Type Retirement/Transfer Curr-Yr Acquis. in Same Year CHAR 3 0 TABW BWASLN
XERLOS Specify Revenue with Asset Retirement CHAR 1 0 XERLOS
XABGMM Ind: Post Gain/Loss from Asset Retirement Automatically CHAR 1 0 XABGMM
XIFREL Indicator: Post gain/loss to asset CHAR 1 0 XIFREL
XVERGA Indicator: Original Transaction in Past CHAR 1 0 XVERGA
XAVERB Asset Transfer Between Affiliated Companies (Gross) CHAR 1 0 XAVERB
XAVERBN Post with affiliated company indicator (net!) CHAR 1 0 XAVERBN
BWAKON Consolidation Transaction Type CHAR 3 0 T856 AM_RMVCT
GITTGR Summariz. of Trans. Types for Asset History Sheet CHAR 2 0 TABWQ GITTGR
XABUCH Indicator: Transaction Type Cannot Be Used Manually CHAR 1 0 XABUCH
XUSBWA Indicator: Call up a user-exit for this transaction type? CHAR 1 0 XUSBWA
XZUGBR Post Acquisition Gross (Including Depreciation) CHAR 1 0 XZUGBRUTTO
ANSHKZ Default Posting Indicator CHAR 1 0 ANSHKZ
GITCOL Classification of Transaction Type Group CHAR 1 0 GITCOL
0 Annual Carryforward
1 Acquisition
2 Retirement
3 Transfer (acquiring)
4 Retiring transfer
5 Post-capitalization
6 Depreciation
7 Transfer transaction
8 Statistical movement
9 Gain/loss
BWATYP Transaction type category CHAR 1 0 BWATYP
0 Posting Generated Automatically
1 Acquisition and production costs
2 Downpayments
3 Investment support measures
4 Manual depreciation
5 Write-up
6 Revaluation
7 Takeover APC
8 Takeover downpayment
9 Takeover investment support
A Retirement costs
B Subsequent revenue
C Transfer Accumulated Values with Mid-Year Transfer
E Transfer Accumulated Values on Last Day of Fiscal Year
SPRAS Language Key LANG 1 0 T002 SPRAS
TXT Transaction type description CHAR 20 0 RMVCT_TXT
GGRTXT Name of Asset Hist. Sheet Group CHAR 50 0 GGRTXT
XZUGNE Indicator: Current-Year Acquisition Transaction CHAR 1 0 XZUGNE
XZUGDA Indicator: Set Date of the First Acquistion CHAR 1 0 XZUGDA
XANTEI Ind: Post Proportional Values Automatically NUMC 1 0 XANTEI
XBMAFA Indicator: Plan/Write-Up Reserve Transfer CHAR 1 0 XBMAFA
XUMJA Set the changeover year in the asset CHAR 1 0 XUMJA
XOBS Transaction Type is Obsolete CHAR 1 0 FAA_TRANSACTION_TYPE_OBSOLETE

V_TABWT_01 foreign key relationships

Table Field Check Table Check Field
0 V_TABWT_01 BLART T003 Document Types MANDT
1 V_TABWT_01 BWAGRP TABWG Transaction type groups MANDT
1 V_TABWT_01 BWAGRP TABWG Transaction type groups BWAGRP
0 V_TABWT_01 BWAKON T856 Transaction Types MANDT
0 V_TABWT_01 BWAKON T856 Transaction Types TRTYP
1 V_TABWT_01 BWASLG TABW Asset transaction types MANDT
0 V_TABWT_01 BWASLN TABW Asset transaction types MANDT
1 V_TABWT_01 GITTGR TABWQ Asset hist. sheet group MANDT
1 V_TABWT_01 GITTGR TABWQ Asset hist. sheet group GITTGR
0 V_TABWT_01 MANDT T000 Clients MANDT
1 V_TABWT_01 SPRAS T002 Language Keys (Component BC-I18) SPRAS