SAP ABAP Table OIANF (Fee Condition Records)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIA (Package) Exg exchanges

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIANF	Table Relationship Diagram
Short Description	Fee Condition Records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KNUMV	☑	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
3	KPOSN	☑	KPOSN	NUM6	NUMC	6	0	Condition Item Number
4	STUNR	☑	STUNR	STUNR	NUMC	3	0	Level Number	*
5	ZAEHK	☑	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
6	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
7	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685A
8	KDATU	☐	KDATU	DATUM	DATS	8	0	Condition pricing date
9	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
10	KAWRT	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
11	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	KKURS	☐	KKURS	KKURS	DEC	9	5	Condition exchange rate for conversion to local currency
14	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
15	KMEIN	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
16	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
17	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
18	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
19	KSTAT	☐	KSTAT	XFELD	CHAR	1	0	Condition is used for statistics
20	KNPRS	☐	KNPRS	KNPRS	CHAR	1	0	Pricing type
21	KRUEK	☐	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
22	KRELI	☐	KRELI	KRELI	CHAR	1	0	Condition for invoice list
23	KHERK	☐	KHERK	KHERK	CHAR	1	0	Condition Origin
24	KGRPE	☐	KGRPE	KGRPE	CHAR	1	0	Group condition
25	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
26	KOLNR	☐	KOLNR	KOLNR	NUMC	2	0	Access Sequence - Access Number	*
27	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
28	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
29	KVSL1	☐	KVSL1	KVSCHL	CHAR	3	0	Account key	T687
30	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
31	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
32	KVSL2	☐	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	T687
33	SAKN2	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
34	MWSK2	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
35	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
36	KUNNR	☐	KUNNR_KO	KUNNR	CHAR	10	0	Customer number (rebate recipient)	KNA1
37	KDIFF	☐	KDIFF	WERTV3	CURR	5	2	Rounding-off difference of the condition
38	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
39	KSTEU	☐	KSTEU	KSTEU	CHAR	1	0	Condition control
40	KINAK	☐	KINAK	KINAK	CHAR	1	0	Condition is inactive
41	KOAID	☐	KOAID	KOAID	CHAR	1	0	Condition class
42	ZAEKO	☐	DZAEKO	ZAEHK	NUMC	2	0	Condition counter for (header conditions)
43	KMXAW	☐	KMXAW	KMXWR	CHAR	1	0	Indicator for maximum condition base value
44	KMXWR	☐	KMXWR	KMXWR	CHAR	1	0	Indicator for maximum condition amount
45	.INCLUDE	☐				0	0	IS-Oil Rel.3.0C - Do not append/add fields
46	OIKOSTL	☐	OIA_KOSTL	KOSTL	CHAR	10	0	Cost center for fee expense accounting	*
47	OIACPOL	☐	OIA_ACPOL	OIA_ACPOL	CHAR	1	0	Fee accounting policy indicator
48	OIFEEMAN	☐	OIA_FEEMAN	OIA_FEEMAN	CHAR	1	0	Fee rate indicator
49	OIKWERT	☐	OIA_KWERT	WERTV7	CURR	13	2	Fee detail clearing amount
50	OIFEEPRT	☐	OIA_FEEPRT	XFELD	CHAR	1	0	Condition is printed at item level
51	OIGRNET	☐	OIC_GRNET	OIC_GRNET	CHAR	1	0	Gross/net pricing indicator
52	OIGNSTRA	☐	OIC_GNSTRA	OIC_GNSTRA	CHAR	1	0	Gross/net pricing strategy used
53	OIGRCHK	☐	OIC_GRCHK	XFELD	CHAR	1	0	Carry out gross/net unit check
54	OIINVCYC	☐	OIA_INVCYC	OIA_INVCYC	NUMC	1	0	Invoice cycle	TOIA10
55	OIINVCYACT	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
56	OIINCYST	☐	OIA_INCYST	KREUZ	CHAR	1	0	Cond. statistical due to invoicing cycle
57	OIA_SPLTIV	☐	OIA_SPLTIV	OIA_SPLTIV	CHAR	1	0	Indicator for split invoice verification
58	OIA_ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
59	KFAKTOR	☐	KFAKTOR	FLTP	FLTP	16	16	Factor for condition base value
60	KDUPL	☐	KDUPL	KDUPL	CHAR	1	0	Structure condition
61	KFAKTOR1	☐	KFAKTOR1	FLTP	FLTP	16	16	Factor for condition basis (period)
62	.INCLUDE	☐				0	0	IS-Oil Rel.3.1H - Do not append/add fields
63	OILICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
64	OILICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
65	OIREPORT	☐	OIC_REPORT	TRANSA	CHAR	8	0	Report number
66	OIDATA	☐	OIC_DATA	GRPNO	NUMC	3	0	Routine number for data capture	*
67	OIHEAD	☐	OIC_HEAD	GRPNO	NUMC	3	0	Header format routine for second level analysis report	*
68	OIITEM	☐	OIC_ITEM	GRPNO	NUMC	3	0	Item routine for second level analysis report	*
69	OIERRHAN	☐	OIC_SECERR	GRPNO	NUMC	3	0	Error handling routine for second level analysis	*
70	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
71	KSTBS	☐	KSTBS	WERTV8	CURR	15	2	Scale base value of the condition
72	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
73	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
74	KAWRT_K	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
75	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
76	KWERT_K	☐	KWERT	WERTV7	CURR	13	2	Condition Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIANF	KAPPL	T681A	KAPPL	REF	1	CN
2	OIANF	KMEIN	T006	MSEHI	REF	C	CN
3	OIANF	KONMS	T006	MSEHI	REF	1	N
4	OIANF	KONWS	TCURC	WAERS	REF	1	N
5	OIANF	KSCHL	T685A	KSCHL	REF	1	CN
6	OIANF	KUNNR	KNA1	KUNNR	REF	C	CN
7	OIANF	KVSL1	T687	KVSL1	REF	C	CN
8	OIANF	KVSL2	T687	KVSL1	REF	C	CN
9	OIANF	LIFNR	LFA1	LIFNR	REF	C	CN
10	OIANF	MANDT	T000	MANDT	KEY	1	CN
11	OIANF	OIINVCYC	TOIA10	OIINVCYC
12	OIANF	SAKN1	SKA1	SAKNR	REF	C	CN
13	OIANF	SAKN2	SKA1	SAKNR	REF	C	CN
14	OIANF	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in