SAP ABAP Table SI_LFB1 (Vendor Master (Company Code))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category | INTTAB | Structure |
Structure | SI_LFB1 | Table Relationship Diagram |
Short Description | Vendor Master (Company Code) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ERDAT | ERDAT_RF | DATUM | DATS | 8 | 0 | Date on which the Record Was Created | ||
2 | ERNAM | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
3 | SPERR | SPERB_B | XFELD | CHAR | 1 | 0 | Posting block for company code | ||
4 | LOEVM | LOEVM_B | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Record (Company Code Level) | ||
5 | ZUAWA | DZUAWA | ZUAWA | CHAR | 3 | 0 | Key for sorting according to assignment numbers | TZUN | |
6 | AKONT | AKONT | SAKNR | CHAR | 10 | 0 | Reconciliation Account in General Ledger | SKB1 | |
7 | BEGRU | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
8 | VZSKZ | VZSKZ | VZSKZ | CHAR | 2 | 0 | Interest calculation indicator | T056 | |
9 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
10 | XVERR | XVERR_LFB1 | XFELD | CHAR | 1 | 0 | Indicator: Clearing between customer and vendor? | ||
11 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | T008 | |
12 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
13 | EIKTO | EIKTO_K | CHAR12 | CHAR | 12 | 0 | Our account number with the vendor | ||
14 | ZSABE | DZSABE_K | TEXT15 | CHAR | 15 | 0 | Clerk at vendor | ||
15 | KVERM | KVERM | TEXT30 | CHAR | 30 | 0 | Memo | ||
16 | FDGRV | FDGRV | FDGRP | CHAR | 10 | 0 | Planning group | T035 | |
17 | BUSAB | BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | T001S | |
18 | LNRZE | LNRZE | LIFNR | CHAR | 10 | 0 | Head office account number | LFA1 | |
19 | LNRZB | LNRZB | LIFNR | CHAR | 10 | 0 | Account number of the alternative payee | LFA1 | |
20 | ZINDT | DZINDT | DATUM | DATS | 8 | 0 | Key date of the last interest calculation | ||
21 | ZINRT | DZINRT | ZINRT | NUMC | 2 | 0 | Interest calculation frequency in months | ||
22 | DATLZ | DATLZ | DATUM | DATS | 8 | 0 | Date of the last interest calculation run | ||
23 | XDEZV | XDEZV | XFELD | CHAR | 1 | 0 | Indicator: Local processing? | ||
24 | WEBTR | WEBTR | WERT7 | CURR | 13 | 2 | Bill of exchange limit (in local currency) | ||
25 | KULTG | KULTG | PACK2 | DEC | 3 | 0 | Probable time until check is paid | ||
26 | REPRF | REPRF | XFELD | CHAR | 1 | 0 | Check Flag for Double Invoices or Credit Memos | ||
27 | TOGRU | TOGRU | TOGRU | CHAR | 4 | 0 | Tolerance group for the business partner/G/L account | T043G | |
28 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
29 | XPORE | XPORE | XFELD | CHAR | 1 | 0 | Indicator: Pay all items separately ? | ||
30 | QSZNR | QSZNR | CHAR10 | CHAR | 10 | 0 | Certificate Number of the Withholding Tax Exemption | ||
31 | QSZDT | QSZDT | DATUM | DATS | 8 | 0 | Validity Date for Withholding Tax Exemption Certificate | ||
32 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
33 | BLNKZ | BLNKZ | BLNKZ | CHAR | 2 | 0 | Subsidy Indicator for Determining the Reduction Rates | * | |
34 | MINDK | MINDK | MINDK | CHAR | 3 | 0 | Minority Indicators | T059M | |
35 | ALTKN | ALTKN | CHAR10 | CHAR | 10 | 0 | Previous Master Record Number | ||
36 | ZGRUP | DZGRUP | ZGRUP | CHAR | 2 | 0 | Key for Payment Grouping | TZGR | |
37 | MGRUP | MGRUP | MGRUP | CHAR | 2 | 0 | Key for dunning notice grouping | T047R | |
38 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
39 | QSREC | QSREC | QSREC | CHAR | 2 | 0 | Vendor Recipient Type | T059A | |
40 | QSBGR | QSBGR | QSBGR | CHAR | 1 | 0 | Authority for Exemption from Withholding Tax | ||
41 | QLAND | QLAND | QLAND | CHAR | 3 | 0 | Withholding Tax Country Key | T005Q | |
42 | XEDIP | XEDIP | XFELD | CHAR | 1 | 0 | Indicator: Send Payment Advices by EDI | ||
43 | FRGRP | FRGRP | FRGRP | CHAR | 4 | 0 | Release Approval Group | VBWF08 | |
44 | TOGRR | TOGRR | TOGRR | CHAR | 4 | 0 | Tolerance group; Invoice Verification | T169L | |
45 | TLFXS | TLFXS | TEXT31 | CHAR | 31 | 0 | Accounting clerk's fax number at the customer/vendor | ||
46 | INTAD | INTAD | TXT130 | CHAR | 130 | 0 | Internet address of partner company clerk | ||
47 | XLFZB | XLFZB | XFELD | CHAR | 1 | 0 | Indicator: Alternative payee using account number | ||
48 | GUZTE | GUZTE | ZTERM | CHAR | 4 | 0 | Payment Terms Key for Credit Memos | ||
49 | GRICD | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | J_1AGICD | |
50 | GRIDT | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | J_1ADTYP | |
51 | XAUSZ | XAUSZ | AUSZG | CHAR | 1 | 0 | Indicator for periodic account statements | T048K | |
52 | CERDT | CERDT | DATUM | DATS | 8 | 0 | Certification date | ||
53 | CONFS | CONFS_B | CHAR1 | CHAR | 1 | 0 | Status of Change Authorization (Company Code Level) | ||
54 | UPDAT | UPDAT_RF | DATUM | DATS | 8 | 0 | Date on Which the Changes Were Confirmed | ||
55 | UPTIM | UPTIM_RF | AS4TIME | TIMS | 6 | 0 | Time of Last Change Confirmation | ||
56 | NODEL | NODEL_B | XFELD | CHAR | 1 | 0 | Deletion bock for master record (company code level) | ||
57 | TLFNS | TLFNS | CHAR30 | CHAR | 30 | 0 | Accounting clerk's telephone number at business partner | ||
58 | AVSND | AVSND | AVSND | CHAR | 1 | 0 | Indicator: Send Payment Advice by XML | ||
59 | AD_HASH | ADHASH | ADHASH | CHAR | 10 | 0 | E-Mail Address for Avis: Hash Value |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SI_LFB1 | AKONT | SKB1 | SAKNR | REF | 1 | CN |
2 | SI_LFB1 | BUSAB | T001S | BUSAB | REF | C | CN |
3 | SI_LFB1 | FDGRV | T035 | GRUPP | REF | C | CN |
4 | SI_LFB1 | FRGRP | VBWF08 | FRGRP | REF | C | CN |
5 | SI_LFB1 | GRICD | J_1AGICD | J_1AGICD | 1 | CN | |
6 | SI_LFB1 | GRIDT | J_1ADTYP | J_1ADTYP | 1 | CN | |
7 | SI_LFB1 | HBKID | T012 | HBKID | REF | C | CN |
8 | SI_LFB1 | LNRZB | LFA1 | LIFNR | REF | C | CN |
9 | SI_LFB1 | LNRZE | LFA1 | LIFNR | REF | C | CN |
10 | SI_LFB1 | MGRUP | T047R | MGRUP | REF | C | CN |
11 | SI_LFB1 | MINDK | T059M | MINDK | REF | C | CN |
12 | SI_LFB1 | QLAND | T005Q | QLAND | REF | 1 | CN |
13 | SI_LFB1 | QSREC | T059A | QSREC | REF | 1 | CN |
14 | SI_LFB1 | TOGRR | T169L | TOGRR | REF | 1 | CN |
15 | SI_LFB1 | TOGRU | T043G | TOGRU | REF | C | CN |
16 | SI_LFB1 | UZAWE | T042F | UZAWE | REF | C | CN |
17 | SI_LFB1 | VZSKZ | T056 | VZSKZ | REF | C | CN |
18 | SI_LFB1 | XAUSZ | T048K | XAUSZ | REF | C | CN |
19 | SI_LFB1 | ZAHLS | T008 | ZAHLS | REF | C | CN |
20 | SI_LFB1 | ZGRUP | TZGR | ZGRUP | REF | C | CN |
21 | SI_LFB1 | ZUAWA | TZUN | ZUAWA | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |