SAP Table VALT_SP_VAL_SEC
Security Prices and NPV for Special Valuation
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table VALT_SP_VAL_SEC (Security Prices and NPV for Special Valuation) is a standard table in SAP ERP. It belongs to the package FTR_VALUATION.
Technical Information
| Table | VALT_SP_VAL_SEC |
| Short Text | Security Prices and NPV for Special Valuation |
| Package | FTR_VALUATION |
| Table Type | Transparent Table |
Fields for Table VALT_SP_VAL_SEC
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| VALUATION_AREA | ✔ | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA |
| VALUATION_CLASS | ✔ | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS |
| COMPANY_CODE | ✔ | Company Code | BUKRS | CHAR | 4 | T001 |
| SECURITY_ACCOUNT | ✔ | Securities Account | RLDEPO | CHAR | 10 | TWD01 |
| SECURITY_ID | ✔ | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA |
| PORTFOLIO | ✔ | Portfolio | RPORTB | CHAR | 10 | TWPOB |
| ACCOUNT_GROUP | ✔ | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP |
| 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 | CHAR | 2 | TW56 |
| OKUART | ✔ | Price/NPV Type for OTC Transactions | TV_OKUART | CHAR | 3 | ATVOK |
| 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 | CUKY | 5 | TCURC | |
| 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 | 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 | CUKY | 5 | * |