Financial Accounting
Table Name Description Important Fields
Financial Accounting
FBAS Financial Accounting “Basis” BKPF Accounting Document Header BUKRS / BELNR / GJAHR BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT / Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK External Systems) FRUN Run Date of a Program PRGID KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR KNB4 Customer Payment History KUNNR / BUKRS KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ Figures LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ Figures VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR
FBASCORE Financial Accounting General Services “Basis”
KNB1 Customer Master (Company Code) KUNNR / BUKRS LFA1 Vendor Master (General Section) LIFNR LFB1 Vendor Master (company Code Section) LIFNR / BUKRS SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR Description) MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS / KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts
SKAS G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR / SCHLW Key Word list) SKB1 G/L Account Master (Company Code) BUKRS / SAKNR FI-GL-GL (FBSC) General Ledger Accounting: Basic Functions - R/3 Customizing for G/L Accounts FIGLREP Settings for G/L Posting Reports MANDT TSAKR Create G/L account with reference BUKRS / SAKNR FI-GL-GL (FFE) General Ledger Accounting: Basic Functions - Fast Data Entry KOMU Account Assignment Templates for G/L KMNAM / KMZEI Account items
FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers KNKA Customer Master Credit Management : KUNNR Central Data KNKK Customer Master Credit Management : KUNNR / KKBER Control Area Data KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2 Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections
PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE / CHECT PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments F111G Global Settings for Payment Program for MANDT Payment Requests FDZA Cash Management Line Items in Payment KEYNO Requests PAYRQ Payment Requests KEYNO
Table name : SKB1 : G/L Account Master ( Company Code) Fields: BUKRS : Company Code SAKNR : G/L Account Table name : SKA1 : G/L Account Master ( Chart of Accounts ) Fields: KTOPL : Char of Accounts SAKNR : G/L Account Table name : SKAT : G/L Account Master Record ( Chart of Accounts) : Description ) Fields: SPRAS : Language KTOPL : Char of Accounts SAKNR : G/L Account
