VALT_SP_VAL_SEC - Security Prices and NPV for Special Valuation
Security Prices and NPV for Special Valuation information is stored in SAP table VALT_SP_VAL_SEC.
It is part of development package FTR_VALUATION in software component FIN-FSCM-TRM-TM-AC. This development package consists of objects that can be grouped under "Treasury: General Valuation".
It is part of development package FTR_VALUATION in software component FIN-FSCM-TRM-TM-AC. This development package consists of objects that can be grouped under "Treasury: General Valuation".
Fields for table VALT_SP_VAL_SEC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| VALUATION_AREA | Treasury Valuation Area | X | TPM_VAL_AREA | CHAR | 6 | TRGC_VAL_AREA |
| VALUATION_CLASS | Valuation Class | X | TPM_VAL_CLASS | NUMC | 8 | TRGC_VAL_CLASS |
| COMPANY_CODE | Company Code | X | BUKRS | CHAR | 8 | T001 |
| SECURITY_ACCOUNT | Securities Account | X | RLDEPO | CHAR | 20 | TWD01 |
| SECURITY_ID | Security Class ID Number | X | VVRANLW | CHAR | 26 | VWPANLA |
| PORTFOLIO | Portfolio | X | RPORTB | CHAR | 20 | TWPOB |
| ACCOUNT_GROUP | Securities Account Group | X | TPM_SEC_ACCT_GRP | CHAR | 20 | TRGT_SECACCGRP |
| LOANS_CONTRACT | Contract Number | X | RANL | CHAR | 26 | |
| KEY_DATE | Key Date for Valuation | X | TPM_VAL_KEYDATE | DATS | 16 | |
| PRICE_TYPE | Rate/Price Type - Treasury Instruments | X | TI_KURSART | CHAR | 4 | TW56 |
| OKUART | Price/NPV Type for OTC Transactions | X | TV_OKUART | CHAR | 6 | ATVOK |
| LOT_ID | Identifier of the Lot | X | TPM_LOT_ID | RAW | 16 | |
| FUND | Fund | X | FM_FUND | CHAR | 20 | * |
| GRANT_NBR | Grant | X | GM_GRANT_NBR | CHAR | 40 | |
| SP_VAL_SEC_CAT | Special Valuation Category | TPM_SP_VAL_SEC_CAT | CHAR | 2 | ||
| PRICE_CURR | Quotation currency (which prices are in) | VVNOTWAERS | CUKY | 10 | TCURC | |
| SECURITY_PRICE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 8 | ||
| PRESENT_VALUE | NPV in Transaction Currency for Special Valuation | TPM_PRES_VAL_FOR_AMT | CURR | 8 | ||
| PV_CURR | Transaction Currency | TPM_FOREIGN_CURR | CUKY | 10 | TCURC | |
| PV_VAL_AMT | NPV in Valuation Currency for Special Valuation | TPM_PRES_VAL_VAL_AMT | CURR | 8 | ||
| PV_VAL_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 10 | TCURC |