SAP Table VWPANLA - Asset master for securities

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
RANL X VVRANLW CHAR 3 13 0 Security ID Number
SANLF SANLF NUMC 16 3 0 TZAF Product Category
SSTATI SEC_STATUS NUMC 19 2 0 Status of a security
RANLALT1 RANLALT1S CHAR 21 13 0 RANLALT1
RANLALT2 RANLALT2S CHAR 34 13 0 Alternative identification 2
GSART VVSART CHAR 47 3 0 TZPA Product Type
SBRSCH BRSCH CHAR 50 4 0 Industry key
SWERTTYP SWERTTYP NUMC 54 1 0 Security Type ID
SBOERNOT SBOERNOT CHAR 55 1 0 Indicator: Listed on an Exchange
WLOMB WLOMB CHAR 56 1 0 Indicator eligible as collateral
JDECK JDECK CHAR 57 1 0 Regulatory reporting BPV (hedge fund Y/N)
WPFAN WPFAN CHAR 58 1 0 Indicator pledgeable
SSTBE SSTBE CHAR 59 1 0 Tax treatment indicator
LOEVM LOEVM CHAR 60 1 0 Deletion Indicator
JABMI JABMI CHAR 61 1 0 Joint partner vote indicator
XALKZ XALKZ CHAR 62 15 0 Short name
XALLB XALLB CHAR 77 60 0 Long name
REPKE REPKE_NEW CHAR 137 10 0 Issuer Identity Key
BEMPREIS BEMPREIS CURR 147 10 2 Issue Price
REWHR REWHR CUKY 153 5 0 TCURC Issue currency
PEMKURS PEMKURS DEC 158 10 7 Issue rate in percent
SNOTI SNOTI NUMC 164 1 0 Quotation Indicator
PKUAB PKUAB DEC 165 10 7 Price deviation in percent
BKUAB BKUAB CURR 171 10 2 Absolute price deviation
DANDPFL DANDPFL DATS 177 8 0 Obligation to offer for sale until
DANDRE DANDRE DATS 185 8 0 Right to offer until
SOBJEKT VVKEYOBJ CHAR 193 10 0 Internal key for object
RERF RERF CHAR 203 12 0 Entered by
DERF DERF DATS 215 8 0 First Entered on
TERF TERF TIMS 223 6 0 Time of Initial Entry
REHER REHER CHAR 229 10 0 Source of initial entry
RBEAR RBEAR CHAR 239 12 0 Employee ID
DBEAR DBEAR DATS 251 8 0 Last Edited on
TBEAR TBEAR TIMS 259 6 0 Last Edited at
RBHER RBHER CHAR 265 10 0 Editing Source
SROLEXT ALWPKL CHAR 275 3 0 General Security Classification
VVSLOEKZ VVSLOEKZ NUMC 278 1 0 Deletion indicator
JMUENDEL VVJMUEND CHAR 279 1 0 Eligibility indicator
SMOVERW SMOVERW CHAR 280 2 0 Possible custody type
SIHERK CHAR2 CHAR 282 2 0 Version Number Component
KBEMPREIS VVKBEMPR DEC 284 15 6 Issue price independent of currency
SDEPOSTAT VVDEPOSTAT NUMC 292 2 0 Securities account statistics key
SFUNDI VVSFUNDI CHAR 294 1 0 Indicator: Funded
SWPHGMPF VVSWPHGMPF CHAR 295 1 0 Securities trading law reporting obligation indicator
RISIN VVRISIN CHAR 296 13 0 International securities ID number (no longer used)
INSTITUTE BP_SOL_INS CHAR 309 4 0 TP07 Institute Providing Credit Standing Information
RATING BP_RATING CHAR 313 3 0 TP06 Rating
PRICE_INDEX TIDX_INDEX_NAME CHAR 316 15 0 TIDX_PRICE_INDEX Name of Price Index

359838Dump in euro analysis progam: EWUTFV02
90300Number ranges in Treasury: overview