In this post, I will try and describe everything you need to know about the SAP f107v 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 F107V 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 F107V....Right lets get started!
Object Name: F107V
Dictionary Type: Structure
Description: Work Fields for SAPF107V
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
LAUFD | LAUFD | DATS | 8(0) | Date on Which the Program Is to Be Run | DATUM | FB | ||||||
LAUFI | LAUFI | CHAR | 6(0) | Additional Identification | LAUFI | FB | ||||||
COPYD | LAUFD | DATS | 8(0) | Date on Which the Program Is to Be Run | DATUM | FB | ||||||
COPYI | LAUFI | CHAR | 6(0) | Additional Identification | LAUFI | FB | ||||||
BUKLS | BUKLS_F150 | CHAR | 80(0) | List of company codes | CHAR80 | FBM | ||||||
AUSDT | F100STAG | DATS | 8(0) | Key Date for OI Overview | DATUM | FBR | ||||||
VONKD | KUNNR | CHAR | 10(0) | KNA1 | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | ||
BISKD | KUNNR | CHAR | 10(0) | KNA1 | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | ||
VONKK | LIFNR | CHAR | 10(0) | LFA1 | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | ||
BISKK | LIFNR | CHAR | 10(0) | LFA1 | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | ||
FLDNA | TBFDNAM | CHAR | 61(0) | Complete field name (table, separator, field name) | CHAR61 | |||||||
FLDBD | FLDBD_F150 | CHAR | 30(0) | Field name | TEXT30 | FBM | ||||||
FLDL1 | FLDL1_F150 | CHAR | 50(0) | List of values | TEXT50 | FBM | ||||||
FLDL2 | FLDL1_F150 | CHAR | 50(0) | List of values | TEXT50 | FBM | ||||||
IGNOR | IGNOR_F150 | CHAR | 1(0) | Exclude Values | XFELD | FB | ||||||
KOART | KOART | CHAR | 1(0) | Account Type | KOART | FB | ||||||
KONTO | KONKO | CHAR | 10(0) | Open item account number | MAXKK | FB | ||||||
KUNNR | KUNNR | CHAR | 10(0) | KNA1 | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | ||
LIFNR | LIFNR | CHAR | 10(0) | LFA1 | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | ||
BUKRS | BUKRS | CHAR | 4(0) | T001 | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
BUSAB | BUSAB | CHAR | 2(0) | T001S | Accounting clerk | BUSAB | FB | |||||
XDANP | XDANP_F150 | CHAR | 1(0) | Indicator: Adjust date details ? | XFELD | FBM | ||||||
ANZPO | ANZPO_F150 | DEC | 5(0) | Nunmber of items in the account | PACK3 | FBM | ||||||
ABPOS | ABPOS_F150 | DEC | 5(0) | Line item number of the first displayed item | PACK3 | FBM | ||||||
AUSWJ | XJA | CHAR | 1(0) | Answer to question asked: Yes | XFELD | FB | ||||||
AUSWN | XNEIN | CHAR | 1(0) | Answer to question asked: No | XFELD | FB | ||||||
ANZT1 | ANZTA_F150 | DEC | 5(0) | Number of table entries | PACK3 | FBM | ||||||
ABTP1 | ABTPO_F150 | DEC | 5(0) | Number of the first table entry displayed | PACK3 | FBM | ||||||
ANZT2 | ANZTA_F150 | DEC | 5(0) | Number of table entries | PACK3 | FBM | ||||||
ABTP2 | ABTPO_F150 | DEC | 5(0) | Number of the first table entry displayed | PACK3 | FBM | ||||||
ANZT3 | ANZTA_F150 | DEC | 5(0) | Number of table entries | PACK3 | FBM | ||||||
ABTP3 | ABTPO_F150 | DEC | 5(0) | Number of the first table entry displayed | PACK3 | FBM | ||||||
STEXT | STEXT_F150 | CHAR | 60(0) | Status text for dunning letters | TEXT60 | FBM | ||||||
HWAERS | WAERS | CUKY | 5(0) | * | Currency Key | WAERS | FWS | FB | ||||
VONLD | VONDT_REGU | DATS | 8(0) | Lower Limit for the Run Date Found | DATUM | FBZ | ||||||
BISLD | BISDT_REGU | DATS | 8(0) | Upper Limit for the Run Date Being Searched For | DATUM | FBZ | ||||||
STRDT | STRDT | DATS | 8(0) | Sched. Start Date | DATUM | FB | ||||||
STRZT | STRZT | TIMS | 6(0) | Planned Start Time | UZEIT | FB | ||||||
STRRE | STRRE | CHAR | 40(0) | Name of the Report To Be Started | PROGN | FB | ||||||
XSTRF | XSTRF | CHAR | 1(0) | Indicator: Start immediately | XFELD | FB | ||||||
XDRAN | XDRAN_F150 | CHAR | 1(0) | Indicator: Print job with scheduling ? | XFELD | FBM | ||||||
PDEST | SYPDEST | CHAR | 4(0) | * | Spool Output Device | RSPOPNAME | SYST | |||||
IDLOE | IDLOE | CHAR | 6(0) | Reorganization run identification | LAUFI | FB | ||||||
XVORL | XVORL_F107 | CHAR | 1(0) | Valuation proposals only | XFELD | |||||||
VERTN | RANL | CHAR | 13(0) | Contract Number | RANL | RAN | FVVW | |||||
VONVN | RANL | CHAR | 13(0) | Contract Number | RANL | RAN | FVVW | |||||
BISVN | RANL | CHAR | 13(0) | Contract Number | RANL | RAN | FVVW | |||||
KOVER | KOVER | CHAR | 13(0) | Account number/contract number | KOVER | |||||||
PROGN | PROGN | CHAR | 40(0) | Program Name | PROGN | FB | ||||||
VARI1 | RALDB_VARI | CHAR | 14(0) | Variant Name | RALDB_VARI | SAB4 | ||||||
BHOST | BHOST | CHAR | 20(0) | Computer on Which the Background Job Is to Be Carried Out | MSHOST | |||||||
PCOUNT | PCOUNT | INT1 | 3(0) | Number of dunning notices for sample printout | INT1 | |||||||
PIMMED | SYPRIMM | CHAR | 1(0) | Immediate Spool Print | SYCHAR01 | SYST | ||||||
OFIST | OFIST | CHAR | 60(0) | Status text Business Transaction Event | CHAR60 | |||||||
ICCD | ICCD | CHAR | 1(0) | Cross-company code dunning | XFELD | |||||||
DB_ITEM | DB_ITEM | CHAR | 1(0) | Indicator: Item Contains Dunning Block | XFELD | |||||||
DB_ACC | DB_ACC | CHAR | 1(0) | Indicator: Account has a dunning block | XFELD | |||||||
L_INCL | L_INCL | CHAR | 1(0) | Indicator: Include line item in list | XFELD | |||||||
DUJ_TYPE | DUJ_TYPE | CHAR | 1(0) | Batch job category in dunning | DUJ_TYPE | |||||||
ANZ | DEC | 1(0) | Work Field | |||||||||
UMBWM | UMBWM | CHAR | 3(0) | Valuation Methods in Financial Accounting | UMBWM | |||||||
CURTP | CURTP_B | CHAR | 2(0) | Currency Type and Valuation View | CURTP_B | |||||||
BWBER | BWBER | CHAR | 2(0) | T033 | Valuation Area for FI Year-End Closing | BWBER | BWB | |||||
XGRUP | ALLGGRUP | CHAR | 1(0) | Evaluate Accounts According to Group Definition | XFELD | |||||||
BINPUT | ALLGBINP_E | CHAR | 1(0) | Generate Postings | XFELD | FBR | ||||||
BBLART | ALLGBLAR | CHAR | 2(0) | T003 | Document Type of the Posting | BLART | FBR | |||||
BSBLAR | ALLGBLAR | CHAR | 2(0) | T003 | Document Type of the Posting | BLART | FBR | |||||
BBUDAT | ALLGBDAT | DATS | 8(0) | Posting Date of the Posting | DATUM | FBR | ||||||
SBUDAT | ALLGSDAT | DATS | 8(0) | Posting Date of the Reverse Batch Input Posting | DATUM | FBR | ||||||
BBUPEM | ALLGBUPE | NUMC | 2(0) | Posting Period of the Posting | MONAT | FBR | ||||||
SBUPEM | ALLGSBUP | NUMC | 2(0) | Posting Period: Reverse Posting | MONAT | FBR | ||||||
BMAPPE | ALLGBINA_E | CHAR | 12(0) | Name of Batch Input Session for Erroneous Postings | CHAR12 | FBR | ||||||
SZBMETH | SZBMETH | CHAR | 1(0) | Interest Calculation Method | SZBMETH | FVV | ||||||
NETDT_MIN | NETDT_MIN | DATS | 8(0) | Earliest Due date (Net) for Discounting | DATUM | FBR | ||||||
XZINSEXP | XZINSEXP | CHAR | 1(0) | Indicator: Exponential Interest Calculation | XFELD | |||||||
VZSKZ | VZSKZ_F107 | CHAR | 2(0) | T056 | Discounting Indicator | VZSKZ | FB | |||||
PREV_AUSDT | F100STAG | DATS | 8(0) | Key Date for OI Overview | DATUM | FBR | ||||||
MON_MIN | F107_MON_MIN | NUMC | 5(0) | Maturity of Long-Term Receivables and Payables | NUMC | |||||||
XAGGR_OFF | F107_AGGR_OFF | CHAR | 1(0) | Valuation for Each Line Item | CHAR1_X |