1. Home
  2. Resources
  3. SAP Tables
  4. TCMS_AST_TYP - Asset Type Details

SAP Table TCMS_AST_TYP

Asset Type Details

TCMS_AST_TYP (Asset Type Details) 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 TCMS_AST_TYP to other SAP tables.

TCMS_AST_TYP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AST_TYP Asset Type CMS_DTE_AST_TYP CHAR 6 0
CATEGORYID Asset Category Identification No CMS_DTE_AST_CAT TCMS_AST_CAT CHAR 6 0
OBJSYSTEMID Object System Reference ID CMS_DTE_OBJ_SYSID TCMS_OBJ_SYS CHAR 6 0
CMICODE Central Monetary Institution Code CMS_DTE_CMI_CODE CHAR 2 0
UNIT_VALN_FREQ Indicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNIT CHAR 2 0
01 Day
02 Week
03 Month
04 Year
PERIOD_VALN_FREQ Revaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIOD NUMC 4 0
SFTY_DSCNT Percentage of Safety Discount CMS_DTE_SAFETY_DSCNT DEC 10 6
0 Range can be between 0 and 100
BPF_SET Business Partner Function Set CMS_DTE_BPF_SET TCMS_BPF_SET CHAR 6 0
DOC_SET Document Set CMS_DTE_DOC_SET TCMS_DOC_SET CHAR 6 0
FSTAT_VAR Object Screen (Field Status Variant) CMS_DTE_FSTAT_VAR TCMS_BDT_FSTAT CHAR 10 0
PROC_CKY Process Control Key CMS_DTE_PCN_PROC_CKY TCMS_PCN_CKY CHAR 10 0
CHG_ALLD_ON_SAS Indicates that the charges are only alllowed on Sub-asset CMS_DTE_FLG_CHG_ALLD_ON_SAS CHAR 1 0
NULL No
X Yes
LENDING_RATE1 Lending Rate 1 CMS_DTE_LRTE_PCT1 DEC 10 6
LENDING_RATE2 Lending Rate 2 CMS_DTE_LRTE_PCT2 DEC 10 6
LENDING_RATE3 Lending Rate 3 CMS_DTE_LRTE_PCT3 DEC 10 6
LENDING_RATE4 Lending Rate 4 CMS_DTE_LRTE_PCT4 DEC 10 6
LENDING_RATE5 Lending Rate 5 CMS_DTE_LRTE_PCT5 DEC 10 6
NUM_RANGE_NUMBER Identification of the Number Range Interval CMS_DTE_AST_NR_INT NRIV CHAR 2 0
NUM_ASSIGN_TYP Number Assignment Type for the entity CMS_DTE_NUM_ASSIGNMENT CHAR 2 0
01 Internal
02 External and within a specified range
03 External Free text/number entry

TCMS_AST_TYP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCMS_AST_TYP BPF_SET TCMS_AST_TYP MANDT TCMS_BPF_SET Business Partner Function Sets MANDT
TCMS_AST_TYP BPF_SET TCMS_AST_TYP BPF_SET TCMS_BPF_SET Business Partner Function Sets .INCLUDE
TCMS_AST_TYP CATEGORYID TCMS_AST_TYP CATEGORYID TCMS_AST_CAT Asset Category Details CATEGORYID
TCMS_AST_TYP DOC_SET TCMS_AST_TYP MANDT TCMS_DOC_SET Define Document Sets MANDT
TCMS_AST_TYP DOC_SET TCMS_AST_TYP DOC_SET TCMS_DOC_SET Define Document Sets .INCLUDE
TCMS_AST_TYP FSTAT_VAR TCMS_AST_TYP FSTAT_VAR TCMS_BDT_FSTAT Field Status Variant .INCLUDE
TCMS_AST_TYP FSTAT_VAR TCMS_AST_TYP MANDT TCMS_BDT_FSTAT Field Status Variant MANDT
TCMS_AST_TYP MANDT TCMS_AST_TYP MANDT T000 Clients MANDT
TCMS_AST_TYP NUM_RANGE_NUMBER TCMS_AST_TYP NUM_RANGE_NUMBER NRIV Number Range Intervals NRRANGENR
TCMS_AST_TYP NUM_RANGE_NUMBER '0000' NRIV Number Range Intervals TOYEAR
TCMS_AST_TYP NUM_RANGE_NUMBER TCMS_AST_TYP MANDT NRIV Number Range Intervals CLIENT
TCMS_AST_TYP NUM_RANGE_NUMBER 'CMS_ASSET' NRIV Number Range Intervals OBJECT
TCMS_AST_TYP NUM_RANGE_NUMBER TCMS_AST_TYP AST_TYP NRIV Number Range Intervals SUBOBJECT
TCMS_AST_TYP OBJSYSTEMID TCMS_AST_TYP OBJSYSTEMID TCMS_OBJ_SYS Object System ID - BTE Relationship OBJSYSTEMID
TCMS_AST_TYP OBJSYSTEMID TCMS_AST_TYP MANDT TCMS_OBJ_SYS Object System ID - BTE Relationship MANDT
TCMS_AST_TYP PROC_CKY TCMS_AST_TYP MANDT TCMS_PCN_CKY Process control key MANDT
TCMS_AST_TYP PROC_CKY 'AST' TCMS_PCN_CKY Process control key .INCLUDE
TCMS_AST_TYP PROC_CKY TCMS_AST_TYP PROC_CKY TCMS_PCN_CKY Process control key PROC_OBJ