CMS_STR_BII_SEC_ACC_DETAIL_SNG SAP (CMS-Basel: Securities Account Details) Structure details

Dictionary Type: Structure
Description: CMS-Basel: Securities Account Details




ABAP Code to SELECT data from CMS_STR_BII_SEC_ACC_DETAIL_SNG
Related tables to CMS_STR_BII_SEC_ACC_DETAIL_SNG
Access table CMS_STR_BII_SEC_ACC_DETAIL_SNG




Structure field list including key, data, relationships and ABAP select examples

CMS_STR_BII_SEC_ACC_DETAIL_SNG 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 "CMS-Basel: Securities Account Details" 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_BII_SEC_ACC_DETAIL_SNG TYPE CMS_STR_BII_SEC_ACC_DETAIL_SNG.

The CMS_STR_BII_SEC_ACC_DETAIL_SNG table consists of various fields, each holding specific information or linking keys about CMS-Basel: Securities Account Details data available in SAP. These include SEC_ACC_IDENTIFIER (GUID for Securities Accounts - Primary key), ACCOUNT_HOLDING_BANK (Depository bank identification), ACCOUNT_NUMBER (Securities account number), SECURITIES_ACCOUNT_DATA ().. 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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SECURITIES_ACCOUNT_KEY 0
SEC_ACC_IDENTIFIERGUID for Securities Accounts - Primary key BAPICMS_DTE_SEC_ACC_GUIDCHAR32SYSUUID_C
ACCOUNT_HOLDING_BANKDepository bank identification BAPICMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities account number BAPICMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
SECURITIES_ACCOUNT_DATA 0
ACCOUNT_HOLDING_BANKDepository bank identification BAPICMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities account number BAPICMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
DESCRIPTIONDescription of the securities account BAPICMS_DTE_SEC_ACC_DESCCHAR30CMS_SEC_DESC
ACCOUNT_OLD_REFERENCEReference number for an external system BAPICMS_DTE_SEC_ACC_REF_NOCHAR32CMS_SEC_EXT_REFID
ACCOUNT_VALUEValue of the securities account BAPICMS_DTE_SEC_ACC_VAL_AMTDEC23(4) BAPICURR
CURRENCY_ACCOUNT_VALUESecurities Account value Currency BAPICMS_DTE_SEC_ACC_VAL_CURRCUKY5WAERS
CURRENCY_ACCOUNT_VALUE_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
VALUATION_DATEDate of last valuation BAPICMS_DTE_SEC_ACC_VAL_DATEDATS8CMS_DATE
ADMINISTRATION_ORG_UNITAdministration Organizational Unit BAPICMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management BAPICMS_DTE_BANKAREACHAR4CMS_BANKAREACMS_BANKAREA
RISK_CODERisk Code BAPICMS_DTE_RISK_CODECHAR6CMS_RISK_CODE
SAFETY_INDICATORIndicates that the asset has a default sfty discount or not BAPICMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SAFETY_DISCOUNTSafety discount BAPICMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SAFETY_AMOUNTSafety discount as an amount BAPICMS_DTE_SAFETY_AMTDEC23(4) BAPICURR
SAFETY_AMOUNT_CURRENCYCurrency of the Safety discount amount BAPICMS_DTE_SAFETY_AMT_CURRCUKY5WAERS
SAFETY_AMOUNT_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
UNIT_VALUATION_FREQUENCYIndicator: Units of time for revaluation of an asset BAPICMS_DTE_IND_AST_VLN_FQ_UNTCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALUATION_FREQUENCYPeriod of revaluation for an asset BAPICMS_DTE_AST_VLN_FQ_PRDNUMC4CMS_AST_VALN_FREQ_PERIOD
START_DATEValuation Start date BAPICMS_DTE_START_DATEDATS8CMS_DATE
END_DATEValuation End date BAPICMS_DTE_END_DATEDATS8CMS_DATE
DEFAULT_LENDING_RATE_INDICATORIndicates that the asset has a default lending rate or not BAPICMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 BAPICMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LIQUIDATION_TYPELiquidation Type BAPICMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQUIDATION_REASONLiquidation Reason BAPICMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQUIDATION_DATECollateral Liquidation Date BAPICMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQUIDATION_AMOUNTReturns from the Liquidation of Collateral BAPICMS_DTE_LIQD_VALUEDEC23(4) BAPICURR
LIQUIDATION_CURRENCYCurrency of Liquidation Value BAPICMS_DTE_LIQD_CURRCUKY5WAERS
LIQUIDATION_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
ASSET_GUIDGUID for Table CMS_AST BAPICMS_DTE_AST_GUIDCHAR32SYSUUID_C
ASSET_TYPEAsset Type BAPICMS_DTE_AST_TYPCHAR6CMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset BAPICMS_DTE_AST_PAR_GUIDCHAR32SYSUUID_C
NOMINAL_VALUENominal Value of the Asset BAPICMS_DTE_AST_NOMINAL_VALUEDEC23(4) BAPICURR
ASSET_VALUEFinal Asset Value BAPICMS_DTE_AST_VALUEDEC23(4) BAPICURR
NOMINAL_VALUE_CURRENCYCurrency of Nominal value BAPICMS_DTE_AST_NOMINL_VAL_CURCUKY5WAERS
NOMINAL_VALUE_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
ASSET_VALUE_CURRENCYCurrency of the final Asset Value BAPICMS_DTE_AST_VALUE_CURRCUKY5WAERS
ASSET_VALUE_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
QUANTITYQuantity BAPICMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASURE_FOR_QUANTITYUnit of Measure of Quantity BAPICMS_DTE_UNITUNIT3CUNITMEINS
UNIT_OF_MEASURE_QUANTITY_ISOISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
ASSET_VALUE_REC_TIMESTAMPAsset Value Recording Timestamp BAPICMS_DTE_REC_ATDEC15TZNTSTMPS
ORGANIZATION_UNIT1Organization Unit 1 for an Asset BAPICMS_DTE_AST_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORGANIZATION_UNIT2Organization Unit 2 for an Asset BAPICMS_DTE_AST_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORGANIZATION_UNIT3Organization Unit 3 for an Asset BAPICMS_DTE_AST_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORGANIZATION_UNIT4Organization Unit 4 for an Asset BAPICMS_DTE_AST_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORGANIZATION_UNIT5Organization Unit 5 for an Asset BAPICMS_DTE_AST_ORG_UNIT5CHAR10CMS_ORG_UNIT
CREATED_BYLogin ID of the User who created the Record BAPICMS_DTE_USERCHAR12CMS_USER
CREATED_ONCreated On BAPICMS_DTE_SEC_CR_ONDATS8CMS_DATE
CREATED_ATCreated At BAPICMS_DTE_SEC_CR_ATTIMS6CMS_TIME
CHANGED_BYLast Changed By BAPICMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
LAST_CHANGED_ONLast Changed on BAPICMS_DTE_SEC_CH_ONDATS8CMS_DATE
LAST_CHANGED_ATLast Changed At BAPICMS_DTE_SEC_CH_ATTIMS6CMS_TIME
SECURITIES_ACCOUNT_POSITIONS 0
BUSINESS_PARTNER_DATA 0
DOCUMENTS_DATA 0
NOTES 0
USER_STATUS 0
SYSTEM_STATUS 0
CALCULATION_RESULTS 0
ACCOUNT_HOLDING_BANKDepository bank identification BAPICMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities account number BAPICMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
ASSET_GUIDGUID for Table CMS_AST BAPICMS_DTE_AST_GUIDCHAR32SYSUUID_C
RESULT_CURRENCYCalculations Result Currency BAPICMS_DTE_CALC_RES_CURRCUKY5WAERS
RESULT_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_VALUE_AMOUNTLending value Calculation for Asset BAPICMS_DTE_AST_LENDING_VALUEDEC23(4) BAPICURR
LENDING_VALUE_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT1_AMOUNTLending Limit 1 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT1DEC23(4) BAPICURR
LENDING_LIMIT1_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT2_AMOUNTLending Limit 2 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT2DEC23(4) BAPICURR
LENDING_LIMIT2_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT3_AMOUNTLending Limit 3 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT3DEC23(4) BAPICURR
LENDING_LIMIT3_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT4_AMOUNTLending Limit 4 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT4DEC23(4) BAPICURR
LENDING_LIMIT4_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT5_AMOUNTLending Limit 5 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT5DEC23(4) BAPICURR
LENDING_LIMIT5_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE1_AMOUNTLending Range 1 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE1DEC23(4) BAPICURR
LENDING_RANGE1_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE2_AMOUNTLending Range 2 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE2DEC23(4) BAPICURR
LENDING_RANGE2_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE3_AMOUNTLending Range 3 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE3DEC23(4) BAPICURR
LENDING_RANGE3_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE4_AMOUNTLending Range 4 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE4DEC23(4) BAPICURR
LENDING_RANGE4_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE5_AMOUNTLending Range 5 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE5DEC23(4) BAPICURR
LENDING_RANGE5_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
CALCULATION_RESULTS_MAIN 0
ACCOUNT_HOLDING_BANKDepository bank identification BAPICMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities account number BAPICMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
ASSET_GUIDGUID for Table CMS_AST BAPICMS_DTE_AST_GUIDCHAR32SYSUUID_C
RESULT_CURRENCYCalculations Result Currency BAPICMS_DTE_CALC_RES_CURRCUKY5WAERS
RESULT_CURRENCY_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_VALUE_AMOUNTLending value Calculation for Asset BAPICMS_DTE_AST_LENDING_VALUEDEC23(4) BAPICURR
LENDING_VALUE_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT1_AMOUNTLending Limit 1 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT1DEC23(4) BAPICURR
LENDING_LIMIT1_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT2_AMOUNTLending Limit 2 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT2DEC23(4) BAPICURR
LENDING_LIMIT2_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT3_AMOUNTLending Limit 3 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT3DEC23(4) BAPICURR
LENDING_LIMIT3_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT4_AMOUNTLending Limit 4 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT4DEC23(4) BAPICURR
LENDING_LIMIT4_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT5_AMOUNTLending Limit 5 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT5DEC23(4) BAPICURR
LENDING_LIMIT5_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE1_AMOUNTLending Range 1 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE1DEC23(4) BAPICURR
LENDING_RANGE1_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE2_AMOUNTLending Range 2 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE2DEC23(4) BAPICURR
LENDING_RANGE2_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE3_AMOUNTLending Range 3 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE3DEC23(4) BAPICURR
LENDING_RANGE3_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE4_AMOUNTLending Range 4 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE4DEC23(4) BAPICURR
LENDING_RANGE4_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE5_AMOUNTLending Range 5 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE5DEC23(4) BAPICURR
LENDING_RANGE5_AMOUNT_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
CALCULATION_RESULTS_PARTS 0
EXTENSIONOUT 0

Key field Non-key field



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

As CMS_STR_BII_SEC_ACC_DETAIL_SNG 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_BII_SEC_ACC_DETAIL_SNG as there is no data to select.

How to access SAP table CMS_STR_BII_SEC_ACC_DETAIL_SNG

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!