SE11 ABAP Dictionary SE11 LFB1

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

LFB1

Vendor Master (Company Code)

SAP SAP Transparent Table 69 Fields

Primary Key:

MANDT LIFNR BUKRS

#	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	PERNR	-	Pers.No.	NUMC	8	-	-	Personnel Number
5	ERDAT	-	Creat.date	DATS	8	-	-	Date on which the Record Was Created
6	ERNAM	-	Created by	CHAR	12	-	-	Name of Person who Created the Object
7	SPERR	-	Pstg block	CHAR	1	-	-	Posting block for company code
8	LOEVM	-	Del.flag	CHAR	1	-	-	Deletion Flag for Master Record (Company Code Level)
9	ZUAWA	-	Sort key	CHAR	3	-	-	Key for sorting according to assignment numbers
10	AKONT	-	Recon.acct	CHAR	10	-	-	Reconciliation Account in General Ledger
11	BEGRU	-	Authoriz.	CHAR	4	-	-	Authorization Group
12	VZSKZ	-	Int ID	CHAR	2	-	-	Interest calculation indicator
13	ZWELS	-	Pmt meths	CHAR	10	-	-	List of the Payment Methods to be Considered
14	XVERR	-	Cust. clrg	CHAR	1	-	-	Indicator: Clearing between customer and vendor?
15	ZAHLS	-	Pymt block	CHAR	1	-	-	Block key for payment
16	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
17	EIKTO	-	Acct w/ vd	CHAR	12	-	-	Our account number with the vendor
18	ZSABE	-	Vend.clerk	CHAR	15	-	-	Clerk at vendor
19	KVERM	-	Memo	CHAR	30	-	-	Memo
20	FDGRV	-	Plan.group	CHAR	10	-	-	Planning group
21	BUSAB	-	Clerk	CHAR	2	-	-	Accounting clerk
22	LNRZE	-	Hd office	CHAR	10	-	-	Head office account number
23	LNRZB	-	Alt.payee	CHAR	10	-	-	Account number of the alternative payee
24	ZINDT	-	Lst key dt	DATS	8	-	-	Key date of the last interest calculation
25	ZINRT	-	Int.cal.fr	NUMC	2	-	-	Interest calculation frequency in months
26	DATLZ	-	Lst int.rn	DATS	8	-	-	Date of the last interest calculation run
27	XDEZV	-	Loc.proc.	CHAR	1	-	-	Indicator: Local processing?
28	WEBTR	-	B/e limit	CURR	13	2	-	Bill of exchange limit (in local currency)
29	KULTG	-	Grace per.	DEC	3	-	-	Probable time until check is paid
30	REPRF	-	Chk d.inv.	CHAR	1	-	-	Check Flag for Double Invoices or Credit Memos
31	TOGRU	-	Tol.group	CHAR	4	-	-	Tolerance group for the business partner/G/L account
32	HBKID	-	House Bank	CHAR	5	-	-	Short Key for a House Bank
33	XPORE	-	Indiv.pmnt	CHAR	1	-	-	Indicator: Pay all items separately ?
34	QSZNR	-	Exempt.no.	CHAR	10	-	-	Certificate Number of the Withholding Tax Exemption
35	QSZDT	-	Val. until	DATS	8	-	-	Validity Date for Withholding Tax Exemption Certificate
36	QSSKZ	-	W.Tax Code	CHAR	2	-	-	Withholding Tax Code
37	BLNKZ	-	Subs.ind.	CHAR	2	-	-	Subsidy indicator for determining the reduction rates
38	MINDK	-	Min.ind.	CHAR	3	-	-	Minority Indicators
39	ALTKN	-	Pre.ac.no.	CHAR	10	-	-	Previous Master Record Number
40	ZGRUP	-	Grpng key	CHAR	2	-	-	Key for Payment Grouping
41	MGRUP	-	Grpng key	CHAR	2	-	-	Key for dunning notice grouping
42	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
43	QSREC	-	Rec.type	CHAR	2	-	-	Vendor Recipient Type
44	QSBGR	-	Exmpt.auth	CHAR	1	-	-	Authority for Exemption from Withholding Tax
45	QLAND	-	Wth.tx cty	CHAR	3	-	-	Withholding Tax Country Key
46	XEDIP	-	EDI	CHAR	1	-	-	Indicator: Send Payment Advices by EDI
47	FRGRP	-	Appr.group	CHAR	4	-	-	Release Approval Group
48	TOGRR	-	Tol.group	CHAR	4	-	-	Tolerance group; Invoice Verification
49	TLFXS	-	Fax	CHAR	31	-	-	Accounting clerk's fax number at the customer/vendor
50	INTAD	-	Internet	CHAR	130	-	-	Internet address of partner company clerk
51	XLFZB	-	AltPayeeAc	CHAR	1	-	-	Indicator: Alternative payee using account number
52	GUZTE	-	CrMemTerms	CHAR	4	-	-	Payment Terms Key for Credit Memos
53	GRICD	-	Activity	CHAR	2	-	-	Activity Code for Gross Income Tax
54	GRIDT	-	Distribut.	CHAR	2	-	-	Distribution Type for Employment Tax
55	XAUSZ	-	Acct stmnt	CHAR	1	-	-	Indicator for periodic account statements
56	CERDT	-	Cert. Date	DATS	8	-	-	Certification date
57	CONFS	-	CCdeCfStat	CHAR	1	-	-	Status of Change Authorization (Company Code Level)
58	UPDAT	-	Conf.date	DATS	8	-	-	Date on Which the Changes Were Confirmed
59	UPTIM	-	Conf.time	TIMS	6	-	-	Time of Last Change Confirmation
60	NODEL	-	Del.block	CHAR	1	-	-	Deletion bock for master record (company code level)
61	TLFNS	-	Telephone	CHAR	30	-	-	Accounting clerk's telephone number at business partner
62	J_SC_SUBCONTYPE	-	Type	CHAR	1	-	-	Subcontractor Type
63	J_SC_COMPDATE	-	Date	NUMC	3	-	-	Completion Date Of Inspection
64	J_SC_OFFSM	-	Method	CHAR	1	-	-	Offset Method
65	J_SC_OFFSR	-	Offset %	NUMC	3	-	-	Offset Percentage
66	BASIS_PNT	-	Basis	DEC	6	3	-	Average daily basis points for purchase cards
67	GMVKZK	-	Execution	CHAR	1	-	-	Vendor is in execution
68	PREPAY_RELEVANT	-	Prepayment	CHAR	1	-	-	Prepayment Relevance (Vendor Master)
69	ASSIGN_TEST	-	Assign.Grp	CHAR	4	-	-	Assignment Test Group

Related References & SQL

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

Interactive ERD Diagrams

SAP FI/CO - Accounts Payable (Vendor Master Data) → SAP Procurement & MM Document Flow - MIRO Service PO Clearing →

Standard T-Codes

FK03 FK01 XK03 FBL1N FK10N F110

Related Tables

LFA1 T001 LFBK LFM1 LFM2 LFB5 EKKO EKPO

ANSI SQL Query

SELECT a.LIFNR,
       a.BUKRS,
       a.PERNR,
       a.ERDAT,
       a.ERNAM,
       a.SPERR,
       a.LOEVM
FROM LFB1 AS a
WHERE a.LIFNR = '0000100001'
  AND a.BUKRS = '1000';

ABAP OpenSQL (7.40+)

SELECT a~lifnr,
       a~bukrs,
       a~pernr,
       a~erdat,
       a~ernam,
       a~sperr,
       a~loevm
  FROM lfb1 AS a
  WHERE a~lifnr = '0000100001'
  and a~bukrs = '1000'
  INTO TABLE @DATA(lt_lfb1)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 LFB1

LFB1

Dictionary Fields Fields

Related References & SQL