SAP Table CMS_SEC_ACC_POS
Securities position details
Unsere Literaturempfehlung
IDoc-Entwicklung für SAP: Customizing, Erweiterung, Eigenentwicklung
Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.
Bei amazon.de ansehen →
The table CMS_SEC_ACC_POS (Securities position details) is a standard table in SAP ERP. It belongs to the package CMS_SEC.
Technical Information
| Table | CMS_SEC_ACC_POS |
| Short Text | Securities position details |
| Package | CMS_SEC |
| Table Type | Transparent Table |
Fields for Table CMS_SEC_ACC_POS
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| SEC_ACC_POS_GUID | ✔ | GUID for securities positions in an account | CMS_DTE_SEC_ACC_POS_GUID | RAW | 16 | |
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | RAW | 16 | ||
| POS_NO | Sequence Number of a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_SEQ_NO | NUMC | 4 | ||
| POS_OLD_REF_NO | ID of a Positiion Referenced from an External System | CMS_DTE_SEC_ACC_POS_REF_NO | CHAR | 32 | ||
| ISIN | Unique ID for a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_ISIN | CHAR | 20 | ||
| NO_OF_UNITS | Number of Units in a Securities Position | CMS_DTE_SEC_ACC_POS_NO_UNIT | DEC | 15 | ||
| NOMINAL_VALUE | Nominal Value of a Position | CMS_DTE_SEC_ACC_POS_NVAL_AMT | CURR | 17 | ||
| NOMINAL_VAL_CURR | Currency of nominal value of a position | CMS_DTE_SEC_ACC_POS_NVAL_CURR | CUKY | 5 | TCURC | |
| CURRENT_PRICE | Current Price of a Securities Postion per Unit | CMS_DTE_SEC_ACC_POS_CP_AMT | CURR | 17 | ||
| CURR_PRICE_CURR | Currency of Current Price of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_CURR | CUKY | 5 | TCURC | |
| CURR_PRICE_PCT | Current Price of a Unit of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_PCT | DEC | 10 | ||
| CURR_PRICE_AT | Position value recording Timestamp | CMS_DTE_SEC_CPRICE_TSTMPS | NUMC | 15 | ||
| MARKET_VALUE | Market Value of a Securities Position | CMS_DTE_SEC_ACC_POS_MKT_VAL | CURR | 17 | ||
| MARKET_VAL_CURR | Currency of the Market Value of Securities Positions | CMS_DTE_SEC_ACC_POS_MKT_CURR | CUKY | 5 | TCURC | |
| CON_MKT_VAL | Market Value of a Securities Account Position | CMS_DTE_SEC_ACC_POS_CONMKT_VAL | CURR | 17 | ||
| CON_MKT_VAL_CURR | Currency of Converted Market Value of Positions | CMS_DTE_SEC_POS_CONMKTVAL_CURR | CUKY | 5 | * | |
| RISK_CODE | Risk Code | CMS_DTE_SEC_RISK_CODE | CHAR | 6 | TCMS_RISKCODE | |
| SFTY_IND | Indicates that the asset has a default sfty discount or not | CMS_DTE_SEC_IND_SFTY_DISC | CHAR | 2 | ||
| SFTY_DSCNT | Safety discount | CMS_DTE_SEC_SAFETY_DSCNT | DEC | 10 | ||
| SFTY_AMOUNT | Safety discount as an amount | CMS_DTE_SEC_SAFETY_AMT | CURR | 17 | ||
| SFTY_AMT_CURR | Currency of the Safety discount amount | CMS_DTE_SEC_SAFETY_AMT_CURR | CUKY | 5 | TCURC | |
| LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | CMS_DTE_SEC_IND_LND_RTE | CHAR | 2 | ||
| LENDING_RATE1 | Lending rate 1 | CMS_DTE_SEC_LRTE_PCT1 | DEC | 10 | ||
| LIQD_TYP | Liquidation type | CMS_DTE_SEC_LIQD_TYP | CHAR | 6 | ||
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CHAR | 6 | ||
| LIQD_DATE | Date of Liquidation of Collateral | CMS_DTE_SEC_LIQD_DATE | DATS | 8 | ||
| LIQD_AMT | Proceeds obtained from liquidation of the collateral | CMS_DTE_SEC_LIQD_VALUE | CURR | 17 | ||
| LIQD_CURR | Currency of Liquidation value | CMS_DTE_SEC_LIQD_CURR | CUKY | 5 | TCURC | |
| CREATED_BY | Securities Add-On User | CMS_DTE_SEC_CR_BY | CHAR | 12 | ||
| CREATED_DATE | Created On | CMS_DTE_SEC_CR_ON | DATS | 8 | ||
| CREATED_TIME | Created At | CMS_DTE_SEC_CR_AT | TIMS | 6 | ||
| LAST_CHG_BY | Last Changed By | CMS_DTE_SEC_CH_BY | CHAR | 12 | ||
| LAST_CHG_DATE | Last Changed on | CMS_DTE_SEC_CH_ON | DATS | 8 | ||
| LAST_CHG_TIME | Last Changed At | CMS_DTE_SEC_CH_AT | TIMS | 6 |