VWPANLA - Asset master for securities
Asset master for securities information is stored in SAP table VWPANLA.
It is part of development package FVVW_CORE in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "TR-CORE: Former Objects from FVVW (TR-TM: Securities)".
It is part of development package FVVW_CORE in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "TR-CORE: Former Objects from FVVW (TR-TM: Securities)".
Fields for table VWPANLA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| RANL | Security Class ID Number | X | VVRANLW | CHAR | 26 | |
| SANLF | Product Category | SANLF | NUMC | 6 | TZAF | |
| SSTATI | Status of a Security | SEC_STATUS | NUMC | 4 | ||
| RANLALT1 | RANLALT1 | RANLALT1S | CHAR | 26 | ||
| RANLALT2 | Alternative identification 2 | RANLALT2S | CHAR | 26 | ||
| GSART | Product Type | VVSART | CHAR | 6 | TZPA | |
| SBRSCH | Industry key | BRSCH | CHAR | 8 | T016 | |
| SWERTTYP | Security Type ID | SWERTTYP | NUMC | 2 | TW20 | |
| SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 2 | ||
| WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 2 | ||
| JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 2 | ||
| WPFAN | Indicator pledgeable | WPFAN | CHAR | 2 | ||
| SSTBE | Tax Treatment Indicator | SSTBE | CHAR | 2 | ||
| LOEVM | Deletion Indicator | LOEVM | CHAR | 2 | ||
| JABMI | Joint partner vote indicator | JABMI | CHAR | 2 | ||
| XALKZ | Short Name | XALKZ | CHAR | 30 | ||
| XALLB | Long Name | XALLB | CHAR | 120 | ||
| REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 20 | ||
| BEMPREIS | Issue Price | BEMPREIS | CURR | 6 | ||
| REWHR | Issue Currency | REWHR | CUKY | 10 | TCURC | |
| PEMKURS | Issue rate in percent | PEMKURS | DEC | 6 | ||
| SNOTI | Quotation Indicator | SNOTI | NUMC | 2 | ||
| PKUAB | Price deviation in percent | PKUAB | DEC | 6 | ||
| BKUAB | Absolute price deviation | BKUAB | CURR | 6 | ||
| DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 16 | ||
| DANDRE | Right to offer until | DANDRE | DATS | 16 | ||
| SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 20 | ||
| RERF | Entered By | RERF | CHAR | 24 | ||
| DERF | First Entered On | DERF | DATS | 16 | ||
| TERF | Time of Creation | TERF | TIMS | 12 | ||
| REHER | Source of Initial Entry | REHER | CHAR | 20 | ||
| RBEAR | Employee ID | RBEAR | CHAR | 24 | ||
| DBEAR | Last Edited On | DBEAR | DATS | 16 | ||
| TBEAR | Last Edited At | TBEAR | TIMS | 12 | ||
| RBHER | Editing Source | RBHER | CHAR | 20 | ||
| SROLEXT | General Security Classification | ALWPKL | CHAR | 6 | TW22 | |
| VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 2 | ||
| JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 2 | ||
| SMOVERW | Possible custody type | SMOVERW | CHAR | 4 | TW50 | |
| SIHERK | Component of the Version Number | CHAR2 | CHAR | 4 | ||
| KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 8 | ||
| SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | NUMC | 4 | TW51 | |
| SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 2 | ||
| SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 2 | ||
| RISIN | International securities ID number (no longer used) | VVRISIN | CHAR | 26 | ||
| INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | CHAR | 8 | TP07 | |
| RATING | Rating | BP_RATING | CHAR | 6 | TP06 | |
| PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | CHAR | 30 | TIDX_PRICE_INDEX | |
| PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 16 | ||
| COICODE | Complementary Identification Code | COICODE | CHAR | 4 | ||
| COILAND | Complementary Identification Country/Region | COILAND | CHAR | 4 | ||
| SFIMAMETHOD | Cash Flow Calculation | VVSFIMAMETHOD | CHAR | 2 | ||
| .INCLU--AP | VWPANLA_CFM | 0 |