LFB1

Vendor Master (Company Code) | #masterdata | Component: Vendor Master
Column Name Description
MANDT FK Client
LIFNR FK Account Number of Supplier
BUKRS FK Company Code
Column Name Description
💲 Currency Key (T001.WAERS):
WEBTR Bill of Exchange Limit (in Local Currency)
WRBTR Amount for Payment Program
Column Name Description
Column Name Description
ERDAT Date on which the Record Was Created
ZINDT Key Date of Last Interest Calculation
DATLZ Date of Last Interest Calculation Run
QSZDT Validity Date for Withholding Tax Exemption Certificate
CERDT Certification Date
UPDAT Date on Which the Changes Were Confirmed
UPTIM Time of Last Change Confirmation
ZBOKD LEDGER MANAGEMENT EXPIRATION DATE
ZQSZDT Validity date for withholding tax exemption certificate
ZMINDAT Certification date for minimum wage
US_REC_DOB US Recipient Date Of Birth
US_W8_RECVDATE US W8 Form Received Date
US_W9_RECVDATE US W8 Form Received Date
Column Name Description
SPERR Posting block for company code Show values
LOEVM Deletion Flag for Master Record (Company Code Level) Show values
XVERR Indicator: Clearing between customer and vendor? Show values
ZINRT Interest Calculation Frequency in Months Show values
XDEZV Indicator: Local Processing? Show values
REPRF Check Flag for Double Invoices or Credit Memos Show values
XPORE Indicator: Pay All Items Separately? Show values
QSBGR Authority for Exemption from Withholding Tax Show values
XEDIP Indicator: Send Payment Advices by EDI Show values
XLFZB Indicator: Alternative Payee Using Account Number Show values
NODEL Deletion bock for master record (company code level) Show values
AVSND Indicator: Send Payment Advice by XML Show values
CVP_XBLCK_B Business Purpose Completed Flag Show values
J_SC_SUBCONTYPE Subcontractor Type Show values
J_SC_OFFSM Offset Method Show values
GMVKZK Vendor is in execution Show values
FORGN Foreign Shareholder Show values
ACTIVE Boolean Variable ('X'=Shareholder is active, ''=not active) Show values
US_TIN_NOTICE Second TIN Notice from IRS Show values
US_PARTNERSHIP_IND Partnership Interest Indicator Show values
US_FATCA_IND US FATCA Indicator Show values
PREPAY_RELEVANT Prepayment Relevance (Supplier Master) Show values
Column Name Description Domain name
PERNR Personnel Number PERNR
ERNAM Name of Person who Created the Object USNAM
BEGRU Authorization Group BRGRU
ZWELS List of Respected Payment Methods ZWELS
ZTERM Terms of payment key ZTERM
EIKTO Our account number with the vendor CHAR12
ZSABE Clerk at vendor TEXT15
KVERM Memo TEXT30
KULTG Probable Time Until Check Is Paid PACK2
QSZNR Certificate Number of the Withholding Tax Exemption CHAR10
QSSKZ Withholding Tax Code QSSKZ
BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction Rate BLNKZ
ALTKN Previous Master Record Number CHAR10
TLFXS Accounting clerk's fax number at the customer/vendor TEXT31
INTAD Internet address of partner company clerk TXT130
GUZTE Payment Terms Key for Credit Memos ZTERM
CONFS Status of Change Authorization (Company Code Level) CHAR1
TLFNS Accounting clerk's telephone number at business partner CHAR30
AD_HASH E-Mail Address for Avis: Hash Value ADHASH
CIIUCODE Main economic activity CIIUCODE
PAYTRSN Payment Reason FARP_PAYT_RSN
LFB1_EEW_CC Dataelement for the Extension Company Code LFB1_EEW_CC
ZQSZNR Certificate number of the withholding tax exemption CHAR10
J_SC_COMPDATE Completion Date Of Inspection /SAPNEA/J_SC_COMPLETIONDATE
J_SC_OFFSR Offset Percentage /SAPNEA/J_SC_OFFSR
BASIS_PNT Average daily basis points for purchase cards FMBASIS_POINTS
SHARE_IN_FOREIGN Share in Dividend Paying Company
NOTES Notes FIWTKW_NOTE
US_REC_COUNTRY Country/Region Key LAND1
US_GIIN US Recipient GIIN
US_FTID US Recipient Foreign Tax ID
US_LOB_CODE LOB Treaty Code
Master Data Relations Join Conditions
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • LFB1.BUKRS == SKB1.BUKRS
  • LFB1.MANDT == SKB1.MANDT
  • LFB1.AKONT == SKB1.SAKNR
