SAP ABAP Table OIANFS (OIANF with additional fields for internal processing)

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	INTTAB	Structure
Structure	OIANFS	Table Relationship Diagram
Short Description	OIANF with additional fields for internal processing

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in