cancel
Showing results for 
Search instead for 
Did you mean: 

tables and fields

Former Member
0 Kudos

Hi GURU;S

CAN ANYBODY HELP ME TO GET TABLES AND FILEDS FOR BELOW

Vendor Number

Vendor Name

Net Value £

VAT £

Gross Value £

Document Number

Document Date

Invoice Date

Invoice Description

General Ledger Code

VAT Code

Fiscal Year

Period

Company Code

Customer Number

Customer Name

Net Value £

VAT £

Gross Value £

Document Number

Document Date

Clearing Date

Clearing Allocation

Document Text

Fiscal Year

Period

Company Code

Document Number

Document Date

Posting Date

Fiscal Year

Period

Reference Document Number

Credit General Ledger Account

Credit Cost Centre Account

Credit Value

Credit Description

Debit General Ledger Account

Debit Cost Centre Account

Debit Vaue

Debit Description

Company Code

i WILL ASSIGN VALUE POINTS

RGDS

Sunitha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi reddy,

Table Name Description Important Fields

Financial Accounting

FBAS Financial Accounting u201CBasisu201D

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 u201CBasisu201D

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 u2013 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 u2013 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 u2013 A/R and A/P RELID / SRTFD / SRTF2

Information System

FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions u2013 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 u2013 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

Also check the below link

http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

Hope this will be help full to you......

Cheers.......

Former Member
0 Kudos

hi kumar thanks for reply.

can you please let me know in which table and in which fields balance sheet and profit and loss account will store data?

thanks

Sunitha

Former Member
0 Kudos

Check This Tables

LFC1 Vendor Master Transaction 
LFC3 Vendor Master Special GL Transactions

Former Member
0 Kudos

thanks to all, i have got many tabels and i am not able to fild few feilds for below

in AP

VAT £

Gross Value £

Invoice Description

General Ledger Code

in AR

Clearing Allocation

in GL

Credit General Ledger Account

Credit Cost Centre Account

Credit Value

Credit Description

Debit General Ledger Account

Debit Cost Centre Account

Debit Vaue

Debit Description

can any body help me to get know the tablels and fileds for above

i will assign value points

thanks

Sunitha

Former Member
0 Kudos

Hi Sunitha,

http://www.erpgenie.com/sap/abap/tables.htm

pick table name like BSIK & then start searching the field in t.code SE16N. may b u can get the rest in this manner.

give some points who is helping u.

regards

Sirisha

Answers (2)

Answers (2)

Former Member
0 Kudos

Some standard tables you can verify are

LFA1 - Vendor master data

LFB1 - Company Code - Vendir master tables

KNA1 - For Customer master data

KNB1 - Comapnyc doe - customer master

Go to SE16N and enter the table name

Former Member
0 Kudos

To get to the table/field name : click on the field, F1 key, Techincal information button(4th button), get the table name and field name from that screen