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