Menu

SAP Table VWPANLA

Asset master for securities

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 VWPANLA (Asset master for securities) is a standard table in SAP ERP. It belongs to the package FVVW_CORE.

Technical Information

Table VWPANLA
Short Text Asset master for securities
Package FVVW_CORE
Table Type Transparent Table

Fields for Table VWPANLA

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
RANL Security ID Number VVRANLW CHAR 13
SANLF Product Category SANLF NUMC 3 TZAF
SSTATI Status of a security SEC_STATUS NUMC 2
RANLALT1 RANLALT1 RANLALT1S CHAR 13
RANLALT2 Alternative identification 2 RANLALT2S CHAR 13
GSART Product Type VVSART CHAR 3 TZPA
SBRSCH Industry key BRSCH CHAR 4 T016
SWERTTYP Security Type ID SWERTTYP NUMC 1 TW20
SBOERNOT Indicator: Listed on an Exchange SBOERNOT CHAR 1
WLOMB Indicator eligible as collateral WLOMB CHAR 1
JDECK Regulatory reporting BPV (hedge fund Y/N) JDECK CHAR 1
WPFAN Indicator pledgeable WPFAN CHAR 1
SSTBE Tax treatment indicator SSTBE CHAR 1
LOEVM Deletion Indicator LOEVM CHAR 1
JABMI Joint partner vote indicator JABMI CHAR 1
XALKZ Short name XALKZ CHAR 15
XALLB Long name XALLB CHAR 60
REPKE Issuer Identity Key REPKE_NEW CHAR 10 *
BEMPREIS Issue Price BEMPREIS CURR 10
REWHR Issue currency REWHR CUKY 5 TCURC
PEMKURS Issue rate in percent PEMKURS DEC 10
SNOTI Quotation Indicator SNOTI NUMC 1
PKUAB Price deviation in percent PKUAB DEC 10
BKUAB Absolute price deviation BKUAB CURR 10
DANDPFL Obligation to offer for sale until DANDPFL DATS 8
DANDRE Right to offer until DANDRE DATS 8
SOBJEKT Internal key for object VVKEYOBJ CHAR 10
RERF Entered by RERF CHAR 12
DERF First Entered on DERF DATS 8
TERF Time of Initial Entry TERF TIMS 6
REHER Source of initial entry REHER CHAR 10
RBEAR Employee ID RBEAR CHAR 12
DBEAR Last Edited on DBEAR DATS 8
TBEAR Last Edited at TBEAR TIMS 6
RBHER Editing Source RBHER CHAR 10
SROLEXT General Security Classification ALWPKL CHAR 3 TW22
VVSLOEKZ Deletion indicator VVSLOEKZ NUMC 1
JMUENDEL Eligibility indicator VVJMUEND CHAR 1
SMOVERW Possible custody type SMOVERW CHAR 2 TW50
SIHERK Version Number Component CHAR2 CHAR 2
KBEMPREIS Issue price independent of currency VVKBEMPR DEC 15
SDEPOSTAT Securities account statistics key VVDEPOSTAT NUMC 2 TW51
SFUNDI Indicator: Funded VVSFUNDI CHAR 1
SWPHGMPF Securities trading law reporting obligation indicator VVSWPHGMPF CHAR 1
RISIN International securities ID number (no longer used) VVRISIN CHAR 13
INSTITUTE Institute Providing Credit Standing Information BP_SOL_INS CHAR 4 TP07
RATING Rating BP_RATING CHAR 3 TP06
PRICE_INDEX Name of Price Index TIDX_INDEX_NAME CHAR 15 TIDX_PRICE_INDEX
PRICE_IDX_BDATE Price Index Base Date TIDX_INDEX_BASE_DATE DATS 8