Industry key
  • Industry key
  • Client
  • LFB1.BRSCH == T016.BRSCH
  • LFB1.MANDT == T016.MANDT
Company Code
  • LFB1.MANDT == T001.MANDT
  • LFB1.BUKRS == T001.BUKRS
Accounting Clerk Abbreviation
  • Company Code
  • Client
  • Accounting Clerk Abbreviation
  • LFB1.BUKRS == T001S.BUKRS
  • LFB1.MANDT == T001S.MANDT
  • LFB1.BUSAB == T001S.BUSAB
Planning Group
  • LFB1.MANDT == T035.MANDT
  • LFB1.FDGRV == T035.GRUPP
Release Approval Group
  • Release Approval Group
  • Client
Activity Code for Employment Tax
  • Activity Code for Gross Income Tax
  • ?
Distrib. Types for Employment Tax
  • Company Code
  • Distribution Type for Employment Tax
Short Key for a House Bank
  • Short Key for a House Bank
  • ?
  • LFB1.MANDT == T012.MANDT
  • LFB1.HBKID == T012.HBKID
  • LFB1.[column in domain "BUKRS"] == T012.BUKRS
Account Number of Supplier
  • LFB1.MANDT == LFA1.MANDT
  • LFB1.LIFNR == LFA1.LIFNR
Account number of the alternative payee
  • LFB1.MANDT == LFA1.MANDT
  • LFB1.LNRZB == LFA1.LIFNR
Head office account number
  • LFB1.MANDT == LFA1.MANDT
  • LFB1.LNRZE == LFA1.LIFNR
Client LFB1.MANDT == T000.MANDT
Key for Dunning Notice Grouping
  • LFB1.MANDT == T047R.MANDT
  • LFB1.MGRUP == T047R.MGRUP
Minority Indicator
  • Minority Indicator
  • Client
  • LFB1.MINDK == T059M.MINDK
  • LFB1.MANDT == T059M.MANDT
Payment Clearing Group ID
Withholding Tax Country/Region Key
  • Withholding Tax Country/Region Key
  • ?
  • LFB1.MANDT == T005Q.MANDT
  • LFB1.QLAND == T005Q.QLAND
  • LFB1.[column in domain "LAND1"] == T005Q.LAND1
Vendor Recipient Type
  • ?
  • Vendor Recipient Type
  • Client
  • LFB1.[column in domain "LAND1"] == T059A.LAND1
  • LFB1.QSREC == T059A.QSREC
  • LFB1.MANDT == T059A.MANDT
Tolerance Group in Invoice Verification
  • Tolerance Group in Invoice Verification
  • Company Code
  • LFB1.MANDT == T169L.MANDT
  • LFB1.TOGRR == T169L.TOGRR
  • LFB1.BUKRS == T169L.BUKRS
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Client
  • LFB1.TOGRU == T043G.TOGRU
  • LFB1.BUKRS == T043G.BUKRS
  • LFB1.MANDT == T043G.MANDT
Payment method supplement
  • LFB1.MANDT == T042F.MANDT
  • LFB1.UZAWE == T042F.UZAWE
Interest Indicator
  • Interest Indicator
  • Client
  • LFB1.VZSKZ == T056.VZSKZ
  • LFB1.MANDT == T056.MANDT
Currency Key
  • LFB1.MANDT == TCURC.MANDT
  • LFB1.WAERS == TCURC.WAERS
Indicator for Periodic Account Statements
  • Indicator for Periodic Account Statements
  • Client
  • LFB1.XAUSZ == T048K.XAUSZ
  • LFB1.MANDT == T048K.MANDT
Block Key for Payment
  • Block Key for Payment
  • Client
  • LFB1.ZAHLS == T008.ZAHLS
  • LFB1.MANDT == T008.MANDT
Key for Payment Grouping LFB1.ZGRUP == TZGR.ZGRUP
Future Withholding tax code
  • ?
  • Client
  • Future Withholding tax code
  • LFB1.[column in domain "LAND1"] == T059Q.LAND1
  • LFB1.MANDT == T059Q.MANDT
  • LFB1.ZQSSKZ == T059Q.QSSKZ
Key for sorting according to assignment numbers LFB1.ZUAWA == TZUN.ZUAWA
Other Relations | to Master Data Relations ↑ Join Conditions
Assignment Test Group
  • Assignment Test Group
  • ?
  • Client