SAP table T093C (Company codes in Asset Accounting)

SAP table T093C has 2 primary key fields being MANDT,BUKRS.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
BUKRSN Company Code for Number Assignment CHAR 4 0 T093N BUKRSN
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
MONMIT First Day of the Second Half of the Month NUMC 2 0 MONMIT
XRUMPF Indicator: Shortened Fiscal Year CHAR 1 0 XRUMPF
DATUM Transfer Date for Legacy Assets Transferred DATS 8 0 DATE_T093C
AFAPL Chart of Depreciaton for Asset Valuation CHAR 4 0 T096 AFAPL
VRMAFB Depreciation Area for Net Worth Tax Valuation NUMC 2 0 T093 VRMAFB
BKRAKT Cost Center Check across Company Codes CHAR 1 0 BKRAKT
XREBUW Ind: Enter Net Book Value During Legacy Data Transfer CHAR 1 0 XREBUW
XANUEB Staus of Asset Data Transfer in the Company Code NUMC 1 0 XANUEB
0 Asset data transfer completed
1 Asset data transfer not yet completed
2 Test company code with data transfer always allowed
3 Company code deactivated - subsequent reporting allowed
LGJAHR Last fiscal year opened by the fiscal year change NUMC 4 0 LGJAHR
AFBLRT Document Type for Depreciation Posting CHAR 2 0 T003 AFBLRT
XVRSKU Recalculate cumulative insurance base value CHAR 1 0 XVRSKU
MWSKZVA Input Tax Code - Assets Without Input Tax CHAR 2 0 T007A MWSKZVA
MWSKZAA Output Tax Code - Asset Is Exempt from Tax (Unused) CHAR 2 0 T007A MWSKZAA
KZRBWB Indicator Post Net Book Value for Retirement CHAR 1 0 KZRBWB
APROF Settlement profile for assets under construction CHAR 6 0 TKB1A AM_APROF
TTECH Min. retention period of assets and asset values INT1 3 0 TTECH
TKUND Retention period of asset and asset values (cust. specific) INT1 3 0 TKUND
XANLE Indicator: Original line item for proof of origin CHAR 1 0 IM_XANLE
VARBZD Variant for Determining Asset Value Date CHAR 14 0 TABVA VARBZDAT
J_1AAOFFCL Official document class for Asset Movements CHAR 1 0 J_1AAOFFCL
XZORG Indicator: Time-Independent Management of Organiz. Units CHAR 1 0 XZORG
APERBLRT Obsolete - Document Type for Periodic Posting of APC Values CHAR 2 0 T003 APERBLRT
XNOSKONTO Subsequent Capitalization of Discount Not Allowed CHAR 1 0 XNOSKONTO
XDFYV Allow Different Fiscal Year Variants CHAR 1 0 XDFYV
REVDMETH Method for Revenue Distribution at Asset Retirement CHAR 1 0 REVDMETH
A By APC
N By Net Book Value
LDTBLRT Document Type for Legacy Data Transfer Asset Accounting CHAR 2 0 T003 LDTBLRT
LDT_WO_AFA Legacy Data Transfer: Suppress Automatic Deprec. Calcul. CHAR 1 0 LDT_WO_AFAR
XLOCKED Asset Accounting: Company Code Locked Against Changes CHAR 1 0 FAA_XLOCKED

T093C foreign key relationships

Table Field Check Table Check Field
0 T093C AFAPL T096 Chart of depreciation MANDT
1 T093C AFBLRT T003 Document Types MANDT
0 T093C APERBLRT T003 Document Types MANDT
1 T093C APROF TKB1A Settlement Profile MANDT
1 T093C APROF TKB1A Settlement Profile APROF
0 T093C BUKRS T001 Company Codes BUKRS
1 T093C BUKRSN T093N Number assignment alloc. AA MANDT
0 T093C LDTBLRT T003 Document Types MANDT
1 T093C MANDT T000 Clients MANDT
0 T093C MWSKZAA T007A Tax Keys KALSM
0 T093C MWSKZAA T007A Tax Keys MWSKZ
1 T093C MWSKZVA T007A Tax Keys KALSM
1 T093C MWSKZVA T007A Tax Keys MWSKZ
0 T093C PERIV T009 Fiscal Year Variants MANDT
0 T093C PERIV T009 Fiscal Year Variants PERIV
1 T093C VARBZD TABVA Variants for determining asset value date MANDT
1 T093C VARBZD TABVA Variants for determining asset value date VARIANTE
0 T093C VRMAFB T093 Real and derived depreciation areas MANDT
0 T093C VRMAFB T093 Real and derived depreciation areas AFAPL
0 T093C VRMAFB T093 Real and derived depreciation areas AFABER