CMS_STR_SEC_ACC_POS_AST_SCR SAP (Screen structure for securities positions) Structure details

Dictionary Type: Structure
Description: Screen structure for securities positions




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




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

CMS_STR_SEC_ACC_POS_AST_SCR 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 "Screen structure for securities positions" 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_SEC_ACC_POS_AST_SCR TYPE CMS_STR_SEC_ACC_POS_AST_SCR.

The CMS_STR_SEC_ACC_POS_AST_SCR table consists of various fields, each holding specific information or linking keys about Screen structure for securities positions data available in SAP. These include SEC_ACC_POS_GUID (GUID for securities positions in an account), SEC_ACC_GUID (GUID for securities account), POS_NO (Sequence Number of a Position in a Securities Account), POS_OLD_REF_NO (ID of a Positiion Referenced from an External System).. 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: Not classified


SAP CMS_STR_SEC_ACC_POS_AST_SCR 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
SEC_ACC_POS_GUIDGUID for securities positions in an account CMS_DTE_SEC_ACC_POS_GUIDRAW16SYSUUID
SEC_ACC_GUIDGUID for securities account CMS_DTE_SEC_ACC_GUIDRAW16SYSUUID
POS_NOSequence Number of a Position in a Securities Account CMS_DTE_SEC_ACC_POS_SEQ_NONUMC4CMS_SEC_POS_ID
POS_OLD_REF_NOID of a Positiion Referenced from an External System CMS_DTE_SEC_ACC_POS_REF_NOCHAR32CMS_SEC_EXT_REFID
ISINUnique ID for a Position in a Securities Account CMS_DTE_SEC_ACC_POS_ISINCHAR20CMS_SEC_POS_ISIN
NO_OF_UNITSNumber of Units in a Securities Position CMS_DTE_SEC_ACC_POS_NO_UNITDEC15(5) CMS_SEC_UNITS
NOMINAL_VALUENominal Value of a Position CMS_DTE_SEC_ACC_POS_NVAL_AMTCURR17(2) CMS_SEC_AMOUNT
NOMINAL_VAL_CURRCurrency of nominal value of a position CMS_DTE_SEC_ACC_POS_NVAL_CURRCUKY5TCURCWAERS
CURRENT_PRICECurrent Price of a Securities Postion per Unit CMS_DTE_SEC_ACC_POS_CP_AMTCURR17(2) CMS_SEC_AMOUNT
CURR_PRICE_CURRCurrency of Current Price of a Securities Position CMS_DTE_SEC_ACC_POS_CP_CURRCUKY5TCURCWAERS
CURR_PRICE_PCTCurrent Price of a Unit of a Securities Position CMS_DTE_SEC_ACC_POS_CP_PCTDEC10(6) CMS_SEC_PCT
CURR_PRICE_ATPosition value recording Timestamp CMS_DTE_SEC_CPRICE_TSTMPSNUMC15TSTPSTZNTSTMPSL
MARKET_VALUEMarket Value of a Securities Position CMS_DTE_SEC_ACC_POS_MKT_VALCURR17(2) CMS_SEC_AMOUNT
MARKET_VAL_CURRCurrency of the Market Value of Securities Positions CMS_DTE_SEC_ACC_POS_MKT_CURRCUKY5TCURCWAERS
CON_MKT_VALMarket Value of a Securities Account Position CMS_DTE_SEC_ACC_POS_CONMKT_VALCURR17(2) CMS_SEC_AMOUNT
CON_MKT_VAL_CURRCurrency of Converted Market Value of Positions CMS_DTE_SEC_POS_CONMKTVAL_CURRCUKY5Assigned to domainWAERS
RISK_CODERisk Code CMS_DTE_SEC_RISK_CODECHAR6TCMS_RISKCODECMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_DTE_SEC_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_DTE_SEC_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_DTE_SEC_SAFETY_AMTCURR17(2) CMS_SEC_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_DTE_SEC_SAFETY_AMT_CURRCUKY5TCURCWAERS
UNIT_VALN_FREQIndicator : Valuation Frequency of Securities Account CMS_DTE_SEC_IND_FREQUENCYCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQPeriod of revaluation for securities CMS_DTE_SEC_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
START_DATEValuation Start date CMS_DTE_SEC_START_DATEDATS8CMS_DATE
END_DATEValuation End date CMS_DTE_SEC_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_DTE_SEC_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_DTE_SEC_LRTE_PCT1DEC10(6) CMS_PCT
LIQD_TYPLiquidation type CMS_DTE_SEC_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate of Liquidation of Collateral CMS_DTE_SEC_LIQD_DATEDATS8CMS_DATE
LIQD_AMTProceeds obtained from liquidation of the collateral CMS_DTE_SEC_LIQD_VALUECURR17(2) CMS_SEC_AMOUNT
LIQD_CURRCurrency of Liquidation value CMS_DTE_SEC_LIQD_CURRCUKY5TCURCWAERS
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3T005LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
CREATED_BYSecurities Add-On User CMS_DTE_SEC_CR_BYCHAR12CMS_USER
CREATED_DATECreated On CMS_DTE_SEC_CR_ONDATS8CMS_DATE
CREATED_TIMECreated At CMS_DTE_SEC_CR_ATTIMS6CMS_TIME
LAST_CHG_BYLast Changed By CMS_DTE_SEC_CH_BYCHAR12CMS_USER
LAST_CHG_DATELast Changed on CMS_DTE_SEC_CH_ONDATS8CMS_DATE
LAST_CHG_TIMELast Changed At CMS_DTE_SEC_CH_ATTIMS6CMS_TIME
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6Assigned to domainCMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
BANK_NAMEName of bank BANKACHAR60TEXT60
SHORT_NAMEShort name of securities ISIN CMS_DTE_SEC_ACC_POS_NAMECHAR40CMS_SEC_NAME

Key field Non-key field



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

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

How to access SAP table CMS_STR_SEC_ACC_POS_AST_SCR

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_SEC_ACC_POS_AST_SCR 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!