CMS_AST_HIST

Asset Value History | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
AST_HIST_GUID Asset history Guid
Column Name Description
💲 Currency of Nominal value (NOM_VALUE_CURR):
NOM_VALUE Nominal Value of the Asset
💲 Currency of the Final Asset Value (AST_VALUE_CURR):
AST_VALUE Final Asset Value
💲 Currency of Purchase Price (PUR_PRICE_CURR):
PUR_PRICE Purchase Price of the Asset
💲 Currency of the Original Protection Value (ORI_VALUE_CURR):
ORI_VALUE Original Protection of the Asset
Column Name Description
📏 Unit of Measure of Quantity (UNIT_OF_MEASURE):
QUANTITY Quantity
Column Name Description
PUR_DATE Date of Purchase
Column Name Description
Column Name Description Domain name
AST_GUID GUID for Table CMS_AST SYSUUID
PARENT_GUID Asset Guid as a parent GUID for a sub-asset SYSUUID
REC_AT Asset Value Recording Timestamp TZNTSTMPS
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
Master Data Relations Join Conditions
Currency of the Final Asset Value
  • CMS_AST_HIST.MANDT == TCURC.MANDT
  • CMS_AST_HIST.AST_VALUE_CURR == TCURC.WAERS
Foreign key for Mandt CMS_AST_HIST.MANDT == T000.MANDT
Currency of Nominal value
  • CMS_AST_HIST.MANDT == TCURC.MANDT
  • CMS_AST_HIST.NOM_VALUE_CURR == TCURC.WAERS
Currency of the Original Protection Value
  • CMS_AST_HIST.MANDT == TCURC.MANDT
  • CMS_AST_HIST.ORI_VALUE_CURR == TCURC.WAERS
Currency of Purchase Price
  • CMS_AST_HIST.MANDT == TCURC.MANDT
  • CMS_AST_HIST.PUR_PRICE_CURR == TCURC.WAERS
Unit of Measure of Quantity
  • CMS_AST_HIST.MANDT == T006.MANDT
  • CMS_AST_HIST.UNIT_OF_MEASURE == T006.MSEHI