SAP ABAP Table CMS_OMS_VAL_LNK (Value Link)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD (Application Component) Master Data
     ⤷ CMS_OMS_COMMON (Package) Collateral Management: Common Services for Object Systems

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_OMS_VAL_LNK	Table Relationship Diagram
Short Description	Value Link

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 Value link
3	VAL_GUID	☑	CMS_DTE_OMS_VAL_GUID	SYSUUID	RAW	16	0	GUID for Value service
4	.INCLUDE	☐				0	0	Link Key for OMS Links -Value
5	VAL_LINK_GUID	☐	CMS_DTE_OMS_VAL_LNK_GUID	SYSUUID	RAW	16	0	GUID for OMS Links - Values
6	.INCLUDE	☐				0	0	Value details
7	VAL_TYPE	☐	CMS_DTE_VALUE_TYPE	CMS_VALUE_TYPE	CHAR	6	0	Value Type	TCMS_OMS_VALTY
8	CALC_AMOUNT	☐	CMS_DTE_OMS_VAL_CALC_AMOUNT	CMS_VAL_AMOUNT	CURR	17	2	Calculated Value
9	CALC_AMT_CURR	☐	CMS_DTE_OMS_VAL_CALC_CURR	WAERS	CUKY	5	0	Currency for Calculated Value	TCURC
10	ENTERED_AMOUNT	☐	CMS_DTE_OMS_VAL_ENTERED_AMOUNT	CMS_VAL_AMOUNT	CURR	17	2	Entered Value
11	ENT_AMT_CURR	☐	CMS_DTE_OMS_VAL_ENTERED_CURR	WAERS	CUKY	5	0	Currency for Entered Value	TCURC
12	VAL_VALID_FROM	☐	CMS_DTE_OMS_VAL_VALID_FROM	CMS_VAL_DATE	DATS	8	0	Date from which Value Stands Valid
13	VAL_VALID_TO	☐	CMS_DTE_OMS_VAL_VALID_TO	CMS_VAL_DATE	DATS	8	0	Date until which Value Stands Valid
14	VAL_DATE	☐	CMS_DTE_OMS_VAL_DATE	CMS_VAL_DATE	DATS	8	0	Date of First Valuation
15	VAL_ORIGIN	☐	CMS_DTE_OMS_ATT_ID_TY_VAL001	CMS_ATT_ID_TYP	CHAR	6	0	Origin of Value	TCMS_ATT_ID_TY
16	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
17	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
18	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
19	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
20	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
21	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_OMS_VAL_LNK	CALC_AMT_CURR	TCURC	WAERS	REF	1	CN
2	CMS_OMS_VAL_LNK	ENT_AMT_CURR	TCURC	WAERS	REF	1	CN
3	CMS_OMS_VAL_LNK	MANDT	T000	MANDT	KEY	1	CN
4	CMS_OMS_VAL_LNK	VAL_ORIGIN	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

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