SAP table GLOFAAASSETDATA (Country-Specific Asset Master Records)

SAP table GLOFAAASSETDATA has 4 primary key fields being MANDT,BUKRS,ANLN1,ANLN2.

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 * MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 * ANLN2
GLO_RUS_DEPGR Depreciation Group CHAR 4 0 J_3RFDEPRGROUP J_3RFAMORTGR
GLO_RUS_OKOF OKOF Code CHAR 9 0 J_3RFTOKOF J_3RFOKOF
GLO_RUS_SERNR Russia: Serial Number CHAR 32 0 J_3RFSERNR
GLO_RUS_PRECCT Precious materials codes CHAR 30 0 J_3RPRECC
GLO_RUS_PRECQ Quantities list of countable precious materials CHAR 40 0 J_3RPRECQ
GLO_RUS_PRECW Weights list of precious materials CHAR 50 0 J_3RPRECW
GLO_RUS_MATNR Material Number CHAR 40 0 MATNR
GLO_RUS_TRC_BEGD Start date of traceability DATS 8 0 J_3RTRACESTART
GLO_RUS_TRC_ENDD End date of traceability DATS 8 0 J_3RTRACEEND
GLO_RUS_TRC_TNVED Foreign Trade Goods Classification Code of the Customs Union CHAR 17 0 J_3RM_TNVED
GLO_RUS_TTX_TYPE Transport Type CHAR 5 0 J_3RTTYPVEHN J_3RTYPV
GLO_RUS_TTX_VIN Manufacturer Vehicle Identification Number for Fleet Object CHAR 30 0 FLEET_VIN
GLO_RUS_TTX_MNFD Manufacturing Date DATS 8 0 J_3RTBAUJJ
GLO_RUS_TTX_ECOCLASS Ecological Class NUMC 1 0 J_3R_ECOCLASS
GLO_RUS_ECOCLASS Ecological Class NUMC 1 0 J_3R_ECOCLASS
GLO_RUS_ECO_CLS Ecological Class CHAR 1 0 J_3R_ECO_CLS
Initial
0
1
2
3
4
5
6
7
8
9
GLO_RUS_PRT_TYPE Property Type CHAR 1 0 J_3RFPROPTYPES J_3RFPROPTYPE
GLO_RUS_PRT_ADDR Russia: Property Address CHAR 10 0 * J_3RF_PRT_ADDRESS
GLO_RUS_LTX_OWRD Registration Date of Real Estate Ownership Rights DATS 8 0 FIRU_REAL_ESTATE_OWN_REGN_DATE
GLO_RUS_LTX_OWTD Termination Date of Real Estate Ownership Rights DATS 8 0 FIRU_REAL_ESTATE_OWN_TERM_DATE
GLO_RUS_LTX_HSCN Land Plot for Housing Construction CHAR 1 0 FIRU_LAND_PLOT_FOR_HOUSING
GLO_RUS_LTX_HSRD Housing Registration Date DATS 8 0 FIRU_HOUSING_REGISTRATION_DATE
GLO_JP_AX16_STRC Japan: Asset Structure of Annex16 CHAR 5 0 GLOFAAJPSTRC GLO_ANX16_STRC
GLO_JP_AX16_ITEM Japan: Asset Item of Annex16 CHAR 5 0 GLOFAAJPITEM GLO_ANX16_ITEM
GLO_JP_PTX_PRDCD Additional Depreciation Code CHAR 8 0 GLO_JP_PROPT_PRDCD
GLO_IN_BLKKEY Block Key NUMC 5 0 GLO_IN_BLKKEY
GLO_IN_SUB_BLKEY Sub Block key NUMC 5 0 GLO_IN_SUB_BLKKEY
GLO_IN_ADDNL_DEP Additional Depreciation CHAR 1 0 GLO_IN_ADDNL_DEP
1 No Additional Depreciation
2 Activate Additional Depreciation
GLO_IN_ADDNL_BLK Block Key for Additional Depreciation NUMC 5 0 GLO_IN_ADDNL_BLK
GLO_IN_R_D_ASSET India: R & D Asset CHAR 1 0 GLO_IN_R_AND_D_ASSET
Normal asset
X R & D asset
GLO_IN_BLK_KEY India: Block Key CHAR 5 0 GLO_IN_BLK_KEY
GLO_IN_ADNLBLK India: Additional Depreciation Block Key CHAR 5 0 GLO_IN_ADNL_BLK_KEY
GLO_IN_AST_USE India: Put to use date DATS 8 0 GLO_IN_AST_PUT_USE
GLO_IN_PRIOR_YR India: Prior Year Transaction CHAR 1 0 GLO_IN_PRIOR_YR
GLO_NATL_CLFN_CODE National Classification Code CHAR 12 0 * GLO_NATL_CLFN_CODE
GLO_TAX_DEPR_GRP Tax Depreciation Group CHAR 4 0 * GLO_TAX_DEPR_GRP
GLO_KR_BUS_PLACE Business Place CHAR 4 0 J_1BBRANCH BUPLA
GLO_PT_VEHICLETYPE Portugal: Vehicle Type CHAR 2 0 GLO_PT_VEHICLETYPE
10 Vehicle which is not elec, GPL & GNV, Hibrid
20 Vehicle which use electric energy
30 GPL & GNV Vehicle
40 Vehicle which use Hybrid plugs
GLO_PT_ISVEHICLEWOLIMIT Portugal: Is Vehicle Without Limit CHAR 1 0 GLO_PT_ISVEHICLEWOLIMIT
GLO_PT_REPAIRASSETLINK Portugal: Repair Asset Link CHAR 8 0 GLO_PT_REPAIRASSETLINK
GLO_PT_LANDASSETLINK Portugal: Land Asset Link CHAR 8 0 GLO_PT_LANDASSETLINK
GLO_PT_ASSETREPFORMCAT Portugal: Asset Report Form Category CHAR 1 0 GLO_PT_ASSETREPFORMCAT
B Biological
P Investment
GLO_PT_ISAMASSETREVAL Portugal: Is Amortized Asset Revaluated CHAR 1 0 GLO_PT_ISAMASSETREVAL

