SAP ABAP Table LFB1 (Vendor Master (Company Code))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-BP-VM (Application Component) Vendor Master
     ⤷ WLIFCORE (Package) General services vendor master

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LFB1	Table Relationship Diagram
Short Description	Vendor Master (Company Code)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	.INCLUDE	☐				0	0	Vendor Master (Company Code)
6	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
7	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
8	SPERR	☐	SPERB_B	XFELD	CHAR	1	0	Posting block for company code
9	LOEVM	☐	LOEVM_B	XFELD	CHAR	1	0	Deletion Flag for Master Record (Company Code Level)
10	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
11	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
12	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
13	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
14	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
15	XVERR	☐	XVERR_LFB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor?
16	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
17	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
18	EIKTO	☐	EIKTO_K	CHAR12	CHAR	12	0	Our account number with the vendor
19	ZSABE	☐	DZSABE_K	TEXT15	CHAR	15	0	Clerk at vendor
20	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
21	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
22	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
23	LNRZE	☐	LNRZE	LIFNR	CHAR	10	0	Head office account number	LFA1
24	LNRZB	☐	LNRZB	LIFNR	CHAR	10	0	Account number of the alternative payee	LFA1
25	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
26	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
27	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
28	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
29	WEBTR	☐	WEBTR	WERT7	CURR	13	2	Bill of exchange limit (in local currency)
30	KULTG	☐	KULTG	PACK2	DEC	3	0	Probable time until check is paid
31	REPRF	☐	REPRF	XFELD	CHAR	1	0	Check Flag for Double Invoices or Credit Memos
32	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
33	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
34	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
35	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
36	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
37	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
38	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	*
39	MINDK	☐	MINDK	MINDK	CHAR	3	0	Minority Indicators	T059M
40	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
41	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
42	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
43	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
44	QSREC	☐	QSREC	QSREC	CHAR	2	0	Vendor Recipient Type	T059A
45	QSBGR	☐	QSBGR	QSBGR	CHAR	1	0	Authority for Exemption from Withholding Tax
46	QLAND	☐	QLAND	QLAND	CHAR	3	0	Withholding Tax Country Key	T005Q
47	XEDIP	☐	XEDIP	XFELD	CHAR	1	0	Indicator: Send Payment Advices by EDI
48	FRGRP	☐	FRGRP	FRGRP	CHAR	4	0	Release Approval Group	VBWF08
49	TOGRR	☐	TOGRR	TOGRR	CHAR	4	0	Tolerance group; Invoice Verification	T169L
50	TLFXS	☐	TLFXS	TEXT31	CHAR	31	0	Accounting clerk's fax number at the customer/vendor
51	INTAD	☐	INTAD	TXT130	CHAR	130	0	Internet address of partner company clerk
52	XLFZB	☐	XLFZB	XFELD	CHAR	1	0	Indicator: Alternative payee using account number
53	GUZTE	☐	GUZTE	ZTERM	CHAR	4	0	Payment Terms Key for Credit Memos
54	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
55	GRIDT	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
56	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	T048K
57	CERDT	☐	CERDT	DATUM	DATS	8	0	Certification date
58	CONFS	☐	CONFS_B	CHAR1	CHAR	1	0	Status of Change Authorization (Company Code Level)
59	UPDAT	☐	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
60	UPTIM	☐	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
61	NODEL	☐	NODEL_B	XFELD	CHAR	1	0	Deletion bock for master record (company code level)
62	TLFNS	☐	TLFNS	CHAR30	CHAR	30	0	Accounting clerk's telephone number at business partner
63	AVSND	☐	AVSND	AVSND	CHAR	1	0	Indicator: Send Payment Advice by XML
64	AD_HASH	☐	ADHASH	ADHASH	CHAR	10	0	E-Mail Address for Avis: Hash Value
65	.INCLU--AP	☐				0	0	Subcontracting Management
66	J_SC_SUBCONTYPE	☐	/SAPNEA/J_SC_SUBCONTYPE	/SAPNEA/J_SC_SUBCONTYPE	CHAR	1	0	Subcontractor Type
67	J_SC_COMPDATE	☐	/SAPNEA/J_SC_COMPLETIONDATE	/SAPNEA/J_SC_COMPLETIONDATE	NUMC	3	0	Completion Date Of Inspection
68	J_SC_OFFSM	☐	/SAPNEA/J_SC_OFFSM	/SAPNEA/J_SC_OFFSM	CHAR	1	0	Offset Method
69	J_SC_OFFSR	☐	/SAPNEA/J_SC_OFFSR	/SAPNEA/J_SC_OFFSR	NUMC	3	0	Offset Percentage
70	.INCLU--AP	☐				0	0	PS fields for company code-specific master data field
71	BASIS_PNT	☐	FMBASIS_POINTS	FMBASIS_POINTS	DEC	6	3	Average daily basis points for purchase cards
72	.INCLU--AP	☐				0	0	IS-PS: Data Appendix Vendor Master Record (Company Code)
73	GMVKZK	☐	GMVKZK	XFELD	CHAR	1	0	Vendor is in execution
74	.INCLU--AP	☐				0	0	LFB1 Extension with New Fields - Seasonal Procurement
75	.INCLUDE	☐				0	0	LFB1 Extension with New Fields - Seasonal Procurement
76	PREPAY_RELEVANT	☐	WRF_PREPAY_RELEVANT	WRF_PREPAY_RELEVANT	CHAR	1	0	Prepayment Relevance (Vendor Master)
77	ASSIGN_TEST	☐	WRF_MRM_ASSIGN_GROUP	WRF_MRM_ASSIGN_GROUP	CHAR	4	0	Assignment Test Group	WRF_ASSIGN_GRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LFB1	AKONT	SKB1	SAKNR	REF	1	CN
2	LFB1	ASSIGN_TEST	WRF_ASSIGN_GRP	ASSIGN_GROUP
3	LFB1	BUKRS	T001	BUKRS	KEY	1	CN
4	LFB1	BUSAB	T001S	BUSAB	REF	C	CN
5	LFB1	FDGRV	T035	GRUPP	REF	C	CN
6	LFB1	FRGRP	VBWF08	FRGRP	REF	C	CN
7	LFB1	GRICD	J_1AGICD	J_1AGICD		1	CN
8	LFB1	GRIDT	J_1ADTYP	J_1ADTYP		1	CN
9	LFB1	HBKID	T012	HBKID	REF	C	CN
10	LFB1	LIFNR	LFA1	LIFNR	KEY	1	CN
11	LFB1	LNRZB	LFA1	LIFNR	REF	C	CN
12	LFB1	LNRZE	LFA1	LIFNR	REF	C	CN
13	LFB1	MANDT	T000	MANDT	KEY	1	CN
14	LFB1	MGRUP	T047R	MGRUP	REF	C	CN
15	LFB1	MINDK	T059M	MINDK	REF	C	CN
16	LFB1	QLAND	T005Q	QLAND	REF	1	CN
17	LFB1	QSREC	T059A	QSREC	REF	1	CN
18	LFB1	TOGRR	T169L	TOGRR	REF	1	CN
19	LFB1	TOGRU	T043G	TOGRU	REF	C	CN
20	LFB1	UZAWE	T042F	UZAWE	REF	C	CN
21	LFB1	VZSKZ	T056	VZSKZ	REF	C	CN
22	LFB1	XAUSZ	T048K	XAUSZ	REF	C	CN
23	LFB1	ZAHLS	T008	ZAHLS	REF	C	CN
24	LFB1	ZGRUP	TZGR	ZGRUP	REF	C	CN
25	LFB1	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in