TXI_LFB1 SAP (Vendor Master (Company Code)) Structure details

Dictionary Type: Structure
Description: Vendor Master (Company Code)




ABAP Code to SELECT data from TXI_LFB1
Related tables to TXI_LFB1
Access table TXI_LFB1




Structure field list including key, data, relationships and ABAP select examples

TXI_LFB1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Vendor Master (Company Code)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXI_LFB1 TYPE TXI_LFB1.

The TXI_LFB1 table consists of various fields, each holding specific information or linking keys about Vendor Master (Company Code) data available in SAP. These include MANDT (Client), LIFNR (Account Number of Vendor or Creditor), BUKRS (Company Code), PERNR (Personnel Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TXI_LFB1 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
SPERRPosting block for company code SPERB_BCHAR1XFELD
LOEVMDeletion Flag for Master Record (Company Code Level) LOEVM_BCHAR1XFELD
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3TZUNZUAWA
AKONTReconciliation Account in General Ledger AKONTCHAR10SKB1ALPHASAKNR
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
VZSKZInterest calculation indicator VZSKZCHAR2T056VZSKZ
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
XVERRIndicator: Clearing between customer and vendor? XVERR_LFB1CHAR1XFELD
ZAHLSBlock Key for Payment DZAHLSCHAR1T008ZAHLS
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
EIKTOOur account number with the vendor EIKTO_KCHAR12CHAR12
ZSABEClerk at vendor DZSABE_KCHAR15TEXT15
KVERMMemo KVERMCHAR30TEXT30
FDGRVPlanning group FDGRVCHAR10T035ALPHAFDGRP
BUSABAccounting clerk BUSABCHAR2T001SBUSAB
LNRZEHead office account number LNRZECHAR10LFA1ALPHALIFNR
LNRZBAccount number of the alternative payee LNRZBCHAR10LFA1ALPHALIFNR
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
DATLZDate of the last interest calculation run DATLZDATS8DATUM
XDEZVIndicator: Local processing? XDEZVCHAR1XFELD
WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
KULTGProbable time until check is paid KULTGDEC3PACK2
REPRFCheck Flag for Double Invoices or Credit Memos REPRFCHAR1XFELD
TOGRUTolerance group for the business partner/G/L account TOGRUCHAR4T043GTOGRU
HBKIDShort Key for a House Bank HBKIDCHAR5T012HBKID
XPOREIndicator: Pay all items separately ? XPORECHAR1XFELD
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2Assigned to domainBLNKZ
MINDKMinority Indicators MINDKCHAR3T059MMINDK
ALTKNPrevious Master Record Number ALTKNCHAR10CHAR10
ZGRUPKey for Payment Grouping DZGRUPCHAR2TZGRZGRUP
MGRUPKey for dunning notice grouping MGRUPCHAR2T047RMGRUP
UZAWEPayment Method Supplement UZAWECHAR2T042FUZAWE
QSRECVendor Recipient Type QSRECCHAR2T059AQSREC
QSBGRAuthority for Exemption from Withholding Tax QSBGRCHAR1QSBGR
QLANDWithholding Tax Country Key QLANDCHAR3T005QQLAND
XEDIPIndicator: Send Payment Advices by EDI XEDIPCHAR1XFELD
FRGRPRelease Approval Group FRGRPCHAR4VBWF08FRGRP
TOGRRTolerance group; Invoice Verification TOGRRCHAR4T169LTOGRR
TLFXSAccounting clerk's fax number at the customer/vendor TLFXSCHAR31TEXT31
INTADInternet address of partner company clerk INTADCHAR130TXT130
XLFZBIndicator: Alternative payee using account number XLFZBCHAR1XFELD
GUZTEPayment Terms Key for Credit Memos GUZTECHAR4ZTERM
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICDJ_1AGICD2
GRIDTDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYPJ_1ADTYP
XAUSZIndicator for periodic account statements XAUSZCHAR1T048KAUSZG
CERDTCertification date CERDTDATS8DATUM
CONFSStatus of Change Authorization (Company Code Level) CONFS_BCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELDeletion bock for master record (company code level) NODEL_BCHAR1XFELD
TLFNSAccounting clerk's telephone number at business partner TLFNSCHAR30CHAR30
AVSNDIndicator: Send Payment Advice by XML AVSNDCHAR1AVSND
AD_HASHE-Mail Address for Avis: Hash Value ADHASHCHAR10ADHASH
.INCLU--AP 0
J_SC_SUBCONTYPESubcontractor Type /SAPNEA/J_SC_SUBCONTYPECHAR1/SAPNEA/J_SC_SUBCONTYPE
J_SC_COMPDATECompletion Date Of Inspection /SAPNEA/J_SC_COMPLETIONDATENUMC3/SAPNEA/J_SC_COMPLETIONDATE
J_SC_OFFSMOffset Method /SAPNEA/J_SC_OFFSMCHAR1/SAPNEA/J_SC_OFFSM
J_SC_OFFSROffset Percentage /SAPNEA/J_SC_OFFSRNUMC3/SAPNEA/J_SC_OFFSR
.INCLU--AP 0
BASIS_PNTAverage daily basis points for purchase cards FMBASIS_POINTSDEC6(3) FMBASIS_POINTS
.INCLU--AP 0
GMVKZKVendor is in execution GMVKZKCHAR1XFELD
.INCLU--AP 0
PREPAY_RELEVANTPrepayment Relevance (Vendor Master) WRF_PREPAY_RELEVANTCHAR1WRF_PREPAY_RELEVANT
ASSIGN_TESTAssignment Test Group WRF_MRM_ASSIGN_GROUPCHAR4WRF_ASSIGN_GRPWRF_MRM_ASSIGN_GROUP
WEBTR_CYCUKY for SYST SYCUKYCUKY5SYCUKY

Key field Non-key field



How do I retrieve data from SAP structure TXI_LFB1 using ABAP code?

As TXI_LFB1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_LFB1 as there is no data to select.

How to access SAP table TXI_LFB1

Within an ECC or HANA version of SAP you can also view further information about TXI_LFB1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!