SAP Table RJGBPDEF_LFB1

IS-M: Struc.for Defining Defaults for LFB1 Fields in SAP BP

RJGBPDEF_LFB1 (IS-M: Struc.for Defining Defaults for LFB1 Fields in SAP BP) 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 RJGBPDEF_LFB1 to other SAP tables.

RJGBPDEF_LFB1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PERNR Personnel Number PERNR_D NUMC 8 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 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
X Yes
NULL No
LOEVM Deletion Flag for Master Record (Company Code Level) LOEVM_B CHAR 1 0
X Yes
NULL No
ZUAWA Key for sorting according to assignment numbers DZUAWA TZUN CHAR 3 0
AKONT Reconciliation Account in General Ledger AKONT SKB1 CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
VZSKZ Interest calculation indicator VZSKZ T056 CHAR 2 0
ZWELS List of the Payment Methods to be Considered DZWELS CHAR 10 0
XVERR Indicator: Clearing between customer and vendor? XVERR_LFB1 CHAR 1 0
X Yes
NULL No
ZAHLS Block Key for Payment DZAHLS T008 CHAR 1 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
EIKTO Our account number with the vendor EIKTO_K CHAR 12 0
ZSABE Clerk at vendor DZSABE_K CHAR 15 0
KVERM Memo KVERM CHAR 30 0
FDGRV Planning group FDGRV T035 CHAR 10 0
BUSAB Accounting clerk BUSAB T001S CHAR 2 0
LNRZE Head office account number LNRZE LFA1 CHAR 10 0
LNRZB Account number of the alternative payee LNRZB LFA1 CHAR 10 0
ZINDT Key date of the last interest calculation DZINDT DATS 8 0
ZINRT Interest calculation frequency in months DZINRT NUMC 2 0
01 1 month
02 2 months
03 3 months
04 4 months
05 5 months
06 6 months
07 7 months
08 8 months
09 9 months
10 10 months
11 11 months
12 12 months
DATLZ Date of the last interest calculation run DATLZ DATS 8 0
XDEZV Indicator: Local processing? XDEZV CHAR 1 0
X Yes
NULL No
WEBTR Bill of exchange limit (in local currency) WEBTR CURR 13 2
KULTG Probable time until check is paid KULTG DEC 3 0
REPRF Check Flag for Double Invoices or Credit Memos REPRF CHAR 1 0
X Yes
NULL No
TOGRU Tolerance group for the business partner/G/L account TOGRU T043G CHAR 4 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
XPORE Indicator: Pay all items separately ? XPORE CHAR 1 0
X Yes
NULL No
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QSZDT Validity Date for Withholding Tax Exemption Certificate QSZDT DATS 8 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
BLNKZ Subsidy indicator for determining the reduction rates BLNKZ CHAR 2 0
MINDK Minority Indicators MINDK T059M CHAR 3 0
ALTKN Previous Master Record Number ALTKN CHAR 10 0
ZGRUP Key for Payment Grouping DZGRUP TZGR CHAR 2 0
MGRUP Key for dunning notice grouping MGRUP T047R CHAR 2 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
QSREC Vendor Recipient Type QSREC T059A CHAR 2 0
QSBGR Authority for Exemption from Withholding Tax QSBGR CHAR 1 0
0 No Exemption Reason Reported
1 Income Connected with a Company in the USA
2 Exempt due to an IRS Code
3 Income not from the USA
4 Exempt due to a Tax Agreement
5 Interest Exemption Portfolio for Internal Revenue Code Sect.
6 Intermediary with Responsibility for Withholding Tax Amount
7 Foreign Private Limited Company / Trust with WH Tax Oblig.
8 U.S. Branch with Status of a U.S. Person
9 Revenues in Accord. with Qualified Intermediary: Tax-Exempt
A Securities Lender for Replacement Dividends
QLAND Withholding Tax Country Key QLAND T005Q CHAR 3 0
XEDIP Indicator: Send Payment Advices by EDI XEDIP CHAR 1 0
X Yes
NULL No
FRGRP Release Approval Group FRGRP VBWF08 CHAR 4 0
TOGRR Tolerance group; Invoice Verification TOGRR T169L CHAR 4 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
XLFZB Indicator: Alternative payee using account number XLFZB CHAR 1 0
X Yes
NULL No
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
XAUSZ Indicator for periodic account statements XAUSZ T048K CHAR 1 0
CERDT Certification date CERDT DATS 8 0
CONFS Status of Change Authorization (Company Code Level) CONFS_B CHAR 1 0
UPDAT Date on Which the Changes Were Confirmed UPDAT_RF DATS 8 0
UPTIM Time of Last Change Confirmation UPTIM_RF TIMS 6 0
NODEL Deletion bock for master record (company code level) NODEL_B CHAR 1 0
X Yes
NULL No
TLFNS Accounting clerk's telephone number at business partner TLFNS CHAR 30 0
AVSND Indicator: Send Payment Advice by XML AVSND CHAR 1 0
X Without E-mail
Y With E-mail
AD_HASH E-Mail Address for Avis: Hash Value ADHASH CHAR 10 0
J_SC_SUBCONTYPE Subcontractor Type /SAPNEA/J_SC_SUBCONTYPE CHAR 1 0
NULL Not subcontractor with chargeable component
1 Subcontractor (Covered by Subcontracting Act)
2 Subcontractor (Not Covered by Subcontracting Act)
J_SC_COMPDATE Completion Date Of Inspection /SAPNEA/J_SC_COMPLETIONDATE NUMC 3 0
J_SC_OFFSM Offset Method /SAPNEA/J_SC_OFFSM CHAR 1 0
1 Inventory-Based Offset
2 Consumption-Based Offset
3 Percentage-Based Offset
4 Payment Condition Offset
NULL No Offset
J_SC_OFFSR Offset Percentage /SAPNEA/J_SC_OFFSR NUMC 3 0
BASIS_PNT Average daily basis points for purchase cards FMBASIS_POINTS DEC 6 3
GMVKZK Vendor is in execution GMVKZK CHAR 1 0
X Yes
NULL No
INTERCOCD Intercompany code OIU_INTERCOCD T001 CHAR 4 0
RSTR_CHG_FL Restricted Mass-transaction flag OIU_RSTR_CHG_FL CHAR 1 0
X Active
NULL Inactive
CHECK_FLAG ID that the owner's check needs to be printed 1st. OIU_CHECK_FLAG CHAR 1 0
X Active
NULL Inactive
OVRD_RCPMT Override Recoupment Flag OIU_OVRD_RCPMT CHAR 1 0
X Active
NULL Inactive
MIN_PAY Mininum Payment Amount OIU_MIN_PAY CURR 6 2
PAY_FRQ_CD Payment Frequency Code OIU_PAY_FRQ_CD CHAR 2 0
01 Normal
02 Quarterly
03 Semi-annually
04 Annually
05 Pay regardless
06 Not applicable
07 Texas annual pay
NULL
RECOUP_PC Recoupment Percentage OIU_RECOUP_PC DEC 5 2
ALLOT_MTH_CD Allotee Payment Method Code OIU_ALLOT_MTH_CD CHAR 2 0
01 Checks to MMS
02 Payments to others
03 EFT to MMS
04 Royalty-in-kind
05 Checks to MMS for BIA
06 EFT to BIA - disconnected
07 Lockbox payments
NULL
ESCH_CD Escheat Code OIU_ESCH_CD CHAR 1 0
N Owner is not in escheat
Y Owner has been identified to be in escheat
S Owner has been processed after being in escheat
ESCHEAT_DT Escheat Date - Owner was put into escheat OIU_ESCH_DT DATS 8 0
PREPAY_RELEVANT Prepayment Relevance (Vendor Master) WRF_PREPAY_RELEVANT CHAR 1 0
NULL Prepayment Not Allowed
A Prepayment Requested
B Prepayment Not Requested Before GR Effected
C Prepayment Possible, but Not Planned
ASSIGN_TEST Assignment Test Group WRF_MRM_ASSIGN_GROUP WRF_ASSIGN_GRP CHAR 4 0

