VWPANLA

Asset master for securities | #masterdata | Component: Transaction Manager
Column Name Description
MANDT FK Client
RANL Security Class ID Number
Column Name Description
💲 Issue Currency (REWHR):
BEMPREIS Issue Price
BKUAB Absolute price deviation
Column Name Description
Column Name Description
DANDPFL Obligation to offer for sale until
DANDRE Right to offer until
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
PRICE_IDX_BDATE Price Index Base Date
Column Name Description
SSTATI Status of a Security Show values
SBOERNOT Indicator: Listed on an Exchange Show values
WLOMB Indicator eligible as collateral Show values
JDECK Regulatory reporting BPV (hedge fund Y/N) Show values
WPFAN Indicator pledgeable Show values
SSTBE Tax Treatment Indicator Show values
LOEVM Deletion Indicator Show values
JABMI Joint partner vote indicator Show values
SNOTI Quotation Indicator Show values
VVSLOEKZ Deletion indicator Show values
JMUENDEL Eligibility indicator Show values
SFUNDI Indicator: Funded Show values
SWPHGMPF Securities trading law reporting obligation indicator Show values
SFIMAMETHOD Cash Flow Calculation Show values
Column Name Description Domain name
RANLALT1 RANLALT1 CHAR13S
RANLALT2 Alternative identification 2 CHAR13S
XALKZ Short Name XKBEZ
XALLB Long Name XLBEZ
REPKE Issuer Identity Key BU_PARTNER
PEMKURS Issue rate in percent DEC3_7
PKUAB Price deviation in percent DEC3_7
SOBJEKT Internal key for object VVKEY
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SIHERK Component of the Version Number CHAR2
KBEMPREIS Issue price independent of currency VVKWKURS
RISIN International securities ID number (no longer used) RISIN
COICODE Complementary Identification Code
COILAND Complementary Identification Country/Region
Master Data Relations Join Conditions
Product Type
  • Product Type
  • Client
  • VWPANLA.GSART == TZPA.GSART
  • VWPANLA.MANDT == TZPA.MANDT
Institute Providing Credit Standing Information
  • Institute Providing Credit Standing Information
  • Client
  • VWPANLA.INSTITUTE == TP07.SOL_INS
  • VWPANLA.MANDT == TP07.MANDT
Client VWPANLA.MANDT == T000.MANDT
Rating
  • VWPANLA.MANDT == TP06.MANDT
  • VWPANLA.RATING == TP06.RATING
Issue Currency
  • VWPANLA.MANDT == TCURC.MANDT
  • VWPANLA.REWHR == TCURC.WAERS
Product Category VWPANLA.SANLF == TZAF.SANLF
Industry key
  • Industry key
  • Client
  • VWPANLA.SBRSCH == T016.BRSCH
  • VWPANLA.MANDT == T016.MANDT
Securities Account Statistics Key
  • Securities account statistics key
  • Client
  • VWPANLA.SDEPOSTAT == TW51.SDEPOSTAT
  • VWPANLA.MANDT == TW51.MANDT
Possible custody type
  • VWPANLA.MANDT == TW50.MANDT
  • VWPANLA.SMOVERW == TW50.SMOVERW
General Security Classification
  • VWPANLA.MANDT == TW22.MANDT
  • VWPANLA.SROLEXT == TW22.ALWPKL
Security Type ID
  • VWPANLA.MANDT == TW20.MANDT
  • VWPANLA.SWERTTYP == TW20.SWERTTYP
Other Relations | to Master Data Relations ↑ Join Conditions
Treasury Index Name
  • Name of Price Index
  • Client