TRFDUMW SAP (TR-EDT: Regulatory Reporting) Structure details

Dictionary Type: Structure
Description: TR-EDT: Regulatory Reporting




ABAP Code to SELECT data from TRFDUMW
Related tables to TRFDUMW
Access table TRFDUMW




Structure field list including key, data, relationships and ABAP select examples

TRFDUMW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "TR-EDT: Regulatory Reporting" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TRFDUMW TYPE TRFDUMW.

The TRFDUMW table consists of various fields, each holding specific information or linking keys about TR-EDT: Regulatory Reporting data available in SAP. These include JBAVG (BAV approval), XAKTZBAV (BAV file number), DBAVGEN (Date of BAV authorization), SGBAV (BAV asset group (C11/74) indicator).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TRFDUMW structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
JDECKRegulatory reporting BPV (hedge fund Y/N) JDECKCHAR1JANEI
JBAVGBAV approval JBAVGCHAR1KENZX
XAKTZBAVBAV file number XAKTZBAVCHAR32TEXT32
DBAVGENDate of BAV authorization DBAVGENDATS8DATUM
SGBAVBAV asset group (C11/74) indicator SGBAVNUMC3TW06SGBAV
SBAV501*** Internal usage *** SBAV501CHAR4TW12BSBAV501
JARW*** Not used *** JARWCHAR1JANEI
DARWGENDate for fixing the accepted value DARWGENDATS8DATUM
XAKTZARWBAV file character_accepted value XAKTZARWCHAR20TEXT20
XAUFORTStorage location XAUFORTCHAR22TEXT22
DERWMELDate when the acquistion was reported to FISO DERWMELDATS8DATUM
SJBUEAsset group R11/76, Asset 6 (yearly stock overview) VVSJBUECHAR6TZ17VVSJBUE
SNEU_ANLAsset group R11/76, appendix 3 and 4 VVSNEU_ANLCHAR9TZ18VVSNEU_ANL
XR5_91_1Indicator R5/91, appendix 1 VVXR5_91_1CHAR2VVXR5_91_1
XR5_91_2Indicator R5/91, appendix 1 VVXR5_91_2CHAR1KENZX
XR5_91_3Indicator R5/91, appendix 3 VVXR5_91_3CHAR1KENZX
XTREU*** Internal usage *** VVXTREUCHAR1KENZX
XDECKIndicator for eligibility for premium reserve fund VVXDECKCHAR1KENZX
XARWBAV approval of accepted value VVXARWCHAR1KENZX
SMW102BAV asset group stmt 102 VVSMW102CHAR5TZ32VVSMW102
X_R97_03Indicator for circular R5/97 appendix 3 and 4 VVX_R97_03CHAR2TZ36VVX_R97_03
X_R97_05Indicator for R5/97 appendix 5 VVX_R97_05CHAR2TZ37VVX_R97_05
X_R97_06Indicator for R5/97 appendix 6 - Collateral VVX_R97_06CHAR1VVX_R97_06
X_R97_08Indicator for R5/97 appendix 8 VVX_R97_08CHAR1TZ38VVX_R97_08
X_R97_101Indicator for R5/97 appendix 10 VVX_R97_10CHAR4TZ39BVVX_R97_10
X_R97_102Indicator for R5/97 appendix 10 VVX_R97_10CHAR4TZ39BVVX_R97_10
X_R97_103Indicator for R5/97 appendix 10 VVX_R97_10CHAR4TZ39BVVX_R97_10
X_R97_104Indicator for R5/97 appendix 10 VVX_R97_10CHAR4TZ39BVVX_R97_10
XTREU1Trustee inflow/outflow list indicator VVXTREU1CHAR1VVXTREU1
DGUEL_ABEntry effective from DGUEL_ABDATS8DATUM
SUDECInsurance Line of Business Indicator SUDECNUMC2TW05SUDEC
SSKZBBAV stock indicator SSKZBNUMC1TZ11SSKZB
SOEFFKLIndicator BAV opening clause SOEFFKLCHAR1JANEI
RINUMBAV identification number RINUMCHAR22RINUM
SSKZFTax office stock indicator SSKZFNUMC1TZ13SSKZF
RINUMHBAV hist. identifications number RINUMHCHAR30CHAR30
RERFEntered by RERFCHAR12SYCHAR12
SANLARTBAV asset type PRF3 and PRF8 VVSANLARTCHAR6TZ19VVSANLART
BARWBAVBAV accepted value UB_BARWBAVNUMC13NUM13
N_BARWBAVNumber of decimal places from legacy system UB_KOMMANUMC1NUM1
SAWHRCurrency ISO code UB_WHRCHAR5CHAR5WHR
BVWERTMarket value BAV UB_BVWERTNUMC13NUM13
N_BVWERTNumber of decimal places from legacy system UB_KOMMANUMC1NUM1
SVWHRCurrency ISO code UB_WHRCHAR5CHAR5WHR
BARW_VUAccepted value VU UB_BARW_VUNUMC13NUM13
N_BARW_VUNumber of decimal places from legacy system UB_KOMMANUMC1NUM1
SAWHR_VUCurrency ISO code UB_WHRCHAR5CHAR5WHR
SAARTAsset Type According to Regulatory Accounting Requirements VVSAARTCHAR6TZ28VVSAART
SDVPremium reserve fund list number VVSDVCHAR2TZ30VVSDVNR
SUABTSubsection number of premium reserve fund list VVSUABTCHAR2TZ31VVSUABT
SMWWHRCurrency ISO code UB_WHRCHAR5CHAR5WHR
SNW600Asset group BAV stmt 101, 201 and 600 VVSNW600CHAR4TZ29PVVSNW600

Key field Non-key field



How do I retrieve data from SAP structure TRFDUMW using ABAP code?

As TRFDUMW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRFDUMW as there is no data to select.

How to access SAP table TRFDUMW

Within an ECC or HANA version of SAP you can also view further information about TRFDUMW and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!