ISSR_RPI_MFT_BCK

ISSR: Fixed and Variable Data for SR as Backup Table | #masterdata | Component: Regulatory reporting for insurance companies

🔑 Keys (5)
💰 Amounts (2)
∑ Quantities
📅 Dates (5)
☰ Categorical (6)
Other (26)
🔗 Relations (19)

Column Name	Description
MANDT	Client
ISSR_MFT_GUID	ISSR: UUID for Basis Table
MW_GUID	ISSR: UUID for Basis Table
COUNTRY_VAR	Statutory Reporting Variant
SAVE_COMPONENT	Application Area for ISSR

Column Name	Description
💲 Currency of accepted value_FISO (ANRWERTWHR):
ANRWERT	Accepted Value
💲 ISSR: Currency of BaFin Market Value (VERKEHRSWWHR):
VERKEHRSW	ISSR: BaFin Market Value

Column Name	Description

Column Name	Description
BUDAT	Effective From Date for Statutory Reporting - Master
GENDAT	Regulatory Body Approval Date for Asset
ANRWERTDAT	Date for Fixing the Accepted Value
EDATUM	Date
ETIME	System Time

Column Name	Description
DURCHR_FONDS	Outside Funds Not Allowed According to Ordinance	Show values
RANTYP	SR Asset Category	Show values
MASTER_REC_KEY	ISSR: Master Record ID for Master Data Table ISSR_RPI_MFT	Show values
FLG_SECONDARY	'Asset Is Subordinated' Indicator	Show values
SIGN_IDENT	ISSR: Identification Number Assignment Indicator	Show values
SL_ID_CHANGEONLY	Ind.: Flows in SL Ledgers Caused Purely by ID Change	Show values

Column Name	Description	Domain name
BUKRS	Company Code	BUKRS
PRODUCT_CATEGORY	Statutory Reporting Product Category	ISSR_PRODUCT_CATEGORY
PRODUCT_TYPE	Statutory Reporting Product Type	ISSR_PRODUCT_TYPE
ASSET_NR	Capital Investment Number in Statutory Reporting	ISSR_ASSET_NR
SEC_ACCOUNT	Securities Account	ISSR_SECURITY_ACCOUNT
PORTFOLIO	Portfolio as Differentiator	RPORTB
ACCOUNT_GRP	ISSR: Securities Account Group	ISSR_ACCOUNT_GRP
NUMB_TP_DAY	Numc3, internal use	NUMC3
SPARTE	Insurance Line of Business Indicator	ISSR_VERS_SPARTE
GENAKTZ	File Number for Asset Approval	TEXT32
ANRWERTAKTZ	BAV file character_accepted value	TEXT32
AUFBWORT	ISSR: Location	TEXT22
ATTRIBUTE_LI01	ISSR: Value for Long Attribute	ISSR_ATTR_VAL_LONG
ATTRIBUTE_LI02	ISSR: Value for Long Attribute	ISSR_ATTR_VAL_LONG
ATTRIBUTE_LI03	ISSR: Value for Long Attribute	ISSR_ATTR_VAL_LONG
ATTRIBUTE_LI04	ISSR: Value for Long Attribute	ISSR_ATTR_VAL_LONG
ATTRIBUTE_LI05	ISSR: Value for Long Attribute	ISSR_ATTR_VAL_LONG
IDENTNR	BAV Identification Number	CHAR22
IDENTNRH	Historical Identification Number BAV	CHAR30
VVKEY	ISSR: DARWIN Universal Key (Without Client)	ISSR_VVKEY
OBJNR	Object number	J_OBJNR
NUMB_PER_ASSET	Numeric field length 5	NUMC5
EPGM	ISSR: Description/Long Text 60 Characters	ISSR_DESCRIPTION
ENAME	User Name	UNAME
FLG_INVESTMENT	'Capital Investment Is Shareholding' Indicator	ISSR_INVESTMENT
ASSET_TYPE	Fixed Assets/Current Assets Indicator	ISSR_ASSET_TYPE

