In this post, I will try and describe everything you need to know about the SAP f100file table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for F100FILE what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from F100FILE....Right lets get started!
Object Name: F100FILE
Dictionary Type: Structure
Description: Extract from the SAPF100 Evaluation
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| BUKRS | BUKRS | CHAR | 4(0) | * | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| GJAHR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| BELNR | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| BUZEI | BUZEI | NUMC | 3(0) | Number of Line Item Within Accounting Document | BUZEI | BUZ | FB | |||||
| HWTYP | XBEW1_044A | CHAR | 1(0) | Local currency type | HWTYP | FBR | ||||||
| WAERS | WAERS | CUKY | 5(0) | * | Currency Key | WAERS | FWS | FB | ||||
| OLDBDIFF | BDIFF | CURR | 13(2) | Valuation Difference | WRTV7 | FB | ||||||
| NEWBDIFF | BDIFF | CURR | 13(2) | Valuation Difference | WRTV7 | FB | ||||||
| PLTYPE | CHAR01 | CHAR | 1(0) | Character Field Length 1 | CHAR1 | |||||||
| BWBER | BWBER | CHAR | 2(0) | * | Valuation Area for FI Year-End Closing | BWBER | BWB |