SAP ABAP Table CMS_STR_CAG_SNG_SA (Special Arrangement for a single CAG)
Hierarchy
☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD (Application Component) Master Data
     ⤷ CMS_CORE (Package) Collateral Management System
Basic Data
Table Category INTTAB    Structure 
Structure CMS_STR_CAG_SNG_SA   Table Relationship Diagram
Short Description Special Arrangement for a single CAG    
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 .INCLUDE       0   0   Primary Key for CMS_CAG_SA  
2 CAG_SA_GUID CMS_DTE_CAG_SA_GUID SYSUUID RAW 16   0   Primary key for CMS_CAG_SA  
3 .INCLUDE       0   0   Link Key for CMS_CAG_SA  
4 REF_GUID CMS_DTE_CAG_SA_REF_GUID SYSUUID RAW 16   0   Link Key for CMS_CAG_SA  
5 .INCLUDE       0   0   Special Arrangement Details  
6 SA_TYPE CMS_DTE_CAG_SA_TYP CMS_CAG_SA_TYP CHAR 6   0   Special Arrangement Type TCMS_CAG_SA_TY
7 SA_ID CMS_DTE_CAG_SA_ID CMS_CAG_SA_ID CHAR 40   0   Special Arrangement ID  
8 PROC_STAT CMS_DTE_CAG_SA_PROC_STAT CMS_CAG_SA_PROC_STAT CHAR 2   0   Processing Status of Special Arrangement  
9 LEGAL_STAT CMS_DTE_CAG_SA_LEGAL_STAT CMS_CAG_CA_LEGAL_STAT CHAR 2   0   Special Arrangement Legal Status  
10 VALID_FROM CMS_DTE_CAG_SA_VALID_FROM CMS_DATE DATS 8   0   Date from which Special Arrangement Stands Valid  
11 VALID_TO CMS_DTE_CAG_SA_VALID_TO CMS_DATE DATS 8   0   Date from which Special Arrangement Stands Valid  
12 NOM_VALUE CMS_DTE_CAG_SA_NOM_VALUE CMS_AMOUNT CURR 17   2   Special Arrangement Nominal Value  
13 NOM_VALUE_CURR CMS_DTE_CAG_SA_NOM_CURR WAERS CUKY 5   0   Currency of Special Arrangement: Nominal Value TCURC
14 ASMT_AMT CMS_DTE_CAG_SA_ASMT_AMT CMS_AMOUNT CURR 17   2   Special Arrangement Assessment Amount  
15 ASMT_AMT_CURR CMS_DTE_CAG_SA_ASMT_CURR WAERS CUKY 5   0   Currency of Special Arrangement: Assessment Amount TCURC
16 BANK_CTRY BANKS LAND1 CHAR 3   0   Bank country key T005
17 BANK_KEY BANKK BANKK CHAR 15   0   Bank Keys  
18 BANK_ACCT BANKN35 BANKN35 CHAR 35   0   Bank account number  
19 BANK_CTRL_KEY BKONT BKONT CHAR 2   0   Bank Control Key  
20 REF_AGMT_ID CMS_DTE_CAG_SA_REFAGMT_ID CMS_CAG_SA_REFAGMT_ID CHAR 40   0   Pruchase Agreement ID of a Special Arrangement  
21 REF_AGMT_DATE CMS_DTE_CAG_SA_REFAGMT_DATE CMS_DATE DATS 8   0   Purchase Agreement Date of Special Arrangement  
22 DESCRIPTION CMS_DTE_CAG_SA_DESC CMS_DSC CHAR 30   0   Description for Special Arrangement  
23 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
24 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
25 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
26 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
27 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
28 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_STR_CAG_SNG_SA ASMT_AMT_CURR TCURC WAERS REF 1 CN
2 CMS_STR_CAG_SNG_SA BANK_CTRY T005 LAND1 REF 1 CN
3 CMS_STR_CAG_SNG_SA NOM_VALUE_CURR TCURC WAERS REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 500