SAP VALT_SP_VAL_SEC Security Prices and NPV for Special Valuation Table
Overview
VALT_SP_VAL_SEC is a standard SAP S/4HANA table that stores Security Prices and NPV for Special Valuation data. There are total 22 fields in the VALT_SP_VAL_SEC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VALT_SP_VAL_SEC belongs to Transfer to Financial Accounting (FIN-FSCM-TRM-TM-AC) module and is located in the package Treasury: General Valuation (FTR_VALUATION).
In addition, following links provide an overview of foreign key relationships, if any, that link VALT_SP_VAL_SEC to other SAP tables and standard CDS views available based on VALT_SP_VAL_SEC table in S/4HANA 2020.
Techincal Settings of VALT_SP_VAL_SEC
Below are technical details of the table VALT_SP_VAL_SEC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VALT_SP_VAL_SEC Fields
The following table gives you an overview of the fields available in VALT_SP_VAL_SEC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VALUATION_AREA | Treasury Valuation Area | TPM_VAL_AREA | TRGC_VAL_AREA | CHAR | 3 |
| VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | TRGC_VAL_CLASS | NUMC | 4 |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 |
| SECURITY_ACCOUNT | Securities Account | RLDEPO | TWD01 | CHAR | 10 |
| SECURITY_ID | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| PORTFOLIO | Portfolio | RPORTB | TWPOB | CHAR | 10 |
| ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | TRGT_SECACCGRP | CHAR | 10 |
| LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | |
| KEY_DATE | Key Date for Valuation | TPM_VAL_KEYDATE | DATS | 8 | |
| PRICE_TYPE | Rate/Price Type - Treasury Instruments | TI_KURSART | TW56 | CHAR | 2 |
| OKUART | Price/NPV Type for OTC Transactions | TV_OKUART | ATVOK | CHAR | 3 |
| LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | |
| FUND | Fund | FM_FUND | * | CHAR | 10 |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| SP_VAL_SEC_CAT | Special Valuation Category | TPM_SP_VAL_SEC_CAT | CHAR | 1 | |
| PRICE_CURR | Quotation currency (which prices are in) | VVNOTWAERS | TCURC | CUKY | 5 |
| SECURITY_PRICE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15 | |
| PRESENT_VALUE | NPV in Transaction Currency for Special Valuation | TPM_PRES_VAL_FOR_AMT | CURR | 15 | |
| PV_CURR | Transaction Currency | TPM_FOREIGN_CURR | TCURC | CUKY | 5 |
| PV_VAL_AMT | NPV in Valuation Currency for Special Valuation | TPM_PRES_VAL_VAL_AMT | CURR | 15 | |
| PV_VAL_CURR | Valuation Currency | TPM_VALUATION_CURR | TCURC | CUKY | 5 |
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 VALT_SP_VAL_SEC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VALT_SP_VAL_SEC | ACCOUNT_GROUP | : | TRGT_SECACCGRP |
| VALT_SP_VAL_SEC | COMPANY_CODE | : | T001 |
| VALT_SP_VAL_SEC | MANDT | : | T000 |
| VALT_SP_VAL_SEC | OKUART | : | ATVOK |
| VALT_SP_VAL_SEC | PORTFOLIO | : | TWPOB |
| VALT_SP_VAL_SEC | PRICE_CURR | : | TCURC |
| VALT_SP_VAL_SEC | PRICE_TYPE | : | TW56 |
| VALT_SP_VAL_SEC | PV_CURR | : | TCURC |
| VALT_SP_VAL_SEC | PV_VAL_CURR | : | TCURC |
| VALT_SP_VAL_SEC | SECURITY_ACCOUNT | : | TWD01 |
| VALT_SP_VAL_SEC | SECURITY_ID | : | VWPANLA |
| VALT_SP_VAL_SEC | VALUATION_AREA | : | TRGC_VAL_AREA |
| VALT_SP_VAL_SEC | VALUATION_CLASS | : | TRGC_VAL_CLASS |