SAP Table SI_BUB1FI
Business Partner: Company Code Data (FI)
SI_BUB1FI (Business Partner: Company Code Data (FI)) 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_BUB1FI to other SAP tables.
SI_BUB1FI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AKONT | Reconciliation Account in General Ledger | AKONT | SKB1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| ALTKN | Previous Master Record Number | ALTKN | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| BLNKZ | Subsidy indicator for determining the reduction rates | BLNKZ | T057 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| BUSAB | Accounting clerk | BUSAB | T001S | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | 0 | |||||||||||||||||||||||||||
| FDGRV | Planning group | FDGRV | T035 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| FRGRP | Release Approval Group | FRGRP | VBWF08 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| GMVDT | Date of the legal dunning proceedings | GMVDT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||||||||||||||||||||||
| KULTG | Probable time until check is paid | KULTG | DEC | 3 | 0 | |||||||||||||||||||||||||||
| KVERM | Memo | KVERM | CHAR | 30 | 0 | |||||||||||||||||||||||||||
| LOCKB | Key of the Lockbox to Which the Customer Is To Pay | LOCKB | T049L | CHAR | 7 | 0 | ||||||||||||||||||||||||||
| MADAT | Last dunned on | MADAT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| MAHNA | Dunning Procedure | MAHNA | T047A | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| MAHNS | Dunning level | MAHNS_D | NUMC | 1 | 0 | |||||||||||||||||||||||||||
| MANSP | Dunning block | MANSP | T040S | CHAR | 1 | 0 | ||||||||||||||||||||||||||
| MGRUP | Key for dunning notice grouping | MGRUP | T047R | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| PERKZ | Collective invoice variant | PERKZ_KNB1 | CHAR | 1 | 0 | |||||||||||||||||||||||||||
| SREGL | Selection Rule for Payment Advices | SREGL | T053A | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| TOGRU | Tolerance group for the business partner/G/L account | TOGRU | T043G | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| URLID | Short Key for Known/Negotiated Leave | URLID | T052A | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| UZAWE | Payment Method Supplement | UZAWE | T042F | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| VERDT | Insurance validity date | VERDT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| VLIBB | Amount Insured | VLIBB | CURR | 13 | 2 | |||||||||||||||||||||||||||
| VRBKZ | Export credit insurance institution number | VRBKZ | CHAR | 2 | 0 | |||||||||||||||||||||||||||
| VRSDG | Reason Code Conversion Version | VRSDG | T053V | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| VRSNR | Insurance number | VRSNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| VRSPR | Deductible percentage rate | VRSPR | DEC | 3 | 0 | |||||||||||||||||||||||||||
| VRSZL | Insurance lead months | VRSZL | DEC | 3 | 0 | |||||||||||||||||||||||||||
| VZSKZ | Interest calculation indicator | VZSKZ | T056 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| WAKON | Terms of payment key for bill of exchange charges | WAKON | CHAR | 4 | 0 | |||||||||||||||||||||||||||
| WEBTR | Bill of exchange limit (in local currency) | WEBTR | CURR | 13 | 2 | |||||||||||||||||||||||||||
| XAUSZ | Indicator for periodic account statements | XAUSZ | T048K | CHAR | 1 | 0 | ||||||||||||||||||||||||||
| XDEZV | Indicator: Local processing? | XDEZV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XEDIP | Indicator: Send Payment Advices by EDI | XEDIP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XPORE | Indicator: Pay all items separately ? | XPORE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XVERR | Indicator: Clearing between customer and vendor ? | XVERR_KNB1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XZVER | Indicator: Record Payment History ? | XZVER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZAHLS | Block Key for Payment | DZAHLS | T008 | CHAR | 1 | 0 | ||||||||||||||||||||||||||
| ZAMIB | Indicator: Payment notice to the accounting department ? | DZAMIB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZAMIM | Indicator: Payment notice to customer (with cleared items)? | DZAMIM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZAMIO | Indicator: payment notice to customer (w/o cleared items)? | DZAMIO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZAMIR | Indicator: payment notice to legal department? | DZAMIR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZAMIV | Indicator: payment notice to sales department? | DZAMIV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZGRUP | Key for Payment Grouping | DZGRUP | TZGR | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZSABE | User at customer | DZSABE_D | CHAR | 15 | 0 | |||||||||||||||||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||||||||||||||||
| ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| ZUAWA | Key for sorting according to assignment numbers | DZUAWA | TZUN | CHAR | 3 | 0 | ||||||||||||||||||||||||||
SI_BUB1FI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SI_BUB1FI | AKONT | FKKBUB1 | MANDT | SKB1 | G/L account master (company code) | MANDT |
| SI_BUB1FI | AKONT | FKKBUB1 | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| SI_BUB1FI | AKONT | SI_BUB1FI | AKONT | SKB1 | G/L account master (company code) | SAKNR |
| SI_BUB1FI | BLNKZ | SI_BUB1FI | BLNKZ | T057 | Preference Indicator | BLNKZ |
| SI_BUB1FI | BLNKZ | * | T057 | Preference Indicator | BEGDA | |
| SI_BUB1FI | BLNKZ | FKKBUB1 | MANDT | T057 | Preference Indicator | MANDT |
| SI_BUB1FI | BUSAB | FKKBUB1 | MANDT | T001S | Accounting Clerks | MANDT |
| SI_BUB1FI | BUSAB | FKKBUB1 | BUKRS | T001S | Accounting Clerks | BUKRS |
| SI_BUB1FI | BUSAB | SI_BUB1FI | BUSAB | T001S | Accounting Clerks | BUSAB |
| SI_BUB1FI | FDGRV | FKKBUB1 | MANDT | T035 | Planning groups | MANDT |
| SI_BUB1FI | FDGRV | SI_BUB1FI | FDGRV | T035 | Planning groups | GRUPP |
| SI_BUB1FI | FRGRP | SI_BUB1FI | FRGRP | VBWF08 | Release Groups | FRGRP |
| SI_BUB1FI | FRGRP | FKKBUB1 | MANDT | VBWF08 | Release Groups | MANDT |
| SI_BUB1FI | HBKID | FKKBUB1 | MANDT | T012 | House Banks | MANDT |
| SI_BUB1FI | HBKID | FKKBUB1 | BUKRS | T012 | House Banks | BUKRS |
| SI_BUB1FI | HBKID | SI_BUB1FI | HBKID | T012 | House Banks | HBKID |
| SI_BUB1FI | LOCKB | FKKBUB1 | BUKRS | T049L | Lockboxes at our House Banks | BUKRS |
| SI_BUB1FI | LOCKB | SI_BUB1FI | LOCKB | T049L | Lockboxes at our House Banks | LOCKB |
| SI_BUB1FI | LOCKB | FKKBUB1 | MANDT | T049L | Lockboxes at our House Banks | MANDT |
| SI_BUB1FI | MAHNA | FKKBUB1 | MANDT | T047A | Account Level Dunning Control | MANDT |
| SI_BUB1FI | MAHNA | SI_BUB1FI | MAHNA | T047A | Account Level Dunning Control | MAHNA |
| SI_BUB1FI | MANSP | FKKBUB1 | MANDT | T040S | Blocking reasons for dunning notices | MANDT |
| SI_BUB1FI | MANSP | SI_BUB1FI | MANSP | T040S | Blocking reasons for dunning notices | MANSP |
| SI_BUB1FI | MGRUP | FKKBUB1 | MANDT | T047R | Grouping rules for dunning notices | MANDT |
| SI_BUB1FI | MGRUP | SI_BUB1FI | MGRUP | T047R | Grouping rules for dunning notices | MGRUP |
| SI_BUB1FI | SREGL | SI_BUB1FI | SREGL | T053A | Selection Rules for Payment Advices | SREGL |
| SI_BUB1FI | SREGL | FKKBUB1 | MANDT | T053A | Selection Rules for Payment Advices | MANDT |
| SI_BUB1FI | TOGRU | FKKBUB1 | MANDT | T043G | Tolerances for Groups of Customers/Vendors | MANDT |
| SI_BUB1FI | TOGRU | FKKBUB1 | BUKRS | T043G | Tolerances for Groups of Customers/Vendors | BUKRS |
| SI_BUB1FI | TOGRU | SI_BUB1FI | TOGRU | T043G | Tolerances for Groups of Customers/Vendors | TOGRU |
| SI_BUB1FI | URLID | FKKBUB1 | MANDT | T052A | Known/Negotiated Leave | MANDT |
| SI_BUB1FI | URLID | SI_BUB1FI | URLID | T052A | Known/Negotiated Leave | URLID |
| SI_BUB1FI | UZAWE | SI_BUB1FI | UZAWE | T042F | Payment method supplements | UZAWE |
| SI_BUB1FI | UZAWE | FKKBUB1 | MANDT | T042F | Payment method supplements | MANDT |
| SI_BUB1FI | VRSDG | FKKBUB1 | MANDT | T053V | Reason Code Conversion Version | MANDT |
| SI_BUB1FI | VRSDG | SI_BUB1FI | VRSDG | T053V | Reason Code Conversion Version | VRSDG |
| SI_BUB1FI | VZSKZ | FKKBUB1 | MANDT | T056 | Interest settlement | MANDT |
| SI_BUB1FI | VZSKZ | SI_BUB1FI | VZSKZ | T056 | Interest settlement | VZSKZ |
| SI_BUB1FI | XAUSZ | FKKBUB1 | MANDT | T048K | Indicator for Periodic Account Statements | MANDT |
| SI_BUB1FI | XAUSZ | SI_BUB1FI | XAUSZ | T048K | Indicator for Periodic Account Statements | XAUSZ |
| SI_BUB1FI | ZAHLS | FKKBUB1 | MANDT | T008 | Blocking Reasons for Automatic Payment Transcations | MANDT |
| SI_BUB1FI | ZAHLS | SI_BUB1FI | ZAHLS | T008 | Blocking Reasons for Automatic Payment Transcations | ZAHLS |
| SI_BUB1FI | ZGRUP | SI_BUB1FI | ZGRUP | TZGR | Grouping rules for automatic payments | ZGRUP |
| SI_BUB1FI | ZUAWA | SI_BUB1FI | ZUAWA | TZUN | Rules for 'Allocation' Field Layout | ZUAWA |
