FNDEI_KNB1_FILTER

Filter View for table KNB1 | view: FNDEIFKNB1 | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: KNB1
Column Name Description
KUNNR FK Customer Number
BUKRS FK Company Code
Column Name Description
VLIBB Amount Insured
WEBTR Bill of Exchange Limit (in Local Currency)
Column Name Description
Column Name Description
ERDAT Date on which the Record Was Created
ZINDT Key Date of Last Interest Calculation
VERDT Insurance Validity Date
DATLZ Date of Last Interest Calculation Run
UPDAT Date on Which the Changes Were Confirmed
UPTIM Time of Last Change Confirmation
Column Name Description
SPERR Posting block for company code Show values
LOEVM Deletion Flag for Master Record (Company Code Level) Show values
ZAMIM Indicator: Payment Notice to Customer (with Cleared Items)? Show values
ZAMIV Indicator: Payment Notice to Sales Department? Show values
ZAMIR Indicator: Payment Notice to Legal Department? Show values
ZAMIB Indicator: Payment Notice to the Accounting Department? Show values
ZAMIO Indicator: Payment Notice to Customer (W/o Cleared Items)? 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
XZVER Indicator: Record Payment History ? Show values
XPORE Indicator: Pay All Items Separately? Show values
XEDIP Indicator: Send Payment Advices by EDI Show values
XKNZB Indicator: Alternative Payer 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
GMVKZD Customer is in execution Show values
Column Name Description Domain name
PERNR Personnel Number PERNR
KNB1_EEW_CC Extensibility enabled for Company Code KNB1_EEW_CC
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
WAKON Terms of Payment Key for Bill of Exchange Charges ZTERM
EIKTO Our account number at customer CHAR12
ZSABE User at customer TEXT15
KVERM Memo TEXT30
VRBKZ Export Credit Insurance Institution Number VRBKZ
VRSZL Insurance Lead Months PACK2
VRSPR Deductible Percentage Rate PACK2
VRSNR Insurance Number CHAR10
PERKZ Collective Invoice Variant PERKZ_KNB1
KULTG Probable Time Until Check Is Paid PACK2
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
Master Data Relations Join Conditions
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • FNDEI_KNB1_FILTER.MANDT == SKB1.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == SKB1.BUKRS
  • FNDEI_KNB1_FILTER.AKONT == SKB1.SAKNR
Company Code
  • Client
  • Company Code
  • FNDEI_KNB1_FILTER.MANDT == T001.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == T001.BUKRS
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Client
  • Company Code
  • FNDEI_KNB1_FILTER.BUSAB == T001S.BUSAB
  • FNDEI_KNB1_FILTER.MANDT == T001S.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == T001S.BUKRS
Accounts Receivable Pledging Indicator
  • Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • FNDEI_KNB1_FILTER.CESSION_KZ == TCESSION.CESSION_KZ
  • FNDEI_KNB1_FILTER.MANDT == TCESSION.CLIENT
  • FNDEI_KNB1_FILTER.BUKRS == TCESSION.COMPANY
Account Number of Buying Group
  • Client
  • Account Number of Buying Group
  • FNDEI_KNB1_FILTER.MANDT == KNA1.MANDT
  • FNDEI_KNB1_FILTER.EKVBD == KNA1.KUNNR
Planning Group
  • Planning Group
  • Client
  • FNDEI_KNB1_FILTER.FDGRV == T035.GRUPP
  • FNDEI_KNB1_FILTER.MANDT == T035.MANDT
Release Approval Group
  • Client
  • Release Approval Group
  • FNDEI_KNB1_FILTER.MANDT == VBWF08.MANDT
  • FNDEI_KNB1_FILTER.FRGRP == VBWF08.FRGRP
Activity Code for Gross Income Tax
  • Client
  • Activity Code for Gross Income Tax
  • ?
  • FNDEI_KNB1_FILTER.MANDT == J_1AGICD.MANDT
  • FNDEI_KNB1_FILTER.GRICD == J_1AGICD.J_1AGICD
  • FNDEI_KNB1_FILTER.[column in domain "LAND1"] == J_1AGICD.LAND1
Distrib. Types for Employment Tax
  • Distribution Type for Employment Tax
  • Client
  • Company Code
  • FNDEI_KNB1_FILTER.GRIDT == J_1ADTYP.J_1ADTYP
  • FNDEI_KNB1_FILTER.MANDT == J_1ADTYP.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == J_1ADTYP.BUKRS
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • ?
  • FNDEI_KNB1_FILTER.MANDT == T012.MANDT
  • FNDEI_KNB1_FILTER.HBKID == T012.HBKID
  • FNDEI_KNB1_FILTER.[column in domain "BUKRS"] == T012.BUKRS
