SAP ABAP Table RFICO_COND_POS_VIEW (Condition Item Denormalized)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-PO (Application Component) Portfolio
     ⤷ FVVD_CONDITION_TABLE (Package) Condition Table

Basic Data

Table Category	INTTAB	Structure
Structure	RFICO_COND_POS_VIEW	Table Relationship Diagram
Short Description	Condition Item Denormalized

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	Key Structure for Condition Table
2	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
3	SKOGRP	☐	SKOGRP	SKOGRP	NUMC	3	0	Condition Group	TZK04
4	O_CONTAB	☐	TB_FICO_CONTAB	T_FICO_CONTAB	CHAR	8	0	Condition Table
5	X_CONTAB	☐	TB_FICO_CONTAB_T	TEXT25	CHAR	25	0	Name of Condition Table
6	VERSION	☐	TB_FICO_CONTAB_VERSION	T_FICO_CONTAB_VERSION	NUMC	4	0	Version Number for a Condition Table
7	.INCLUDE	☐				0	0	Structure for Conditions
8	.INCLUDE	☐				0	0	Condition Table: Selection Criteria Condition
9	SLOANFUNC	☐	VVSLOANFUNC	VVSLOANFUNC	CHAR	3	0	Application subfunction	TDLOANSUBFUNC
10	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TDLOANFKO
11	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TDLOANFUNC
12	I_COND	☐	TB_FICO_ICOND	SYSUUID	RAW	16	0	Condition ID
13	O_LEVEL	☐	TB_FICO_OLEVEL	T_FICO_OLEVEL	NUMC	1	0	Scaled or Interval Calculation
14	O_LEVELTOFROM	☐	TB_FICO_OLEVELTOFROM	T_FICO_OLEVELTOFROM	NUMC	1	0	Scale Item FROM or TO in Condition Determination
15	.INCLUDE	☐				0	0	Structure for Amount and Interest Calculation
16	O_AMTCATG	☐	TB_FICO_OAMTCATG	T_FICO_OAMTCATG	CHAR	6	0	Amount Category
17	O_SINTCALC	☐	TFMSINTCALC	TFMSINTCALC	NUMC	1	0	Type of interest calculation
18	O_BASEREF	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	*
19	O_BASEFIXING	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
20	O_ROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
21	U_ROUNDUNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
22	O_IRUNIT	☐	TB_FICO_OIRUNIT	T_FICO_OIRUNIT	NUMC	3	0	Time Unit for Interest Rate
23	O_INTMETHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
24	O_AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
25	O_CAL	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
26	X_COND	☐	TB_FICO_CONDITION_T	TEXT25	CHAR	25	0	Description of a Condition
27	I_COMP	☐	TB_FICO_ICOMP	SYSUUID	RAW	16	0	Component ID
28	I_POSNO	☐	TB_FICO_IPOSNO	T_FICO_IPOSNO	NUMC	4	0	Number of Condition Item
29	I_VARIABLE	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
30	.INCLUDE	☐				0	0	Structure for Limit Values
31	LIMIT_AMOUNT	☐	TB_FICO_AAMTLIM	T_CML_AMOUNT_STANDARD	CURR	13	2	Amount Limit
32	LIMIT_TERM_VALUE	☐	TB_FICO_LIMIT_TERM_VALUE	T_PROD_TIME_QUANTITY_TERM	NUMC	4	0	Term Limit: Number of Time Units
33	LIMIT_TERM_UNIT	☐	TB_FICO_LIMIT_TERM_UNIT	T_PROD_TIME_UNIT_TERM	NUMC	1	0	Term Limit: Unit
34	C_CURRENCY	☐	TB_FICO_CURRAMT	WAERS	CUKY	5	0	Currency of Amount Component	*
35	.INCLUDE	☐				0	0	Structure for Amount Item
36	A_BASE	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
37	A_AMT	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
38	A_AMTMIN	☐	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
39	A_AMTMAX	☐	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
40	N_DIVISOR	☐	TB_FICO_NDIVISOR	T_FICO_NDIVISOR	DEC	4	0	Divisor
41	I_FORMULA	☐	VVSFORMREF	T_FORMBE	CHAR	4	0	Formula reference for the cash flow calculator	*
42	.INCLUDE	☐				0	0	Structure for Amount Item Interest
43	R_PERCENTAGE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
44	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
45	O_INTREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
46	R_INCREMENT	☐	TB_FICO_RINTREFINCREM	T_CML_PERCENTAGE	DEC	10	7	Reference Interest Rate Markup / Markdown
47	R_INTMAX	☐	TB_FICO_RINTMIN	T_CML_PERCENTAGE	DEC	10	7	Minimum Interest Rate: Reference Interest Rate + Supplement
48	R_INTMIN	☐	TB_FICO_RINTMAX	T_CML_PERCENTAGE	DEC	10	7	Maximum Interest Rate: Reference Interest Rate + Supplement
49	R_USR_INCR	☐	TB_FICO_RUSR_INCR	T_CML_PERCENTAGE	DEC	10	7	Permitted Upper Deviation from Interest Rate
50	R_USR_DECR	☐	TB_FICO_RUSR_DECR	T_CML_PERCENTAGE	DEC	10	7	Permitted Lower Deviation from Interest Rate
51	.INCLUDE	☐				0	0	Condition Items for Installment Loans
52	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
53	REGION	☐	TB_SREGION	REGIO	CHAR	3	0	Region Where Contract Concluded	T005S
54	VALID_FROM_DATE	☐	TB_VALID_FROM_DATE	DATUM	DATS	8	0	Start of Validity Period
55	VALID_FROM_PER	☐	TB_VALID_FROM_PERIOD	T_PROD_TIME_QUANTITY_TERM	NUMC	4	0	Valid from Date
56	A_CAP_PERIOD	☐	TB_CAP_PERIOD	T_CML_PERCENTAGE	DEC	10	7	Cap on Interest Rate for a Period
57	A_FLOOR_PERIOD	☐	TB_FLR_PERIOD	T_CML_PERCENTAGE	DEC	10	7	Floor on Interest Rate for a Period
58	R_CAP_ADJUST	☐	TB_CAP_ADJUST	T_CML_PERCENTAGE	DEC	10	7	Interest Rate Cap for Interest Adjustment
59	R_FLOOR_ADJUST	☐	TB_FLR_ADJUST	T_CML_PERCENTAGE	DEC	10	7	Floor on Interest Rate for Interest Adjustment
60	WAIVE_PROF_ID	☐	TB_WAIVE_PROF_ID	T_WAIVE_PROF_ID	CHAR	4	0	Waiver Profile ID	VDWAIVE_PR_HEAD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFICO_COND_POS_VIEW	COUNTRY	T005	LAND1	KEY	1	CN
2	RFICO_COND_POS_VIEW	REGION	T005S	BLAND	KEY	1	CN
3	RFICO_COND_POS_VIEW	SBEWART	TDLOANFUNC	SBEWART
4	RFICO_COND_POS_VIEW	SKOART	TDLOANFKO	SKOART
5	RFICO_COND_POS_VIEW	SKOGRP	TZK04	SKOGRP
6	RFICO_COND_POS_VIEW	SLOANFUNC	TDLOANSUBFUNC	SLOANFUNC
7	RFICO_COND_POS_VIEW	WAIVE_PROF_ID	VDWAIVE_PR_HEAD	WAIVE_PROF_ID

History

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