RJGBPDEF_LFB1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RJGBPDEF_LFB1 AKONT RJGBPDEF_LFB1 AKONT SKB1 G/L account master (company code) SAKNR
RJGBPDEF_LFB1 AKONT RJGBPDEF_LFB1 MANDT SKB1 G/L account master (company code) MANDT
RJGBPDEF_LFB1 AKONT RJGBPDEF_LFB1 BUKRS SKB1 G/L account master (company code) BUKRS
RJGBPDEF_LFB1 ASSIGN_TEST SYST MANDT WRF_ASSIGN_GRP Assignment Test Group MANDT
RJGBPDEF_LFB1 ASSIGN_TEST * WRF_ASSIGN_GRP Assignment Test Group BUKRS
RJGBPDEF_LFB1 ASSIGN_TEST RJGBPDEF_LFB1 ASSIGN_TEST WRF_ASSIGN_GRP Assignment Test Group ASSIGN_GROUP
RJGBPDEF_LFB1 BUKRS RJGBPDEF_LFB1 MANDT T001 Company Codes MANDT
RJGBPDEF_LFB1 BUKRS RJGBPDEF_LFB1 BUKRS T001 Company Codes BUKRS
RJGBPDEF_LFB1 BUSAB RJGBPDEF_LFB1 MANDT T001S Accounting Clerks MANDT
RJGBPDEF_LFB1 BUSAB RJGBPDEF_LFB1 BUKRS T001S Accounting Clerks BUKRS
RJGBPDEF_LFB1 BUSAB RJGBPDEF_LFB1 BUSAB T001S Accounting Clerks BUSAB
RJGBPDEF_LFB1 FDGRV RJGBPDEF_LFB1 MANDT T035 Planning groups MANDT
RJGBPDEF_LFB1 FDGRV RJGBPDEF_LFB1 FDGRV T035 Planning groups GRUPP
RJGBPDEF_LFB1 FRGRP RJGBPDEF_LFB1 MANDT VBWF08 Release Groups MANDT
RJGBPDEF_LFB1 FRGRP RJGBPDEF_LFB1 FRGRP VBWF08 Release Groups FRGRP
RJGBPDEF_LFB1 GRICD RJGBPDEF_LFB1 MANDT J_1AGICD Activity codes for gross income tax declaration MANDT
RJGBPDEF_LFB1 GRICD T001 LAND1 J_1AGICD Activity codes for gross income tax declaration LAND1
RJGBPDEF_LFB1 GRICD RJGBPDEF_LFB1 GRICD J_1AGICD Activity codes for gross income tax declaration J_1AGICD
RJGBPDEF_LFB1 GRIDT RJGBPDEF_LFB1 MANDT J_1ADTYP Distribution Types for Gross Income Tax MANDT
RJGBPDEF_LFB1 GRIDT RJGBPDEF_LFB1 BUKRS J_1ADTYP Distribution Types for Gross Income Tax BUKRS
RJGBPDEF_LFB1 GRIDT RJGBPDEF_LFB1 GRIDT J_1ADTYP Distribution Types for Gross Income Tax J_1ADTYP
RJGBPDEF_LFB1 HBKID RJGBPDEF_LFB1 HBKID T012 House Banks HBKID
RJGBPDEF_LFB1 HBKID RJGBPDEF_LFB1 MANDT T012 House Banks MANDT
RJGBPDEF_LFB1 HBKID RJGBPDEF_LFB1 BUKRS T012 House Banks BUKRS
RJGBPDEF_LFB1 INTERCOCD RJGBPDEF_LFB1 INTERCOCD T001 Company Codes BUKRS
RJGBPDEF_LFB1 INTERCOCD SYST MANDT T001 Company Codes MANDT
RJGBPDEF_LFB1 LIFNR RJGBPDEF_LFB1 MANDT LFA1 Vendor Master (General Section) MANDT
RJGBPDEF_LFB1 LIFNR RJGBPDEF_LFB1 LIFNR LFA1 Vendor Master (General Section) LIFNR
RJGBPDEF_LFB1 LNRZB RJGBPDEF_LFB1 MANDT LFA1 Vendor Master (General Section) MANDT
RJGBPDEF_LFB1 LNRZB RJGBPDEF_LFB1 LNRZB LFA1 Vendor Master (General Section) LIFNR
RJGBPDEF_LFB1 LNRZE RJGBPDEF_LFB1 MANDT LFA1 Vendor Master (General Section) MANDT
RJGBPDEF_LFB1 LNRZE RJGBPDEF_LFB1 LNRZE LFA1 Vendor Master (General Section) LIFNR
RJGBPDEF_LFB1 MANDT RJGBPDEF_LFB1 MANDT T000 Clients MANDT
RJGBPDEF_LFB1 MGRUP RJGBPDEF_LFB1 MANDT T047R Grouping rules for dunning notices MANDT
RJGBPDEF_LFB1 MGRUP RJGBPDEF_LFB1 MGRUP T047R Grouping rules for dunning notices MGRUP
RJGBPDEF_LFB1 MINDK RJGBPDEF_LFB1 MANDT T059M Minority Indicators MANDT
RJGBPDEF_LFB1 MINDK RJGBPDEF_LFB1 MINDK T059M Minority Indicators MINDK
RJGBPDEF_LFB1 QLAND T001 LAND1 T005Q Country Keys for Withholding Tax Calculation LAND1
RJGBPDEF_LFB1 QLAND RJGBPDEF_LFB1 QLAND T005Q Country Keys for Withholding Tax Calculation QLAND
RJGBPDEF_LFB1 QLAND RJGBPDEF_LFB1 MANDT T005Q Country Keys for Withholding Tax Calculation MANDT
RJGBPDEF_LFB1 QSREC RJGBPDEF_LFB1 QSREC T059A Type of Recipient For Vendors QSREC
RJGBPDEF_LFB1 QSREC RJGBPDEF_LFB1 MANDT T059A Type of Recipient For Vendors MANDT
RJGBPDEF_LFB1 QSREC T001 LAND1 T059A Type of Recipient For Vendors LAND1
RJGBPDEF_LFB1 TOGRR RJGBPDEF_LFB1 TOGRR T169L Vendor-Specific Parameters for Invoice Verification TOGRR
RJGBPDEF_LFB1 TOGRR RJGBPDEF_LFB1 MANDT T169L Vendor-Specific Parameters for Invoice Verification MANDT
RJGBPDEF_LFB1 TOGRR RJGBPDEF_LFB1 BUKRS T169L Vendor-Specific Parameters for Invoice Verification BUKRS
RJGBPDEF_LFB1 TOGRU RJGBPDEF_LFB1 MANDT T043G Tolerances for Groups of Customers/Vendors MANDT
RJGBPDEF_LFB1 TOGRU RJGBPDEF_LFB1 BUKRS T043G Tolerances for Groups of Customers/Vendors BUKRS
RJGBPDEF_LFB1 TOGRU RJGBPDEF_LFB1 TOGRU T043G Tolerances for Groups of Customers/Vendors TOGRU
RJGBPDEF_LFB1 UZAWE RJGBPDEF_LFB1 MANDT T042F Payment method supplements MANDT
RJGBPDEF_LFB1 UZAWE RJGBPDEF_LFB1 UZAWE T042F Payment method supplements UZAWE
RJGBPDEF_LFB1 VZSKZ RJGBPDEF_LFB1 MANDT T056 Interest settlement MANDT
RJGBPDEF_LFB1 VZSKZ RJGBPDEF_LFB1 VZSKZ T056 Interest settlement VZSKZ
RJGBPDEF_LFB1 XAUSZ RJGBPDEF_LFB1 MANDT T048K Indicator for Periodic Account Statements MANDT
RJGBPDEF_LFB1 XAUSZ RJGBPDEF_LFB1 XAUSZ T048K Indicator for Periodic Account Statements XAUSZ
RJGBPDEF_LFB1 ZAHLS RJGBPDEF_LFB1 MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
RJGBPDEF_LFB1 ZAHLS RJGBPDEF_LFB1 ZAHLS T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
RJGBPDEF_LFB1 ZGRUP RJGBPDEF_LFB1 ZGRUP TZGR Grouping rules for automatic payments ZGRUP
RJGBPDEF_LFB1 ZUAWA RJGBPDEF_LFB1 ZUAWA TZUN Rules for 'Allocation' Field Layout ZUAWA