Account number of an alternative payer
  • Account number of an alternative payer
  • Client
  • FNDEI_KNB1_FILTER.KNRZB == KNA1.KUNNR
  • FNDEI_KNB1_FILTER.MANDT == KNA1.MANDT
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • FNDEI_KNB1_FILTER.MANDT == KNA1.MANDT
  • FNDEI_KNB1_FILTER.KNRZE == KNA1.KUNNR
Customer Number
  • Client
  • Customer Number
  • FNDEI_KNB1_FILTER.MANDT == KNA1.MANDT
  • FNDEI_KNB1_FILTER.KUNNR == KNA1.KUNNR
Key for Dunning Notice Grouping
  • Client
  • Key for Dunning Notice Grouping
  • FNDEI_KNB1_FILTER.MANDT == T047R.MANDT
  • FNDEI_KNB1_FILTER.MGRUP == T047R.MGRUP
Payment Clearing Group ID
  • Client
  • Payment Clearing Group ID
Withholding Tax Country/Region Key
  • Client
  • ?
  • Withholding Tax Country/Region Key
  • FNDEI_KNB1_FILTER.MANDT == T005Q.MANDT
  • FNDEI_KNB1_FILTER.[column in domain "LAND1"] == T005Q.LAND1
  • FNDEI_KNB1_FILTER.QLAND == T005Q.QLAND
Next payee
  • Client
  • Next payee
  • FNDEI_KNB1_FILTER.MANDT == KNA1.MANDT
  • FNDEI_KNB1_FILTER.REMIT == KNA1.KUNNR
Selection Rule for Payment Advices
  • Client
  • Selection Rule for Payment Advices
  • FNDEI_KNB1_FILTER.MANDT == T053A.MANDT
  • FNDEI_KNB1_FILTER.SREGL == T053A.SREGL
Tolerance Group for Business Partner/G/L Account
  • Client
  • Company Code
  • Tolerance Group for Business Partner/G/L Account
  • FNDEI_KNB1_FILTER.MANDT == T043G.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == T043G.BUKRS
  • FNDEI_KNB1_FILTER.TOGRU == T043G.TOGRU
Short Key for Known/Negotiated Leave
  • Client
  • Short Key for Known/Negotiated Leave
  • FNDEI_KNB1_FILTER.MANDT == T052A.MANDT
  • FNDEI_KNB1_FILTER.URLID == T052A.URLID
Payment method supplement
  • Client
  • Payment method supplement
  • FNDEI_KNB1_FILTER.MANDT == T042F.MANDT
  • FNDEI_KNB1_FILTER.UZAWE == T042F.UZAWE
Reason Code Conversion Version
  • Client
  • Reason Code Conversion Version
  • FNDEI_KNB1_FILTER.MANDT == T053V.MANDT
  • FNDEI_KNB1_FILTER.VRSDG == T053V.VRSDG
Interest Indicator
  • Client
  • Interest Indicator
  • FNDEI_KNB1_FILTER.MANDT == T056.MANDT
  • FNDEI_KNB1_FILTER.VZSKZ == T056.VZSKZ
Value Adjustment Key
  • Client
  • ?
  • ?
  • ?
  • ?
  • Value Adjustment Key
  • FNDEI_KNB1_FILTER.MANDT == T044G.MANDT
  • FNDEI_KNB1_FILTER.[column in domain "FFUTURE"] == T044G.FUTURE
  • FNDEI_KNB1_FILTER.[column in domain "LAND1"] == T044G.LAND1
  • FNDEI_KNB1_FILTER.[column in domain "OVDUE"] == T044G.OVDUE
  • FNDEI_KNB1_FILTER.[column in domain "BWBER"] == T044G.BWBER
  • FNDEI_KNB1_FILTER.WBRSL == T044G.WBRSL
Indicator for Periodic Account Statements
  • Client
  • Indicator for Periodic Account Statements
  • FNDEI_KNB1_FILTER.MANDT == T048K.MANDT
  • FNDEI_KNB1_FILTER.XAUSZ == T048K.XAUSZ
Block Key for Payment
  • Client
  • Block Key for Payment
  • FNDEI_KNB1_FILTER.MANDT == T008.MANDT
  • FNDEI_KNB1_FILTER.ZAHLS == T008.ZAHLS
Key for Payment Grouping FNDEI_KNB1_FILTER.ZGRUP == TZGR.ZGRUP
Key for sorting according to assignment numbers FNDEI_KNB1_FILTER.ZUAWA == TZUN.ZUAWA
Other Relations | to Master Data Relations ↑ Join Conditions
Key of the Lockbox to Which the Customer Is to Pay
  • Key of the Lockbox to Which the Customer Is to Pay
  • Client
  • Company Code
  • FNDEI_KNB1_FILTER.LOCKB == T049L.LOCKB
  • FNDEI_KNB1_FILTER.MANDT == T049L.MANDT
  • FNDEI_KNB1_FILTER.BUKRS == T049L.BUKRS