SAP ABAP Table FILA_RE_S_PRG_COMPLET (Complete Refinancing Program)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ FI-LA (Application Component) Lease Accounting
     ⤷ FI_LA_RE_APPL (Package) Applications for the Refinancing Solution

Basic Data

Table Category	INTTAB	Structure
Structure	FILA_RE_S_PRG_COMPLET	Table Relationship Diagram
Short Description	Complete Refinancing Program

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	Structure: Refinancing Program + Name
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	PRGNO	☐	FILA_RE_E_PRGNO	FILA_RE_PRGNO	CHAR	10	0	Refinancing Program Number	FILA_RE_PRG
4	.INCLUDE	☐				0	0	Structure: Refinancing Program
5	REFICAT	☐	FILA_RE_E_REFICAT	FILA_RE_REFICAT	CHAR	10	0	Refinancing Category	TFILA_RE_CAT
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	PBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
8	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
9	GP_DEB_FIN	☐	FILA_RE_E_GP_DEB_FIN	KUNNR	CHAR	10	0	Customer Number of Financing Party for Refinancing	KNA1
10	GP_CRED_FIN	☐	FILA_RE_E_GP_CRED_FIN	LIFNR	CHAR	10	0	Vendor Number of Financing Party for Refinancing	LFA1
11	GP_DEB_SALB	☐	FILA_RE_E_GP_DEB_SALB	KUNNR	CHAR	10	0	Customer Number of Sales Company for Object Company	KNA1
12	GP_CRED_SALB	☐	FILA_RE_E_GP_CRED_SALB	LIFNR	CHAR	10	0	Vendor Number of Sales Company for Object Company	LFA1
13	FROMDATE	☐	FROMDATE	DATUM	DATS	8	0	Valid-from date
14	TODATE	☐	TODATE	DATUM	DATS	8	0	Valid to Date
15	INTEREST	☐	FILA_RE_E_INTEREST	DEC3_7	DEC	10	7	Interest Rate for Refinancing
16	INTEREST_INSTAL	☐	FILA_RE_E_INTEREST_INSTAL	DEC3_7	DEC	10	7	Interest Rate for Present Value Calculation
17	PRESVAL_MIN	☐	FILA_RE_E_PRESVAL_MIN	T_PRESVAL	CURR	17	2	Minimum Present Value per Contract
18	PRESVAL_MIN_TR	☐	FILA_RE_E_PRESVAL_MIN_TR	T_PRESVAL	CURR	17	2	Minimum Present Value per Tranche
19	PRESVAL_MAX_PRG	☐	FILA_RE_E_PRESVAL_MAX_PRG	T_PRESVAL	CURR	17	2	Maximum Present Value per Refinancing Program
20	PAYMENT_FORM	☐	TFM_SZAWS	TFM_SZAWS	NUMC	1	0	Payment Form (Period Start, Mid-Period, Period End, Other)
21	TFM_PERIODICITY	☐	TFM_PERIODICITY	TFM_PERIODICITY	NUMC	2	0	Periods
22	VVSINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
23	TB_JZINSRE	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
24	TFM_AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
25	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
26	.INCLUDE	☐				0	0	Structure: Refinancing Program Name
27	TEXT	☐	FILA_RE_E_TXT_RPRG	TEXT40	CHAR	40	0	Name of Refinancing Program
28	.INCLUDE	☐				0	0	Structure: Refinancing Category
29	REFITYP	☐	FILA_RE_E_REFITYP	FILA_RE_REFITYP	CHAR	4	0	Refinancing Type
30	.INCLUDE	☐				0	0	Structure: Name of Refinancing Category
31	TXT_RCAT	☐	FILA_RE_E_TXT_RCAT	TEXT40	CHAR	40	0	Name of Refinancing Category
32	.INCLUDE	☐				0	0	Structure: Tax Code and Clearing Account
33	MWSKZ_AA	☐	FILA_RE_E_MWSKZ_AA	MWSKZ	CHAR	2	0	Tax Code for Asset Sale (Output Tax)	T007A
34	MWSKZ_VA	☐	FILA_RE_E_MWSKZ_VA	MWSKZ	CHAR	2	0	Tax Code for Asset Sale (Input Tax)	T007A
35	MWSKZ_AL	☐	FILA_RE_E_MWSKZ_AL	MWSKZ	CHAR	2	0	Tax Code for Lessor Contract (Output Tax)	T007A
36	MWSKZ_VL	☐	FILA_RE_E_MWSKZ_VL	MWSKZ	CHAR	2	0	Tax Code for Lessee Contract (Input Tax)	T007A
37	SAKNR_S	☐	FILA_RE_E_SAKNR_S	SAKNR	CHAR	10	0	Sale Clearing Account	SKA1
38	SAKNR_B	☐	FILA_RE_E_SAKNR_B	SAKNR	CHAR	10	0	Purchase Clearing Account	SKA1
39	SAKNR_R	☐	FILA_RE_E_SAKNR_R	SAKNR	CHAR	10	0	Installment Clearing Account	SKA1
40	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
41	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
42	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	T685
43	KSCHL_V	☐	FILA_RE_E_KSCHA	KSCHL	CHAR	4	0	Condition Type Input Tax	*
44	.INCLUDE	☐				0	0	Number Ranges per Refinancing Type
45	REFINKNRP	☐	FILA_RE_E_REFINKNRP	CHAR2	CHAR	2	0	Number Range Number for Refinancing (Passive Contract)
46	REFINKNRA	☐	FILA_RE_E_REFINKNRA	CHAR2	CHAR	2	0	Number Range Number for Refinancing (SALB Only)
47	CHGPR	☐	FILA_RE_T_CHGPR_T		TTYP	0	0
48	EVENT	☐	FILA_RE_T_EVENT_T		TTYP	0	0
49	VAL	☐	FILA_RE_T_VAL_T		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FILA_RE_S_PRG_COMPLET	ALAND	T005	LAND1
2	FILA_RE_S_PRG_COMPLET	BLART	T003	BLART
3	FILA_RE_S_PRG_COMPLET	BUKRS	T001	BUKRS
4	FILA_RE_S_PRG_COMPLET	CURRENCY	TCURC	WAERS
5	FILA_RE_S_PRG_COMPLET	GP_CRED_FIN	LFA1	LIFNR
6	FILA_RE_S_PRG_COMPLET	GP_CRED_SALB	LFA1	LIFNR
7	FILA_RE_S_PRG_COMPLET	GP_DEB_FIN	KNA1	KUNNR
8	FILA_RE_S_PRG_COMPLET	GP_DEB_SALB	KNA1	KUNNR
9	FILA_RE_S_PRG_COMPLET	KSCHL	T685	KSCHL
10	FILA_RE_S_PRG_COMPLET	MWSKZ_AA	T007A	MWSKZ
11	FILA_RE_S_PRG_COMPLET	MWSKZ_AL	T007A	MWSKZ
12	FILA_RE_S_PRG_COMPLET	MWSKZ_VA	T007A	MWSKZ
13	FILA_RE_S_PRG_COMPLET	MWSKZ_VL	T007A	MWSKZ
14	FILA_RE_S_PRG_COMPLET	PBUKRS	T001	BUKRS
15	FILA_RE_S_PRG_COMPLET	PRGNO	FILA_RE_PRG	MANDT
16	FILA_RE_S_PRG_COMPLET	REFICAT	TFILA_RE_CAT	REFICAT
17	FILA_RE_S_PRG_COMPLET	SAKNR_B	SKA1	SAKNR
18	FILA_RE_S_PRG_COMPLET	SAKNR_R	SKA1	SAKNR
19	FILA_RE_S_PRG_COMPLET	SAKNR_S	SKA1	SAKNR

History

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