SAP Table TCMS_SAS_TYP
Sub-asset type details
TCMS_SAS_TYP (Sub-asset type details) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCMS_SAS_TYP to other SAP tables.
TCMS_SAS_TYP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||
| SUBAST_TYP | Sub-asset Type | CMS_DTE_SAS_TYP | CHAR | 6 | 0 | |||||||||||
| DOC_SET | Document Set | CMS_DTE_DOC_SET | TCMS_DOC_SET | CHAR | 6 | 0 | ||||||||||
| BPF_SET | Business Partner Function Set | CMS_DTE_BPF_SET | TCMS_BPF_SET | CHAR | 6 | 0 | ||||||||||
| AST_TYP | Asset Type | CMS_DTE_AST_TYP | TCMS_AST_TYP | CHAR | 6 | 0 | ||||||||||
| CATEGORYID | Asset Category Identification No | CMS_DTE_AST_CAT | TCMS_AST_CAT | CHAR | 6 | 0 | ||||||||||
| CMICODE | Central Monetary Institution Code | CMS_DTE_CMI_CODE | CHAR | 2 | 0 | |||||||||||
| UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | CMS_DTE_IND_AST_VALN_FREQ_UNIT | CHAR | 2 | 0 |
Possible values
|
||||||||||
| PERIOD_VALN_FREQ | Revaluation Period for an Asset | CMS_DTE_AST_VALN_FREQ_PERIOD | NUMC | 4 | 0 | |||||||||||
| SFTY_DSCNT | Percentage of Safety Discount | CMS_DTE_SAFETY_DSCNT | DEC | 10 | 6 |
Possible values
|
||||||||||
| LENDING_RATE1 | Lending Rate 1 | CMS_DTE_LRTE_PCT1 | DEC | 10 | 6 | |||||||||||
| LENDING_RATE2 | Lending Rate 2 | CMS_DTE_LRTE_PCT2 | DEC | 10 | 6 | |||||||||||
| LENDING_RATE3 | Lending Rate 3 | CMS_DTE_LRTE_PCT3 | DEC | 10 | 6 | |||||||||||
| LENDING_RATE4 | Lending Rate 4 | CMS_DTE_LRTE_PCT4 | DEC | 10 | 6 | |||||||||||
| LENDING_RATE5 | Lending Rate 5 | CMS_DTE_LRTE_PCT5 | DEC | 10 | 6 | |||||||||||
TCMS_SAS_TYP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TCMS_SAS_TYP | AST_TYP | TCMS_SAS_TYP | MANDT | TCMS_AST_TYP | Asset Type Details | MANDT |
| TCMS_SAS_TYP | AST_TYP | TCMS_SAS_TYP | AST_TYP | TCMS_AST_TYP | Asset Type Details | AST_TYP |
| TCMS_SAS_TYP | BPF_SET | TCMS_SAS_TYP | MANDT | TCMS_BPF_SET | Business Partner Function Sets | MANDT |
| TCMS_SAS_TYP | BPF_SET | TCMS_SAS_TYP | BPF_SET | TCMS_BPF_SET | Business Partner Function Sets | .INCLUDE |
| TCMS_SAS_TYP | CATEGORYID | TCMS_SAS_TYP | CATEGORYID | TCMS_AST_CAT | Asset Category Details | CATEGORYID |
| TCMS_SAS_TYP | DOC_SET | TCMS_SAS_TYP | MANDT | TCMS_DOC_SET | Define Document Sets | MANDT |
| TCMS_SAS_TYP | DOC_SET | TCMS_SAS_TYP | DOC_SET | TCMS_DOC_SET | Define Document Sets | .INCLUDE |
