SAP ABAP Table CMS_AST_HIST (Asset Value History)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD (Application Component) Master Data
     ⤷ CMS_CORE (Package) Collateral Management System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_AST_HIST	Table Relationship Diagram
Short Description	Asset Value History

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Primary Key for CMS_AST_HIST
3	AST_HIST_GUID	☑	CMS_DTE_AST_HIST_GUID	SYSUUID	RAW	16	0	Asset history Guid
4	.INCLUDE	☐				0	0	Link to CMS_AST Table
5	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
6	.INCLUDE	☐				0	0	Asset Guid as a parent GUID for a sub-asset
7	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
8	.INCLUDE	☐				0	0	Structure for Asset values
9	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
10	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value	TCURC
11	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
12	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value	TCURC
13	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
14	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
15	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
16	.INCLUDE	☐				0	0	Purchase price data
17	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
18	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price	TCURC
19	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
20	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
21	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
22	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
23	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
24	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
25	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_AST_HIST	AST_VALUE_CURR	TCURC	WAERS
2	CMS_AST_HIST	MANDT	T000	MANDT	KEY	1	CN
3	CMS_AST_HIST	NOM_VALUE_CURR	TCURC	WAERS
4	CMS_AST_HIST	PUR_PRICE_CURR	TCURC	WAERS
5	CMS_AST_HIST	UNIT_OF_MEASURE	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20040819
SAP Release Created in	110