SAP Table SI_KNB1_DI
Customer Master (Company Code)
SI_KNB1_DI (Customer Master (Company Code)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SI_KNB1_DI to other SAP tables.
SI_KNB1_DI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ERDAT
Date on Which Record was Added (Direct Input)
|
ERDAT_RF_DI |
CHAR
|
10 | 0 | ||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||
|
SPERR
Posting block for company code
|
SPERB_B |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LOEVM
Deletion Flag for Master Record (Company Code Level)
|
LOEVM_B |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZUAWA
Key for sorting according to assignment numbers
|
DZUAWA | TZUN |
CHAR
|
3 | 0 | |||||||
|
BUSAB
Accounting clerk
|
BUSAB | T001S |
CHAR
|
2 | 0 | |||||||
|
AKONT
Reconciliation Account in General Ledger
|
AKONT | SKB1 |
CHAR
|
10 | 0 | |||||||
|
BEGRU
Authorization Group
|
BRGRU |
CHAR
|
4 | 0 | ||||||||
|
KNRZE
Head office account number (in branch accounts)
|
KNRZE | KNA1 |
CHAR
|
10 | 0 | |||||||
|
KNRZB
Account number of an alternative payer
|
KNRZB | KNA1 |
CHAR
|
10 | 0 | |||||||
|
ZAMIM
Indicator: Payment notice to customer (with cleared items)?
|
DZAMIM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZAMIV
Indicator: payment notice to sales department?
|
DZAMIV |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZAMIR
Indicator: payment notice to legal department?
|
DZAMIR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZAMIB
Indicator: Payment notice to the accounting department ?
|
DZAMIB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZAMIO
Indicator: payment notice to customer (w/o cleared items)?
|
DZAMIO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZWELS
List of the Payment Methods to be Considered
|
DZWELS |
CHAR
|
10 | 0 | ||||||||
|
XVERR
Indicator: Clearing between customer and vendor ?
|
XVERR_KNB1 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ZAHLS
Block Key for Payment
|
DZAHLS | T008 |
CHAR
|
1 | 0 | |||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||
|
WAKON
Terms of payment key for bill of exchange charges
|
WAKON |
CHAR
|
4 | 0 | ||||||||
|
VZSKZ
Interest calculation indicator
|
VZSKZ | T056 |
CHAR
|
2 | 0 | |||||||
|
ZINDT
Key Date of Last Interest Calculation (Direct Input)
|
DZINDT_DI |
CHAR
|
10 | 0 | ||||||||
|
ZINRT
Interest Calculation Frequency in Months (Direct Input)
|
DZINRT_DI |
CHAR
|
2 | 0 | ||||||||
|
EIKTO
Our account number at customer
|
EIKTO_D |
CHAR
|
12 | 0 | ||||||||
|
ZSABE
User at customer
|
DZSABE_D |
CHAR
|
15 | 0 | ||||||||
|
KVERM
Memo
|
KVERM |
CHAR
|
30 | 0 | ||||||||
|
FDGRV
Planning group
|
FDGRV | T035 |
CHAR
|
10 | 0 | |||||||
|
VRBKZ
Export credit insurance institution number
|
VRBKZ |
CHAR
|
2 | 0 | ||||||||
|
VLIBB
Amount Insured
|
VLIBB_DI |
CHAR
|
16 | 0 | ||||||||
|
VRSZL
Insurance Target (Direct Input)
|
VRSZL_DI |
CHAR
|
3 | 0 | ||||||||
|
VRSPR
Percentage of Deductible (Direct Input)
|
VRSPR_DI |
CHAR
|
3 | 0 | ||||||||
|
VRSNR
Insurance number
|
VRSNR |
CHAR
|
10 | 0 | ||||||||
|
VERDT
Validity Date of Insurance (Direct Input)
|
VERDT_DI |
CHAR
|
10 | 0 | ||||||||
|
PERKZ
Collective invoice variant
|
PERKZ_KNB1 |
CHAR
|
1 | 0 | ||||||||
|
XDEZV
Indicator: Local processing?
|
XDEZV |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XAUSZ
Indicator for periodic account statements
|
XAUSZ | T048K |
CHAR
|
1 | 0 | |||||||
|
WEBTR
Bill of Exchange Limit (in Local Currency) (Direct Input)
|
WEBTR_DI |
CHAR
|
16 | 0 | ||||||||
|
REMIT
Next payee
|
REMIT | KNA1 |
CHAR
|
10 | 0 | |||||||
|
DATLZ
CPU Date of Last Interest Calculation Run (Direct Input)
|
DATLZ_DI |
CHAR
|
10 | 0 | ||||||||
|
XZVER
Indicator: Record Payment History ?
|
XZVER |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TOGRU
Tolerance group for the business partner/G/L account
|
TOGRU | T043G |
CHAR
|
4 | 0 | |||||||
|
KULTG
Probable Time Until Check Is Encashed
|
KULTG_DI |
CHAR
|
3 | 0 | ||||||||
|
HBKID
Short Key for a House Bank
|
HBKID | T012 |
CHAR
|
5 | 0 | |||||||
|
XPORE
Indicator: Pay all items separately ?
|
XPORE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BLNKZ
Subsidy indicator for determining the reduction rates
|
BLNKZ |
CHAR
|
2 | 0 | ||||||||
|
ALTKN
Previous Master Record Number
|
ALTKN |
CHAR
|
10 | 0 | ||||||||
|
ZGRUP
Key for Payment Grouping
|
DZGRUP | TZGR |
CHAR
|
2 | 0 | |||||||
|
URLID
Short Key for Known/Negotiated Leave
|
URLID | T052A |
CHAR
|
4 | 0 | |||||||
|
MGRUP
Key for dunning notice grouping
|
MGRUP | T047R |
CHAR
|
2 | 0 | |||||||
|
LOCKB
Key of the Lockbox to Which the Customer Is To Pay
|
LOCKB | T049L |
CHAR
|
7 | 0 | |||||||
|
UZAWE
Payment Method Supplement
|
UZAWE | T042F |
CHAR
|
2 | 0 | |||||||
|
EKVBD
Account Number of Buying Group
|
EKVBD | KNA1 |
CHAR
|
10 | 0 | |||||||
|
SREGL
Selection Rule for Payment Advices
|
SREGL | T053A |
CHAR
|
3 | 0 | |||||||
|
XEDIP
Indicator: Send Payment Advices by EDI
|
XEDIP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FRGRP
Release Approval Group
|
FRGRP | VBWF08 |
CHAR
|
4 | 0 | |||||||
|
VRSDG
Reason Code Conversion Version
|
VRSDG | T053V |
CHAR
|
3 | 0 | |||||||
|
TLFXS
Accounting clerk's fax number at the customer/vendor
|
TLFXS |
CHAR
|
31 | 0 | ||||||||
|
INTAD
Internet address of partner company clerk
|
INTAD |
CHAR
|
130 | 0 | ||||||||
|
XKNZB
Indicator: Alternative payer using account number
|
XKNZB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
GUZTE
Payment Terms Key for Credit Memos
|
GUZTE |
CHAR
|
4 | 0 | ||||||||
|
GRICD
Activity Code for Gross Income Tax
|
J_1AGICD_D | J_1AGICD |
CHAR
|
2 | 0 | |||||||
|
GRIDT
Distribution Type for Employment Tax
|
J_1ADTYP_D | J_1ADTYP |
CHAR
|
2 | 0 | |||||||
|
WBRSL
Value Adjustment Key
|
WBRSL | T044G |
CHAR
|
2 | 0 | |||||||
|
CONFS
Status of Change Authorization (Company Code Level)
|
CONFS_B |
CHAR
|
1 | 0 | ||||||||
|
UPDAT
Date on which Changes were Confirmed (Direct Input)
|
UPDAT_RF_DI |
CHAR
|
10 | 0 | ||||||||
|
UPTIM
Time of Last Change Confirmation (Direct Input)
|
UPTIM_RF_DI |
CHAR
|
8 | 0 | ||||||||
|
NODEL
Deletion bock for master record (company code level)
|
NODEL_B |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TLFNS
Accounting clerk's telephone number at business partner
|
TLFNS |
CHAR
|
30 | 0 | ||||||||
|
CESSION_KZ
Accounts Receivable Pledging Indicator
|
CESSION_KZ | TCESSION |
CHAR
|
2 | 0 | |||||||
SI_KNB1_DI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SI_KNB1_DI | AKONT | SI_KNB1_DI | AKONT |
SKB1
G/L account master (company code)
|
SAKNR |
| SI_KNB1_DI | AKONT | KNB1 | MANDT |
SKB1
G/L account master (company code)
|
MANDT |
| SI_KNB1_DI | AKONT | KNB1 | BUKRS |
SKB1
G/L account master (company code)
|
BUKRS |
| SI_KNB1_DI | BUSAB | KNB1 | MANDT |
T001S
Accounting Clerks
|
MANDT |
| SI_KNB1_DI | BUSAB | KNB1 | BUKRS |
T001S
Accounting Clerks
|
BUKRS |
| SI_KNB1_DI | BUSAB | SI_KNB1_DI | BUSAB |
T001S
Accounting Clerks
|
BUSAB |
| SI_KNB1_DI | CESSION_KZ | KNB1 | BUKRS |
TCESSION
Accounts Receivable Pledging
|
COMPANY |
| SI_KNB1_DI | CESSION_KZ | SI_KNB1_DI | CESSION_KZ |
TCESSION
Accounts Receivable Pledging
|
CESSION_KZ |
| SI_KNB1_DI | CESSION_KZ | KNB1 | MANDT |
TCESSION
Accounts Receivable Pledging
|
CLIENT |
| SI_KNB1_DI | EKVBD | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| SI_KNB1_DI | EKVBD | SI_KNB1_DI | EKVBD |
KNA1
General Data in Customer Master
|
KUNNR |
| SI_KNB1_DI | FDGRV | KNB1 | MANDT |
T035
Planning groups
|
MANDT |
| SI_KNB1_DI | FDGRV | SI_KNB1_DI | FDGRV |
T035
Planning groups
|
GRUPP |
| SI_KNB1_DI | FRGRP | SI_KNB1_DI | FRGRP |
VBWF08
Release Groups
|
FRGRP |
| SI_KNB1_DI | FRGRP | KNB1 | MANDT |
VBWF08
Release Groups
|
MANDT |
| SI_KNB1_DI | GRICD | KNB1 | MANDT |
J_1AGICD
Activity codes for gross income tax declaration
|
MANDT |
| SI_KNB1_DI | GRICD | T001 | LAND1 |
J_1AGICD
Activity codes for gross income tax declaration
|
LAND1 |
| SI_KNB1_DI | GRICD | SI_KNB1_DI | GRICD |
J_1AGICD
Activity codes for gross income tax declaration
|
J_1AGICD |
| SI_KNB1_DI | GRIDT | KNB1 | MANDT |
J_1ADTYP
Distribution Types for Gross Income Tax
|
MANDT |
| SI_KNB1_DI | GRIDT | KNB1 | BUKRS |
J_1ADTYP
Distribution Types for Gross Income Tax
|
BUKRS |
| SI_KNB1_DI | GRIDT | SI_KNB1_DI | GRIDT |
J_1ADTYP
Distribution Types for Gross Income Tax
|
J_1ADTYP |
| SI_KNB1_DI | HBKID | KNB1 | MANDT |
T012
House Banks
|
MANDT |
| SI_KNB1_DI | HBKID | KNB1 | BUKRS |
T012
House Banks
|
BUKRS |
| SI_KNB1_DI | HBKID | SI_KNB1_DI | HBKID |
T012
House Banks
|
HBKID |
| SI_KNB1_DI | KNRZB | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| SI_KNB1_DI | KNRZB | SI_KNB1_DI | KNRZB |
KNA1
General Data in Customer Master
|
KUNNR |
| SI_KNB1_DI | KNRZE | SI_KNB1_DI | KNRZE |
KNA1
General Data in Customer Master
|
KUNNR |
| SI_KNB1_DI | KNRZE | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| SI_KNB1_DI | LOCKB | KNB1 | BUKRS |
T049L
Lockboxes at our House Banks
|
BUKRS |
| SI_KNB1_DI | LOCKB | SI_KNB1_DI | LOCKB |
T049L
Lockboxes at our House Banks
|
LOCKB |
| SI_KNB1_DI | LOCKB | KNB1 | MANDT |
T049L
Lockboxes at our House Banks
|
MANDT |
| SI_KNB1_DI | MGRUP | KNB1 | MANDT |
T047R
Grouping rules for dunning notices
|
MANDT |
| SI_KNB1_DI | MGRUP | SI_KNB1_DI | MGRUP |
T047R
Grouping rules for dunning notices
|
MGRUP |
| SI_KNB1_DI | REMIT | KNB1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| SI_KNB1_DI | REMIT | SI_KNB1_DI | REMIT |
KNA1
General Data in Customer Master
|
KUNNR |
| SI_KNB1_DI | SREGL | SI_KNB1_DI | SREGL |
T053A
Selection Rules for Payment Advices
|
SREGL |
| SI_KNB1_DI | SREGL | KNB1 | MANDT |
T053A
Selection Rules for Payment Advices
|
MANDT |
| SI_KNB1_DI | TOGRU | KNB1 | MANDT |
T043G
Tolerances for Groups of Customers/Vendors
|
MANDT |
| SI_KNB1_DI | TOGRU | KNB1 | BUKRS |
T043G
Tolerances for Groups of Customers/Vendors
|
BUKRS |
| SI_KNB1_DI | TOGRU | SI_KNB1_DI | TOGRU |
T043G
Tolerances for Groups of Customers/Vendors
|
TOGRU |
| SI_KNB1_DI | URLID | KNB1 | MANDT |
T052A
Known/Negotiated Leave
|
MANDT |
| SI_KNB1_DI | URLID | SI_KNB1_DI | URLID |
T052A
Known/Negotiated Leave
|
URLID |
| SI_KNB1_DI | UZAWE | KNB1 | MANDT |
T042F
Payment method supplements
|
MANDT |
| SI_KNB1_DI | UZAWE | SI_KNB1_DI | UZAWE |
T042F
Payment method supplements
|
UZAWE |
| SI_KNB1_DI | VRSDG | KNB1 | MANDT |
T053V
Reason Code Conversion Version
|
MANDT |
| SI_KNB1_DI | VRSDG | SI_KNB1_DI | VRSDG |
T053V
Reason Code Conversion Version
|
VRSDG |
| SI_KNB1_DI | VZSKZ | KNB1 | MANDT |
T056
Interest settlement
|
MANDT |
| SI_KNB1_DI | VZSKZ | SI_KNB1_DI | VZSKZ |
T056
Interest settlement
|
VZSKZ |
| SI_KNB1_DI | WBRSL | KNB1 | MANDT |
T044G
Valuation Adjustment Key
|
MANDT |
| SI_KNB1_DI | WBRSL | SI_KNB1_DI | WBRSL |
T044G
Valuation Adjustment Key
|
WBRSL |
| SI_KNB1_DI | WBRSL | * |
T044G
Valuation Adjustment Key
|
BWBER | |
| SI_KNB1_DI | WBRSL | * |
T044G
Valuation Adjustment Key
|
LAND1 | |
| SI_KNB1_DI | WBRSL | * |
T044G
Valuation Adjustment Key
|
OVDUE | |
| SI_KNB1_DI | WBRSL | * |
T044G
Valuation Adjustment Key
|
FUTURE | |
| SI_KNB1_DI | XAUSZ | KNB1 | MANDT |
T048K
Indicator for Periodic Account Statements
|
MANDT |
| SI_KNB1_DI | XAUSZ | SI_KNB1_DI | XAUSZ |
T048K
Indicator for Periodic Account Statements
|
XAUSZ |
| SI_KNB1_DI | ZAHLS | KNB1 | MANDT |
T008
Blocking Reasons for Automatic Payment Transcations
|
MANDT |
| SI_KNB1_DI | ZAHLS | SI_KNB1_DI | ZAHLS |
T008
Blocking Reasons for Automatic Payment Transcations
|
ZAHLS |
| SI_KNB1_DI | ZGRUP | SI_KNB1_DI | ZGRUP |
TZGR
Grouping rules for automatic payments
|
ZGRUP |
| SI_KNB1_DI | ZUAWA | SI_KNB1_DI | ZUAWA |
TZUN
Rules for 'Allocation' Field Layout
|
ZUAWA |