SAP table VWPANLA (Asset master for securities)

SAP table VWPANLA has 2 primary key fields being MANDT,RANL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VWPANLA foreign key relationships

Table Field Check Table Check Field
0 VWPANLA GSART TZPA Financial Assets Management Product Types MANDT
0 VWPANLA GSART TZPA Financial Assets Management Product Types GSART
1 VWPANLA INSTITUTE TP07 Business Partner: Credit Rating Institute SOL_INS
0 VWPANLA MANDT T000 Clients MANDT
1 VWPANLA PRICE_INDEX TIDX_PRICE_INDEX Price Index Main Entity MANDT
0 VWPANLA RATING TP06 Business Partner: Rating MANDT
0 VWPANLA RATING TP06 Business Partner: Rating RATING
1 VWPANLA REWHR TCURC Currency Codes MANDT
1 VWPANLA REWHR TCURC Currency Codes WAERS
0 VWPANLA SANLF TZAF Product categories SANLF
1 VWPANLA SBRSCH T016 Industries BRSCH
0 VWPANLA SDEPOSTAT TW51 Securities Account Statistics Key MANDT
0 VWPANLA SDEPOSTAT TW51 Securities Account Statistics Key SDEPOSTAT
1 VWPANLA SMOVERW TW50 Table for possible deposit types MANDT
1 VWPANLA SMOVERW TW50 Table for possible deposit types SMOVERW
0 VWPANLA SROLEXT TW22 Securities classification MANDT
1 VWPANLA SWERTTYP TW20 Security category SWERTTYP