SAP ABAP Table VWPDEP1 (Securities account position (VWPDEPO) +add. fields)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR-DE (Application Component) Germany
     ⤷ VVSRG (Package) Statutory Reporting Germany

Basic Data

Table Category	INTTAB	Structure
Structure	VWPDEP1	Table Relationship Diagram
Short Description	Securities account position (VWPDEPO) +add. fields

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	.INCLUDE	☐				0	0	Securities Account Position
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
5	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
6	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
7	XDKBZ	☐	XDKBZ	XKBEZ	CHAR	15	0	Sec.acct position short description
8	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
9	SVERWA	☐	SVERWA	SVERWA	CHAR	1	0	Custody type	*
10	DANDPFL	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
11	DANDRE	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
12	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
13	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
14	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
15	JSPRI	☐	JSPRI	JANEI	CHAR	1	0	Intercorporate privilege indicator
16	JBTEI	☐	JBTEI	JANEI	CHAR	1	0	Shareholding indicator
17	RFGEB	☐	RFGEB_NEW	BU_PARTNER	CHAR	10	0	Releaser of master record (person)	*
18	DFREI	☐	DFREI	DATUM	DATS	8	0	Date of release
19	TFREI	☐	TFREI	TIMES	TIMS	6	0	Time of release
20	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
21	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
22	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
24	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
25	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
26	TBHER	☐	TBHER	TBHER	CHAR	1	0	Origin indicator for table
27	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
28	SBESANT	☐	SBESANT	SBESANT	CHAR	2	0	Holding	TZBA
29	JBETEIL	☐	JBETEIL	JANEI	CHAR	1	0	Shareholding indicator
30	VVSLOEKZ	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
31	SKWG14NEU	☐	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
32	SMOVERW	☐	TB_SVERWA	SMOVERW	CHAR	2	0	Custody type	TW50
33	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
34	DERIV_CAT	☐	TPM_DERIV_CAT	TPM_DERIV_CAT	NUMC	3	0	Position management procedure
35	DGUELAB	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
36	DGUELBIS	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
37	JZUGANG	☐	JARW	JANEI	CHAR	1	0	*** Not used ***
38	JABGANG	☐	JARW	JANEI	CHAR	1	0	*** Not used ***

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VWPDEP1	BUKRS	T001	BUKRS
2	VWPDEP1	MANDT	T000	MANDT
3	VWPDEP1	RANL	VWPANLA	RANL
4	VWPDEP1	RLDEPO	TWD01	RLDEPO	KEY	1	CN
5	VWPDEP1	RREFKONT	T037S	RREFKONT
6	VWPDEP1	SBESANT	TZBA	SBESANT
7	VWPDEP1	SBILK	TW11	SBILK
8	VWPDEP1	SFIBG	TW08	SFIBG
9	VWPDEP1	SGLZB	TW07	SGLZB
10	VWPDEP1	SMOVERW	TW50	SMOVERW	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in