GLOFAAASSETDATA foreign key relationships

Table Field Check Table Check Field
0 GLOFAAASSETDATA ANLN1 ANLH Main asset number BUKRS
0 GLOFAAASSETDATA ANLN1 ANLH Main asset number ANLN1
1 GLOFAAASSETDATA BUKRS T001 Company Codes BUKRS
0 GLOFAAASSETDATA GLO_JP_AX16_ITEM GLOFAAJPITEM FI-AA: Japan / Asset item (Annex16) MANDT
1 GLOFAAASSETDATA GLO_JP_AX16_STRC GLOFAAJPSTRC FI-AA: Japan / Asset structure (Annex16) MANDT
1 GLOFAAASSETDATA GLO_JP_AX16_STRC GLOFAAJPSTRC FI-AA: Japan / Asset structure (Annex16) STRUCTURE
0 GLOFAAASSETDATA GLO_KR_BUS_PLACE J_1BBRANCH Business Place BUKRS
0 GLOFAAASSETDATA GLO_KR_BUS_PLACE J_1BBRANCH Business Place BRANCH
0 GLOFAAASSETDATA GLO_KR_BUS_PLACE J_1BBRANCH Business Place BUPLA_TYPE
1 GLOFAAASSETDATA GLO_RUS_DEPGR J_3RFDEPRGROUP Depreciation group of fixed asset Russia MANDT
0 GLOFAAASSETDATA GLO_RUS_OKOF J_3RFTOKOF Deprecation Groups for OKOF Codes MANDT
0 GLOFAAASSETDATA GLO_RUS_OKOF J_3RFTOKOF Deprecation Groups for OKOF Codes OKOF
0 GLOFAAASSETDATA GLO_RUS_OKOF J_3RFTOKOF Deprecation Groups for OKOF Codes OKOF_DOP
1 GLOFAAASSETDATA GLO_RUS_PRT_TYPE J_3RFPROPTYPES Property types MANDT
1 GLOFAAASSETDATA GLO_RUS_PRT_TYPE J_3RFPROPTYPES Property types PROPTYPE
0 GLOFAAASSETDATA GLO_RUS_TTX_TYPE J_3RTTYPVEHN Vehicle tax type CTYPV