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
⤷ 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 |