SAP ACE_SOP_SCRT_SEC Hypothetical Security Price Performance for Simulation Table
Overview
ACE_SOP_SCRT_SEC is a standard SAP S/4HANA table that stores Hypothetical Security Price Performance for Simulation data. There are total 6 fields in the ACE_SOP_SCRT_SEC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACE_SOP_SCRT_SEC belongs to Provisions for Awards (FI-GL-GL-SOA) module and is located in the package Stock Option Accounting (FI-SOA).
In addition, following links provide an overview of foreign key relationships, if any, that link ACE_SOP_SCRT_SEC to other SAP tables and standard CDS views available based on ACE_SOP_SCRT_SEC table in S/4HANA 2020.
Techincal Settings of ACE_SOP_SCRT_SEC
Below are technical details of the table ACE_SOP_SCRT_SEC
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of ACE_SOP_SCRT_SEC Fields
The following table gives you an overview of the fields available in ACE_SOP_SCRT_SEC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| VERSN | Version of the Price Performance of a Stock | ACE_SOP_CHART_VERSN | ACE_SOP_VERSNS | CHAR | 3 |
| SECURITY_ID | Security Identification Number | ACE_SOP_SECURITY_ID | VWPANLA | CHAR | 13 |
| PRICEDATE | Price Date | ACE_SOP_RATE_DATE | DATS | 8 | |
| CURRENCY | Quotation Currency | ACE_SOP_RATE_CURRENCY | TCURC | CUKY | 5 |
| PRICE | Security Price | ACE_SOP_SECURITY_PRICE | DEC | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACE_SOP_SCRT_SEC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ACE_SOP_SCRT_SEC | CURRENCY | : | TCURC |
| ACE_SOP_SCRT_SEC | SECURITY_ID | : | VWPANLA |
| ACE_SOP_SCRT_SEC | VERSN | : | ACE_SOP_VERSNS |