1. Home
  2. Resources
  3. SAP Tables
  4. OICF5_A - Structure for display of A term calculation rules

SAP Table OICF5_A

Structure for display of A term calculation rules

OICF5_A (Structure for display of A term calculation rules) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OICF5_A to other SAP tables.

OICF5_A table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
FORTRMTYP Formula term type OIC_TRMTYP CHAR 1 0
1 'A' Term
2 'B' Term
PFIND Formula provisional/final indicator OIC_PFIND CHAR 1 0
1 Final
2 Provisional
REFDATE User exit for reference date determination OIC_REFDAT NUMC 3 0
TIMUOM Time unit of measure exit OIC_TIMUOM NUMC 3 0
WERULE Weekend rule exit OIC_WERULE NUMC 3 0
NPDAYS Non-posted days rule exit OIC_NPDAYS NUMC 3 0
ERRHAN Error handling exit, if no quotation found OIC_ERRHAN NUMC 3 0
RDOFFSET Offset from reference date OIC_RDOFF NUMC 3 0
PERBEF Period before base date OIC_PERBEF NUMC 3 0
PERAFT Period after base date OIC_PERAFT NUMC 3 0
EXCEX Exclude Base Date OIC_EXCEV CHAR 1 0
X Yes
NULL No
DATFRM 'Date from' for average period OIC_DATFRM DATS 8 0
DATTO 'Date to' for fixation period OIC_DATTO DATS 8 0
CARULE Average currency rule OIC_CARULE NUMC 3 0
CDRULE Daily currency rule OIC_CDRULE NUMC 3 0
CREFDATE Determination exit for currency reference date OIC_CREFDT NUMC 3 0
CTIMUOM Currency time unit of measure exit OIC_CTIMUM NUMC 3 0
CWERULE Currency weekend rule exit OIC_CWERUL NUMC 3 0
CNPDAYS Currency non-posted days rule exit OIC_CNPDAY NUMC 3 0
CERRHAN Error-handling exit (if no exch.rate found) OIC_CERRHN NUMC 3 0
CRDOFFSET Offset from reference date for currency OIC_CRDOFF NUMC 3 0
CPERBEF Period before base date for currency OIC_CPERBF NUMC 3 0
CPERAFT Period after base date for currency OIC_CPERAF NUMC 3 0
CEXCEV Exclude Base Date for Currency OIC_CEXCEV CHAR 1 0
X Yes
NULL No
CDATFRM Date from for fixation period for currency OIC_CDATFR DATS 8 0
CDATTO Date to for fixation period for currency OIC_CDATTO DATS 8 0
TERMVAL Formula term value OIC_TERMVL CURR 15 2
TERMCURR Currency for formula term OIC_TERMCU TCURC CUKY 5 0
DDATFRM 'Date from' determined for fixation period OIC_DDATFR DATS 8 0
DDATTO 'Date to' determined for fixation period OIC_DDATTO DATS 8 0
CDDATFRM Date from for fixation period for currency OIC_CDDATF DATS 8 0
CDDDATTO End date for currency period OIC_CDDATT DATS 8 0
TSTAT Term status OIC_TSTAT CHAR 1 0
NULL Not evaluated
1 Evaluated successfully using final rules
2 Evaluated successfully using provisional rules
3 Evaluated provisionally (some of quot fix per. in future)
4 Quotation fixation period in future, eval at current date
5 Quotation fixation period could not be determined
6 Quotation fixation period is in the future
7 Quotation lookup error
8 Evaluated provisionally (some of curr fix per. in future)
9 Currency fixation period in the future, eval at current date
A Currency fixation period could not be determined
B Currency fixation period is in the future
C Currency lookup error
D Currency lookup error: no rate on date in average period
E No lookup of posting in contract (E & P)
G Error: gravity scale not found or not valid
S No posting on exact date
T Error: gravity type not matching
V Error: gravity scale not active
CALID Factory calendar ID for currency OIC_CFACTC TFACD CHAR 2 0
RNDTERM Rule for rounding formula term value OIC_RNDTERM NUMC 3 0
RNDCURT Rule for rounding currency exchange rate OIC_RNDCURT NUMC 3 0
OIU_DAYS Days for simple average OIU_DAYS_AVERG CHAR 30 0
TRMRATE_FORM Unrounded term rate in formula Cuky/Prun/UoM OIC_TRMRATE_FORM DEC 31 14
TRMRATE_RND Rounded term rate in formula Cuky/Prun/UoM OIC_TRMRATE_RND DEC 31 14

OICF5_A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OICF5_A CALID OICF5_A CALID TFACD Factory calendar definition IDENT
OICF5_A TERMCURR OICF5_A TERMCURR TCURC Currency Codes WAERS
OICF5_A TERMCURR SYST MANDT TCURC Currency Codes MANDT