SAP ABAP Table VALV_SP_VAL_SEC (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | VALV_SP_VAL_SEC |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | KEY_DATE |
TPM_VAL_KEYDATE | DATUM | DATS | 8 | 0 | Key Date for Valuation | ||
| 3 | VALUATION_AREA |
TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | TRGC_VAL_AREA | |
| 4 | VALUATION_CLASS |
TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | TRGC_VAL_CLASS | |
| 5 | COMPANY_CODE |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 6 | SECURITY_ACCOUNT |
RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
| 7 | SECURITY_ID |
VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | VWPANLA | |
| 8 | PRICE_TYPE |
TI_KURSART | VVSKURSART | CHAR | 2 | 0 | Rate/Price Type - Treasury Instruments | TW56 | |
| 9 | PORTFOLIO |
RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
| 10 | ACCOUNT_GROUP |
TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | TRGT_SECACCGRP | |
| 11 | LOANS_CONTRACT |
RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
| 12 | OKUART |
TV_OKUART | T_OKUART | CHAR | 3 | 0 | Price/NPV type for OTC transactions | ATVOK | |
| 13 | LOT_ID |
TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
| 14 | SP_VAL_SEC_CAT |
TPM_SP_VAL_SEC_CAT | TPM_SP_VAL_SEC_CAT | CHAR | 1 | 0 | Special Valuation Category | ||
| 15 | SECURITY_PRICE |
VVPKTKUR | VVPKTKUR | DEC | 15 | 6 | Price of Unit- or Percentage-Quoted Security | ||
| 16 | PRICE_CURR |
VVNOTWAERS | WAERS | CUKY | 5 | 0 | Quotation currency (which prices are in) | TCURC | |
| 17 | PRESENT_VALUE |
TV_BARWERT | WERTV8_TR | CURR | 15 | 2 | Net present value of OTC transaction | ||
| 18 | PV_CURR |
TV_WBARWE | WAERS | CUKY | 5 | 0 | Currency of net present value |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | VALV_SP_VAL_SEC | ACCOUNT_GROUP |  TRGT_SECACCGRP |
SEC_ACCT_GRP |
KEY | ||
| 2 | VALV_SP_VAL_SEC | COMPANY_CODE | T001 |
BUKRS |
KEY | ||
| 3 | VALV_SP_VAL_SEC | MANDT | T000 |
MANDT |
KEY | ||
| 4 | VALV_SP_VAL_SEC | OKUART | ATVOK |
OKUART |
|||
| 5 | VALV_SP_VAL_SEC | PORTFOLIO | TWPOB |
RPORTB |
KEY | ||
| 6 | VALV_SP_VAL_SEC | PRICE_CURR | TCURC |
WAERS |
|||
| 7 | VALV_SP_VAL_SEC | PRICE_TYPE | TW56 |
SKURSART |
KEY | ||
| 8 | VALV_SP_VAL_SEC | SECURITY_ACCOUNT | TWD01 |
RLDEPO |
KEY | ||
| 9 | VALV_SP_VAL_SEC | SECURITY_ID | VWPANLA |
RANL |
KEY | ||
| 10 | VALV_SP_VAL_SEC | VALUATION_AREA | TRGC_VAL_AREA |
VALUATION_AREA |
|||
| 11 | VALV_SP_VAL_SEC | VALUATION_CLASS | TRGC_VAL_CLASS |
VALUATION_CLASS |
KEY |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
