FICOT_DATE - Date (Obsolete; Not used for persistency)
Date (Obsolete; Not used for persistency) information is stored in SAP table FICOT_DATE.
It is part of development package FICO in software component CA-FIM-FCO. This development package consists of objects that can be grouped under "Financial Conditions".
It is part of development package FICO in software component CA-FIM-FCO. This development package consists of objects that can be grouped under "Financial Conditions".
Fields for table FICOT_DATE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| I_DATE | Date | X | FICO_IDATE | RAW | 16 | |
| .INCLUDE | FICOS_COMPONENT | 0 | ||||
| I_COND | Condition GUID | FICO_ICOND | RAW | 16 | * | |
| D_VALIDFROM | Valid-From Date of Condition | FICO_DVALIDFROM | DATS | 16 | ||
| F_VALIDFROMINC | Inclusive indicator for valid from date | FICO_FVALIDFROMINC | CHAR | 2 | ||
| F_VALIDFROMULT | Month-End Indicator for Valid-From Date | FICO_FVALIDFROMULT | CHAR | 2 | ||
| D_VALIDTO | Valid-Top Date of Condition | FICO_DVALIDTO | DATS | 16 | ||
| F_VALIDTOINC | Inclusive indicator for valid to date | FICO_FVALIDTOINC | CHAR | 2 | ||
| F_VALIDTOULT | Month-End Indicator for Valid-To Date | FICO_FVALIDTOULT | CHAR | 2 | ||
| O_LEVEL | Tiered or Interval Calculation | FICO_OLEVEL | NUMC | 2 | ||
| O_LEVELTOFROM | Condition Item (Upper/Lower Limit) | FICO_OLEVELTOFROM | NUMC | 2 | ||
| F_ZEROCOND | Condition Form | FICO_FZEROCOND | CHAR | 2 | ||
| O_TIMELIM | Reason for Assignment of Condition | FICO_OTIMELIM | NUMC | 4 | FICOC_TIMELIM | |
| O_LEVELEVAL | Levels for Condition Determination | FICO_OLEVELEVAL | NUMC | 2 | ||
| O_STATUS | Status of Validity Period of a Condition | FICO_OSTATUS | NUMC | 4 | ||
| F_CORRESPONDENCE | Create Correspondence | FICO_FCORRESPONDENCE | CHAR | 2 | ||
| O_LEVELTOFREVAL | Indicator: Upper/Lower Limit for Condition Determination | FICO_OLEVELTOFREVAL | NUMC | 2 | ||
| O_RELCONDTYPE | Reference Condition Type | FICO_ORELCONDTYPE | NUMC | 12 | FICOC_COND | |
| F_NOINHERITANCE | Condition is not Passed On | FICO_FNO_INHERITANCE | CHAR | 2 | ||
| O_CONDSOURCE | Origin of the Validity Period | FICO_OCONDSOURCE | CHAR | 20 | ||
| I_LIST_SOURCE | Original List GUID for the Validity Period | FICO_ILISTSOURCE | RAW | 16 | ||
| O_REFUND | Category for Interest Reimbursement | FICO_OREFUND | NUMC | 2 | ||
| I_BASIS_ORDER | Ordinal Number for Basis Conditions in Condition Merger | FICO_IBASIS_MERGENO | NUMC | 8 | ||
| I_COMP_REL | Dependent Condition Component from Release | FICO_ICOMP_REL | RAW | 16 | ||
| .INCLUDE | FICOS_DATE | 0 | ||||
| O_DATECATG | Date Category | FICO_ODATECATG | CHAR | 12 | FICOB_DATE | |
| N_REPPERIOD | Repetition period | FICO_NREPPERIOD | INT4 | 4 | ||
| O_REPUNIT | Repetition Unit | FICO_OREPUNIT | CHAR | 2 | ||
| O_KEYDATE | Key Date | FICO_OKEYDATE | NUMC | 4 | ||
| D_STARTDATE | First Calculation Date for Date Update | FICO_DSTARTDATE | DATS | 16 | ||
| F_STARTDATEINC | Inclusive Indicator | FICO_FSTARTDATEINC | CHAR | 2 | ||
| F_STARTDATEULT | Month-End Indicator for Start Date | FICO_FSTARTDATEULT | CHAR | 2 | ||
| O_DATERULE | Update Rule | FICO_ODATERULE | NUMC | 4 | ||
| O_PULLDATE | Shift Due Date | FICO_OPULLDATE | CHAR | 4 | ||
| O_RHYTHMCATG | Frequency Category | FICO_ORHYTHMCATG | CHAR | 2 | ||
| O_REFSTARTDATE | Reference Date for Start Date | FICO_OREFSTARTDATE | NUMC | 8 | ||
| N_REFSTARTNUM | Shift of Reference Date for Start Date: Number of Units | FICO_NREFSTARTNUM | NUMC | 6 | ||
| U_REFSTARTUNIT | Shift of Reference Date for Start Date: Unit | FICO_UREFSTARTUNIT | NUMC | 2 | ||
| F_FIXEDPERIOD | Update With Fixed Periods | FICO_FFIXEDPERIOD | CHAR | 2 | ||
| O_RELDATECATG | Reference Date Category | FICO_ORELDATECATG | CHAR | 12 | FICOB_DATE | |
| O_RELDATESHIFT | Reference Date After Working Day Shift | FICO_ORELDATESHIFT | CHAR | 2 | ||
| O_REL_MISC | Reference Category for Date Category Adjustment | FICO_ORELMISC | CHAR | 2 | ||
| O_CAL1 | Calendar 1 | FICO_OCAL1 | CHAR | 4 | TFACD | |
| O_CAL2 | Calendar 2 | FICO_OCAL2 | CHAR | 4 | TFACD | |
| O_CAL3 | Calendar 3 | FICO_OCAL3 | CHAR | 4 | TFACD | |
| O_CAL5 | Calendar 4 | FICO_OCAL5 | CHAR | 4 | TFACD | |
| O_CAL6 | Calendar 5 | FICO_OCAL6 | CHAR | 4 | TFACD | |
| O_KEYDATES40 | Multiple Key Dates, CHAR Field With One Character Per Day | FICO_OKEYDATES40 | CHAR | 80 | ||
| N_LOCKOUTDAYS | Duration of Lockout Period in Working Days | FICO_NLOCKOUTDAYS | NUMC | 4 | ||
| .INCLUDE | FICOS_USERDATA | 0 | ||||
| X_CREATEUSER | Created by | FICO_XCREATEUSER | CHAR | 24 | ||
| D_CREATEDATE | Created on | FICO_DCREATEDATE | DATS | 16 | ||
| T_CREATETIME | Creation Time | FICO_TCREATETIME | TIMS | 12 | ||
| X_CHANGEUSER | Last changed by | FICO_XCHANGEUSER | CHAR | 24 | ||
| D_CHANGEDATE | Changed on | FICO_DCHANGEDATE | DATS | 16 | ||
| T_CHANGETIME | Changed at | FICO_TCHANGETIME | TIMS | 12 | ||
| X_RELEASEUSER | Released by | FICO_XRELEASEUSER | CHAR | 24 | ||
| D_RELEASEDATE | Released on | FICO_DRELEASEDATE | DATS | 16 | ||
| T_RELEASETIME | Released at | FICO_TRELEASETIME | TIMS | 12 | ||
| D_VALIDTO_ARCHIV | Valid-to Date (Calculated) for Archiving | FICO_DVALIDTO_ARCHIVE | DATS | 16 | ||
| .INCLUDE | AFX_STR_ARCHIVE_DATA | 0 | ||||
| ARCHIVE_STATUS | Archivability Status | AFX_DTE_ARCHIVE_STATUS | CHAR | 2 | ||
| ARCHIVE_FLUD | Resubmission Date | AFX_DTE_ARCHIVE_FLUD | DATS | 16 | ||
| I_GRP | Grouping Components of Validity Period | FICO_IGRP | RAW | 16 | ||
| D_VALIDTO_IMPL | Valid-Top Date of Condition | FICO_DVALIDTO | DATS | 16 | ||
| I_FLDLSTID | Field List | FICO_IFLDLSTID | RAW | 16 | ||
| F_VTO_ADAPTED | Checkbox for Automatic Deletion of Valid-To Date | FICO_FVALIDTO_ADAPTED | CHAR | 2 | ||
| D_VTO_RESTORE | Valid-To Date of Condition to Be Restored | FICO_DVALIDTO_RESTORE | DATS | 16 |