Financial Accounting Table Name Description Important FieldsFinancial AccountingFBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation BUKRS / LIFNR / WAERS / BLDAT /
of Double Documents XBLNR / WRBTR / BELNR / GJAHR
/ BUZEI
BVOR Inter Company Posting BVORG / BUKRS / GJAHR / BELNR
Procedure
EBKPF Accounting Document Header GLSBK / BELNR / GJHAR / GLEBK
(docs from 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 KUNNR / BUKRS / GJHAR
Figures
KNC3 Customer Master Special KUNNR / BUKRS / GJAHR / SHBKZ
GL Transactions Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction LIFNR / BUKRS / GJHAR
Figures
LFC3 Vendor Master Special LIFNR / BUKRS / GJHAR / SHBKZ
GL Transactions Figures
VBKPF Document Header for AUSBK / BUKRS / BELNR / GJHAR
Document ParkingFBASCORE 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 KOART / BUKRS / KONKO / MABER
Selection
MHNK Dunning Data LAUFD / LAUFI / KOART / BUKRS /
(Account Entries) KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSABFI-GL-GL (FBS) General Ledger Accounting: Basic Functions-
G/L AccountsSKAS G/L Account Master – SPRAS / KTOPL / SAKNR / SCHLW
(Chart of Accounts 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 itemsFI-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 : LOGSYS / KUNNR / KKBER / REGUL
FI Status data
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information SystemFI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D)
Transactions – General SectionsPAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPLFI-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
What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?
As far as general ledger master data is concerned, the following tables are involved : 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
0 comments: on "Important Tables for SAP FI"
Post a Comment