- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Business Partner (FS-BP)
- Claims Management (FS-CM)
- Collateral Management System (FS-CMS)
- Collections/Disbursements (FS-CD)
- Loans Management (FS-CML)
- Policy Management (FS-PM)
- Regulatory reporting for insurance companies (FS-SR)
- SAP Policy Management for Auto Insurance (FS-PMA)
- Value Adjustment (FS-RBD)
- msg.PM Connection (FS-MPM)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
CMS_AST
Asset Details
|
#masterdata
|
Component: Master Data
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| AST_GUID | GUID for Table CMS_AST |
| Column Name | Description | |
|---|---|---|
| 💲 Currency of the Safety Discount Amount (SFTY_AMT_CURR): | ||
| SFTY_AMOUNT | Amount of Safety Discount | |
| 💲 Currency of Liquidation Value (LIQD_CURR): | ||
| LIQD_AMT | Returns from the Liquidation of Collateral | |
| 💲 Currency: Expected Proceed (EXP_PRCD_CURR): | ||
| EXP_PRCD_AMNT | Expected Proceed Amount | |
| 💲 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 | |
|---|---|---|
| PAST_VALUED_DATE | Last Date on which the Asset was Valued | |
| START_DATE | Date on which the First Valuation is Performed on the Asset | |
| END_DATE | Date on which the Last Valuation is Performed on the Asset | |
| LIQD_DATE | Date on which the Collateral was Liquidated | |
| EXP_ACC_DATE | Expected accrual date | |
| OBJ_EXP_PRC_TIME | Expected Time of Proceeds | |
| LAST_VERF_DATE | Last Verification Date | |
| PUR_DATE | Date of Purchase | |
| NXT_VALUED_DATE | Next revalution date of object |
| Column Name | Description | |
|---|---|---|
| SFTY_IND | Indicates if the Asset has a Default Safety Discount | Show values |
| SFTY_DSCNT | Percentage of Safety Discount | Show values |
| VALUATION_TYP | Type of Valuation Check performed on Collateral Object | Show values |
| UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | Show values |
| LENDING_RATE_IND | Indicator to specify if Asset has a Default Lending Rate | Show values |
| UNIT_VERF_FREQ | Indicator: Units of time for verification of an asset | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| AST_ID | Asset ID | CMS_AST_ID | |
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | SYSUUID | |
| SUBAST_ID | Sub-asset ID | CMS_SAS_ID | |
| SUBAST_TYP | Sub-asset Type | CMS_TYP | |
| DESCRIPTION | Description | CMS_DSC | |
| OBJECT_REF_ID | Reference ID for the object | CMS_OBJ_REFID | |
| OBJECT_TYP | Not used | CMS_OBJ_TYP | |
| OBJSYSID | Object System Reference ID | CMS_SYS | |
| PERIOD_VALN_FREQ | Revaluation Period for an Asset | CMS_AST_VALN_FREQ_PERIOD | |
| LENDING_RATE1 | Lending Rate 1 | CMS_PCT | |
| LENDING_RATE2 | Lending Rate 2 | CMS_PCT | |
| LENDING_RATE3 | Lending Rate 3 | CMS_PCT | |
| LENDING_RATE4 | Lending Rate 4 | CMS_PCT | |
| LENDING_RATE5 | Lending Rate 5 | CMS_PCT | |
| ACC_NUMBER_LIQ | Account number for liquidation proceeds | BANKN35 | |
| BANK_KEY_LIQ | Bank Key | BANKK | |
| BANK_CTRLKEY_LIQ | Bank Control Key | BKONT | |
| PERIOD_VERF_FREQ | Statement Period for an Asset | CMS_AST_VERF_FREQ_PERIOD | |
| REC_AT | Asset Value Recording Timestamp | TZNTSTMPS | |
| ADMIN_ORG_UNIT | Administration Organizational Unit | TEXT12 | |
| BANKAREA | Bank Area in Collateral Management | CMS_BANKAREA | |
| ORG_UNIT1 | Organizational Unit 1 of an Asset | CMS_ORG_UNIT | |
| ORG_UNIT2 | Organizational Unit 2 of an Asset | CMS_ORG_UNIT | |
| ORG_UNIT3 | Organizational Unit 3 of an Asset | CMS_ORG_UNIT | |
| ORG_UNIT4 | Organizational Unit 4 of an Asset | CMS_ORG_UNIT | |
| ORG_UNIT5 | Organizational Unit 5 of an Asset | CMS_ORG_UNIT | |
| 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 |
|---|---|
| Foreign key for Asset type |
|
| Currency of the Final Asset Value | |
Key of Bank Country/Region
| |
Identification Key for Country/Region
| |
| Currency: Expected Proceed | |
| Currency of Liquidation Value | |
Liquidation Reason
|
|
| Foreign key relationship |
|
| Foreign key for Mandt | CMS_AST.MANDT == T000.MANDT |
| Currency of Nominal value | |
| Currency of the Original Protection Value | |
| Currency of Purchase Price | |
| Currency of the Safety Discount Amount | |
| Foreign key for unit of measure |