OIANF SAP (Fee Condition Records) Table details
Dictionary Type: Table
Description: Fee Condition Records
Description: Fee Condition Records
Table field list including key, data, relationships and ABAP select examples
OIANF is a standard SAP Table which is used to store Fee Condition Records data and is available within R/3 SAP systems depending on the version and release level.
The OIANF table consists of various fields, each holding specific information or linking keys about Fee Condition Records data available in SAP. These include KNUMV (Number of the document condition), KPOSN (Condition item number), STUNR (Step number), ZAEHK (Condition counter).. 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 OIANF 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KPOSN | Condition item number | KPOSN | NUMC | 6 | NUM6 | ||||
STUNR | Step number | STUNR | NUMC | 3 | Assigned to domain | STUNR | |||
ZAEHK | Condition counter | DZAEHK | NUMC | 2 | ZAEHK | ||||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KSCHL | Condition type | KSCHA | CHAR | 4 | T685A | KSCHL | VKS | ||
KDATU | Condition pricing date | KDATU | DATS | 8 | DATUM | ||||
KRECH | Calculation type for condition | KRECH | CHAR | 1 | KRECH | ||||
KAWRT | Condition base value | KAWRT | CURR | 15(2) | WERTV8 | ||||
KBETR | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
KKURS | Condition exchange rate for conversion to local currency | KKURS | DEC | 9(5) | KKURS | ||||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition unit in the document | KVMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
KUMZA | Numerator for converting condition units to base units | KUMZA | DEC | 5 | UMBSZ | ||||
KUMNE | Denominator for converting condition units to base units | KUMNE | DEC | 5 | UMBSN | ||||
KNTYP | Condition category (examples: tax, freight, price, cost) | KNTYP | CHAR | 1 | KNTYP | ||||
KSTAT | Condition is used for statistics | KSTAT | CHAR | 1 | XFELD | ||||
KNPRS | Pricing type | KNPRS | CHAR | 1 | KNPRS | ||||
KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR | 1 | XFELD | ||||
KRELI | Condition for invoice list | KRELI | CHAR | 1 | KRELI | ||||
KHERK | Origin of the condition | KHERK | CHAR | 1 | KHERK | ||||
KGRPE | Group condition | KGRPE | CHAR | 1 | KGRPE | ||||
KOUPD | Condition update | KOUPD | CHAR | 1 | XFELD | ||||
KOLNR | Access sequence - Access number | KOLNR | NUMC | 2 | Assigned to domain | KOLNR | |||
KNUMH | Condition record number | KNUMH | CHAR | 10 | KNUMB | ||||
KOPOS | Sequential number of the condition | KOPOS | NUMC | 2 | NUM02 | ||||
KVSL1 | Account key | KVSL1 | CHAR | 3 | T687 | KVSCHL | |||
SAKN1 | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
MWSK1 | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
KVSL2 | Account key - accruals / provisions | KVSL2 | CHAR | 3 | T687 | KVSCHL | |||
SAKN2 | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
MWSK2 | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Customer number (rebate recipient) | KUNNR_KO | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
KDIFF | Rounding-off difference of the condition | KDIFF | CURR | 5(2) | WERTV3 | ||||
KWERT | Condition value | KWERT | CURR | 13(2) | WERTV7 | ||||
KSTEU | Condition control | KSTEU | CHAR | 1 | KSTEU | ||||
KINAK | Condition is inactive | KINAK | CHAR | 1 | KINAK | ||||
KOAID | Condition class | KOAID | CHAR | 1 | KOAID | ||||
ZAEKO | Condition counter for (header conditions) | DZAEKO | NUMC | 2 | ZAEHK | ||||
KMXAW | Indicator for maximum condition base value | KMXAW | CHAR | 1 | KMXWR | ||||
KMXWR | Indicator for maximum condition amount | KMXWR | CHAR | 1 | KMXWR | ||||
OIKOSTL | Cost center for fee expense accounting | OIA_KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
OIACPOL | Fee accounting policy indicator | OIA_ACPOL | CHAR | 1 | OIA_ACPOL | ||||
OIFEEMAN | Fee rate indicator | OIA_FEEMAN | CHAR | 1 | OIA_FEEMAN | ||||
OIKWERT | Fee detail clearing amount | OIA_KWERT | CURR | 13(2) | WERTV7 | ||||
OIFEEPRT | Condition is printed at item level | OIA_FEEPRT | CHAR | 1 | XFELD | ||||
OIGRNET | Gross/net pricing indicator | OIC_GRNET | CHAR | 1 | OIC_GRNET | ||||
OIGNSTRA | Gross/net pricing strategy used | OIC_GNSTRA | CHAR | 1 | OIC_GNSTRA | ||||
OIGRCHK | Carry out gross/net unit check | OIC_GRCHK | CHAR | 1 | XFELD | ||||
OIINVCYC | Invoice cycle | OIA_INVCYC | NUMC | 1 | TOIA10 | OIA_INVCYC | |||
OIINVCYACT | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 1 | KREUZ | ||||
OIINCYST | Cond. statistical due to invoicing cycle | OIA_INCYST | CHAR | 1 | KREUZ | ||||
OIA_SPLTIV | Indicator for split invoice verification | OIA_SPLTIV | CHAR | 1 | OIA_SPLTIV | ||||
OIA_ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
KFAKTOR | Factor for condition base value | KFAKTOR | FLTP | 16(16) | FLTP | ||||
KDUPL | Structure condition | KDUPL | CHAR | 1 | KDUPL | ||||
KFAKTOR1 | Factor for condition basis (period) | KFAKTOR1 | FLTP | 16(16) | FLTP | ||||
OILICIN | Excise tax internal license number | OIH_LICIN | CHAR | 10 | Assigned to domain | ALPHA | OIH_LICIN | OIH | OIHL |
OILICTP | License type | OIH_LICTP | CHAR | 4 | Assigned to domain | OIH_LICTP | OII | ||
OIREPORT | Report number | OIC_REPORT | CHAR | 8 | TRANSA | ||||
OIDATA | Routine number for data capture | OIC_DATA | NUMC | 3 | Assigned to domain | GRPNO | |||
OIHEAD | Header format routine for second level analysis report | OIC_HEAD | NUMC | 3 | Assigned to domain | GRPNO | |||
OIITEM | Item routine for second level analysis report | OIC_ITEM | NUMC | 3 | Assigned to domain | GRPNO | |||
OIERRHAN | Error handling routine for second level analysis | OIC_SECERR | NUMC | 3 | Assigned to domain | GRPNO | |||
KZBZG | Scale basis indicator | KZBZG | CHAR | 1 | KZBZG | ||||
KSTBS | Scale base value of the condition | KSTBS | CURR | 15(2) | WERTV8 | ||||
KONMS | Condition scale unit of measure | KONMS | UNIT | 3 | T006 | CUNIT | MEINS | ||
KONWS | Scale currency | KONWS | CUKY | 5 | TCURC | WAERS | FWS | ||
KAWRT_K | Condition base value | KAWRT | CURR | 15(2) | WERTV8 | ||||
KWAEH | Condition currency (for cumulation fields) | KWAEH | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KWERT_K | Condition value | KWERT | CURR | 13(2) | WERTV7 |
Key field | Non-key field |
How do I retrieve data from SAP table OIANF using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIANF to SELECT all data from the tableDATA: WA_OIANF TYPE OIANF.
SELECT SINGLE *
FROM OIANF
INTO CORRESPONDING FIELDS OF WA_OIANF
WHERE...
How to access SAP table OIANF
Within an ECC or HANA version of SAP you can also view further information about OIANF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects