SAP ABAP Table V_CMS_CAG_CHG_SH (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | V_CMS_CAG_CHG_SH |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
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 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | CAG_GUID |
CMS_DTE_CAG_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_CAG | ||
| 3 | CHG_GUID |
CMS_DTE_CHG_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_CHG | ||
| 4 | AST_GUID |
CMS_DTE_AST_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_AST | ||
| 5 | CAGMTID |
CMS_DTE_CAGID | CMS_CAGID | CHAR | 40 | 0 | Collateral Agreement ID | ||
| 6 | CAGMT_TYPE |
CMS_DTE_CAG_TYP | CMS_CAG_TYP | CHAR | 6 | 0 | Collateral Agreement Type | TCMS_CAG_TYP | |
| 7 | CAGMT_DATE |
CMS_DTE_CAG_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Collateral Agreement was Concluded | ||
| 8 | NOM_VALUE |
CMS_DTE_CAG_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Collateral Agreement | ||
| 9 | NOM_VALUE_CURR |
CMS_DTE_CAG_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Currency for Nominal Value of the Collateral Agreement | TCURC | |
| 10 | DESCRIPTION |
CMS_DTE_CAG_DESC | CMS_DSC | CHAR | 30 | 0 | Description of Collateral Agreement | ||
| 11 | REG_ENTRY_NO |
CMS_DTE_CHG_REG_NO | CMS_INTFID | CHAR | 32 | 0 | Register Number | ||
| 12 | REG_DATE |
CMS_DTE_CHG_REG_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Land Charge was Registered | ||
| 13 | AST_ID |
CMS_DTE_AST_ID | CMS_AST_ID | CHAR | 40 | 0 | Asset ID | ||
| 14 | AST_TYP |
CMS_DTE_AST_TYP | CMS_AST_TYP | CHAR | 6 | 0 | Asset Type | TCMS_AST_TYP | |
| 15 | SUBAST_ID |
CMS_DTE_SAS_ID | CMS_SAS_ID | NUMC | 4 | 0 | Sub-asset ID | ||
| 16 | SUBAST_TYP |
CMS_DTE_SAS_TYP | CMS_TYP | CHAR | 6 | 0 | Sub-asset Type | ||
| 17 | CREATED_BY |
CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | V_CMS_CAG_CHG_SH | AST_TYP |  TCMS_AST_TYP |
AST_TYP |
REF | 1 | CN |
| 2 | V_CMS_CAG_CHG_SH | CAGMT_TYPE | TCMS_CAG_TYP |
CAGMT_TYPE |
REF | 1 | CN |
| 3 | V_CMS_CAG_CHG_SH | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 4 | V_CMS_CAG_CHG_SH | NOM_VALUE_CURR | TCURC |
WAERS |
REF | 1 | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |
