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) →

Standard T-Codes

FK03 FK01 XK03 FBL1N FK10N F110

Related Tables

LFA1 T001 LFBK LFM1 LFM2 LFB5

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