VZBAVF_AEND

null | #other | Component: Germany

🔑 Keys (3)
💰 Amounts (3)
∑ Quantities
📅 Dates (3)
☰ Categorical (12)
Other (3)
🔗 Relations (20)

Column Name	Description
MANDT FK	Client
RANTYP	Contract Type	Show values
VVKEY	DARWIN universal key (no client)

Column Name	Description
💲 Currency of accepted value_FISO (SAWHR):
BARWBAV	BAV accepted value
💲 Market value currency_FISO (SVWHR):
BVWERT	Current market value_BAV
💲 Currency of accepted value_VV (SAWHR_VU):
BARW_VU	Accepted value_VU

Column Name	Description

Column Name	Description
DBAVGEN	Date of BAV authorization
DARWGEN	Date for fixing the accepted value
DERWMEL	Date when the acquistion was reported to FISO

Column Name	Description
RANTYP	Contract Type	Show values
JDECK	Regulatory reporting BPV (hedge fund Y/N)	Show values
JBAVG	BAV approval	Show values
JARW	* Not used *	Show values
XR5_91_1	Indicator R5/91, appendix 1	Show values
XR5_91_2	Indicator R5/91, appendix 1	Show values
XR5_91_3	Indicator R5/91, appendix 3	Show values
XTREU	* Internal usage *	Show values
XDECK	Indicator for eligibility for premium reserve fund	Show values
XARW	BAV approval of accepted value	Show values
X_R97_06	Indicator for R5/97 appendix 6 - Collateral	Show values
XTREU1	Trustee inflow/outflow list indicator	Show values

Column Name	Description	Domain name
XAKTZBAV	BAV file number	TEXT32
XAKTZARW	BAV file character_accepted value	TEXT20
XAUFORT	Storage location	TEXT22

Master Data Relations	Join Conditions
Client	`VZBAVF_AEND.MANDT == T000.MANDT`
Currency of accepted value_FISO	`VZBAVF_AEND.MANDT == TCURC.MANDT` `VZBAVF_AEND.SAWHR == TCURC.WAERS`
Currency of accepted value_VV	`VZBAVF_AEND.MANDT == TCURC.MANDT` `VZBAVF_AEND.SAWHR_VU == TCURC.WAERS`
Balance Sheet Indicator Balance Sheet Indicator Client	`VZBAVF_AEND.SBILK == TW11.SBILK` `VZBAVF_AEND.MANDT == TW11.MANDT`
BAV asset group (C11/74) indicator	`VZBAVF_AEND.MANDT == TW06.MANDT` `VZBAVF_AEND.SGBAV == TW06.SGBAV`
Asset group R11/76, Asset 6 (yearly stock overview) Contract Type Asset group R11/76, Asset 6 (yearly stock overview)	`VZBAVF_AEND.MANDT == TZ17.MANDT` `VZBAVF_AEND.RANTYP == TZ17.RANTYP` `VZBAVF_AEND.SJBUE == TZ17.SJBUE`
Asset group R11/76, appendix 3 and 4 Asset group R11/76, appendix 3 and 4 Contract Type	`VZBAVF_AEND.MANDT == TZ18.MANDT` `VZBAVF_AEND.SNEU_ANL == TZ18.SNEU_ANL` `VZBAVF_AEND.RANTYP == TZ18.RANTYP`
* Internal usage * Contract Type Client * Internal usage *	`VZBAVF_AEND.RANTYP == TZ14.RANTYP` `VZBAVF_AEND.MANDT == TZ14.MANDT` `VZBAVF_AEND.SNW101 == TZ14.SNW101`
* Internal usage * Contract Type * Internal usage *	`VZBAVF_AEND.MANDT == TZ15.MANDT` `VZBAVF_AEND.RANTYP == TZ15.RANTYP` `VZBAVF_AEND.SNW102 == TZ15.SNW102`
* Internal usage * * Internal usage * Contract Type	`VZBAVF_AEND.MANDT == TZ16.MANDT` `VZBAVF_AEND.SNW201 == TZ16.SNW201` `VZBAVF_AEND.RANTYP == TZ16.RANTYP`
Market value currency_FISO	`VZBAVF_AEND.MANDT == TCURC.MANDT` `VZBAVF_AEND.SVWHR == TCURC.WAERS`
Indicator for appendix 3 of circular R5/97 ? Indicator for circular R5/97 appendix 3 and 4	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ36.XLAND` `VZBAVF_AEND.X_R97_03 == TZ36.X_R97_03`
Indicator for appendix 5 of circular R5/97 Indicator for R5/97 appendix 5 ?	`VZBAVF_AEND.X_R97_05 == TZ37.X_R97_05` `VZBAVF_AEND.[column in domain "VVXLAND"] == TZ37.XLAND`
Indicator for appendix 8 of circular R5/97 ? Indicator for R5/97 appendix 8	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ38.XLAND` `VZBAVF_AEND.X_R97_08 == TZ38.X_R97_08`
Indicator for R5/97 appendix 10 ? ? Indicator for R5/97 appendix 10	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ39B.XLAND` `VZBAVF_AEND.[column in domain "VVSAART"] == TZ39B.SAART` `VZBAVF_AEND.X_R97_101 == TZ39B.X_R97_10`
Indicator for appendix 10 of circular R5/97 ? ? Indicator for R5/97 appendix 10	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ39B.XLAND` `VZBAVF_AEND.[column in domain "VVSAART"] == TZ39B.SAART` `VZBAVF_AEND.X_R97_102 == TZ39B.X_R97_10`
Indicator for appendix 10 of circular R5/97 ? ? Indicator for R5/97 appendix 10	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ39B.XLAND` `VZBAVF_AEND.[column in domain "VVSAART"] == TZ39B.SAART` `VZBAVF_AEND.X_R97_103 == TZ39B.X_R97_10`
Indicator for appendix 10 of circular R5/97 ? ? Indicator for R5/97 appendix 10	`VZBAVF_AEND.[column in domain "VVXLAND"] == TZ39B.XLAND` `VZBAVF_AEND.[column in domain "VVSAART"] == TZ39B.SAART` `VZBAVF_AEND.X_R97_104 == TZ39B.X_R97_10`

Other Relations \| to Master Data Relations ↑	Join Conditions
* Internal usage * Contract Type * Internal usage *	`VZBAVF_AEND.MANDT == TW12B.MANDT` `VZBAVF_AEND.RANTYP == TW12B.RANTYP` `VZBAVF_AEND.SBAV501 == TW12B.SBAV501`