SAP table TCMS_AST_TYP (Asset Type Details)

SAP table TCMS_AST_TYP has 2 primary key fields being MANDT,AST_TYP.

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
AST_TYP Asset Type CHAR 6 0 CMS_DTE_AST_TYP
CATEGORYID Asset Category Identification No CHAR 6 0 TCMS_AST_CAT CMS_DTE_AST_CAT
OBJSYSTEMID Object System Reference ID CHAR 6 0 TCMS_OBJ_SYS CMS_DTE_OBJ_SYSID
CMICODE Central Monetary Institution Code CHAR 2 0 CMS_DTE_CMI_CODE
UNIT_VALN_FREQ Indicator: Units of time for revaluation of an asset CHAR 2 0 CMS_DTE_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQ Revaluation Period for an Asset NUMC 4 0 CMS_DTE_AST_VALN_FREQ_PERIOD
SFTY_DSCNT Percentage of Safety Discount DEC 10 6 CMS_DTE_SAFETY_DSCNT
BPF_SET Business Partner Function Set CHAR 6 0 TCMS_BPF_SET CMS_DTE_BPF_SET
DOC_SET Document Set CHAR 6 0 TCMS_DOC_SET CMS_DTE_DOC_SET
FSTAT_VAR Object Screen (Field Status Variant) CHAR 10 0 TCMS_BDT_FSTAT CMS_DTE_FSTAT_VAR
PROC_CKY Process Control Key CHAR 10 0 TCMS_PCN_CKY CMS_DTE_PCN_PROC_CKY
CHG_ALLD_ON_SAS Indicates that the charges are only alllowed on Sub-asset CHAR 1 0 CMS_DTE_FLG_CHG_ALLD_ON_SAS
LENDING_RATE1 Lending Rate 1 DEC 10 6 CMS_DTE_LRTE_PCT1
LENDING_RATE2 Lending Rate 2 DEC 10 6 CMS_DTE_LRTE_PCT2
LENDING_RATE3 Lending Rate 3 DEC 10 6 CMS_DTE_LRTE_PCT3
LENDING_RATE4 Lending Rate 4 DEC 10 6 CMS_DTE_LRTE_PCT4
LENDING_RATE5 Lending Rate 5 DEC 10 6 CMS_DTE_LRTE_PCT5
NUM_RANGE_NUMBER Identification of the Number Range Interval CHAR 2 0 NRIV CMS_DTE_AST_NR_INT
NUM_ASSIGN_TYP Number Assignment Type for the entity CHAR 2 0 CMS_DTE_NUM_ASSIGNMENT

TCMS_AST_TYP foreign key relationships

Table Field Check Table Check Field
0 TCMS_AST_TYP BPF_SET TCMS_BPF_SET Business Partner Function Sets MANDT
0 TCMS_AST_TYP BPF_SET TCMS_BPF_SET Business Partner Function Sets .INCLUDE
1 TCMS_AST_TYP CATEGORYID TCMS_AST_CAT Asset Category Details CATEGORYID
0 TCMS_AST_TYP DOC_SET TCMS_DOC_SET Define Document Sets MANDT
0 TCMS_AST_TYP DOC_SET TCMS_DOC_SET Define Document Sets .INCLUDE
1 TCMS_AST_TYP FSTAT_VAR TCMS_BDT_FSTAT Field Status Variant MANDT
1 TCMS_AST_TYP FSTAT_VAR TCMS_BDT_FSTAT Field Status Variant .INCLUDE
0 TCMS_AST_TYP NUM_RANGE_NUMBER NRIV Number Range Intervals CLIENT
0 TCMS_AST_TYP NUM_RANGE_NUMBER NRIV Number Range Intervals SUBOBJECT
0 TCMS_AST_TYP NUM_RANGE_NUMBER NRIV Number Range Intervals NRRANGENR
0 TCMS_AST_TYP NUM_RANGE_NUMBER NRIV Number Range Intervals TOYEAR
1 TCMS_AST_TYP OBJSYSTEMID TCMS_OBJ_SYS Object System ID - BTE Relationship MANDT
1 TCMS_AST_TYP OBJSYSTEMID TCMS_OBJ_SYS Object System ID - BTE Relationship OBJSYSTEMID
0 TCMS_AST_TYP PROC_CKY TCMS_PCN_CKY Process control key MANDT
0 TCMS_AST_TYP PROC_CKY TCMS_PCN_CKY Process control key .INCLUDE
0 TCMS_AST_TYP PROC_CKY TCMS_PCN_CKY Process control key PROC_OBJ