FNDEI_LFB1_FILTER

Filter View for table LFB1 | view: FNDEIFLFB1 | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: LFB1
Column Name Description
LIFNR FK Account Number of Supplier
BUKRS FK Company Code
Column Name Description
WEBTR Bill of Exchange Limit (in Local Currency)
💲 Currency Key (WAERS):
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
  • Reconciliation Account in General Ledger
  • Client
  • FNDEI_LFB1_FILTER.BUKRS == SKB1.BUKRS
  • FNDEI_LFB1_FILTER.AKONT == SKB1.SAKNR
  • FNDEI_LFB1_FILTER.MANDT == SKB1.MANDT
Industry key
  • Industry key
  • Client
  • FNDEI_LFB1_FILTER.BRSCH == T016.BRSCH
  • FNDEI_LFB1_FILTER.MANDT == T016.MANDT
Company Code
  • Company Code
  • Client
  • FNDEI_LFB1_FILTER.BUKRS == T001.BUKRS
  • FNDEI_LFB1_FILTER.MANDT == T001.MANDT
Accounting Clerk Abbreviation
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • FNDEI_LFB1_FILTER.BUKRS == T001S.BUKRS
  • FNDEI_LFB1_FILTER.BUSAB == T001S.BUSAB
  • FNDEI_LFB1_FILTER.MANDT == T001S.MANDT
Planning Group
  • Planning Group
  • Client
  • FNDEI_LFB1_FILTER.FDGRV == T035.GRUPP
  • FNDEI_LFB1_FILTER.MANDT == T035.MANDT
Release Approval Group
  • Client
  • Release Approval Group
  • FNDEI_LFB1_FILTER.MANDT == VBWF08.MANDT
  • FNDEI_LFB1_FILTER.FRGRP == VBWF08.FRGRP
Activity Code for Employment Tax
  • Client
  • Activity Code for Gross Income Tax
  • ?
  • FNDEI_LFB1_FILTER.MANDT == J_1AGICD.MANDT
  • FNDEI_LFB1_FILTER.GRICD == J_1AGICD.J_1AGICD
  • FNDEI_LFB1_FILTER.[column in domain "LAND1"] == J_1AGICD.LAND1
Distrib. Types for Employment Tax
  • Company Code
  • Client
  • Distribution Type for Employment Tax
  • FNDEI_LFB1_FILTER.BUKRS == J_1ADTYP.BUKRS
  • FNDEI_LFB1_FILTER.MANDT == J_1ADTYP.MANDT
  • FNDEI_LFB1_FILTER.GRIDT == J_1ADTYP.J_1ADTYP
Short Key for a House Bank
  • Short Key for a House Bank
  • Client
  • ?
  • FNDEI_LFB1_FILTER.HBKID == T012.HBKID
  • FNDEI_LFB1_FILTER.MANDT == T012.MANDT
  • FNDEI_LFB1_FILTER.[column in domain "BUKRS"] == T012.BUKRS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FNDEI_LFB1_FILTER.LIFNR == LFA1.LIFNR
  • FNDEI_LFB1_FILTER.MANDT == LFA1.MANDT
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • FNDEI_LFB1_FILTER.LNRZB == LFA1.LIFNR
  • FNDEI_LFB1_FILTER.MANDT == LFA1.MANDT
Head office account number
  • Head office account number
  • Client
  • FNDEI_LFB1_FILTER.LNRZE == LFA1.LIFNR
  • FNDEI_LFB1_FILTER.MANDT == LFA1.MANDT
Key for Dunning Notice Grouping
  • Key for Dunning Notice Grouping
  • Client
  • FNDEI_LFB1_FILTER.MGRUP == T047R.MGRUP
  • FNDEI_LFB1_FILTER.MANDT == T047R.MANDT
Minority Indicator
  • Client
  • Minority Indicator
  • FNDEI_LFB1_FILTER.MANDT == T059M.MANDT
  • FNDEI_LFB1_FILTER.MINDK == T059M.MINDK
Payment Clearing Group ID
  • Payment Clearing Group ID
  • Client
Withholding Tax Country/Region Key
  • Withholding Tax Country/Region Key
  • Client
  • ?
  • FNDEI_LFB1_FILTER.QLAND == T005Q.QLAND
  • FNDEI_LFB1_FILTER.MANDT == T005Q.MANDT
  • FNDEI_LFB1_FILTER.[column in domain "LAND1"] == T005Q.LAND1
Vendor Recipient Type
  • Client
  • Vendor Recipient Type
  • ?
  • FNDEI_LFB1_FILTER.MANDT == T059A.MANDT
  • FNDEI_LFB1_FILTER.QSREC == T059A.QSREC
  • FNDEI_LFB1_FILTER.[column in domain "LAND1"] == T059A.LAND1
Tolerance Group in Invoice Verification
  • Company Code
  • Tolerance Group in Invoice Verification
  • Client
  • FNDEI_LFB1_FILTER.BUKRS == T169L.BUKRS
  • FNDEI_LFB1_FILTER.TOGRR == T169L.TOGRR
  • FNDEI_LFB1_FILTER.MANDT == T169L.MANDT
Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Client
  • Tolerance Group for Business Partner/G/L Account
  • FNDEI_LFB1_FILTER.BUKRS == T043G.BUKRS
  • FNDEI_LFB1_FILTER.MANDT == T043G.MANDT
  • FNDEI_LFB1_FILTER.TOGRU == T043G.TOGRU
Payment method supplement
  • Payment method supplement
  • Client
  • FNDEI_LFB1_FILTER.UZAWE == T042F.UZAWE
  • FNDEI_LFB1_FILTER.MANDT == T042F.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • FNDEI_LFB1_FILTER.MANDT == T056.MANDT
  • FNDEI_LFB1_FILTER.VZSKZ == T056.VZSKZ
Currency Key
  • Client
  • Currency Key
  • FNDEI_LFB1_FILTER.MANDT == TCURC.MANDT
  • FNDEI_LFB1_FILTER.WAERS == TCURC.WAERS
Indicator for Periodic Account Statements
  • Client
  • Indicator for Periodic Account Statements
  • FNDEI_LFB1_FILTER.MANDT == T048K.MANDT
  • FNDEI_LFB1_FILTER.XAUSZ == T048K.XAUSZ
Block Key for Payment
  • Client
  • Block Key for Payment
  • FNDEI_LFB1_FILTER.MANDT == T008.MANDT
  • FNDEI_LFB1_FILTER.ZAHLS == T008.ZAHLS
Key for Payment Grouping FNDEI_LFB1_FILTER.ZGRUP == TZGR.ZGRUP
Future Withholding tax code
  • Client
  • Future Withholding tax code
  • ?
  • FNDEI_LFB1_FILTER.MANDT == T059Q.MANDT
  • FNDEI_LFB1_FILTER.ZQSSKZ == T059Q.QSSKZ
  • FNDEI_LFB1_FILTER.[column in domain "LAND1"] == T059Q.LAND1
Key for sorting according to assignment numbers FNDEI_LFB1_FILTER.ZUAWA == TZUN.ZUAWA
Other Relations | to Master Data Relations ↑ Join Conditions
Assignment Test Group
  • ?
  • Assignment Test Group
  • Client