Master Data Relations \| to Other Relations ↓	Join Conditions
Currency of accepted value_FISO	`ISSR_RPI_MFT_BCK.MANDT == TCURC.MANDT` `ISSR_RPI_MFT_BCK.ANRWERTWHR == TCURC.WAERS`
ISSR: Country of Situs ISSR: Country of Situs Client	`ISSR_RPI_MFT_BCK.AUFBLAND == T005.LAND1` `ISSR_RPI_MFT_BCK.MANDT == T005.MANDT`
ISSR: Settlement and Cover Provision Currency	`ISSR_RPI_MFT_BCK.MANDT == TCURC.MANDT` `ISSR_RPI_MFT_BCK.BEDECKWHR == TCURC.WAERS`
Application Area for ISSR	`ISSR_RPI_MFT_BCK.MANDT == TISSR_ARGB.MANDT` `ISSR_RPI_MFT_BCK.ECOMPONENT == TISSR_ARGB.ARBGB`
Purpose of Capital Investment (of Derivative Transaction) ? ? Purpose of Capital Investment (of Derivative Transaction)	`ISSR_RPI_MFT_BCK.MANDT == TISSR_ADMN_PURP.MANDT` `ISSR_RPI_MFT_BCK.[column in domain "ISSR_REP_COUNTRY"] == TISSR_ADMN_PURP.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.[column in domain "ISSR_RANTYP"] == TISSR_ADMN_PURP.RANTYP` `ISSR_RPI_MFT_BCK.PURPOSE == TISSR_ADMN_PURP.PURPOSE`
Asset Indicator Statutory Reporting Variant Asset Indicator	`ISSR_RPI_MFT_BCK.MANDT == TISSR_STOCKBAV.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_STOCKBAV.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.STOCKBAV == TISSR_STOCKBAV.STOCKBAV`
Tax Office Asset Indicator Statutory Reporting Variant Client Tax Office Asset Indicator	`ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_STOCKFA.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.MANDT == TISSR_STOCKFA.MANDT` `ISSR_RPI_MFT_BCK.STOCKFA == TISSR_STOCKFA.STOCKFA`
Hedged Contract Object of a Derivative Transaction ? ? Hedged Contract Object of a Derivative Transaction Client	`ISSR_RPI_MFT_BCK.[column in domain "ISSR_REP_COUNTRY"] == TISSR_ADMN_SUBJ.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.[column in domain "ISSR_RANTYP"] == TISSR_ADMN_SUBJ.RANTYP` `ISSR_RPI_MFT_BCK.SUBJECT == TISSR_ADMN_SUBJ.SUBJECT` `ISSR_RPI_MFT_BCK.MANDT == TISSR_ADMN_SUBJ.MANDT`
ISSR: Currency of BaFin Market Value	`ISSR_RPI_MFT_BCK.MANDT == TCURC.MANDT` `ISSR_RPI_MFT_BCK.VERKEHRSWWHR == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Asset Type According to Regulatory Accounting Requirements Statutory Reporting Product Category Client Statutory Reporting Variant Asset Type According to Regulatory Accounting Requirements	`ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_ANLARTB.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.MANDT == TISSR_ANLARTB.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_ANLARTB.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.ABS54AVAG == TISSR_ANLARTB.ABS54AVAG`
List Number of Premium Reserve Fund List Number of Premium Reserve Fund Client Statutory Reporting Product Category Statutory Reporting Variant	`ISSR_RPI_MFT_BCK.DV == TISSR_DV_PT.DV` `ISSR_RPI_MFT_BCK.MANDT == TISSR_DV_PT.MANDT` `ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_DV_PT.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_DV_PT.COUNTRY_VAR`
Subsection Numbers of Premium Reserve Fund Lists Subsection Numbers of Premium Reserve Fund Lists Statutory Reporting Variant Statutory Reporting Product Category Client List Number of Premium Reserve Fund	`ISSR_RPI_MFT_BCK.DVUA == TISSR_DVUAB.DVUA` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_DVUAB.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_DVUAB.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.MANDT == TISSR_DVUAB.MANDT` `ISSR_RPI_MFT_BCK.DV == TISSR_DVUAB.DV`
Annexes R30NW670 Statutory Reporting Variant Client Asset Type According to Regulatory Accounting Requirements Annexes R30NW670	`ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_NW670B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_NW670B.MANDT` `ISSR_RPI_MFT_BCK.ABS54AVAG == TISSR_BAV_NW670B.ABS54AVAG` `ISSR_RPI_MFT_BCK.NW670 == TISSR_BAV_NW670B.NW670`
Annexes R30NW671 Annexes R30NW671 Client Statutory Reporting Variant Asset Type According to Regulatory Accounting Requirements	`ISSR_RPI_MFT_BCK.NW671 == TISSR_BAV_NW671B.NW671` `ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_NW671B.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_NW671B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.ABS54AVAG == TISSR_BAV_NW671B.ABS54AVAG`
Identifiers for Circular R30/2002 Annex 3 Statutory Reporting Variant Identifiers for Circular R30/2002 Annex 3 Statutory Reporting Product Category	`ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_R5973B.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_R5973B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.R59703 == TISSR_BAV_R5973B.R59703` `ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_BAV_R5973B.PRODUCT_CATEGORY`
Identifiers for Fund Annex Identifiers for Fund Annex Client Statutory Reporting Variant Statutory Reporting Product Category	`ISSR_RPI_MFT_BCK.R59704 == TISSR_BAV_R5974B.R59704` `ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_R5974B.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_R5974B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_BAV_R5974B.PRODUCT_CATEGORY`
Notional Allocation - Annex 8 R30/2002 Statutory Reporting Product Category Statutory Reporting Variant Notional Allocation - Annex 8 R30/2002	`ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_R5975B.MANDT` `ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_BAV_R5975B.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_R5975B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.R59705 == TISSR_BAV_R5975B.R59705`
Type of Defined Collateral Statutory Reporting Product Category Client Statutory Reporting Variant Type of Defined Collateral	`ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_BAV_R5976B.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_R5976B.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_R5976B.COUNTRY_VAR` `ISSR_RPI_MFT_BCK.R59706 == TISSR_BAV_R5976B.R59706`
Identifiers for Circular R30/2002 Annex 8 Statutory Reporting Product Category Identifiers for Circular R30/2002 Annex 8 Client Statutory Reporting Variant	`ISSR_RPI_MFT_BCK.PRODUCT_CATEGORY == TISSR_BAV_R5978B.PRODUCT_CATEGORY` `ISSR_RPI_MFT_BCK.R59708 == TISSR_BAV_R5978B.R59708` `ISSR_RPI_MFT_BCK.MANDT == TISSR_BAV_R5978B.MANDT` `ISSR_RPI_MFT_BCK.COUNTRY_VAR == TISSR_BAV_R5978B.COUNTRY_VAR`