SAP ABAP Table ISSR_DE_TP_MFT_LEDGER_RET (Strukt.zur Selekt.der umb.relevanten Daten aus ISSR_RPI_MFT)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR (Application Component) Regulatory reporting for insurance companies
     ⤷ VVSRFISL (Package) Statutory Reporting for Insurance from FI-SL

Basic Data

Table Category	INTTAB	Structure
Structure	ISSR_DE_TP_MFT_LEDGER_RET	Table Relationship Diagram
Short Description	Strukt.zur Selekt.der umb.relevanten Daten aus ISSR_RPI_MFT

Delivery and Maintenance

Pool/cluster
Delivery Class
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	Actual line item table
2	RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
4	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
5	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
6	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
7	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
9	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
10	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
12	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
13	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
14	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
15	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	RCOUNTRY_VAR	☐	ISSR_REP_COUNTRY	ISSR_REP_COUNTRY	CHAR	4	0		TISSR_MARECO
17	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
18	RSPARTE	☐	ISSR_VERS_SPARTE	ISSR_VERS_SPARTE	CHAR	2	0	Insurance Line of Business Indicator	TISSR_SPARTE
19	RSTOCKBAV	☐	ISSR_STOCKBAV	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator	TISSR_STOCKBAV
20	RSTOCKFA	☐	ISSR_STOCKFA	ISSR_STOCKFA	CHAR	1	0	Tax office stock indicator	TISSR_STOCKFA
21	RDV	☐	ISSR_DV	ISSR_DV	CHAR	5	0	Premium reserve fund list number	TISSR_DV
22	RDVUA	☐	ISSR_UA	ISSR_UA	CHAR	2	0	Subsection number of premium reserve fund list	TISSR_DVUA
23	RRANTYP	☐	ISSR_RANTYP	RANTYP	CHAR	1	0	External System ID for Capital Investment Type for Reporting
24	RASSET_NR	☐	ISSR_ASSET_NR	ISSR_ASSET_NR	CHAR	13	0	Capital Investment Number for Regulatory Reporting
25	RPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
26	RVAL_AREA	☐	ISSR_VAL_AREA	ISSR_VAL_AREA	CHAR	3	0		TISSR_MAVAAR
27	RSEC_ACCOUNT	☐	ISSR_SECURITY_ACCOUNT	ISSR_SECURITY_ACCOUNT	CHAR	10	0	Securities Account
28	RPRODUCT_TYPE	☐	ISSR_PRODUCT_TYPE	ISSR_PRODUCT_TYPE	CHAR	8	0		*
29	RFLOWTYPE	☐	ISSR_FLOWTYPE	ISSR_FLOWTYPE	CHAR	8	0		*
30	PRIMANOTA	☐	ISSR_PRIMANOTA	ISSR_PRIMANOTA	CHAR	24	0
31	PRODUCT_CAT	☐	ISSR_PRODUCT_CATEGORY	ISSR_PRODUCT_CATEGORY	CHAR	3	0		*
32	ABS54AVAG	☐	ISSR_ABS54AVAG	ISSR_ABS54AVAG	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	*
33	NW101	☐	ISSR_NW101	ISSR_NW101	CHAR	4	0	BAV asset group stmt 101	*
34	NW600	☐	ISSR_NW600	ISSR_NW600	CHAR	4	0		*
35	NW102	☐	ISSR_NW102	ISSR_NW102	CHAR	5	0	BAV Asset Group Statement 102 (Germany Only)	*
36	NW201	☐	ISSR_NW201	ISSR_NW201	CHAR	5	0	BAV asset group stmt 201	*
37	R59710_1	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	*
38	R59710_2	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	*
39	R59710_3	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	*
40	R59710_4	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	*
41	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
42	KONTL_3	☐	ISSR_KONTL	ISSR_KONTL	CHAR	24	0	ISSR: Idennummer
43	NW670_3	☐	ISSR_NW670	ISSR_NW670	CHAR	10	0	Anlagen R30NW670	*
44	NW671_3	☐	ISSR_NW671	ISSR_NW671	CHAR	10	0	Anlagen R30NW671	*
45	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
46	SCOUNTRY_VAR	☐	ISSR_REP_COUNTRY_S	ISSR_REP_COUNTRY	CHAR	4	0		TISSR_MARECO
47	SACCT	☐	PRACCT	SAKNR	CHAR	10	0	Partner account number	*
48	SSPARTE	☐	ISSR_VERS_SPARTE_S	ISSR_VERS_SPARTE	CHAR	2	0		TISSR_SPARTE
49	SSTOCKBAV	☐	ISSR_STOCKBAV_S	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator (Sender Field)	TISSR_STOCKBAV
50	SSTOCKFA	☐	ISSR_STOCKFA_S	ISSR_STOCKFA	CHAR	1	0		TISSR_STOCKFA
51	SDV	☐	ISSR_DV_S	ISSR_DV	CHAR	5	0		TISSR_DV
52	SDVUA	☐	ISSR_UA_S	ISSR_UA	CHAR	2	0		TISSR_DVUA
53	SVAL_AREA	☐	ISSR_VAL_AREA_S	ISSR_VAL_AREA	CHAR	3	0		TISSR_MAVAAR
54	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
55	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
56	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
57	MSL	☐	QUAN1_9	MENGV9	QUAN	17	3	Quantity
58	ASL	☐	QUAN2_9	MENGV9	QUAN	17	3	Additional Quantity
59	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
60	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
61	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
62	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
63	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
64	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
65	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
66	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
67	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
68	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
69	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
70	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
71	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
72	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
73	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
74	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
75	REFDOCNR_REV_3	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
76	REFAWORG_REV_3	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
77	NWBTR_3	☐	ISSR_NSL	WERTV9	CURR	17	2
78	NWCUR_3	☐	ISSR_NSLCUR	WAERS	CUKY	5	0	Nominal currency	TCURC
79	FTP_3	☐	ISSR_FTP	ISSR_FTP	CHAR	15	0	MW-Bewegungsteil	TISSR_MAFTP
80	ANLN1_3	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
81	ANLN2_3	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
82	VS_BELNR_3	☐	ISSR_VORSYSTEM_BLNR	CHAR32	CHAR	32	0	ISSR: Vorsystem Belegnummer
83	VS_POSNR_3	☐	ISSR_VORSYSTEM_POSNR	POSNR	NUMC	6	0	ISSR: Vorsystem Positionsnummer eines Beleg	*
84	VS_BELNR_REV_3	☐	ISSR_VORSYSTEM_BLNR_REV	CHAR32	CHAR	32	0	ISSR: Vorsystem Belegnummer des stornierten Beleges
85	VS_EDATUM_3	☐	ISSR_VS_CREATE_DATE	DATUM	DATS	8	0	ISSR: Tag der Erfassung des Beleges im Vorsystem
86	VS_ETIME_3	☐	ISSR_VS_CREATE_TIME	UZEIT	TIMS	6	0	ISSR: Uhrzeit der Erfassung im Vorsystem
87	VS_ENAME_3	☐	ISSR_VS_CREATER	UNAME	CHAR	12	0	ISSR: Entry Clerk in Operational System
88	VS_SHKZG_3	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
89	FI_BELNR_3	☐	ISSR_FI_BELNR	BELNR	CHAR	10	0	ISSR: Document Number for an FI Accounting Document
90	FI_BUZEI_3	☐	ISSR_FI_POSNR	BUZEI	NUMC	3	0	ISSR:Number for Posting Line within Accounting Document
91	BUTIME_3	☐	ISSR_FI_TIME	UZEIT	TIMS	6	0
92	PFLOW_GUID_3	☐	ISSR_FLOW_NR	ISSR_CHAR_GUID	CHAR	32	0
93	PFLOW_GUID_REV_3	☐	ISSR_PREFLOW_REV	ISSR_CHAR_GUID	CHAR	32	0	Verweis zu Originalbeleg, der mit diesem storniert wird
94	MFT_GUID_3	☐	ISSR_FLOW_NR	ISSR_CHAR_GUID	CHAR	32	0
95	MW_GUID_3	☐	ISSR_FLOW_NR	ISSR_CHAR_GUID	CHAR	32	0
96	ECOMPONENT_3	☐	ISSR_ARBGB	ISSR_ARGB	CHAR	4	0		*
97	EPGM_3	☐	ISSR_DESCRIPTION	ISSR_DESCRIPTION	CHAR	60	0
98	ENAME_3	☐	UNAME	UNAME	CHAR	12	0	User Name
99	BWHR_3	☐	ISSR_COVER_PROV_CURR	WAERS	CUKY	5	0	ISSR: Erfüllungs- und Bedeckungswährung	*
100	VALUATION_CLS_3	☐	ISSR_VALUATION_CLASS	ISSR_VALUATION_CLASS	NUMC	4	0	Bewertungsklasse

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISSR_DE_TP_MFT_LEDGER_RET	AUNIT	T006	MSEHI	REF	C	CN
2	ISSR_DE_TP_MFT_LEDGER_RET	AWTYP	TTYP	AWTYP	REF	C	CN
3	ISSR_DE_TP_MFT_LEDGER_RET	DOCTY	T889	DOCTY	REF	C	CN
4	ISSR_DE_TP_MFT_LEDGER_RET	FTP_3	TISSR_MAFTP	FTP	REF	C	CN
5	ISSR_DE_TP_MFT_LEDGER_RET	NWCUR_3	TCURC	WAERS	REF	C	CN
6	ISSR_DE_TP_MFT_LEDGER_RET	RBUKRS	T001	BUKRS	REF	C	CN
7	ISSR_DE_TP_MFT_LEDGER_RET	RCLNT	T000	MANDT	KEY	1	CN
8	ISSR_DE_TP_MFT_LEDGER_RET	RCOUNTRY_VAR	TISSR_MARECO	COUNTRY_VAR	REF	C	CN
9	ISSR_DE_TP_MFT_LEDGER_RET	RDV	TISSR_DV	DV	KEY	1	CN
10	ISSR_DE_TP_MFT_LEDGER_RET	RDVUA	TISSR_DVUA	DVUA	KEY	1	CN
11	ISSR_DE_TP_MFT_LEDGER_RET	RLDNR	T881	RLDNR	REF	C	CN
12	ISSR_DE_TP_MFT_LEDGER_RET	RPARTNER	BUT000	PARTNER	REF	C	CN
13	ISSR_DE_TP_MFT_LEDGER_RET	RSPARTE	TISSR_SPARTE	SPARTE	REF	C	CN
14	ISSR_DE_TP_MFT_LEDGER_RET	RSTOCKBAV	TISSR_STOCKBAV	STOCKBAV	KEY	1	CN
15	ISSR_DE_TP_MFT_LEDGER_RET	RSTOCKFA	TISSR_STOCKFA	STOCKFA	KEY	1	CN
16	ISSR_DE_TP_MFT_LEDGER_RET	RTCUR	TCURC	WAERS	REF	C	CN
17	ISSR_DE_TP_MFT_LEDGER_RET	RUNIT	T006	MSEHI	REF	C	CN
18	ISSR_DE_TP_MFT_LEDGER_RET	RVAL_AREA	TISSR_MAVAAR	VAL_AREA	REF	C	CN
19	ISSR_DE_TP_MFT_LEDGER_RET	RVERS	T894	RVERS	REF	C	CN
20	ISSR_DE_TP_MFT_LEDGER_RET	SBUKRS	T001	BUKRS	REF	C	CN
21	ISSR_DE_TP_MFT_LEDGER_RET	SCOUNTRY_VAR	TISSR_MARECO	COUNTRY_VAR	REF	C	CN
22	ISSR_DE_TP_MFT_LEDGER_RET	SDV	TISSR_DV	DV	REF	C	CN
23	ISSR_DE_TP_MFT_LEDGER_RET	SDVUA	TISSR_DVUA	DVUA	REF	C	CN
24	ISSR_DE_TP_MFT_LEDGER_RET	SSPARTE	TISSR_SPARTE	SPARTE	REF	C	CN
25	ISSR_DE_TP_MFT_LEDGER_RET	SSTOCKBAV	TISSR_STOCKBAV	STOCKBAV	REF	C	CN
26	ISSR_DE_TP_MFT_LEDGER_RET	SSTOCKFA	TISSR_STOCKFA	STOCKFA	REF	C	CN
27	ISSR_DE_TP_MFT_LEDGER_RET	SVAL_AREA	TISSR_MAVAAR	VAL_AREA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110