SAP Table FICOT_DATE
Date
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table FICOT_DATE (Date) is a standard table in SAP ERP. It belongs to the package FICO.
Technical Information
| Table | FICOT_DATE |
| Short Text | Date |
| Package | FICO |
| Table Type | Transparent Table |
Fields for Table FICOT_DATE
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| I_DATE | ✔ | Date | FICO_IDATE | RAW | 16 | |
| I_COND | Condition GUID | FICO_ICOND | RAW | 16 | * | |
| D_VALIDFROM | Valid-From Date of Condition | FICO_DVALIDFROM | DATS | 8 | ||
| F_VALIDFROMINC | Inclusive indicator for valid from date | FICO_FVALIDFROMINC | CHAR | 1 | ||
| F_VALIDFROMULT | Month-End Indicator for Valid-From Date | FICO_FVALIDFROMULT | CHAR | 1 | ||
| D_VALIDTO | Valid-Top Date of Condition | FICO_DVALIDTO | DATS | 8 | ||
| F_VALIDTOINC | Inclusive indicator for valid to date | FICO_FVALIDTOINC | CHAR | 1 | ||
| F_VALIDTOULT | Month-End Indicator for Valid-To Date | FICO_FVALIDTOULT | CHAR | 1 | ||
| O_LEVEL | Tiered or Interval Calculation | FICO_OLEVEL | NUMC | 1 | ||
| O_LEVELTOFROM | Condition Item (Upper/Lower Limit) | FICO_OLEVELTOFROM | NUMC | 1 | ||
| F_ZEROCOND | Condition Form | FICO_FZEROCOND | CHAR | 1 | ||
| O_TIMELIM | Reason for Assignment of Condition | FICO_OTIMELIM | NUMC | 2 | FICOC_TIMELIM | |
| O_LEVELEVAL | Levels for Condition Determination | FICO_OLEVELEVAL | NUMC | 1 | ||
| O_STATUS | Status of Validity Period of a Condition | FICO_OSTATUS | NUMC | 2 | ||
| F_CORRESPONDENCE | Generate Correspondence | FICO_FCORRESPONDENCE | CHAR | 1 | ||
| O_LEVELTOFREVAL | Indicator: Upper/Lower Limit for Condition Determination | FICO_OLEVELTOFREVAL | NUMC | 1 | ||
| O_RELCONDTYPE | Reference Condition Type | FICO_ORELCONDTYPE | NUMC | 6 | FICOC_COND | |
| F_NOINHERITANCE | Condition is not Passed On | FICO_FNO_INHERITANCE | CHAR | 1 | ||
| O_CONDSOURCE | Origin of the Validity Period | FICO_OCONDSOURCE | CHAR | 10 | ||
| I_LIST_SOURCE | Original List GUID for the Validity Period | FICO_ILISTSOURCE | RAW | 16 | ||
| O_REFUND | Category for Interest Reimbursement | FICO_OREFUND | NUMC | 1 | ||
| I_BASIS_ORDER | Ordinal Number for Basis Conditions in Condition Merger | FICO_IBASIS_MERGENO | NUMC | 4 | ||
| I_COMP_REL | Dependent Condition Component from Release | FICO_ICOMP_REL | RAW | 16 | ||
| O_DATECATG | Date Category | FICO_ODATECATG | CHAR | 6 | FICOB_DATE | |
| N_REPPERIOD | Repetition period | FICO_NREPPERIOD | INT4 | 10 | ||
| O_REPUNIT | Repetition Unit | FICO_OREPUNIT | CHAR | 1 | ||
| O_KEYDATE | Key Date | FICO_OKEYDATE | NUMC | 2 | ||
| D_STARTDATE | First Calculation Date for Date Update | FICO_DSTARTDATE | DATS | 8 | ||
| F_STARTDATEINC | Inclusive Indicator for Start Date | FICO_FSTARTDATEINC | CHAR | 1 | ||
| F_STARTDATEULT | Month-End Indicator for Start Date | FICO_FSTARTDATEULT | CHAR | 1 | ||
| O_DATERULE | Update Rule | FICO_ODATERULE | NUMC | 2 | ||
| O_PULLDATE | Shift Due Date | FICO_OPULLDATE | CHAR | 2 | ||
| O_RHYTHMCATG | Frequency Category | FICO_ORHYTHMCATG | CHAR | 1 | ||
| O_REFSTARTDATE | Reference Date for Start Date | FICO_OREFSTARTDATE | NUMC | 4 | ||
| N_REFSTARTNUM | Shift of Reference Date for Start Date: Number of Units | FICO_NREFSTARTNUM | NUMC | 3 | ||
| U_REFSTARTUNIT | Shift of Reference Date for Start Date: Unit | FICO_UREFSTARTUNIT | NUMC | 1 | ||
| F_FIXEDPERIOD | Update With Fixed Periods | FICO_FFIXEDPERIOD | CHAR | 1 | ||
| O_RELDATECATG | Reference Date Category | FICO_ORELDATECATG | CHAR | 6 | FICOB_DATE | |
| O_RELDATESHIFT | Reference Date After Working Day Shift | FICO_ORELDATESHIFT | CHAR | 1 | ||
| O_REL_MISC | Reference Category for Date Category Adjustment | FICO_ORELMISC | CHAR | 1 | ||
| O_CAL1 | Calendar 1 | FICO_OCAL1 | CHAR | 2 | TFACD | |
| O_CAL2 | Calendar 2 | FICO_OCAL2 | CHAR | 2 | TFACD | |
| O_CAL3 | Calendar 3 | FICO_OCAL3 | CHAR | 2 | TFACD | |
| O_CAL5 | Calendar 4 | FICO_OCAL5 | CHAR | 2 | TFACD | |
| O_CAL6 | Calendar 5 | FICO_OCAL6 | CHAR | 2 | TFACD | |
| O_KEYDATES40 | Multiple Key Dates, CHAR Field With One Character Per Day | FICO_OKEYDATES40 | CHAR | 40 | ||
| X_CREATEUSER | Created by | FICO_XCREATEUSER | CHAR | 12 | ||
| D_CREATEDATE | Created on | FICO_DCREATEDATE | DATS | 8 | ||
| T_CREATETIME | Creation Time | FICO_TCREATETIME | TIMS | 6 | ||
| X_CHANGEUSER | Last changed by | FICO_XCHANGEUSER | CHAR | 12 | ||
| D_CHANGEDATE | Changed on | FICO_DCHANGEDATE | DATS | 8 | ||
| T_CHANGETIME | Changed at | FICO_TCHANGETIME | TIMS | 6 | ||
| X_RELEASEUSER | Released by | FICO_XRELEASEUSER | CHAR | 12 | ||
| D_RELEASEDATE | Released on | FICO_DRELEASEDATE | DATS | 8 | ||
| T_RELEASETIME | Released at | FICO_TRELEASETIME | TIMS | 6 | ||
| D_VALIDTO_ARCHIV | Valid-to Date (Calculated) for Archiving | FICO_DVALIDTO_ARCHIVE | DATS | 8 | ||
| ARCHIVE_STATUS | Archivability Status | AFX_DTE_ARCHIVE_STATUS | CHAR | 1 | ||
| ARCHIVE_FLUD | Resubmission Date | AFX_DTE_ARCHIVE_FLUD | DATS | 8 | ||
| I_GRP | Grouping Components of Validity Period | FICO_IGRP | RAW | 16 | ||
| D_VALIDTO_IMPL | Valid-Top Date of Condition | FICO_DVALIDTO | DATS | 8 | ||
| I_FLDLSTID | Field List | FICO_IFLDLSTID | RAW | 16 | ||
| F_VTO_ADAPTED | Checkbox for Automatic Deletion of Valid-To Date | FICO_FVALIDTO_ADAPTED | CHAR | 1 | ||
| D_VTO_RESTORE | Valid-To Date of Condition to Be Restored | FICO_DVALIDTO_RESTORE | DATS | 8 |