LFC1 SAP Vendor master (transaction figures) Table and data
LFC1 is a standard SAP Table which is used to store Vendor master (transaction figures) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP LFC1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP LFC1 Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| LIFNR | LIFNR | CHAR | 10 | LFA1 | Account Number of Vendor or Creditor | ALPHA |
| BUKRS | BUKRS | CHAR | 4 | LFB1 | Company Code | |
| GJAHR | GJAHR | NUMC | 4 | Fiscal Year | GJAHR | |
| ERDAT | ERDAT | DATS | 8 | Date on Which Record Was Created | ||
| USNAM | USNAM | CHAR | 12 |
* | User name | |
| UMSAV | UMSAV | CURR | 15(2) | Balance Carried Forward in Local Currency | ||
| UM01S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM01H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM01U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM02S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM02H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM02U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM03S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM03H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM03U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM04S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM04H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM04U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM05S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM05H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM05U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM06S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM06H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM06U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM07S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM07H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM07U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM08S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM08H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM08U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM09S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM09H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM09U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM10S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM10H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM10U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM11S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM11H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM11U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM12S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM12H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM12U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM13S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM13H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM13U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM14S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM14H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM14U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM15S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM15H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM15U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| UM16S | UMXXS | CURR | 15(2) | Total of the Debit Postings for the Month | ||
| UM16H | UMXXH | CURR | 15(2) | Total of the Credit Postings for the Month | ||
| UM16U | UMXXU | CURR | 15(2) | Sales in the Posting Period | ||
| Key field | |
| Non-key field |
LFC1 relationships with other tables
BOSG-Uppermost Hierarchy Segment for BRF
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BSET-Tax Data Document Segment
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
KNA1-General Data in Customer Master
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNKK-Credit Management Cust. Mstr: Control Area Data
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
LFA1-Vendor Master (General Section)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
LFA1-Vendor Master (General Section)
ADDR1_VAL-Address Data
LFAS-Vendor Master (General Part EU Tax Number)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
BSIK-Accounting: Secondary Index for Vendors
ADMI_FILES-Archive Files
BSIKEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
LFC1 - Vendor master (transaction figures) LFBW_KEY_S - Key withholding tax types vendor with client LFBW_KEY - Key Withholding Tax Types: Vendor LFBW - Vendor master record (withholding tax types) X LFBK_KEY_S - Key bank connection vendor with client LFBK_EMC_JP_ST - Electronic Monetary Claims Japan