SAP ABAP Table VWPANLA (Asset master for securities)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ TR (Application Component) Treasury
     ⤷ FVVW_CORE (Package) TR-CORE: Former Objects from FVVW (TR-TM: Securities)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VWPANLA	Table Relationship Diagram
Short Description	Asset master for securities

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RANL	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number
3	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
4	SSTATI	☐	SEC_STATUS	SEC_STATUS	NUMC	2	0	Status of a security
5	RANLALT1	☐	RANLALT1S	CHAR13S	CHAR	13	0	RANLALT1
6	RANLALT2	☐	RANLALT2S	CHAR13S	CHAR	13	0	Alternative identification 2
7	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
8	SBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
9	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
10	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
11	WLOMB	☐	WLOMB	JANEI	CHAR	1	0	Indicator eligible as collateral
12	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
13	WPFAN	☐	WPFAN	JANEI	CHAR	1	0	Indicator pledgeable
14	SSTBE	☐	SSTBE	JANEI	CHAR	1	0	Tax treatment indicator
15	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
16	JABMI	☐	JABMI	JANEI	CHAR	1	0	Joint partner vote indicator
17	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
18	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
19	REPKE	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key	*
20	BEMPREIS	☐	BEMPREIS	VVBNENNW	CURR	10	2	Issue Price
21	REWHR	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
22	PEMKURS	☐	PEMKURS	DEC3_7	DEC	10	7	Issue rate in percent
23	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
24	PKUAB	☐	PKUAB	DEC3_7	DEC	10	7	Price deviation in percent
25	BKUAB	☐	BKUAB	WHRBTRG	CURR	10	2	Absolute price deviation
26	DANDPFL	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
27	DANDRE	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
28	SOBJEKT	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
29	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
30	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
31	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
32	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
33	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
34	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
35	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
36	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
37	SROLEXT	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
38	VVSLOEKZ	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
39	JMUENDEL	☐	VVJMUEND	JANEI	CHAR	1	0	Eligibility indicator
40	SMOVERW	☐	SMOVERW	SMOVERW	CHAR	2	0	Possible custody type	TW50
41	SIHERK	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
42	KBEMPREIS	☐	VVKBEMPR	VVKWKURS	DEC	15	6	Issue price independent of currency
43	SDEPOSTAT	☐	VVDEPOSTAT	VVDEPOSTA	NUMC	2	0	Securities account statistics key	TW51
44	SFUNDI	☐	VVSFUNDI	JANEI	CHAR	1	0	Indicator: Funded
45	SWPHGMPF	☐	VVSWPHGMPF	JANEI	CHAR	1	0	Securities trading law reporting obligation indicator
46	RISIN	☐	VVRISIN	RISIN	CHAR	13	0	International securities ID number (no longer used)
47	INSTITUTE	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
48	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
49	PRICE_INDEX	☐	TIDX_INDEX_NAME	TIDX_INDEX_NAME	CHAR	15	0	Name of Price Index	TIDX_PRICE_INDEX
50	PRICE_IDX_BDATE	☐	TIDX_INDEX_BASE_DATE	DATPER	DATS	8	0	Price Index Base Date
51	.INCLU--AP	☐				0	0	Append for VWPANLA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VWPANLA	GSART	TZPA	GSART	KEY	1	CN
2	VWPANLA	INSTITUTE	TP07	SOL_INS
3	VWPANLA	MANDT	T000	MANDT	KEY	1	1
4	VWPANLA	PRICE_INDEX	TIDX_PRICE_INDEX	INDEX_NAME	REF	C	CN
5	VWPANLA	RATING	TP06	RATING
6	VWPANLA	REWHR	TCURC	WAERS	KEY	1	1
7	VWPANLA	SANLF	TZAF	SANLF	KEY	1	CN
8	VWPANLA	SBRSCH	T016	BRSCH	KEY	1	1
9	VWPANLA	SDEPOSTAT	TW51	SDEPOSTAT	REF	C	CN
10	VWPANLA	SMOVERW	TW50	SMOVERW	KEY	1	CN
11	VWPANLA	SROLEXT	TW22	ALWPKL	REF	C	CN
12	VWPANLA	SWERTTYP	TW20	SWERTTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in