SE11 ABAP Dictionary SE11 LFC1

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

LFC1

Vendor master (transaction figures)
SAP SAP Transparent Table 55 Fields
Primary Key:
MANDT LIFNR BUKRS GJAHR

Dictionary Fields Fields

(55 dari 55 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
LIFNR
KEY Vendor CHAR 10 - LFA1 Account Number of Vendor or Creditor
3
BUKRS
KEY CoCode CHAR 4 - T001 Company Code
4
GJAHR
KEY Fiscal Yr NUMC 4 - - Fiscal Year
5
ERDAT
- On DATS 8 - - Date on Which Record Was Created
6
USNAM
- User CHAR 12 - - User Name
7
UMSAV
- C/f bal. CURR 15 2 - Balance Carried Forward in Local Currency
8
UM01S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
9
UM01H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
10
UM01U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
11
UM02S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
12
UM02H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
13
UM02U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
14
UM03S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
15
UM03H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
16
UM03U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
17
UM04S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
18
UM04H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
19
UM04U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
20
UM05S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
21
UM05H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
22
UM05U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
23
UM06S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
24
UM06H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
25
UM06U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
26
UM07S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
27
UM07H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
28
UM07U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
29
UM08S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
30
UM08H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
31
UM08U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
32
UM09S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
33
UM09H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
34
UM09U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
35
UM10S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
36
UM10H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
37
UM10U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
38
UM11S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
39
UM11H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
40
UM11U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
41
UM12S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
42
UM12H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
43
UM12U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
44
UM13S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
45
UM13H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
46
UM13U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
47
UM14S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
48
UM14H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
49
UM14U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
50
UM15S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
51
UM15H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
52
UM15U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period
53
UM16S
- Debit CURR 15 2 - Total of the Debit Postings for the Month
54
UM16H
- Credit CURR 15 2 - Total of the Credit Postings for the Month
55
UM16U
- Sales in the Posting Period CURR 15 2 - Sales in the Posting Period

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk LFC1.

Interactive ERD Diagrams
SAP Finance - FI/CO Document Tables →
Standard T-Codes
SE11 SE16
Related Tables
LFA1 T001 BKPF BSEG BSAD BSID BSIK BSAK
ANSI SQL Query 
SELECT a.LIFNR,
       a.BUKRS,
       a.GJAHR,
       a.ERDAT,
       a.USNAM,
       a.UMSAV,
       a.UM01S
FROM LFC1 AS a
WHERE a.LIFNR = '0000100001'
  AND a.BUKRS = '1000';
ABAP OpenSQL (7.40+) 
SELECT a~lifnr,
       a~bukrs,
       a~gjahr,
       a~erdat,
       a~usnam,
       a~umsav,
       a~um01s
  FROM lfc1 AS a
  WHERE a~lifnr = '0000100001'
  and a~bukrs = '1000'
  INTO TABLE @DATA(lt_lfc1)
  UP TO 100 ROWS.