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