SAP CMS_STR_CAG_CHARGE_CRM Collateral Agreement + Charge Table data and field list

CMS_STR_CAG_CHARGE_CRM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Collateral Agreement + Charge" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_CAG_CHARGE_CRM TYPE CMS_STR_CAG_CHARGE_CRM.

The CMS_STR_CAG_CHARGE_CRM table consists of various fields, each holding specific information or linking keys about Collateral Agreement + Charge data available in SAP. These include BTD_ID (), ID (Text field, length 35), SCHEME_ID (60 Characters Lower Case), SCHEME_AGENCY_ID (Character String 60)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_STR_CAG_CHARGE_CRM structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP CMS_STR_CAG_CHARGE_CRM structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_STR_CAG_CHARGE_CRM table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
COLLATERAL_AGREEMENT 0
BTD_ID 0
IDText field, length 35 CHAR_35CHAR35CHAR_35
SCHEME_ID60 Characters Lower Case CMS_DTE_CHAR60LOW_CRMCHAR60CHAR60LOW
SCHEME_AGENCY_IDCharacter String 60 CHAR_60CHAR60CHAR_60
IDCollateral Agreement ID CMS_DTE_CAGIDCHAR40ALPHACMS_CAGIDCMS_CAGIDCMS_SRCH_CAG
TYPECollateral Agreement Type BAPICMS_DTE_CAG_TYPCHAR6CMS_CAG_TYPCMS_CAG_TYP
VALIDITY_START_DATEDate from when it is valid BAPICMS_DTE_VALID_FROMDATS8CMS_DATE
VALIDITY_END_DATEDate until when it is valid BAPICMS_DTE_VALID_TODATS8CMS_DATE
ASSESSMENT_AMOUNTAssessment Amount BAPICMS_DTE_CAG_ASMT_AMTDEC23(4) BAPICURR
ASSESSMENT_AMOUNT_CISO Currency Code BAPIISOCDCHAR3ISOCD
ASSESSMENT_DATEDate on which the Assessment Value was Calculated BAPICMS_DTE_CAG_ASMT_DATEDATS8CMS_DATE
DESCRIPTIONDescription of Collateral Agreement BAPICMS_DTE_CAG_DESCCHAR30CMS_DSC
WIDE_PURPOSE_DECLARN_INDICATORFlag to indicate a Global Collateral Agreement BAPICMS_DTE_FLG_CAG_GLOBALCHAR1CMS_FLG_GLOBAL_CAGMT
FREE_AMOUNTS 0
LAND_CHARGE 0
COLLECTIVITY_INDICATORFlag: Collective Land Charge CMS_DTE_FLG_CAG_LCHG_COLLCHAR1CMS_FLG_CAG_LCHG_COLLECTIVE
CERTIFIATE_EXISTENCY_INDICATORFlag: Land Charge certificate exists CMS_DTE_FLG_CAG_LCHG_CERTCHAR1CMS_FLG_LCHG_CERT
CERTIFIATE_IDCharge Certificate Number CMS_DTE_CAG_LCHG_CERT_NUMCHAR30CMS_LCHG_CERT_NUM
REGISTER_RECORD_SERIAL_NUMBERFile Number CMS_DTE_CAG_LCHG_FILE_NUMCHAR30CMS_LCHG_FILE_NUM
INTEREST 0
RATELand Charge Interest Rate CMS_DTE_CAG_LCHG_INT_RATEDEC10(6) CMS_PCT
INCIDENTAL_PAYMENT_PERCENTAGEIncidental Payments in Percentage CMS_DTE_CAG_LCHG_INCD_PAYMTDEC10(6) CMS_PCT
PAYMENT_FREQUENCYPeriod for Frequency of Payment of Land Charge Interest CMS_DTE_CAG_PYMT_FREQ_PERIODNUMC4CMS_CAG_FREQ_PERIOD
PAYMENT_FREQUENCY_UNITThe unit for period of payment frequency CMS_DTE_IND_CAG_PYMT_FREQ_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
CALCULATION_START_DATEStart Date for Land Charge Interest Calculation CMS_DTE_CAG_LCHG_INT_START_DATDATS8CMS_DATE
CAPITALISATION_YEARSNumber of Years the Land Charge Interest can be Capitalized CMS_DTE_CAG_LCHG_INT_YRNUMC4CMS_CAG_LCHG_INT_YR
CHARGE 0
BTD_ID 0
IDText field, length 35 CHAR_35CHAR35CHAR_35
SCHEME_ID60 Characters Lower Case CMS_DTE_CHAR60LOW_CRMCHAR60CHAR60LOW
SCHEME_AGENCY_IDCharacter String 60 CHAR_60CHAR60CHAR_60
REAL_ESTATE_REFERENCE_ID 0
IDText field, length 35 CHAR_35CHAR35CHAR_35
SCHEME_ID60 Characters Lower Case CMS_DTE_CHAR60LOW_CRMCHAR60CHAR60LOW
SCHEME_AGENCY_IDCharacter String 60 CHAR_60CHAR60CHAR_60
CAG_REFERENCE_ID 0
IDText field, length 35 CHAR_35CHAR35CHAR_35
SCHEME_ID60 Characters Lower Case CMS_DTE_CHAR60LOW_CRMCHAR60CHAR60LOW
SCHEME_AGENCY_IDCharacter String 60 CHAR_60CHAR60CHAR_60
DESCRIPTIONDescription for Charges CMS_DTE_CHG_DESCCHAR30CMS_DSC
RANKING_ORDERRanking of a Collateral Agreement in an Asset CMS_DTE_RANKING_ORDERNUMC4CMS_PRIORITY
SEQUENCESequence of an Asset in a Collateral agreement CMS_DTE_SEQUENCENUMC4CMS_PRIORITY
REGISTRATION_NUMBERRegister Number CMS_DTE_CHG_REG_NOCHAR32CMS_INTFID
REGISTRATION_DATEDate on which the Land Charge was Registered CMS_DTE_CHG_REG_DATEDATS8CMS_DATE
ASSET_AMOUNTAsset Value Amount used as Charge BAPICMS_DTE_AST_PART_VALDEC23(4) BAPICURR
ASSET_AMOUNT_CURRENCYISO currency code ISOCDCHAR3ISOCD
ASSET_PERCENTShare of the Asset in the Charge CMS_DTE_AST_PCT_SHAREDEC6(2) CMS_PCT_SHARE

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_CAG_CHARGE_CRM using ABAP code?

As CMS_STR_CAG_CHARGE_CRM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_CAG_CHARGE_CRM as there is no data to select.

How to access SAP table CMS_STR_CAG_CHARGE_CRM

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_CAG_CHARGE_CRM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).