TISSR_ASSET_R30 SAP table for – Stichtagsbezogene Kennzeichen je Anlage gem. R30/2002

Here we would like to draw your attention to TISSR_ASSET_R30 table in SAP. As we know it is being mainly used with the SAP FS-SR (Regulatory reporting for insurance companies in FS) component which is coming under FS module (Financial Services). TISSR_ASSET_R30 is a SAP standard transp table used for storing Stichtagsbezogene Kennzeichen je Anlage gem. R30/2002 related data in SAP. It comes under the package VVSRFISL.

SAP TISSR_ASSET_R30 table

Table TISSR_ASSET_R30 technical data

TableTISSR_ASSET_R30
Data storingStichtagsbezogene Kennzeichen je Anlage gem. R30/2002
ModuleFS
Sub ModuleFS-SR
SAP PackageVVSRFISL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP TISSR_ASSET_R30 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TISSR_ASSET_R30 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COUNTRY_VAR
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • STICHTAG_FONDS : Stichtag Fondsdurchsicht
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASSET_NR : Capital Investment Number for Regulatory Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • PRODUCT_CATEGORY : Product Category
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PRODUCT_TYPE : Product Type
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • RANTYP : External System ID for Capital Investment Type for Reporting
    Its data type is CHAR (Character String) with field length 1
  • BONITAET : Einstufung Bonitätsgruppierung
    Its data type is CHAR (Character String) with field length 2
  • ART_PRODUCT : Art des strukturierten Produkts
    Its data type is CHAR (Character String) with field length 2
  • ABS_CLN : Kennzeichnung ABS oder CLN
    Its data type is CHAR (Character String) with field length 3
  • R3_1999 : Berichtspflicht gemäß R3/1999
    Its data type is CHAR (Character String) with field length 1
  • R3_2000
    Its data type is CHAR (Character String) with field length 1
  • R1_2002 : Berichtspflicht gemäß R1/2002
    Its data type is CHAR (Character String) with field length 1
  • FLG_PRIVATE_CAP : Anlage ist Risikokapital mit Eigenkapitalcharakter
    Its data type is CHAR (Character String) with field length 1
  • INDEXGRP : Indexgruppenzugehörigkeit der Wertpapiere
    Its data type is CHAR (Character String) with field length 2
  • FLG_DIVIDEND : Dividendenausschüttung ist in letzten 12 Monaten erfolgt
    Its data type is CHAR (Character String) with field length 1
  • FLG_TRANSP_FONDS
    Its data type is CHAR (Character String) with field length 1
  • FONDS_BENCH
    Its data type is CHAR (Character String) with field length 2
  • RATING_COMPANY : Ratinggesellschaft des Wertpapiers
    Its data type is CHAR (Character String) with field length 2
  • ISSR_RATING
    Its data type is CHAR (Character String) with field length 3
  • FLG_DACHFONDS : Dachfonds
    Its data type is CHAR (Character String) with field length 1
  • FLG_CAP_GUARANTY : Kapitalgarantie
    Its data type is CHAR (Character String) with field length 1
  • FLG_NEG_INTEREST : Negativ-Verzinsung wird ausgeschlossen
    Its data type is CHAR (Character String) with field length 1
  • PORTFOLIO : Art des Collateral Pools / Referenzakitivums bei ABS/CLN
    Its data type is CHAR (Character String) with field length 2
  • FLG_P77A4VAG : Vorrecht besteht nach §77 Abs. 4 VAG
    Its data type is CHAR (Character String) with field length 1
  • HF_TYPE : Art des Hedgefonds
    Its data type is CHAR (Character String) with field length 2
  • FLG_HF_BOUND : Kapitalanlage an Hedgefonds gebunden
    Its data type is CHAR (Character String) with field length 1
  • FLG_HF_RETURN : Ertrag und Rückzahlung sind an Hedgefonds gebunden
    Its data type is CHAR (Character String) with field length 1
  • HF_LOCATION : Sitz des Emittenten
    Its data type is CHAR (Character String) with field length 7
  • FLG_HF_INDICES : Anlage ist an Hedgefonds-Indizes gebunden
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_HF : Keine Anlagen in Hedgefonds und in daran gebundene Anlagen
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_ABS : Keine Anlagen in ABS/CLN
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_NONEWR : Keine Aktien und Genüsse von Untern. mit Sitz außerhalb EWR
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_07C : Keine Schuldverschr. gemäß §1 Abs. 1 Nr.7 Bst. c AnlV
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_08 : Keine Schuldverschreibung gemäß §1 Abs. 1 Nr.8 AnlV
    Its data type is CHAR (Character String) with field length 1
  • FLG_MAX_YLD : Kapitalanlage enthält High-Yield-Rentenpapiere
    Its data type is CHAR (Character String) with field length 1
  • FLG_CALLABLE : Kapitalanlage ist Callable Bond
    Its data type is CHAR (Character String) with field length 1
  • FLG_NO_MAX_YLD : Keine High-Yield-Rentenpapiere enthalten
    Its data type is CHAR (Character String) with field length 1
  • FONDS_TYPE : Kategorisierung intransparenter Fonds
    Its data type is CHAR (Character String) with field length 1
  • INVEST_STRAT : Anlagestrategie eines Fonds
    Its data type is CHAR (Character String) with field length 3
  • FONDS_TERM : Festgelegte Rückgabe-/Kündigungsfristen für Fondsanteile
    Its data type is CHAR (Character String) with field length 2
  • ABS : Zuordnung ABS/CLN zu Rundschreiben des BaFin
    Its data type is CHAR (Character String) with field length 2
  • MARKET_RISK : Marktrisikopotenzial eines Fonds
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FONDSART : Fondsart
    Its data type is CHAR (Character String) with field length 2
  • FUND_SHR_HF : ISSR: Anteil Anlagen in Hedgefonds/an Hedgefonds geb. Anlage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FUND_SHR_ABS : ISSR: Anteil Anlagen in ABS/CLN
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FUND_SHR_NONEWR : ISSR: Anteil Anlagen in Aktien/Genüsse mit Sitz NON-EWR
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FUND_SHR_7C : ISSR: Anteil Anlagen in Anleihen nach § 1 Abs. 1 Nr. 7c AnlV
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FUND_SHR_08 : ISSR: Anteil Anlagen in Anleihen nach § 1 Abs. 1 Nr. 8 AnlV
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FUND_SHR_MAXYLD : ISSR: Anteil Anlagen in High Yield Anleihen
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • INVG_CAT : Kategorisierung des Fonds gemäß Investmentgesetz (InvG)
    Its data type is CHAR (Character String) with field length 4
  • FONDS_BENCH2
    Its data type is CHAR (Character String) with field length 2
  • FLG_NEG_CLAUSE : Anforderungen Besicherung mit Negativklausel nicht erfüllt
    Its data type is CHAR (Character String) with field length 1
  • FLG_INVG_FRGN : Ausländische Fonds entsprechen den Anforderungen gemäß InvG
    Its data type is CHAR (Character String) with field length 1
  • FLG_SIDEP_A : Anlage bietet Möglichkeit, Side Pockets zu bilden
    Its data type is CHAR (Character String) with field length 1
  • FLG_STREU_BER : Fonds ist in Anlage Streuung zu berücksichtigen
    Its data type is CHAR (Character String) with field length 1
  • COM_RISK_TYP : Art des Rohstoffrisikos
    Its data type is CHAR (Character String) with field length 8
  • FLG_INVG_HF : Hedgefonds entspricht den Anforderungen gemäß InvG
    Its data type is CHAR (Character String) with field length 1
  • FLG_COM_FUND : Rohstoff-Fonds
    Its data type is CHAR (Character String) with field length 1
  • FONDS_CANC : Festgelegte Kündigungsfristen für Fondsanteile
    Its data type is CHAR (Character String) with field length 2
  • FLG_SIDEP_B : Anlage bietet Möglichkeit, Side Pockets zu bilden
    Its data type is CHAR (Character String) with field length 1
  • LOCK_PER : Lockup-Periode
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LOCK_PER_TYP : Typ der Dauer (Tage, Monate, Jahre) der Lockup-Periode
    Its data type is CHAR (Character String) with field length 1
  • ART_ABSCLN : Art des strukturierten Produkts
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Erweiterungen TISSR_ASSET_R30 um Rundschreiben R2009
  • FLG_COMRISKBOUND : Gebunden an Rohstoffrisiko
    Its data type is CHAR (Character String) with field length 1
  • RISK_TYPE : Art des Risikos
    Its data type is CHAR (Character String) with field length 8
  • FLG_RCV_LIAB : Notierte Forderungen aus nachrangigen Verbindlichkeiten
    Its data type is CHAR (Character String) with field length 1
  • FLG_HLD_LIAB : Nicht notierte Genussrechte/Beteiligungen/Nachrangverbindl.
    Its data type is CHAR (Character String) with field length 1
  • GUAR_LIAB : Art der Gewährträgerhaftung
    Its data type is CHAR (Character String) with field length 3