SAP Table GLO_S_DB_ASSET_DATA

Time-Independent Country-Specific Asset Master Data

GLO_S_DB_ASSET_DATA (Time-Independent Country-Specific Asset Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link GLO_S_DB_ASSET_DATA to other SAP tables.

GLO_S_DB_ASSET_DATA table fields

Field Data element Checktable Datatype Length Decimals
ASSET_ID GUID That Uniquely Identifies an Asset FAA_ASSET_ID CHAR 32 0
ORGUNIT Leading Organizational Unit for Asset Accounting FAA_ORG_CA CHAR 4 0
ASSET Main Asset Number ANLN1 CHAR 12 0
SUBNUMBER Asset Subnumber ANLN2 CHAR 4 0
GLO_RUS_DEPGR Depreciation Group J_3RFAMORTGR J_3RFDEPRGROUP CHAR 4 0
GLO_RUS_OKOF OKOF Code J_3RFOKOF J_3RFTOKOF CHAR 9 0
GLO_RUS_SERNR Serial Number J_3RFSERNR CHAR 32 0
GLO_RUS_PRECCT Precious materials codes J_3RPRECC CHAR 30 0
GLO_RUS_PRECQ Quantities list of countable precious materials J_3RPRECQ CHAR 40 0
GLO_RUS_PRECW Weights list of precious materials J_3RPRECW CHAR 50 0
GLO_RUS_PRT_TYPE Property Type J_3RFPROPTYPE J_3RFPROPTYPES CHAR 1 0
GLO_RUS_TTX_TYPE Transport Type J_3RTYPV J_3RTTYPVEH CHAR 5 0
GLO_RUS_TTX_VIN Manufacturer Vehicle Identification Number for Fleet Object FLEET_VIN CHAR 30 0
GLO_RUS_TTX_MNFD Manufacturing Date J_3RTBAUJJ DATS 8 0
GLO_RUS_TTX_ECOCLASS Ecological Class J_3R_ECOCLASS NUMC 1 0
1
GLO_RUS_ECOCLASS Ecological Class J_3R_ECOCLASS NUMC 1 0
1
GLO_RUS_ECO_CLS Ecological Class J_3R_ECO_CLS CHAR 1 0
0
1
2
3
4
5
6
7
8
9
NULL Initial
GLO_JP_AX16_STRC Asset Structure GLO_ANX16_STRC GLOFAAJPSTRC CHAR 5 0
GLO_JP_AX16_ITEM Asset Item GLO_ANX16_ITEM GLOFAAJPITEM CHAR 5 0
GLO_JP_PTX_PRDCD Additional Depreciation Code GLO_JP_PROPT_PRDCD CHAR 8 0
GLO_IN_BLKKEY Block Key GLO_IN_BLKKEY NUMC 5 0
GLO_IN_SUB_BLKEY Sub Block key GLO_IN_SUB_BLKKEY NUMC 5 0
GLO_IN_ADDNL_DEP Additional Depreciation GLO_IN_ADDNL_DEP CHAR 1 0
1 No Additional Depreciation
2 Activate Additional Depreciation
GLO_IN_ADDNL_BLK Block Key for Additional Depreciation GLO_IN_ADDNL_BLK NUMC 5 0
GLO_IN_R_D_ASSET R & D Asset GLO_IN_R_AND_D_ASSET CHAR 1 0
NULL Normal asset
X R & D asset
GLO_IN_BLK_KEY Block Key GLO_IN_BLK_KEY CHAR 5 0
GLO_IN_ADNLBLK Additional Depreciation Block Key GLO_IN_ADNL_BLK_KEY CHAR 5 0
GLO_IN_AST_USE Put to use date GLO_IN_AST_PUT_USE DATS 8 0
GLO_IN_PRIOR_YR Prior Year Transaction GLO_IN_PRIOR_YR CHAR 1 0

GLO_S_DB_ASSET_DATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
GLO_S_DB_ASSET_DATA GLO_JP_AX16_ITEM SYST MANDT GLOFAAJPITEM FI-AA: Japan / Asset item (Annex16) MANDT
GLO_S_DB_ASSET_DATA GLO_JP_AX16_ITEM GLO_S_DB_ASSET_DATA GLO_JP_AX16_ITEM GLOFAAJPITEM FI-AA: Japan / Asset item (Annex16) ITEM
GLO_S_DB_ASSET_DATA GLO_JP_AX16_STRC GLO_S_DB_ASSET_DATA GLO_JP_AX16_STRC GLOFAAJPSTRC FI-AA: Japan / Asset structure (Annex16) STRUCTURE
GLO_S_DB_ASSET_DATA GLO_JP_AX16_STRC SYST MANDT GLOFAAJPSTRC FI-AA: Japan / Asset structure (Annex16) MANDT
GLO_S_DB_ASSET_DATA GLO_RUS_DEPGR SYST MANDT J_3RFDEPRGROUP Depreciation group of fixed asset Russia MANDT
GLO_S_DB_ASSET_DATA GLO_RUS_DEPGR GLO_S_DB_ASSET_DATA GLO_RUS_DEPGR J_3RFDEPRGROUP Depreciation group of fixed asset Russia AMORTGR
GLO_S_DB_ASSET_DATA GLO_RUS_OKOF SYST MANDT J_3RFTOKOF Deprecation Groups for OKOF Codes MANDT
GLO_S_DB_ASSET_DATA GLO_RUS_OKOF GLO_S_DB_ASSET_DATA GLO_RUS_OKOF J_3RFTOKOF Deprecation Groups for OKOF Codes OKOF
GLO_S_DB_ASSET_DATA GLO_RUS_OKOF * J_3RFTOKOF Deprecation Groups for OKOF Codes OKOF_DOP
GLO_S_DB_ASSET_DATA GLO_RUS_PRT_TYPE SYST MANDT J_3RFPROPTYPES Property types MANDT
GLO_S_DB_ASSET_DATA GLO_RUS_PRT_TYPE GLO_S_DB_ASSET_DATA GLO_RUS_PRT_TYPE J_3RFPROPTYPES Property types PROPTYPE
GLO_S_DB_ASSET_DATA GLO_RUS_TTX_TYPE SYST MANDT J_3RTTYPVEH Vehicle tax type MANDT
GLO_S_DB_ASSET_DATA GLO_RUS_TTX_TYPE GLO_S_DB_ASSET_DATA GLO_RUS_TTX_TYPE J_3RTTYPVEH Vehicle tax type CTYPV
GLO_S_DB_ASSET_DATA GLO_RUS_TTX_TYPE * J_3RTTYPVEH Vehicle tax type OKOF