SAP ABAP Table FICO_STR_AMT_FDB (Amounts)
Hierarchy
☛
SAP_ABA (Software Component) Cross-Application Component
⤷ CA-FIM-FCO (Application Component) Financial Conditions
⤷ FICO (Package) Financial Conditions
⤷ CA-FIM-FCO (Application Component) Financial Conditions
⤷ FICO (Package) Financial Conditions
Basic Data
Table Category | INTTAB | Structure |
Structure | FICO_STR_AMT_FDB | Table Relationship Diagram |
Short Description | Amounts |
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 | Mutual Data of Condition Parts | |||||
2 | I_COND | FICO_ICOND | SYSUUID | RAW | 16 | 0 | Condition GUID | ||
3 | D_VALIDFROM | FICO_DVALIDFROM | FICO_DDATE | DATS | 8 | 0 | Valid-From Date of Condition | ||
4 | F_VALIDFROMINC | FICO_FVALIDFROMINC | FICO_FFLAG | CHAR | 1 | 0 | Inclusive indicator for valid from date | ||
5 | F_VALIDFROMULT | FICO_FVALIDFROMULT | FICO_FFLAG | CHAR | 1 | 0 | Month-End Indicator for Valid-From Date | ||
6 | D_VALIDTO | FICO_DVALIDTO | FICO_DDATE | DATS | 8 | 0 | Valid-Top Date of Condition | ||
7 | F_VALIDTOINC | FICO_FVALIDTOINC | FICO_FFLAG | CHAR | 1 | 0 | Inclusive indicator for valid to date | ||
8 | F_VALIDTOULT | FICO_FVALIDTOULT | FICO_FFLAG | CHAR | 1 | 0 | Month-End Indicator for Valid-To Date | ||
9 | O_LEVEL | FICO_OLEVEL | FICO_OLEVEL | NUMC | 1 | 0 | Tiered or Interval Calculation | ||
10 | O_LEVELTOFROM | FICO_OLEVELTOFROM | FICO_OLEVELTOFROM | NUMC | 1 | 0 | Condition Item (Upper/Lower Limit) | ||
11 | F_ZEROCOND | FICO_FZEROCOND | FICO_FZEROCOND | CHAR | 1 | 0 | Condition Form | ||
12 | O_TIMELIM | FICO_OTIMELIM | FICO_OTIMELIM | NUMC | 2 | 0 | Reason for Assignment of Condition | FICOC_TIMELIM | |
13 | O_LEVELEVAL | FICO_OLEVELEVAL | FICO_OLEVELEVAL | NUMC | 1 | 0 | Levels for Condition Determination | ||
14 | O_STATUS | FICO_OSTATUS | FICO_OSTATUS | NUMC | 2 | 0 | Status of Validity Period of a Condition | ||
15 | F_CORRESPONDENCE | FICO_FCORRESPONDENCE | FICO_FFLAG | CHAR | 1 | 0 | Generate Correspondence | ||
16 | O_LEVELTOFREVAL | FICO_OLEVELTOFREVAL | FICO_OLEVELTOFREVAL | NUMC | 1 | 0 | Indicator: Upper/Lower Limit for Condition Determination | ||
17 | O_RELCONDTYPE | FICO_ORELCONDTYPE | FICO_OCONDTYP | NUMC | 6 | 0 | Reference Condition Type | FICOC_COND | |
18 | F_NOINHERITANCE | FICO_FNO_INHERITANCE | FICO_FNO_INHERITANCE | CHAR | 1 | 0 | Condition is not Passed On | ||
19 | O_CONDSOURCE | FICO_OCONDSOURCE | FICO_OCONDSOURCE | CHAR | 10 | 0 | Origin of the Validity Period | ||
20 | I_LIST_SOURCE | FICO_ILISTSOURCE | SYSUUID | RAW | 16 | 0 | Original List GUID for the Validity Period | ||
21 | O_REFUND | FICO_OREFUND | FICO_OREFUND | NUMC | 1 | 0 | Category for Interest Reimbursement | ||
22 | I_BASIS_ORDER | FICO_IBASIS_MERGENO | FICO_IMERGENO | NUMC | 4 | 0 | Ordinal Number for Basis Conditions in Condition Merger | ||
23 | I_COMP_REL | FICO_ICOMP_REL | SYSUUID | RAW | 16 | 0 | Dependent Condition Component from Release | ||
24 | .INCLUDE | 0 | 0 | Amount data | |||||
25 | O_AMTCATG | FICO_OAMTCATG | FICO_OAMTCATG | CHAR | 6 | 0 | Amount Category | FICOB_AMT | |
26 | F_ADDDEBIT | FICO_FADDDEBIT | FICO_FFLAG | CHAR | 1 | 0 | Obsolete: Ind. Overdraft Int. in Addition to Debit Interest | ||
27 | O_INSTMETH | FICO_OINSTMETH | FICO_OINSTMETH | CHAR | 4 | 0 | Amout Determination Category for Payment Condition | ||
28 | O_INTMETHOD | FICO_OINTMETHOD | SZBMETH_NEW | CHAR | 1 | 0 | Interest Calculation Method | ||
29 | F_EXPINT | FICO_FEXPINT | FICO_FEXPINT | CHAR | 1 | 0 | Exponential/Linear Interest Calculation | ||
30 | O_AMMRHYZV | TFM_AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | 0 | Interest Settlement Frequency for Exponential Interest Calc. | ||
31 | A_FREEAMT | FICO_AFREEAMT | FICO_AAMT | CURR | 23 | 2 | Exemption | ||
32 | N_FREECOUNT | FICO_NFREECOUNT | FICO_NCOUNT | NUMC | 7 | 0 | Number of Free Items | ||
33 | F_CAPITALINCREM | FICO_FCAPITALINCREM | FICO_FFLAG | CHAR | 1 | 0 | Indicator: Capitalization | ||
34 | F_DUEDATEREL | FICO_FDUEDATEREL | FICO_FFLAG | CHAR | 1 | 0 | Due Date-Related Calculation Indicator | ||
35 | F_GRACEINT | FICO_FGRACEINT | FICO_FFLAG | CHAR | 1 | 0 | Grace Period Interest Method | ||
36 | O_CAL4 | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | TFACD | |
37 | F_ROUND | FICO_FROUND | TFM_SROUND | CHAR | 1 | 0 | Rounding Category | ||
38 | U_ROUNDUNIT | FICO_UROUNDUNIT | TFMSRUNIT | DEC | 13 | 7 | Rounding Unit | ||
39 | F_COUNT_AMOUNT | FICO_FCOUNT_AMOUNT | FICO_FFLAG | CHAR | 1 | 0 | Amount Counter | ||
40 | O_SETTLEMENT | FICO_OSETTLEMENT | FICO_OSETTLEMENT | CHAR | 1 | 0 | Type of Clearing | ||
41 | O_FIMATIMEPROP | FICO_OFIMATIMEPROP | VVSZEITANT | NUMC | 1 | 0 | Indicator for Pro Rata Calculations in Cash Flow | ||
42 | O_ITEMCOUNTER | FICO_OITEMCOUNTER | FICO_OITEMCOUNTER | CHAR | 6 | 0 | Counter | ||
43 | .INCLUDE | 0 | 0 | Amount Component for Interest Penalty Calculation | |||||
44 | O_PCALCREF | FICO_OPCALC | FICO_OPCALC | CHAR | 2 | 0 | Calculation Method for Early Withdrawal Penalty | FICOC_PCALCREF | |
45 | F_REDUCTION | FICO_FREDUCTION | FICO_FFLAG | CHAR | 1 | 0 | Obsolete: Do Not Use | ||
46 | O_RES_METH_TYPE | FICO_ORES_METH_TYPE | NUMC | 4 | 0 | Result Calculation Type | |||
47 | .INCLUDE | 0 | 0 | Amount and/or Installment-Based Reduction | |||||
48 | A_AMT_CUTB | FICO_AAMT_CUTB | FICO_AAMT | CURR | 23 | 2 | Reduction Amount | ||
49 | R_PERC_CUTB | FICO_RPERCENTAGE_CUTB | FICO_RPERCENTAGE | DEC | 15 | 10 | Perecentage Reduction | ||
50 | O_INTREF_CUTB | FICO_OINTREF_CUTB | CHAR | 10 | 0 | Reference Interest Rate Reduction | |||
51 | R_INTMIN_CUTB | FICO_RINTMIN_CUTB | FICO_RPERCENTAGE | DEC | 15 | 10 | Minimum Interest Reduction | ||
52 | R_INTMAX_CUTB | FICO_RINTMAX_CUTB | FICO_RPERCENTAGE | DEC | 15 | 10 | Maximum Interest Reduction | ||
53 | N_CHRGCOUNT | FICO_NCHRGCOUNT | FICO_NCOUNT | NUMC | 7 | 0 | Maximum Number of Items | ||
54 | F_RELATION | FICO_FRELATION | FICO_FFLAG | CHAR | 1 | 0 | Condition has Relationships | ||
55 | .INCLUDE | 0 | 0 | Condition Determination | |||||
56 | O_REFDATE | FICO_OREFDATE | FICO_OREFDATE | NUMC | 1 | 0 | Reference Date | ||
57 | U_REFDATUNIT | FICO_UREFDATUNIT | FICO_UDATEUNIT | NUMC | 1 | 0 | Shift of Reference Date: Unit | ||
58 | N_REFDATNUM | FICO_NREFDATNUM | FICO_NNUMUNIT | NUMC | 3 | 0 | Shift of reference date: Number of units | ||
59 | O_REFDATSETDATE | FICO_OREFDATSETDATE | FICO_OSETDATE | NUMC | 2 | 0 | Shift of reference date: Key date | ||
60 | U_UNITDETSHIFT | FICO_UUNITDETSHIFT | FICO_UDATEUNIT | NUMC | 1 | 0 | Shift of Determination Period: Unit | ||
61 | N_NUMDETSHIFT | FICO_NNUMDETSHIFT | FICO_NNUMUNIT | NUMC | 3 | 0 | Shift of Calculation Period: Number of Units | ||
62 | O_USEPRD | FICO_OUSEPRD | FICO_OUSEPRD | NUMC | 2 | 0 | Use Period | FICOC_USEPRD | |
63 | O_DETPRD | FICO_ODETPRD | FICO_ODETPRD | NUMC | 2 | 0 | Determination Period | FICOC_DETPRD | |
64 | O_TIMEPROPCALC | FICO_OTIMEPROPCALC | FICO_OTIMEPROPCALC | NUMC | 2 | 0 | Charge Calculation Method | ||
65 | O_TRNOVRCLASS | FICO_OTRNOVRCLASS | FICO_OTRNOVRCLASS | CHAR | 4 | 0 | Turnover Class | ||
66 | O_TRNOVRCLBASE | FICO_OTRNOVRCLBASE | FICO_OTRNOVRCLBASE | NUMC | 2 | 0 | Balancing Method | ||
67 | O_BALANCECATG | FICO_OBALANCECATG | FICO_OBALANCECATG | NUMC | 2 | 0 | Balance Category | ||
68 | O_BALANCEBASE | FICO_OBALANCEBASE | FICO_OBALANCEBASE | NUMC | 2 | 0 | Basis of Balances | ||
69 | O_PERIODCATG | FICO_OPERIODCATG | FICO_OPERIODCATG | NUMC | 2 | 0 | Period Category | ||
70 | O_BASEREFEVAL | FICO_OBASEREFEVAL | CHAR | 10 | 0 | Calculation Basis | |||
71 | FICO_AMTPOS | FICO_TAB_AMTPOS_FDB | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FICO_STR_AMT_FDB | O_AMTCATG | FICOB_AMT | O_AMTCATG | KEY | ||
2 | FICO_STR_AMT_FDB | O_CAL4 | TFACD | IDENT | REF | 1 | CN |
3 | FICO_STR_AMT_FDB | O_DETPRD | FICOC_DETPRD | O_DETPRD | REF | 1 | C |
4 | FICO_STR_AMT_FDB | O_PCALCREF | FICOC_PCALCREF | O_PCALCREF | KEY | 1 | CN |
5 | FICO_STR_AMT_FDB | O_RELCONDTYPE | FICOC_COND | O_CONDTYPE | REF | 1 | CN |
6 | FICO_STR_AMT_FDB | O_TIMELIM | FICOC_TIMELIM | O_TIMELIM | REF | 1 | C |
7 | FICO_STR_AMT_FDB | O_USEPRD | FICOC_USEPRD | O_USEPRD | REF | 1 | C |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 30 |