FICOT_DATE SAP (Date (Obsolete; Not used for persistency)) Table details

Dictionary Type: Table
Description: Date (Obsolete; Not used for persistency)




ABAP Code to SELECT data from FICOT_DATE
Related tables to FICOT_DATE
Access table FICOT_DATE




Table field list including key, data, relationships and ABAP select examples

FICOT_DATE is a standard SAP Table which is used to store Date (Obsolete; Not used for persistency) data and is available within R/3 SAP systems depending on the version and release level.

The FICOT_DATE table consists of various fields, each holding specific information or linking keys about Date (Obsolete; Not used for persistency) data available in SAP. These include I_DATE (Date), I_COND (Condition GUID), D_VALIDFROM (Valid-From Date of Condition), F_VALIDFROMINC (Inclusive indicator for valid from date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FICOT_DATE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
I_DATEDate FICO_IDATERAW16SYSUUID
I_CONDCondition GUID FICO_ICONDRAW16Assigned to domainSYSUUID
D_VALIDFROMValid-From Date of Condition FICO_DVALIDFROMDATS8FICO_DDATE
F_VALIDFROMINCInclusive indicator for valid from date FICO_FVALIDFROMINCCHAR1FICO_FFLAG
F_VALIDFROMULTMonth-End Indicator for Valid-From Date FICO_FVALIDFROMULTCHAR1FICO_FFLAG
D_VALIDTOValid-Top Date of Condition FICO_DVALIDTODATS8FICO_DDATE
F_VALIDTOINCInclusive indicator for valid to date FICO_FVALIDTOINCCHAR1FICO_FFLAG
F_VALIDTOULTMonth-End Indicator for Valid-To Date FICO_FVALIDTOULTCHAR1FICO_FFLAG
O_LEVELTiered or Interval Calculation FICO_OLEVELNUMC1FICO_OLEVEL
O_LEVELTOFROMCondition Item (Upper/Lower Limit) FICO_OLEVELTOFROMNUMC1FICO_OLEVELTOFROM
F_ZEROCONDCondition Form FICO_FZEROCONDCHAR1FICO_FZEROCOND
O_TIMELIMReason for Assignment of Condition FICO_OTIMELIMNUMC2FICOC_TIMELIMFICO_OTIMELIM
O_LEVELEVALLevels for Condition Determination FICO_OLEVELEVALNUMC1FICO_OLEVELEVAL
O_STATUSStatus of Validity Period of a Condition FICO_OSTATUSNUMC2FICO_OSTATUS
F_CORRESPONDENCEGenerate Correspondence FICO_FCORRESPONDENCECHAR1FICO_FFLAG
O_LEVELTOFREVALIndicator: Upper/Lower Limit for Condition Determination FICO_OLEVELTOFREVALNUMC1FICO_OLEVELTOFREVAL
O_RELCONDTYPEReference Condition Type FICO_ORELCONDTYPENUMC6FICOC_CONDFICO_OCONDTYP
F_NOINHERITANCECondition is not Passed On FICO_FNO_INHERITANCECHAR1FICO_FNO_INHERITANCE
O_CONDSOURCEOrigin of the Validity Period FICO_OCONDSOURCECHAR10FICO_OCONDSOURCE
I_LIST_SOURCEOriginal List GUID for the Validity Period FICO_ILISTSOURCERAW16SYSUUID
O_REFUNDCategory for Interest Reimbursement FICO_OREFUNDNUMC1FICO_OREFUND
I_BASIS_ORDEROrdinal Number for Basis Conditions in Condition Merger FICO_IBASIS_MERGENONUMC4FICO_IMERGENO
I_COMP_RELDependent Condition Component from Release FICO_ICOMP_RELRAW16SYSUUID
O_DATECATGDate Category FICO_ODATECATGCHAR6FICOB_DATEFICO_ODATECATG
N_REPPERIODRepetition period FICO_NREPPERIODINT410FICO_NREPPERIOD
O_REPUNITRepetition Unit FICO_OREPUNITCHAR1FICO_OREPUNIT
O_KEYDATEKey Date FICO_OKEYDATENUMC2FICO_OKEYDATE
D_STARTDATEFirst Calculation Date for Date Update FICO_DSTARTDATEDATS8FICO_DDATE
F_STARTDATEINCInclusive Indicator for Start Date FICO_FSTARTDATEINCCHAR1FICO_FFLAG
F_STARTDATEULTMonth-End Indicator for Start Date FICO_FSTARTDATEULTCHAR1FICO_FFLAG
O_DATERULEUpdate Rule FICO_ODATERULENUMC2FICO_ODATERULE
O_PULLDATEShift Due Date FICO_OPULLDATECHAR2FICO_OPULLDATE
O_RHYTHMCATGFrequency Category FICO_ORHYTHMCATGCHAR1FICO_ORHYTHMCATG
O_REFSTARTDATEReference Date for Start Date FICO_OREFSTARTDATENUMC4
N_REFSTARTNUMShift of Reference Date for Start Date: Number of Units FICO_NREFSTARTNUMNUMC3FICO_NNUMUNIT
U_REFSTARTUNITShift of Reference Date for Start Date: Unit FICO_UREFSTARTUNITNUMC1FICO_UDATEUNIT
F_FIXEDPERIODUpdate With Fixed Periods FICO_FFIXEDPERIODCHAR1FICO_FFLAG
O_RELDATECATGReference Date Category FICO_ORELDATECATGCHAR6FICOB_DATEFICO_ODATECATG
O_RELDATESHIFTReference Date After Working Day Shift FICO_ORELDATESHIFTCHAR1FICO_ORELDATESHIFT
O_REL_MISCReference Category for Date Category Adjustment FICO_ORELMISCCHAR1FICO_DOM_ORELMISC
O_CAL1Calendar 1 FICO_OCAL1CHAR2TFACDWFCIDH_TFACD
O_CAL2Calendar 2 FICO_OCAL2CHAR2TFACDWFCIDH_TFACD
O_CAL3Calendar 3 FICO_OCAL3CHAR2TFACDWFCIDH_TFACD
O_CAL5Calendar 4 FICO_OCAL5CHAR2TFACDWFCIDH_TFACD
O_CAL6Calendar 5 FICO_OCAL6CHAR2TFACDWFCIDH_TFACD
O_KEYDATES40Multiple Key Dates, CHAR Field With One Character Per Day FICO_OKEYDATES40CHAR40CHAR40
X_CREATEUSERCreated by FICO_XCREATEUSERCHAR12FICO_XUSER
D_CREATEDATECreated on FICO_DCREATEDATEDATS8FICO_DDATE
T_CREATETIMECreation Time FICO_TCREATETIMETIMS6FICO_TTIME
X_CHANGEUSERLast changed by FICO_XCHANGEUSERCHAR12FICO_XUSER
D_CHANGEDATEChanged on FICO_DCHANGEDATEDATS8FICO_DDATE
T_CHANGETIMEChanged at FICO_TCHANGETIMETIMS6FICO_TTIME
X_RELEASEUSERReleased by FICO_XRELEASEUSERCHAR12FICO_XUSER
D_RELEASEDATEReleased on FICO_DRELEASEDATEDATS8FICO_DDATE
T_RELEASETIMEReleased at FICO_TRELEASETIMETIMS6FICO_TTIME
D_VALIDTO_ARCHIVValid-to Date (Calculated) for Archiving FICO_DVALIDTO_ARCHIVEDATS8FICO_DDATE
ARCHIVE_STATUSArchivability Status AFX_DTE_ARCHIVE_STATUSCHAR1AFX_ARCHIVE_STATUS
ARCHIVE_FLUDResubmission Date AFX_DTE_ARCHIVE_FLUDDATS8DATS
I_GRPGrouping Components of Validity Period FICO_IGRPRAW16SYSUUID
D_VALIDTO_IMPLValid-Top Date of Condition FICO_DVALIDTODATS8FICO_DDATE
I_FLDLSTIDField List FICO_IFLDLSTIDRAW16SYSUUID
F_VTO_ADAPTEDCheckbox for Automatic Deletion of Valid-To Date FICO_FVALIDTO_ADAPTEDCHAR1FICO_FFLAG
D_VTO_RESTOREValid-To Date of Condition to Be Restored FICO_DVALIDTO_RESTOREDATS8FICO_DDATE

Key field Non-key field



How do I retrieve data from SAP table FICOT_DATE using ABAP code

The following ABAP code Example will allow you to do a basic selection on FICOT_DATE to SELECT all data from the table
DATA: WA_FICOT_DATE TYPE FICOT_DATE.

SELECT SINGLE *
FROM FICOT_DATE
INTO CORRESPONDING FIELDS OF WA_FICOT_DATE
WHERE...

How to access SAP table FICOT_DATE

Within an ECC or HANA version of SAP you can also view further information about FICOT_DATE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!