SAP ABAP Table CMS_STR_MOV_AST_DATA_MAP_GET (MAPI : GET : Asset details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-MOV (Application Component) Movables
     ⤷ CMS_OMS_MOV (Package) Object Systems for Collateral Management: Movables

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_MOV_AST_DATA_MAP_GET	Table Relationship Diagram
Short Description	MAPI : GET : Asset details

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CATEGORY	☐	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category	*
2	CATEGORY_NAME	☐	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
3	TYPE	☐	CMS_DTE_MOV_TYP	CMS_MOV_TYP	CHAR	6	0	Movable types	*
4	TYPE_NAME	☐	CMS_DTE_MOV_TYP_NAME	CMS_MOV_NAME	CHAR	40	0	Name in a specified language
5	IDENTIFICATION	☐	CMS_DTE_MOV_ID	CMS_MOV_ID	CHAR	40	0	Identification Number
6	MOV_DESCRIPTION	☐	CMS_DTE_MOV_DESC	CMS_MOV_DESC	CHAR	30	0	Description of the object
7	.INCLUDE	☐				0	0	Structure with Asset Details for Table CMS_AST
8	.INCLUDE	☐				0	0	Basic Asset data
9	DESCRIPTION	☐	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
10	OBJECT_REF_ID	☐	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
11	OBJECT_TYP	☐	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
12	COUNTRY_KEY	☐	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country	*
13	RISK_CODE	☐	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
14	SFTY_IND	☐	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
15	SFTY_DSCNT	☐	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
16	SFTY_AMOUNT	☐	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
17	SFTY_AMT_CURR	☐	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount	TCURC
18	OBJSYSID	☐	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
19	.INCLUDE	☐				0	0	Valuation data
20	VALUATION_TYP	☐	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
21	UNIT_VALN_FREQ	☐	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
22	PERIOD_VALN_FREQ	☐	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
23	PAST_VALUED_DATE	☐	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
24	START_DATE	☐	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
25	END_DATE	☐	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
26	.INCLUDE	☐				0	0	Lending rate data
27	LENDING_RATE_IND	☐	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
28	.INCLUDE	☐				0	0	Lending rates structure
29	LENDING_RATE1	☐	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
30	LENDING_RATE2	☐	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
31	LENDING_RATE3	☐	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
32	LENDING_RATE4	☐	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
33	LENDING_RATE5	☐	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
34	.INCLUDE	☐				0	0	Liquidation rights data
35	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
36	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
37	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
38	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
39	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value	TCURC
40	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
41	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed	TCURC
42	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
43	.INCLUDE	☐				0	0	Account for liquidation proceeds
44	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
45	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
46	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
47	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
48	.INCLUDE	☐				0	0	Verfication Data
49	UNIT_VERF_FREQ	☐	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
50	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
51	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
52	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
53	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
54	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
55	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
56	.INCLUDE	☐				0	0	Structure for Asset values
57	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
58	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value	TCURC
59	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
60	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value	TCURC
61	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
62	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
63	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
64	.INCLUDE	☐				0	0	Purchase price data
65	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
66	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price	TCURC
67	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
68	.INCLUDE	☐				0	0	Administrative organization unit
69	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
70	.INCLUDE	☐				0	0	Bank area
71	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
72	.INCLUDE	☐				0	0	Organization unit structure
73	ORG_UNIT1	☐	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1	*
74	ORG_UNIT2	☐	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2	*
75	ORG_UNIT3	☐	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3	*
76	ORG_UNIT4	☐	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4	*
77	ORG_UNIT5	☐	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5	*
78	.INCLUDE	☐				0	0	Inventory Specific details
79	IDEN_ACC	☐	CMS_DTE_INV_IDEN_ACC	CMS_SEC_FLG	CHAR	1	0	Identification land accessories
80	BILL_NO	☐	CMS_DTE_INV_BILL_NO	CMS_INV_BILL_NO	CHAR	20	0	Bill number of the inventory
81	UNIT_PRICE	☐	CMS_DTE_INV_UNIT_PRICE	CMS_AMOUNT	CURR	17	2	Unit Price
82	UNIT_PRICE_CURR	☐	CMS_DTE_INV_UNIT_CURR	WAERS	CUKY	5	0	Currency for unit price	TCURC
83	TYPE_STK_EXCH	☐	CMS_DTE_INV_TYPE_STK_EXCH	CMS_ATT_ID_TYP	CHAR	6	0	Type of stock exchange	TCMS_ATT_ID_TY
84	STK_EXCH_ID	☐	CMS_DTE_INV_STK_EXCH_ID	CMS_ATT_ID_TYP	CHAR	6	0	Place of stock exchange	TCMS_ATT_ID_TY
85	RATE_FIX_DAT	☐	CMS_DTE_INV_RATE_FIX_DAT	DATUM	DATS	8	0	Date of previous quotation
86	DET_PRICE	☐	CMS_DTE_INV_DET_PRICE	CMS_AMOUNT	CURR	17	2	Determined price
87	DET_CURR	☐	CMS_DTE_INV_DET_CURR	WAERS	CUKY	5	0	Currency for determined price	TCURC
88	STOCK_QUANTITY	☐	CMS_DTE_INV_QTY	CMS_QTY	QUAN	13	3	Quantity of inventory
89	STOCK_UOM	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_MOV_AST_DATA_MAP_GET	AST_VALUE_CURR	TCURC	WAERS
2	CMS_STR_MOV_AST_DATA_MAP_GET	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
3	CMS_STR_MOV_AST_DATA_MAP_GET	DET_CURR	TCURC	WAERS
4	CMS_STR_MOV_AST_DATA_MAP_GET	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
5	CMS_STR_MOV_AST_DATA_MAP_GET	LIQD_CURR	TCURC	WAERS
6	CMS_STR_MOV_AST_DATA_MAP_GET	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
7	CMS_STR_MOV_AST_DATA_MAP_GET	NOM_VALUE_CURR	TCURC	WAERS
8	CMS_STR_MOV_AST_DATA_MAP_GET	PUR_PRICE_CURR	TCURC	WAERS
9	CMS_STR_MOV_AST_DATA_MAP_GET	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN
10	CMS_STR_MOV_AST_DATA_MAP_GET	STK_EXCH_ID	TCMS_ATT_ID_TY	INDICATOR_TYPE
11	CMS_STR_MOV_AST_DATA_MAP_GET	STOCK_UOM	T006	MSEHI
12	CMS_STR_MOV_AST_DATA_MAP_GET	TYPE_STK_EXCH	TCMS_ATT_ID_TY	INDICATOR_TYPE
13	CMS_STR_MOV_AST_DATA_MAP_GET	UNIT_OF_MEASURE	T006	MSEHI	REF	1	CN
14	CMS_STR_MOV_AST_DATA_MAP_GET	UNIT_PRICE_CURR	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in	500