CMS_AST is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_AST in SAP.
- Table description : Asset Details
- Module : FS-CMS-MD
- Parent Module : FS
- Package : CMS_CORE
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMS_AST Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| .INCLUDE | Primary Key for CMS_AST | ||
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | SYSUUID |
| .INCLUDE | Semantic Key for Table CMS_AST | ||
| AST_ID | Asset ID | CMS_DTE_AST_ID | CMS_AST_ID |
| AST_TYP | Asset Type | CMS_DTE_AST_TYP | CMS_AST_TYP |
| .INCLUDE | Asset Guid as a parent GUID for a sub-asset | ||
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | CMS_DTE_SAS_PAR_GUID | SYSUUID |
| .INCLUDE | Sub-asset Identification | ||
| SUBAST_ID | Sub-asset ID | CMS_DTE_SAS_ID | CMS_SAS_ID |
| SUBAST_TYP | Sub-asset Type | CMS_DTE_SAS_TYP | CMS_TYP |
| .INCLUDE | Structure with Asset Details for Table CMS_AST | ||
| .INCLUDE | Basic Asset data | ||
| DESCRIPTION | Description | CMS_DTE_AST_DESC | CMS_DSC |
| OBJECT_REF_ID | Reference ID for the object | CMS_DTE_OBJ_REFID | CMS_OBJ_REFID |
| OBJECT_TYP | Not used | CMS_DTE_OBJ_TYP | CMS_OBJ_TYP |
| COUNTRY_KEY | Identification Key for Country | CMS_DTE_AST_COUNTRY_KEY | LAND1 |
| RISK_CODE | Risk Code | CMS_DTE_RISK_CODE | CMS_RISK_CODE |
| SFTY_IND | Indicates if the Asset has a Default Safety Discount | CMS_DTE_IND_SFTY_DISC | CMS_IND_SFTY |
| SFTY_DSCNT | Percentage of Safety Discount | CMS_DTE_SAFETY_DSCNT | CMS_SFTY_PCT |
| SFTY_AMOUNT | Amount of Safety Discount | CMS_DTE_SAFETY_AMT | CMS_AMOUNT |
| SFTY_AMT_CURR | Currency of the Safety Discount Amount | CMS_DTE_SAFETY_AMT_CURR | WAERS |
| OBJSYSID | Object System Reference ID | CMS_DTE_OBJ_SYSID | CMS_SYS |
| .INCLUDE | Valuation data | ||
| VALUATION_TYP | Type of Valuation Check performed on Collateral Object | CMS_DTE_IND_VALN_TYP | CMS_VALN_TYP |
| UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | CMS_DTE_IND_AST_VALN_FREQ_UNIT | CMS_IND_AST_VALN_FREQ_UNIT |
| PERIOD_VALN_FREQ | Revaluation Period for an Asset | CMS_DTE_AST_VALN_FREQ_PERIOD | CMS_AST_VALN_FREQ_PERIOD |
| PAST_VALUED_DATE | Last Date on which the Asset was Valued | CMS_DTE_VALN_DATE | CMS_DATE |
| START_DATE | Date on which the First Valuation is Performed on the Asset | CMS_DTE_START_DATE | CMS_DATE |
| END_DATE | Date on which the Last Valuation is Performed on the Asset | CMS_DTE_END_DATE | CMS_DATE |
| .INCLUDE | Lending rate data | ||
| LENDING_RATE_IND | Indicator to specify if Asset has a Default Lending Rate | CMS_DTE_IND_LND_RTE | CMS_IND_LRTE |
| .INCLUDE | Lending rates structure | ||
| LENDING_RATE1 | Lending Rate 1 | CMS_DTE_LRTE_PCT1 | CMS_PCT |
| LENDING_RATE2 | Lending Rate 2 | CMS_DTE_LRTE_PCT2 | CMS_PCT |
| LENDING_RATE3 | Lending Rate 3 | CMS_DTE_LRTE_PCT3 | CMS_PCT |
| LENDING_RATE4 | Lending Rate 4 | CMS_DTE_LRTE_PCT4 | CMS_PCT |
| LENDING_RATE5 | Lending Rate 5 | CMS_DTE_LRTE_PCT5 | CMS_PCT |
| .INCLUDE | Liquidation rights data | ||
| LIQD_TYP | Liquidation Type | CMS_DTE_LIQD_TYP | CMS_TYP |
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CMS_ATT_ID_TYP |
| LIQD_DATE | Date on which the Collateral was Liquidated | CMS_DTE_LIQD_DATE | CMS_DATE |
| LIQD_AMT | Returns from the Liquidation of Collateral | CMS_DTE_LIQD_VALUE | CMS_AMOUNT |
| LIQD_CURR | Currency of Liquidation Value | CMS_DTE_LIQD_CURR | WAERS |
| EXP_PRCD_AMNT | Expected Proceed Amount | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CMS_AMOUNT |
| EXP_PRCD_CURR | Currency: Expected Proceed | CMS_DTE_LIQ_EXP_PRCD_CURR | WAERS |
| EXP_ACC_DATE | Expected accrual date | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | CMS_DATE |
| .INCLUDE | Account for liquidation proceeds | ||
| ACC_NUMBER_LIQ | Account number for liquidation proceeds | CMS_DTE_LIQ_ACC_NUMBER | BANKN35 |
| BANK_CNTRY_LIQ | Bank country key | CMS_DTE_LIQ_BNK_CTRY_KY | LAND1 |
| BANK_KEY_LIQ | Bank Key | CMS_DTE_LIQ_BNK_KEY | BANKK |
| BANK_CTRLKEY_LIQ | Bank Control Key | BKONT | BKONT |
| .INCLUDE | Verfication Data | ||
| UNIT_VERF_FREQ | Indicator: Units of time for verification of an asset | CMS_DTE_IND_AST_VERF_FREQ_UNIT | CMS_IND_AST_VERF_FREQ_UNIT |
| PERIOD_VERF_FREQ | Statement Period for an Asset | CMS_DTE_AST_VERF_FREQ_PERIOD | CMS_AST_VERF_FREQ_PERIOD |
| LAST_VERF_DATE | Last Verification Date | CMS_DTE_AST_VERF_DATE | CMS_DATE |
| .INCLUDE | Structure for Asset values | ||
| NOM_VALUE | Nominal Value of the Asset | CMS_DTE_AST_NOMINAL_VALUE | CMS_AMOUNT |
| NOM_VALUE_CURR | Currency of Nominal value | CMS_DTE_AST_NOMINAL_VALUE_CURR | WAERS |
| AST_VALUE | Final Asset Value | CMS_DTE_AST_VALUE | CMS_AMOUNT |
| AST_VALUE_CURR | Currency of the Final Asset Value | CMS_DTE_AST_VALUE_CURR | WAERS |
| QUANTITY | Quantity | CMS_DTE_QTY | CMS_QTY |
| UNIT_OF_MEASURE | Unit of Measure of Quantity | CMS_DTE_UNIT | MEINS |
| REC_AT | Asset Value Recording Timestamp | CMS_DTE_REC_AT | TZNTSTMPS |
| .INCLUDE | Purchase price data | ||
| PUR_PRICE | Purchase Price of the Asset | CMS_DTE_AST_PURCHASE_PRICE | CMS_AMOUNT |
| PUR_PRICE_CURR | Currency of Purchase Price | CMS_DTE_AST_PUR_PRICE_CURR | WAERS |
| PUR_DATE | Date of Purchase | CMS_DTE_AST_PUR_PRICE_DATE | CMS_DATE |
| .INCLUDE | Administrative organization unit | ||
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | TEXT12 |
| .INCLUDE | Bank area | ||
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CMS_BANKAREA |
| .INCLUDE | Organization unit structure: Assets | ||
| ORG_UNIT1 | Organizational Unit 1 of an Asset | CMS_DTE_AST_ORG_UNIT1 | CMS_ORG_UNIT |
| ORG_UNIT2 | Organizational Unit 2 of an Asset | CMS_DTE_AST_ORG_UNIT2 | CMS_ORG_UNIT |
| ORG_UNIT3 | Organizational Unit 3 of an Asset | CMS_DTE_AST_ORG_UNIT3 | CMS_ORG_UNIT |
| ORG_UNIT4 | Organizational Unit 4 of an Asset | CMS_DTE_AST_ORG_UNIT4 | CMS_ORG_UNIT |
| ORG_UNIT5 | Organizational Unit 5 of an Asset | CMS_DTE_AST_ORG_UNIT5 | CMS_ORG_UNIT |
| .INCLUDE | Stucture to record history of changes in all application tab | ||
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CMS_USER |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | TZNTSTMPS |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CMS_USER |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | TZNTSTMPS |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE |
CMS_AST related tables
| Table | Note |
|---|---|
| FAAASSETID | Assignment Table - Asset Key to Asset GUID |
| IDSAU_TD_C_AGAC | Assignment of Asset Group to Asset Class |
| T087U | Asset group number / asset group |
| T087V | Text table asset group number / asset group |
| TABVO | Determine asset value date in Asset Accounting transactions |
| TZ17 | Asset group C11/76 Asset 6 (Annual stock overview) |
| VWPANAN | Asset master/asset master relationship |
| CMS_AST | Asset Details |
| CRMC_FS_ASTCAT | Asset Category details |
| CRMC_FS_ASTTYP | Asset Type Details |
| CRM_FS_ASSET | Details of Asset |
| CRM_FS_ASSETH | Details of Asset |
| TCMS_AST_CAT | Asset Category Details |
| TCMS_AST_TYP | Asset Type Details |
| TCMS_SAS_TYP | Sub-asset type details |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP