SAP ABAP Table CMS_STR_AST_VAL_HIST (Structure (DB Format))
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE (Package) Collateral Management System
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE (Package) Collateral Management System
Basic Data
Table Category | INTTAB | Structure |
Structure | CMS_STR_AST_VAL_HIST | Table Relationship Diagram |
Short Description | Structure (DB Format) |
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 | .INCLUDE | 0 | 0 | Primary Key for CMS_AST_HIST | |||||
2 | AST_HIST_GUID | CMS_DTE_AST_HIST_GUID | SYSUUID | RAW | 16 | 0 | Asset history Guid | ||
3 | .INCLUDE | 0 | 0 | Link to CMS_AST Table | |||||
4 | AST_GUID | CMS_DTE_AST_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_AST | ||
5 | .INCLUDE | 0 | 0 | Asset Guid as a parent GUID for a sub-asset | |||||
6 | PARENT_GUID | CMS_DTE_SAS_PAR_GUID | SYSUUID | RAW | 16 | 0 | Asset Guid as a parent GUID for a sub-asset | ||
7 | .INCLUDE | 0 | 0 | Structure for Asset values | |||||
8 | NOM_VALUE | CMS_DTE_AST_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Asset | ||
9 | NOM_VALUE_CURR | CMS_DTE_AST_NOMINAL_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency of Nominal value | TCURC | |
10 | AST_VALUE | CMS_DTE_AST_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Final Asset Value | ||
11 | AST_VALUE_CURR | CMS_DTE_AST_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency of the Final Asset Value | TCURC | |
12 | QUANTITY | CMS_DTE_QTY | CMS_QTY | QUAN | 13 | 3 | Quantity | ||
13 | UNIT_OF_MEASURE | CMS_DTE_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure of Quantity | T006 | |
14 | REC_AT | CMS_DTE_REC_AT | TZNTSTMPS | DEC | 15 | 0 | Asset Value Recording Timestamp | ||
15 | .INCLUDE | 0 | 0 | Purchase price data | |||||
16 | PUR_PRICE | CMS_DTE_AST_PURCHASE_PRICE | CMS_AMOUNT | CURR | 17 | 2 | Purchase Price of the Asset | ||
17 | PUR_PRICE_CURR | CMS_DTE_AST_PUR_PRICE_CURR | WAERS | CUKY | 5 | 0 | Currency of Purchase Price | TCURC | |
18 | PUR_DATE | CMS_DTE_AST_PUR_PRICE_DATE | CMS_DATE | DATS | 8 | 0 | Date of Purchase | ||
19 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
20 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
21 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
22 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
23 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
24 | 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_STR_AST_VAL_HIST | AST_VALUE_CURR | TCURC | WAERS | |||
2 | CMS_STR_AST_VAL_HIST | NOM_VALUE_CURR | TCURC | WAERS | |||
3 | CMS_STR_AST_VAL_HIST | PUR_PRICE_CURR | TCURC | WAERS | |||
4 | CMS_STR_AST_VAL_HIST | UNIT_OF_MEASURE | T006 | MSEHI | REF | 1 | CN |
History
Last changed by/on | SAP | 20040819 |
SAP Release Created in | 200 |