SAP ABAP Table OIAFE (Fee history table)

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	OIAFE	Table Relationship Diagram
Short Description	Fee history table

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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	LFBNR	☑	WEBLN	BELNR	CHAR	10	0	Number of goods receipt document
6	LFPOS	☑	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
7	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
8	BLPOS	☑	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
9	VGABE	☑	VGABE	VGABE	CHAR	1	0	Transaction/event type, purchase order history
10	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
11	BEWTP	☐	BEWTP	BEWTP	CHAR	1	0	Purchase Order History Category	T163B
12	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
14	OIDMBTR	☐	OIA_DMBTR	OIA_FEETOT	CURR	13	2	Fee amount in local currency
15	OIWRBTR	☐	OIA_WRBTR	OIA_FEETOT	CURR	13	2	Fee amount in document currency
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	AREWR	☐	OIA_AREWR	OIA_FEETOT	CURR	13	2	GR/IR account clearing value in local currency
18	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
19	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
20	XBLNR	☐	OIA_XBLNR	XBLNR1	CHAR	16	0	External delivery note number
21	FRBNR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
22	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
23	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
24	REEWR	☐	OIA_REEWR	OIA_FEETOT	CURR	13	2	Invoice fee value entered in local currency
25	REFWR	☐	OIA_REFWR	OIA_FEETOT	CURR	13	2	Invoice fee value entered in document currency
26	OINEGPSTG	☐	OIA_NGPSTL	OI0_XFELD	CHAR	1	0	Negative posting line (exchange fees)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIAFE	BEWTP	T163B	BEWTP	REF	C	CN
2	OIAFE	EBELN	EKKO	EBELN	KEY	1	CN
3	OIAFE	EBELP	EKPO	EBELP	KEY	1	CN
4	OIAFE	LIFNR	LFA1	LIFNR	REF	1	CN
5	OIAFE	MANDT	T000	MANDT	KEY	1	N
6	OIAFE	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in