SAP table TCMS_MOV_TYP (Customizing table for Movable Type)

SAP table TCMS_MOV_TYP has 3 primary key fields being MANDT,MOV_CATEGORY,MOV_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
MOV_CATEGORY Object Category CHAR 6 0 TCMS_OMS_CAT CMS_DTE_OMS_OBJ_CAT
MOV_TYP Movable types CHAR 6 0 CMS_DTE_MOV_TYP
IS_TEMPLATE Type to be used as template CHAR 1 0 CMS_DTE_MOV_FLG_TEMPLATE
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
UNIT_VALN_FREQ Indicator for frequency of Valuation CHAR 2 0 CMS_DTE_MOV_IND_FREQUENCY
PERIOD_VALN_FREQ Period of revaluation for a movable NUMC 4 0 CMS_DTE_MOV_VALN_FREQ_PERIOD
SFTY_DSCNT Safety discount DEC 10 6 CMS_DTE_MOV_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
VAL_SET Value Set CHAR 6 0 TCMS_OMS_VALST CMS_DTE_VALUE_SET
INS_SET Insurance Set CHAR 6 0 TCMS_INS_SET CMS_DTE_INS_SET
AST_TYP Asset Type CHAR 6 0 TCMS_AST_TYP CMS_DTE_AST_TYP
LENDING_RATE1 Lending rate 1 DEC 10 6 CMS_DTE_MOV_LRTE_PCT1
LENDING_RATE2 Lending rate 2 DEC 10 6 CMS_DTE_MOV_LRTE_PCT2
LENDING_RATE3 Lending rate 3 DEC 10 6 CMS_DTE_MOV_LRTE_PCT3
LENDING_RATE4 Lending rate 4 DEC 10 6 CMS_DTE_MOV_LRTE_PCT4
LENDING_RATE5 Lending rate 5 DEC 10 6 CMS_DTE_MOV_LRTE_PCT5
NUM_RANGE_NUMBER Identification of the Number Range Interval CHAR 2 0 CMS_DTE_MOV_NR_INT
NUM_ASSIGN_TYP Type of Number assignment for the entity CHAR 2 0 CMS_DTE_MOV_NUM_ASSIGNMENT
COR_GRP Correspondence group CHAR 6 0 TCMS_COR_GRP CMS_DTE_COR_GRP
COR_ROLE Correspondence role CHAR 4 0 TFK070M CMS_DTE_COR_ROLE

TCMS_MOV_TYP foreign key relationships

Table Field Check Table Check Field
0 TCMS_MOV_TYP AST_TYP TCMS_AST_TYP Asset Type Details MANDT
0 TCMS_MOV_TYP AST_TYP TCMS_AST_TYP Asset Type Details AST_TYP
1 TCMS_MOV_TYP BPF_SET TCMS_BPF_SET Business Partner Function Sets MANDT
1 TCMS_MOV_TYP BPF_SET TCMS_BPF_SET Business Partner Function Sets .INCLUDE
0 TCMS_MOV_TYP COR_GRP TCMS_COR_GRP Correspondence group definition(customizing) MANDT
0 TCMS_MOV_TYP COR_GRP TCMS_COR_GRP Correspondence group definition(customizing) .INCLUDE
1 TCMS_MOV_TYP COR_ROLE TFK070M Correspondence Roles MANDT
1 TCMS_MOV_TYP COR_ROLE TFK070M Correspondence Roles CORR_ROLE
0 TCMS_MOV_TYP DOC_SET TCMS_DOC_SET Define Document Sets MANDT
0 TCMS_MOV_TYP DOC_SET TCMS_DOC_SET Define Document Sets .INCLUDE
1 TCMS_MOV_TYP FSTAT_VAR TCMS_BDT_FSTAT Field Status Variant MANDT
1 TCMS_MOV_TYP FSTAT_VAR TCMS_BDT_FSTAT Field Status Variant .INCLUDE
0 TCMS_MOV_TYP INS_SET TCMS_INS_SET Insurance Set MANDT
0 TCMS_MOV_TYP INS_SET TCMS_INS_SET Insurance Set .INCLUDE
1 TCMS_MOV_TYP MOV_CATEGORY TCMS_OMS_CAT Object Categories CATEGORYID
0 TCMS_MOV_TYP PROC_CKY TCMS_PCN_CKY Process control key MANDT
0 TCMS_MOV_TYP PROC_CKY TCMS_PCN_CKY Process control key .INCLUDE
0 TCMS_MOV_TYP PROC_CKY TCMS_PCN_CKY Process control key PROC_OBJ
1 TCMS_MOV_TYP VAL_SET TCMS_OMS_VALST Value set MANDT
1 TCMS_MOV_TYP VAL_SET TCMS_OMS_VALST Value set .INCLUDE